/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.Workers model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Workers set "); strSql.Append("WorkerName=@WorkerName,"); strSql.Append("WorkerPhone=@WorkerPhone,"); strSql.Append("Remark=@Remark"); strSql.Append(" where WorkerID=@WorkerID"); SqlParameter[] parameters = { new SqlParameter("@WorkerName", SqlDbType.VarChar, 50), new SqlParameter("@WorkerPhone", SqlDbType.VarChar, 50), new SqlParameter("@Remark", SqlDbType.VarChar, 200), new SqlParameter("@WorkerID", SqlDbType.Int, 4) }; parameters[0].Value = model.WorkerName; parameters[1].Value = model.WorkerPhone; parameters[2].Value = model.Remark; parameters[3].Value = model.WorkerID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(WebDemo.Model.WebDemo.Workers model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Workers("); strSql.Append("WorkerName,WorkerPhone,Remark)"); strSql.Append(" values ("); strSql.Append("@WorkerName,@WorkerPhone,@Remark)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@WorkerName", SqlDbType.VarChar, 50), new SqlParameter("@WorkerPhone", SqlDbType.VarChar, 50), new SqlParameter("@Remark", SqlDbType.VarChar, 200) }; parameters[0].Value = model.WorkerName; parameters[1].Value = model.WorkerPhone; parameters[2].Value = model.Remark; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtWorkerName.Text.Trim().Length == 0) { strErr += "WorkerName不能为空!\\n"; } if (this.txtWorkerPhone.Text.Trim().Length == 0) { strErr += "WorkerPhone不能为空!\\n"; } if (this.txtRemark.Text.Trim().Length == 0) { strErr += "Remark不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string WorkerName = this.txtWorkerName.Text; string WorkerPhone = this.txtWorkerPhone.Text; string Remark = this.txtRemark.Text; WebDemo.Model.WebDemo.Workers model = new WebDemo.Model.WebDemo.Workers(); model.WorkerName = WorkerName; model.WorkerPhone = WorkerPhone; model.Remark = Remark; WebDemo.BLL.WebDemo.Workers bll = new WebDemo.BLL.WebDemo.Workers(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
private void ShowInfo(int WorkerID) { WebDemo.BLL.WebDemo.Workers bll = new WebDemo.BLL.WebDemo.Workers(); WebDemo.Model.WebDemo.Workers model = bll.GetModel(WorkerID); this.lblWorkerID.Text = model.WorkerID.ToString(); this.lblWorkerName.Text = model.WorkerName; this.lblWorkerPhone.Text = model.WorkerPhone; this.lblRemark.Text = model.Remark; }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.Workers DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.Workers model = new WebDemo.Model.WebDemo.Workers(); if (row != null) { if (row["WorkerID"] != null && row["WorkerID"].ToString() != "") { model.WorkerID = int.Parse(row["WorkerID"].ToString()); } if (row["WorkerName"] != null) { model.WorkerName = row["WorkerName"].ToString(); } if (row["WorkerPhone"] != null) { model.WorkerPhone = row["WorkerPhone"].ToString(); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.Workers GetModel(int WorkerID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 WorkerID,WorkerName,WorkerPhone,Remark from Workers "); strSql.Append(" where WorkerID=@WorkerID"); SqlParameter[] parameters = { new SqlParameter("@WorkerID", SqlDbType.Int, 4) }; parameters[0].Value = WorkerID; WebDemo.Model.WebDemo.Workers model = new WebDemo.Model.WebDemo.Workers(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }