protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtsname.Text.Trim().Length == 0) { strErr += "sname不能为空!\\n"; } if (!PageValidate.IsNumber(txtsminutes.Text)) { strErr += "sminutes格式错误!\\n"; } if (this.txtsdesc.Text.Trim().Length == 0) { strErr += "sdesc不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string sname = this.txtsname.Text; int sminutes = int.Parse(this.txtsminutes.Text); string sdesc = this.txtsdesc.Text; Jium.Model.servicetype model = new Jium.Model.servicetype(); model.sname = sname; model.sminutes = sminutes; model.sdesc = sdesc; Jium.BLL.servicetype bll = new Jium.BLL.servicetype(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Jium.Model.servicetype model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update servicetype set "); strSql.Append("sname=@sname,"); strSql.Append("sminutes=@sminutes,"); strSql.Append("sdesc=@sdesc"); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@sname", MySqlDbType.VarChar, 40), new MySqlParameter("@sminutes", MySqlDbType.Int32, 11), new MySqlParameter("@sdesc", MySqlDbType.VarChar, 256), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.sname; parameters[1].Value = model.sminutes; parameters[2].Value = model.sdesc; parameters[3].Value = model.id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Jium.Model.servicetype model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into servicetype("); strSql.Append("sname,sminutes,sdesc)"); strSql.Append(" values ("); strSql.Append("@sname,@sminutes,@sdesc)"); MySqlParameter[] parameters = { new MySqlParameter("@sname", MySqlDbType.VarChar, 40), new MySqlParameter("@sminutes", MySqlDbType.Int32, 11), new MySqlParameter("@sdesc", MySqlDbType.VarChar, 256) }; parameters[0].Value = model.sname; parameters[1].Value = model.sminutes; parameters[2].Value = model.sdesc; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(int id) { Jium.BLL.servicetype bll = new Jium.BLL.servicetype(); Jium.Model.servicetype model = bll.GetModel(id); this.lblid.Text = model.id.ToString(); this.lblsname.Text = model.sname; this.lblsminutes.Text = model.sminutes.ToString(); this.lblsdesc.Text = model.sdesc; }
/// <summary> /// 得到一个对象实体 /// </summary> public Jium.Model.servicetype DataRowToModel(DataRow row) { Jium.Model.servicetype model = new Jium.Model.servicetype(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["sname"] != null) { model.sname = row["sname"].ToString(); } if (row["sminutes"] != null && row["sminutes"].ToString() != "") { model.sminutes = int.Parse(row["sminutes"].ToString()); } if (row["sdesc"] != null) { model.sdesc = row["sdesc"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Jium.Model.servicetype GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,sname,sminutes,sdesc from servicetype "); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32) }; parameters[0].Value = id; Jium.Model.servicetype model = new Jium.Model.servicetype(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }