保存数据时站点名称唯一

protected void btnSave_Click(object sender, EventArgs e)

{

try

{

string SiteName = "";

string companyid = ((DropDownList)fvBSWeekReport.FindControl("ddlCompany")).SelectedValue;

string id = Request["ID"] == null ? string.Empty : Request["ID"].ToString();

TextBox txtSiteName = (this.fvBSWeekReport.FindControl("txtSiteName")) as TextBox;

if (txtSiteName != null)

{

SiteName = txtSiteName.Text;

}

Database db = DatabaseFactory.CreateDatabase();

string EixsitSiteName = string.Empty;

if (this.fvBSWeekReport.DefaultMode == FormViewMode.Edit)

{

object res = db.ExecuteScalar(CommandType.Text, string.Format(@"

select top 1 1

from [EPMSReport].[dbo].[FourGProjectOutWeekReport]

where ID <>'{0}' and SiteName='{1}'

AND [YEAR]=(SELECT w.year

FROM [EPMSReport].[dbo].WeekInfo w

WHERE w.BeginTime <= getdate() AND w.EndTime >= getdate())

AND WeekNum= (SELECT w.WeekOfYear

FROM [EPMSReport].[dbo].WeekInfo w

WHERE w.BeginTime <= getdate() AND w.EndTime >= getdate())", id, SiteName));

EixsitSiteName = res != null ? res.ToString() : string.Empty;

}

else

{

object res = db.ExecuteScalar(CommandType.Text, string.Format(@"

select top 1 1

from [EPMSReport].[dbo].[FourGProjectOutWeekReport]

where SiteName='{1}'

AND [YEAR]=(SELECT w.year

FROM [EPMSReport].[dbo].WeekInfo w

WHERE w.BeginTime <= getdate() AND w.EndTime >= getdate())

AND WeekNum= (SELECT w.WeekOfYear

FROM [EPMSReport].[dbo].WeekInfo w

WHERE w.BeginTime <= getdate() AND w.EndTime >= getdate())", id, SiteName));

EixsitSiteName = res != null ? res.ToString() : string.Empty;

}

if (!string.IsNullOrEmpty(EixsitSiteName))

{

ClientHelper.ShowMessage(this.Page, "该站点名称已存在，请重新命站点名");

return;

}

else

{

string sortorder = (db.ExecuteScalar(CommandType.Text, string.Format("select top 1 SortOrder from Region where CompanyID='{0}'", companyid))).ToString();

this.sdsFv.UpdateParameters["CompanyID"].DefaultValue = companyid;

this.sdsFv.UpdateParameters["CompanyName"].DefaultValue = ((DropDownList)fvBSWeekReport.FindControl("ddlCompany")).SelectedItem.Text;

this.sdsFv.UpdateParameters["SortOrder"].DefaultValue = sortorder;

this.fvBSWeekReport.UpdateItem(true);

}

}

catch (Exception ex)

{

ClientHelper.ShowMessage(this, string.Format("保存失败！\n {0}", ex.Message));

return;

}

ClientHelper.ShowMessage(this, "保存成功！");

ClientHelper.CloseModalDialog(this, "", "saved");

}