/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.shangke model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into shangke("); strSql.Append("qishu,kecheng,jiangshi,keshi)"); strSql.Append(" values ("); strSql.Append("@qishu,@kecheng,@jiangshi,@keshi)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@qishu", SqlDbType.NChar, 10), new SqlParameter("@kecheng", SqlDbType.NVarChar, 50), new SqlParameter("@jiangshi", SqlDbType.NChar, 10), new SqlParameter("@keshi", SqlDbType.Float, 8) }; parameters[0].Value = model.qishu; parameters[1].Value = model.kecheng; parameters[2].Value = model.jiangshi; parameters[3].Value = model.keshi; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.shangke model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update shangke set "); strSql.Append("qishu=@qishu,"); strSql.Append("kecheng=@kecheng,"); strSql.Append("jiangshi=@jiangshi,"); strSql.Append("keshi=@keshi"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@qishu", SqlDbType.NChar, 10), new SqlParameter("@kecheng", SqlDbType.NVarChar, 50), new SqlParameter("@jiangshi", SqlDbType.NChar, 10), new SqlParameter("@keshi", SqlDbType.Float, 8), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.qishu; parameters[1].Value = model.kecheng; parameters[2].Value = model.jiangshi; parameters[3].Value = model.keshi; parameters[4].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.shangke DataRowToModel(DataRow row) { Maticsoft.Model.shangke model = new Maticsoft.Model.shangke(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["qishu"] != null) { model.qishu = row["qishu"].ToString(); } if (row["kecheng"] != null) { model.kecheng = row["kecheng"].ToString(); } if (row["jiangshi"] != null) { model.jiangshi = row["jiangshi"].ToString(); } if (row["keshi"] != null && row["keshi"].ToString() != "") { model.keshi = decimal.Parse(row["keshi"].ToString()); } } return(model); }
private void ShowInfo(int id) { Maticsoft.BLL.shangke bll = new Maticsoft.BLL.shangke(); Maticsoft.Model.shangke model = bll.GetModel(id); this.lblid.Text = model.id.ToString(); this.lblqishu.Text = model.qishu; this.lblkecheng.Text = model.kecheng; this.lbljiangshi.Text = model.jiangshi; this.lblkeshi.Text = model.keshi.ToString(); }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtqishu.Text.Trim().Length == 0) { strErr += "qishu不能为空!\\n"; } if (this.txtkecheng.Text.Trim().Length == 0) { strErr += "kecheng不能为空!\\n"; } if (this.txtjiangshi.Text.Trim().Length == 0) { strErr += "jiangshi不能为空!\\n"; } if (!PageValidate.IsDecimal(txtkeshi.Text)) { strErr += "keshi格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int id = int.Parse(this.lblid.Text); string qishu = this.txtqishu.Text; string kecheng = this.txtkecheng.Text; string jiangshi = this.txtjiangshi.Text; decimal keshi = decimal.Parse(this.txtkeshi.Text); Maticsoft.Model.shangke model = new Maticsoft.Model.shangke(); model.id = id; model.qishu = qishu; model.kecheng = kecheng; model.jiangshi = jiangshi; model.keshi = keshi; Maticsoft.BLL.shangke bll = new Maticsoft.BLL.shangke(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
protected void btnSave_Click(object sender, EventArgs e) { //string strErr=""; //if(this.txtqishu.Text.Trim().Length==0) //{ // strErr+="qishu不能为空!\\n"; //} //if(this.txtkecheng.Text.Trim().Length==0) //{ // strErr+="kecheng不能为空!\\n"; //} //if(this.txtjiangshi.Text.Trim().Length==0) //{ // strErr+="jiangshi不能为空!\\n"; //} //if(!PageValidate.IsDecimal(txtkeshi.Text)) //{ // strErr+="keshi格式错误!\\n"; //} //if(strErr!="") //{ // MessageBox.Show(this,strErr); // return; //} string qishu = peixunban_id; string kecheng = this.DropDownList2.SelectedValue; string jiangshi = this.DropDownList3.SelectedValue; decimal keshi = decimal.Parse(this.txtkeshi.Text); Maticsoft.Model.shangke model = new Maticsoft.Model.shangke(); model.qishu = qishu; model.kecheng = kecheng; model.jiangshi = jiangshi; model.keshi = keshi; Maticsoft.BLL.shangke bll = new Maticsoft.BLL.shangke(); bll.Add(model); string url = "add.aspx?peixunban_id=" + peixunban_id; Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", url); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.shangke GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,qishu,kecheng,jiangshi,keshi from shangke "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Maticsoft.Model.shangke model = new Maticsoft.Model.shangke(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }