/// <summary> /// 更新一条数据 /// </summary> public bool Update(CHSS.Model.CMedicalEquipment model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CMedicalEquipment set "); strSql.Append("MediDescription=@MediDescription,"); strSql.Append("MediAddDate=@MediAddDate,"); strSql.Append("MediName=@MediName,"); strSql.Append("UID=@UID"); strSql.Append(" where MID=@MID"); SqlParameter[] parameters = { new SqlParameter("@MediDescription", SqlDbType.NVarChar, 200), new SqlParameter("@MediAddDate", SqlDbType.NVarChar, 20), new SqlParameter("@MediName", SqlDbType.NVarChar, 20), new SqlParameter("@UID", SqlDbType.Int, 4), new SqlParameter("@MID", SqlDbType.Int, 4) }; parameters[0].Value = model.MediDescription; parameters[1].Value = model.MediAddDate; parameters[2].Value = model.MediName; parameters[3].Value = model.UID; parameters[4].Value = model.MID; int rows = DBHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(CHSS.Model.CMedicalEquipment model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CMedicalEquipment("); strSql.Append("MediDescription,MediAddDate,MediName,UID)"); strSql.Append(" values ("); strSql.Append("@MediDescription,@MediAddDate,@MediName,@UID)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MediDescription", SqlDbType.NVarChar, 200), new SqlParameter("@MediAddDate", SqlDbType.NVarChar, 20), new SqlParameter("@MediName", SqlDbType.NVarChar, 20), new SqlParameter("@UID", SqlDbType.Int, 4) }; parameters[0].Value = model.MediDescription; parameters[1].Value = model.MediAddDate; parameters[2].Value = model.MediName; parameters[3].Value = model.UID; object obj = DBHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public CHSS.Model.CMedicalEquipment DataRowToModel(DataRow row) { CHSS.Model.CMedicalEquipment model = new CHSS.Model.CMedicalEquipment(); if (row != null) { if (row["MID"] != null && row["MID"].ToString() != "") { model.MID = int.Parse(row["MID"].ToString()); } if (row["MediDescription"] != null) { model.MediDescription = row["MediDescription"].ToString(); } if (row["MediAddDate"] != null) { model.MediAddDate = row["MediAddDate"].ToString(); } if (row["MediName"] != null) { model.MediName = row["MediName"].ToString(); } if (row["UID"] != null && row["UID"].ToString() != "") { model.UID = int.Parse(row["UID"].ToString()); } } return(model); }
private void ShowInfo(int MID) { CHSS.BLL.CMedicalEquipment bll = new CHSS.BLL.CMedicalEquipment(); CHSS.Model.CMedicalEquipment model = bll.GetModel(MID); this.txtMID.Text = model.MID.ToString(); this.txtMediDescription.Text = model.MediDescription; this.txtMediAddDate.Text = model.MediAddDate; this.txtMediName.Text = model.MediName; }
protected void btnSave_Click(object sender, EventArgs e) { string MediDescription = this.txtMediDescription.Text; string MediAddDate = this.txtMediAddDate.Text; string MediName = this.txtMediName.Text; int UID = int.Parse(Session["UID"].ToString()); CHSS.Model.CMedicalEquipment model = new CHSS.Model.CMedicalEquipment(); model.MediDescription = MediDescription; model.MediAddDate = MediAddDate; model.MediName = MediName; model.UID = UID; CHSS.BLL.CMedicalEquipment bll = new CHSS.BLL.CMedicalEquipment(); bll.Add(model); Response.Redirect("Show.aspx?id=" + (bll.GetMaxId() - 1)); }
public void btnSave_Click(object sender, EventArgs e) { int MID = int.Parse(this.txtMID.Text); string MediDescription = this.txtMediDescription.Text; string MediAddDate = this.txtMediAddDate.Text; string MediName = this.txtMediName.Text; int UID = int.Parse(Session["UID"].ToString()); CHSS.Model.CMedicalEquipment model = new CHSS.Model.CMedicalEquipment(); model.MID = MID; model.MediDescription = MediDescription; model.MediAddDate = MediAddDate; model.MediName = MediName; model.UID = UID; CHSS.BLL.CMedicalEquipment bll = new CHSS.BLL.CMedicalEquipment(); bll.Update(model); Response.Redirect("Show.aspx?id=" + MID); }
/// <summary> /// 得到一个对象实体 /// </summary> public CHSS.Model.CMedicalEquipment GetModel(int MID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 MID,MediDescription,MediAddDate,MediName,UID from CMedicalEquipment "); strSql.Append(" where MID=@MID"); SqlParameter[] parameters = { new SqlParameter("@MID", SqlDbType.Int, 4) }; parameters[0].Value = MID; CHSS.Model.CMedicalEquipment model = new CHSS.Model.CMedicalEquipment(); DataSet ds = DBHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }