private void ShowInfo(int EID) { CHSS.BLL.CExpert bll = new CHSS.BLL.CExpert(); CHSS.Model.CExpert model = bll.GetModel(EID); this.txtEID.Text = model.EID.ToString(); this.txtExpeDescription.Text = model.ExpeDescription; this.txtExpeAddDate.Text = model.ExpeAddDate; this.txtExpeName.Text = model.ExpeName; this.txtExpePhone.Text = model.ExpePhone; this.txtExpePicURL.Text = model.ExpePicURL; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(CHSS.Model.CExpert model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CExpert set "); strSql.Append("ExpeDescription=@ExpeDescription,"); strSql.Append("ExpeAddDate=@ExpeAddDate,"); strSql.Append("ExpeName=@ExpeName,"); strSql.Append("ExpePhone=@ExpePhone,"); strSql.Append("ExpePicURL=@ExpePicURL,"); strSql.Append("UID=@UID"); strSql.Append(" where EID=@EID"); SqlParameter[] parameters = { new SqlParameter("@ExpeDescription", SqlDbType.NVarChar, 200), new SqlParameter("@ExpeAddDate", SqlDbType.NVarChar, 20), new SqlParameter("@ExpeName", SqlDbType.NVarChar, 20), new SqlParameter("@ExpePhone", SqlDbType.Char, 11), new SqlParameter("@ExpePicURL", SqlDbType.NVarChar, 50), new SqlParameter("@UID", SqlDbType.Int, 4), new SqlParameter("@EID", SqlDbType.Int, 4) }; parameters[0].Value = model.ExpeDescription; parameters[1].Value = model.ExpeAddDate; parameters[2].Value = model.ExpeName; parameters[3].Value = model.ExpePhone; parameters[4].Value = model.ExpePicURL; parameters[5].Value = model.UID; parameters[6].Value = model.EID; int rows = DBHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void btnSave_Click(object sender, EventArgs e) { string ExpeDescription = this.txtExpeDescription.Text; string ExpeAddDate = this.txtExpeAddDate.Text; string ExpeName = this.txtExpeName.Text; string ExpePhone = this.txtExpePhone.Text; string ExpePicURL = this.txtExpePicURL.Text; int UID = int.Parse(Session["UID"].ToString()); CHSS.Model.CExpert model = new CHSS.Model.CExpert(); model.ExpeDescription = ExpeDescription; model.ExpeAddDate = ExpeAddDate; model.ExpeName = ExpeName; model.ExpePhone = ExpePhone; model.ExpePicURL = ExpePicURL; model.UID = UID; CHSS.BLL.CExpert bll = new CHSS.BLL.CExpert(); bll.Add(model); Response.Redirect("Show.aspx?id=" + (bll.GetMaxId() - 1)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(CHSS.Model.CExpert model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CExpert("); strSql.Append("ExpeDescription,ExpeAddDate,ExpeName,ExpePhone,ExpePicURL,UID)"); strSql.Append(" values ("); strSql.Append("@ExpeDescription,@ExpeAddDate,@ExpeName,@ExpePhone,@ExpePicURL,@UID)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ExpeDescription", SqlDbType.NVarChar, 200), new SqlParameter("@ExpeAddDate", SqlDbType.NVarChar, 20), new SqlParameter("@ExpeName", SqlDbType.NVarChar, 20), new SqlParameter("@ExpePhone", SqlDbType.Char, 11), new SqlParameter("@ExpePicURL", SqlDbType.NVarChar, 50), new SqlParameter("@UID", SqlDbType.Int, 4) }; parameters[0].Value = model.ExpeDescription; parameters[1].Value = model.ExpeAddDate; parameters[2].Value = model.ExpeName; parameters[3].Value = model.ExpePhone; parameters[4].Value = model.ExpePicURL; parameters[5].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.CExpert DataRowToModel(DataRow row) { CHSS.Model.CExpert model = new CHSS.Model.CExpert(); if (row != null) { if (row["EID"] != null && row["EID"].ToString() != "") { model.EID = int.Parse(row["EID"].ToString()); } if (row["ExpeDescription"] != null) { model.ExpeDescription = row["ExpeDescription"].ToString(); } if (row["ExpeAddDate"] != null) { model.ExpeAddDate = row["ExpeAddDate"].ToString(); } if (row["ExpeName"] != null) { model.ExpeName = row["ExpeName"].ToString(); } if (row["ExpePhone"] != null) { model.ExpePhone = row["ExpePhone"].ToString(); } if (row["ExpePicURL"] != null) { model.ExpePicURL = row["ExpePicURL"].ToString(); } if (row["UID"] != null && row["UID"].ToString() != "") { model.UID = int.Parse(row["UID"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public CHSS.Model.CExpert GetModel(int EID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 EID,ExpeDescription,ExpeAddDate,ExpeName,ExpePhone,ExpePicURL,UID from CExpert "); strSql.Append(" where EID=@EID"); SqlParameter[] parameters = { new SqlParameter("@EID", SqlDbType.Int, 4) }; parameters[0].Value = EID; CHSS.Model.CExpert model = new CHSS.Model.CExpert(); DataSet ds = DBHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }