/// <summary> /// 更新一条数据 /// </summary> public bool Update(WalleProject.Model.t_staffmenu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_staffmenu set "); strSql.Append("StaM_User=@StaM_User,"); strSql.Append("StaM_Boss=@StaM_Boss,"); strSql.Append("StaM_Admin=@StaM_Admin,"); strSql.Append("StaM_Staff=@StaM_Staff,"); strSql.Append("StaM_Url=@StaM_Url,"); strSql.Append("StaM_Name=@StaM_Name,"); strSql.Append("StaM_Delete=@StaM_Delete,"); strSql.Append("StaM_MenuClass=@StaM_MenuClass,"); strSql.Append("StaM_Valid=@StaM_Valid"); strSql.Append("StaM_Icon=@StaM_Icon"); strSql.Append(" where StaM_ID=@StaM_ID"); MySqlParameter[] parameters = { new MySqlParameter("@StaM_User", MySqlDbType.Int32, 1), new MySqlParameter("@StaM_Boss", MySqlDbType.Int32, 1), new MySqlParameter("@StaM_Admin", MySqlDbType.Int32, 1), new MySqlParameter("@StaM_Staff", MySqlDbType.Int32, 1), new MySqlParameter("@StaM_Url", MySqlDbType.VarChar, 100), new MySqlParameter("@StaM_Name", MySqlDbType.VarChar, 50), new MySqlParameter("@StaM_Delete", MySqlDbType.Int32, 1), new MySqlParameter("@StaM_MenuClass", MySqlDbType.Int32, 10), new MySqlParameter("@StaM_Valid", MySqlDbType.Int32, 1), new MySqlParameter("@StaM_Icon", MySqlDbType.VarChar, 50), new MySqlParameter("@StaM_ID", MySqlDbType.Int32, 10) }; parameters[0].Value = model.StaM_User; parameters[1].Value = model.StaM_Boss; parameters[2].Value = model.StaM_Admin; parameters[3].Value = model.StaM_Staff; parameters[4].Value = model.StaM_Url; parameters[5].Value = model.StaM_Name; parameters[6].Value = model.StaM_Delete; parameters[7].Value = model.StaM_MenuClass; parameters[8].Value = model.StaM_Valid; parameters[9].Value = model.StaM_ID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WalleProject.Model.t_staffmenu DataRowToModel(DataRow row) { WalleProject.Model.t_staffmenu model = new WalleProject.Model.t_staffmenu(); if (row != null) { if (row["StaM_User"] != null && row["StaM_User"].ToString() != "") { model.StaM_User = int.Parse(row["StaM_User"].ToString()); } if (row["StaM_Boss"] != null && row["StaM_Boss"].ToString() != "") { model.StaM_Boss = int.Parse(row["StaM_Boss"].ToString()); } if (row["StaM_Admin"] != null && row["StaM_Admin"].ToString() != "") { model.StaM_Admin = int.Parse(row["StaM_Admin"].ToString()); } if (row["StaM_Staff"] != null && row["StaM_Staff"].ToString() != "") { model.StaM_Staff = int.Parse(row["StaM_Staff"].ToString()); } if (row["StaM_Url"] != null) { model.StaM_Url = row["StaM_Url"].ToString(); } if (row["StaM_Name"] != null) { model.StaM_Name = row["StaM_Name"].ToString(); } if (row["StaM_ID"] != null && row["StaM_ID"].ToString() != "") { model.StaM_ID = int.Parse(row["StaM_ID"].ToString()); } if (row["StaM_Delete"] != null && row["StaM_Delete"].ToString() != "") { model.StaM_Delete = int.Parse(row["StaM_Delete"].ToString()); } if (row["StaM_MenuClass"] != null && row["StaM_MenuClass"].ToString() != "") { model.StaM_MenuClass = int.Parse(row["StaM_MenuClass"].ToString()); } if (row["StaM_Valid"] != null && row["StaM_Valid"].ToString() != "") { model.StaM_Valid = int.Parse(row["StaM_Valid"].ToString()); } if (row["StaM_Icon"] != null && row["StaM_Icon"].ToString() != "") { model.StaM_Icon = int.Parse(row["StaM_Icon"].ToString()); } } return(model); }
private void ShowInfo(int StaM_ID) { WalleProject.BLL.t_staffmenu bll = new WalleProject.BLL.t_staffmenu(); WalleProject.Model.t_staffmenu model = bll.GetModel(StaM_ID); this.lblStaM_User.Text = model.StaM_User.ToString(); this.lblStaM_Boss.Text = model.StaM_Boss.ToString(); this.lblStaM_Admin.Text = model.StaM_Admin.ToString(); this.lblStaM_Staff.Text = model.StaM_Staff.ToString(); this.lblStaM_Url.Text = model.StaM_Url; this.lblStaM_Name.Text = model.StaM_Name; this.lblStaM_ID.Text = model.StaM_ID.ToString(); this.lblStaM_Delete.Text = model.StaM_Delete.ToString(); this.lblStaM_MenuClass.Text = model.StaM_MenuClass.ToString(); this.lblStaM_Valid.Text = model.StaM_Valid.ToString(); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(WalleProject.Model.t_staffmenu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_staffmenu("); strSql.Append("StaM_User,StaM_Boss,StaM_Admin,StaM_Staff,StaM_Url,StaM_Name,StaM_Delete,StaM_MenuClass,StaM_Valid,StaM_Icon)"); strSql.Append(" values ("); strSql.Append("@StaM_User,@StaM_Boss,@StaM_Admin,@StaM_Staff,@StaM_Url,@StaM_Name,@StaM_Delete,@StaM_MenuClass,@StaM_Valid,@StaM_Icon)"); MySqlParameter[] parameters = { new MySqlParameter("@StaM_User", MySqlDbType.Int32, 1), new MySqlParameter("@StaM_Boss", MySqlDbType.Int32, 1), new MySqlParameter("@StaM_Admin", MySqlDbType.Int32, 1), new MySqlParameter("@StaM_Staff", MySqlDbType.Int32, 1), new MySqlParameter("@StaM_Url", MySqlDbType.VarChar, 100), new MySqlParameter("@StaM_Name", MySqlDbType.VarChar, 50), new MySqlParameter("@StaM_Delete", MySqlDbType.Int32, 1), new MySqlParameter("@StaM_MenuClass", MySqlDbType.Int32, 10), new MySqlParameter("@StaM_Valid", MySqlDbType.Int32, 1), new MySqlParameter("@StaM_Icon", MySqlDbType.VarChar, 50) }; parameters[0].Value = model.StaM_User; parameters[1].Value = model.StaM_Boss; parameters[2].Value = model.StaM_Admin; parameters[3].Value = model.StaM_Staff; parameters[4].Value = model.StaM_Url; parameters[5].Value = model.StaM_Name; parameters[6].Value = model.StaM_Delete; parameters[7].Value = model.StaM_MenuClass; parameters[8].Value = model.StaM_Valid; parameters[9].Value = model.StaM_Icon; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WalleProject.Model.t_staffmenu GetModel(int StaM_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select StaM_User,StaM_Boss,StaM_Admin,StaM_Staff,StaM_Url,StaM_Name,StaM_ID,StaM_Delete,StaM_MenuClass,StaM_Valid from t_staffmenu "); strSql.Append(" where StaM_ID=@StaM_ID"); MySqlParameter[] parameters = { new MySqlParameter("@StaM_ID", MySqlDbType.Int32) }; parameters[0].Value = StaM_ID; WalleProject.Model.t_staffmenu model = new WalleProject.Model.t_staffmenu(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtStaM_User.Text)) { strErr += "StaM_User格式错误!\\n"; } if (!PageValidate.IsNumber(txtStaM_Boss.Text)) { strErr += "StaM_Boss格式错误!\\n"; } if (!PageValidate.IsNumber(txtStaM_Admin.Text)) { strErr += "StaM_Admin格式错误!\\n"; } if (!PageValidate.IsNumber(txtStaM_Staff.Text)) { strErr += "StaM_Staff格式错误!\\n"; } if (this.txtStaM_Url.Text.Trim().Length == 0) { strErr += "StaM_Url不能为空!\\n"; } if (this.txtStaM_Name.Text.Trim().Length == 0) { strErr += "StaM_Name不能为空!\\n"; } if (!PageValidate.IsNumber(txtStaM_Delete.Text)) { strErr += "StaM_Delete格式错误!\\n"; } if (!PageValidate.IsNumber(txtStaM_MenuClass.Text)) { strErr += "StaM_MenuClass格式错误!\\n"; } if (!PageValidate.IsNumber(txtStaM_Valid.Text)) { strErr += "StaM_Valid格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int StaM_User = int.Parse(this.txtStaM_User.Text); int StaM_Boss = int.Parse(this.txtStaM_Boss.Text); int StaM_Admin = int.Parse(this.txtStaM_Admin.Text); int StaM_Staff = int.Parse(this.txtStaM_Staff.Text); string StaM_Url = this.txtStaM_Url.Text; string StaM_Name = this.txtStaM_Name.Text; int StaM_Delete = int.Parse(this.txtStaM_Delete.Text); int StaM_MenuClass = int.Parse(this.txtStaM_MenuClass.Text); int StaM_Valid = int.Parse(this.txtStaM_Valid.Text); WalleProject.Model.t_staffmenu model = new WalleProject.Model.t_staffmenu(); model.StaM_User = StaM_User; model.StaM_Boss = StaM_Boss; model.StaM_Admin = StaM_Admin; model.StaM_Staff = StaM_Staff; model.StaM_Url = StaM_Url; model.StaM_Name = StaM_Name; model.StaM_Delete = StaM_Delete; model.StaM_MenuClass = StaM_MenuClass; model.StaM_Valid = StaM_Valid; WalleProject.BLL.t_staffmenu bll = new WalleProject.BLL.t_staffmenu(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }