protected void btnSave_Click(object sender, EventArgs e) { bool result = false; HoneyWell.Model.Sys_Area area = SetObjectValue(); if (nodeValue != "") { //判断区域代码是否重复 DataSet ds = new HoneyWell.BLL.Sys_Public().SelectData("top 1 ID", "Sys_Area", " and AreaCode='" + txt_ClassCode.Value.Trim() + "' and AreaCode<>'" + nodeValue + "'"); if (ds != null && ds.Tables[0].Rows.Count > 0) { Response.Write("<script language='javascript'>alert('您输入的区域代码已存在,请重新输入!');location.href='sys_Area_Manage.aspx?nodeText=" + nodeText + "&nodeValue=" + nodeValue + "'</script>"); Response.End(); } //判断区域名称是否重复 DataSet ds1 = new HoneyWell.BLL.Sys_Public().SelectData("top 1 ID", "Sys_Area", " and AreaName='" + txt_ClassName.Value.Trim() + "' and AreaCode<>'" + nodeValue + "'"); if (ds1 != null && ds1.Tables[0].Rows.Count > 0) { Response.Write("<script language='javascript'>alert('您输入的区域名称已存在,请重新输入!');location.href='sys_Area_Manage.aspx?nodeText=" + nodeText + "&nodeValue=" + nodeValue + "'</script>"); Response.End(); } result = new HoneyWell.BLL.Sys_Area().Update(area); } if (true) { ScriptManager.RegisterClientScriptBlock(btnSave, GetType(), "", "alert('操作成功!');location.href='sys_Area_Manage.aspx?nodeText=" + nodeText + "&nodeValue=" + nodeValue + "'", true); } }
public HoneyWell.Model.Sys_Area SetObjectValue() { string tableName = "Sys_Area"; string showField = " top 1 ID"; string strWhere = " and AreaCode='" + nodeValue + "'"; DataTable dt = new BLL.Sys_Public().SelectData(showField, tableName, strWhere).Tables[0]; if (dt != null && dt.Rows.Count > 0) { nodeId = Utils.ToInt(dt.Rows[0]["ID"].ToString()); } HoneyWell.Model.Sys_Area area = new HoneyWell.Model.Sys_Area(); area.ID = nodeId; area.AreaCode = txt_ClassCode.Value.Trim(); area.AreaName = txt_ClassName.Value.Trim(); area.ParentAreaCode = h_ParentCode.Value; area.AreaLevel = Utils.ToInt(h_ClassLevel.Value); area.AreaOrder = Utils.ToInt(txt_ClassOrder.Value.Trim()); area.KeyWord = txt_KeyWord.Value.Trim(); area.ModifyUser = GetUserName(); area.ModifyTime = DateTime.Now; area.MoreCol1 = ""; area.MoreCol2 = ""; return(area); }
public HoneyWell.Model.Sys_Area SetObjectValue() { HoneyWell.Model.Sys_Area area = new HoneyWell.Model.Sys_Area(); area.AreaCode = txt_ClassCode.Value.Trim(); area.AreaName = txt_ClassName.Value.Trim(); area.ParentAreaCode = nodeValue; area.AreaLevel = Utils.ToInt(h_ClassLevel.Value) + 1; area.AreaOrder = Utils.ToInt(txt_ClassOrder.Value.Trim()); area.KeyWord = txt_KeyWord.Value.Trim();; area.CreateUser = GetUserName(); area.CreateTime = DateTime.Now; area.ModifyUser = GetUserName(); area.ModifyTime = DateTime.Now; area.MoreCol1 = ""; area.MoreCol2 = ""; return(area); }