/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.sys_Module DataRowToModel(DataRow row) { Maticsoft.Model.sys_Module model = new Maticsoft.Model.sys_Module(); if (row != null) { if (row["ModuleID"] != null && row["ModuleID"].ToString() != "") { model.ModuleID = int.Parse(row["ModuleID"].ToString()); } if (row["M_ApplicationID"] != null && row["M_ApplicationID"].ToString() != "") { model.M_ApplicationID = int.Parse(row["M_ApplicationID"].ToString()); } if (row["M_ParentID"] != null && row["M_ParentID"].ToString() != "") { model.M_ParentID = int.Parse(row["M_ParentID"].ToString()); } if (row["M_PageCode"] != null) { model.M_PageCode = row["M_PageCode"].ToString(); } if (row["M_CName"] != null) { model.M_CName = row["M_CName"].ToString(); } if (row["M_Directory"] != null) { model.M_Directory = row["M_Directory"].ToString(); } if (row["M_OrderLevel"] != null) { model.M_OrderLevel = row["M_OrderLevel"].ToString(); } if (row["M_IsSystem"] != null && row["M_IsSystem"].ToString() != "") { model.M_IsSystem = int.Parse(row["M_IsSystem"].ToString()); } if (row["M_Close"] != null && row["M_Close"].ToString() != "") { model.M_Close = int.Parse(row["M_Close"].ToString()); } if (row["M_Icon"] != null) { model.M_Icon = row["M_Icon"].ToString(); } if (row["M_Info"] != null) { model.M_Info = row["M_Info"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.sys_Module DataRowToModel(DataRow row) { Maticsoft.Model.sys_Module model=new Maticsoft.Model.sys_Module(); if (row != null) { if(row["ModuleID"]!=null && row["ModuleID"].ToString()!="") { model.ModuleID=int.Parse(row["ModuleID"].ToString()); } if(row["M_ApplicationID"]!=null && row["M_ApplicationID"].ToString()!="") { model.M_ApplicationID=int.Parse(row["M_ApplicationID"].ToString()); } if(row["M_ParentID"]!=null && row["M_ParentID"].ToString()!="") { model.M_ParentID=int.Parse(row["M_ParentID"].ToString()); } if(row["M_PageCode"]!=null) { model.M_PageCode=row["M_PageCode"].ToString(); } if(row["M_CName"]!=null) { model.M_CName=row["M_CName"].ToString(); } if(row["M_Directory"]!=null) { model.M_Directory=row["M_Directory"].ToString(); } if(row["M_OrderLevel"]!=null) { model.M_OrderLevel=row["M_OrderLevel"].ToString(); } if(row["M_IsSystem"]!=null && row["M_IsSystem"].ToString()!="") { model.M_IsSystem=int.Parse(row["M_IsSystem"].ToString()); } if(row["M_Close"]!=null && row["M_Close"].ToString()!="") { model.M_Close=int.Parse(row["M_Close"].ToString()); } if(row["M_Icon"]!=null) { model.M_Icon=row["M_Icon"].ToString(); } if(row["M_Info"]!=null) { model.M_Info=row["M_Info"].ToString(); } } return model; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.sys_Module model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update sys_Module set "); strSql.Append("M_ParentID=@M_ParentID,"); strSql.Append("M_CName=@M_CName,"); strSql.Append("M_Directory=@M_Directory,"); strSql.Append("M_OrderLevel=@M_OrderLevel,"); strSql.Append("M_IsSystem=@M_IsSystem,"); strSql.Append("M_Close=@M_Close,"); strSql.Append("M_Icon=@M_Icon,"); strSql.Append("M_Info=@M_Info"); strSql.Append(" where ModuleID=@ModuleID"); SqlParameter[] parameters = { new SqlParameter("@M_ParentID", SqlDbType.Int, 4), new SqlParameter("@M_CName", SqlDbType.NVarChar, 50), new SqlParameter("@M_Directory", SqlDbType.NVarChar, 255), new SqlParameter("@M_OrderLevel", SqlDbType.VarChar, 4), new SqlParameter("@M_IsSystem", SqlDbType.TinyInt, 1), new SqlParameter("@M_Close", SqlDbType.TinyInt, 1), new SqlParameter("@M_Icon", SqlDbType.VarChar, 255), new SqlParameter("@M_Info", SqlDbType.NVarChar, 500), new SqlParameter("@ModuleID", SqlDbType.Int, 4), new SqlParameter("@M_ApplicationID", SqlDbType.Int, 4), new SqlParameter("@M_PageCode", SqlDbType.VarChar, 100) }; parameters[0].Value = model.M_ParentID; parameters[1].Value = model.M_CName; parameters[2].Value = model.M_Directory; parameters[3].Value = model.M_OrderLevel; parameters[4].Value = model.M_IsSystem; parameters[5].Value = model.M_Close; parameters[6].Value = model.M_Icon; parameters[7].Value = model.M_Info; parameters[8].Value = model.ModuleID; parameters[9].Value = model.M_ApplicationID; parameters[10].Value = model.M_PageCode; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(int ModuleID) { Maticsoft.BLL.sys_Module bll = new Maticsoft.BLL.sys_Module(); Maticsoft.Model.sys_Module model = bll.GetModel(ModuleID); this.lblModuleID.Text = model.ModuleID.ToString(); this.lblM_ApplicationID.Text = model.M_ApplicationID.ToString(); this.lblM_ParentID.Text = model.M_ParentID.ToString(); this.lblM_PageCode.Text = model.M_PageCode; this.lblM_CName.Text = model.M_CName; this.lblM_Directory.Text = model.M_Directory; this.lblM_OrderLevel.Text = model.M_OrderLevel; this.lblM_IsSystem.Text = model.M_IsSystem.ToString(); this.lblM_Close.Text = model.M_Close.ToString(); this.lblM_Icon.Text = model.M_Icon; this.lblM_Info.Text = model.M_Info; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.sys_Module model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into sys_Module("); strSql.Append("M_ApplicationID,M_ParentID,M_PageCode,M_CName,M_Directory,M_OrderLevel,M_IsSystem,M_Close,M_Icon,M_Info)"); strSql.Append(" values ("); strSql.Append("@M_ApplicationID,@M_ParentID,@M_PageCode,@M_CName,@M_Directory,@M_OrderLevel,@M_IsSystem,@M_Close,@M_Icon,@M_Info)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@M_ApplicationID", SqlDbType.Int, 4), new SqlParameter("@M_ParentID", SqlDbType.Int, 4), new SqlParameter("@M_PageCode", SqlDbType.VarChar, 100), new SqlParameter("@M_CName", SqlDbType.NVarChar, 50), new SqlParameter("@M_Directory", SqlDbType.NVarChar, 255), new SqlParameter("@M_OrderLevel", SqlDbType.VarChar, 4), new SqlParameter("@M_IsSystem", SqlDbType.TinyInt, 1), new SqlParameter("@M_Close", SqlDbType.TinyInt, 1), new SqlParameter("@M_Icon", SqlDbType.VarChar, 255), new SqlParameter("@M_Info", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.M_ApplicationID; parameters[1].Value = model.M_ParentID; parameters[2].Value = model.M_PageCode; parameters[3].Value = model.M_CName; parameters[4].Value = model.M_Directory; parameters[5].Value = model.M_OrderLevel; parameters[6].Value = model.M_IsSystem; parameters[7].Value = model.M_Close; parameters[8].Value = model.M_Icon; parameters[9].Value = model.M_Info; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.sys_Module GetModel(int ModuleID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ModuleID,M_ApplicationID,M_ParentID,M_PageCode,M_CName,M_Directory,M_OrderLevel,M_IsSystem,M_Close,M_Icon,M_Info from sys_Module "); strSql.Append(" where ModuleID=@ModuleID"); SqlParameter[] parameters = { new SqlParameter("@ModuleID", SqlDbType.Int, 4) }; parameters[0].Value = ModuleID; Maticsoft.Model.sys_Module model = new Maticsoft.Model.sys_Module(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(!PageValidate.IsNumber(txtM_ParentID.Text)) { strErr+="所属父级模块ID与Module格式错误!\\n"; } if(this.txtM_CName.Text.Trim().Length==0) { strErr+="模块/栏目名称当ParentI不能为空!\\n"; } if(this.txtM_Directory.Text.Trim().Length==0) { strErr+="模块/栏目???录名不能为空!\\n"; } if(this.txtM_OrderLevel.Text.Trim().Length==0) { strErr+="当前所在排序级别支持双层99级不能为空!\\n"; } if(!PageValidate.IsNumber(txtM_IsSystem.Text)) { strErr+="是否为系统模块1:是0:否如为格式错误!\\n"; } if(!PageValidate.IsNumber(txtM_Close.Text)) { strErr+="是否关闭1:是0:否格式错误!\\n"; } if(this.txtM_Icon.Text.Trim().Length==0) { strErr+="模块Icon不能为空!\\n"; } if(this.txtM_Info.Text.Trim().Length==0) { strErr+="模块说明不能为空!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } int ModuleID=int.Parse(this.lblModuleID.Text); int M_ApplicationID=int.Parse(this.lblM_ApplicationID.Text); int M_ParentID=int.Parse(this.txtM_ParentID.Text); string M_PageCode=this.lblM_PageCode.Text; string M_CName=this.txtM_CName.Text; string M_Directory=this.txtM_Directory.Text; string M_OrderLevel=this.txtM_OrderLevel.Text; int M_IsSystem=int.Parse(this.txtM_IsSystem.Text); int M_Close=int.Parse(this.txtM_Close.Text); string M_Icon=this.txtM_Icon.Text; string M_Info=this.txtM_Info.Text; Maticsoft.Model.sys_Module model=new Maticsoft.Model.sys_Module(); model.ModuleID=ModuleID; model.M_ApplicationID=M_ApplicationID; model.M_ParentID=M_ParentID; model.M_PageCode=M_PageCode; model.M_CName=M_CName; model.M_Directory=M_Directory; model.M_OrderLevel=M_OrderLevel; model.M_IsSystem=M_IsSystem; model.M_Close=M_Close; model.M_Icon=M_Icon; model.M_Info=M_Info; Maticsoft.BLL.sys_Module bll=new Maticsoft.BLL.sys_Module(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.sys_Module GetModel(int ModuleID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 ModuleID,M_ApplicationID,M_ParentID,M_PageCode,M_CName,M_Directory,M_OrderLevel,M_IsSystem,M_Close,M_Icon,M_Info from sys_Module "); strSql.Append(" where ModuleID=@ModuleID"); SqlParameter[] parameters = { new SqlParameter("@ModuleID", SqlDbType.Int,4) }; parameters[0].Value = ModuleID; Maticsoft.Model.sys_Module model=new Maticsoft.Model.sys_Module(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtM_ParentID.Text)) { strErr += "所属父级模块ID与Module格式错误!\\n"; } if (this.txtM_CName.Text.Trim().Length == 0) { strErr += "模块/栏目名称当ParentI不能为空!\\n"; } if (this.txtM_Directory.Text.Trim().Length == 0) { strErr += "模块/栏目???录名不能为空!\\n"; } if (this.txtM_OrderLevel.Text.Trim().Length == 0) { strErr += "当前所在排序级别支持双层99级不能为空!\\n"; } if (!PageValidate.IsNumber(txtM_IsSystem.Text)) { strErr += "是否为系统模块1:是0:否如为格式错误!\\n"; } if (!PageValidate.IsNumber(txtM_Close.Text)) { strErr += "是否关闭1:是0:否格式错误!\\n"; } if (this.txtM_Icon.Text.Trim().Length == 0) { strErr += "模块Icon不能为空!\\n"; } if (this.txtM_Info.Text.Trim().Length == 0) { strErr += "模块说明不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int ModuleID = int.Parse(this.lblModuleID.Text); int M_ApplicationID = int.Parse(this.lblM_ApplicationID.Text); int M_ParentID = int.Parse(this.txtM_ParentID.Text); string M_PageCode = this.lblM_PageCode.Text; string M_CName = this.txtM_CName.Text; string M_Directory = this.txtM_Directory.Text; string M_OrderLevel = this.txtM_OrderLevel.Text; int M_IsSystem = int.Parse(this.txtM_IsSystem.Text); int M_Close = int.Parse(this.txtM_Close.Text); string M_Icon = this.txtM_Icon.Text; string M_Info = this.txtM_Info.Text; Maticsoft.Model.sys_Module model = new Maticsoft.Model.sys_Module(); model.ModuleID = ModuleID; model.M_ApplicationID = M_ApplicationID; model.M_ParentID = M_ParentID; model.M_PageCode = M_PageCode; model.M_CName = M_CName; model.M_Directory = M_Directory; model.M_OrderLevel = M_OrderLevel; model.M_IsSystem = M_IsSystem; model.M_Close = M_Close; model.M_Icon = M_Icon; model.M_Info = M_Info; Maticsoft.BLL.sys_Module bll = new Maticsoft.BLL.sys_Module(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }