/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.BookTaskInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BookTaskInfo set "); strSql.Append("BookID=@BookID,"); strSql.Append("ReadDate=@ReadDate,"); strSql.Append("BookCode=@BookCode,"); strSql.Append("BookName=@BookName,"); strSql.Append("OperatorID=@OperatorID,"); strSql.Append("Remark=@Remark,"); strSql.Append("Routes=@Routes,"); strSql.Append("UserNum=@UserNum,"); strSql.Append("FactNum=@FactNum,"); strSql.Append("UpdateTime=@UpdateTime"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@BookID", SqlDbType.Int, 4), new SqlParameter("@ReadDate", SqlDbType.VarChar, 50), new SqlParameter("@BookCode", SqlDbType.VarChar, 50), new SqlParameter("@BookName", SqlDbType.VarChar, 50), new SqlParameter("@OperatorID", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.VarChar, 100), new SqlParameter("@Routes", SqlDbType.VarChar, 500), new SqlParameter("@UserNum", SqlDbType.Int, 4), new SqlParameter("@FactNum", SqlDbType.Int, 4), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.BookID; parameters[1].Value = model.ReadDate; parameters[2].Value = model.BookCode; parameters[3].Value = model.BookName; parameters[4].Value = model.OperatorID; parameters[5].Value = model.Remark; parameters[6].Value = model.Routes; parameters[7].Value = model.UserNum; parameters[8].Value = model.FactNum; parameters[9].Value = model.UpdateTime; parameters[10].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.BookTaskInfo DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.BookTaskInfo model = new WebDemo.Model.WebDemo.BookTaskInfo(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["BookID"] != null && row["BookID"].ToString() != "") { model.BookID = int.Parse(row["BookID"].ToString()); } if (row["ReadDate"] != null) { model.ReadDate = row["ReadDate"].ToString(); } if (row["BookCode"] != null) { model.BookCode = row["BookCode"].ToString(); } if (row["BookName"] != null) { model.BookName = row["BookName"].ToString(); } if (row["OperatorID"] != null && row["OperatorID"].ToString() != "") { model.OperatorID = int.Parse(row["OperatorID"].ToString()); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } if (row["Routes"] != null) { model.Routes = row["Routes"].ToString(); } if (row["UserNum"] != null && row["UserNum"].ToString() != "") { model.UserNum = int.Parse(row["UserNum"].ToString()); } if (row["FactNum"] != null && row["FactNum"].ToString() != "") { model.FactNum = int.Parse(row["FactNum"].ToString()); } if (row["UpdateTime"] != null && row["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString()); } } return(model); }
private void ShowInfo(int ID) { WebDemo.BLL.WebDemo.BookTaskInfo bll = new WebDemo.BLL.WebDemo.BookTaskInfo(); WebDemo.Model.WebDemo.BookTaskInfo model = bll.GetModel(ID); this.lblID.Text = model.ID.ToString(); this.txtBookID.Text = model.BookID.ToString(); this.txtReadDate.Text = model.ReadDate; this.txtBookCode.Text = model.BookCode; this.txtBookName.Text = model.BookName; this.txtOperatorID.Text = model.OperatorID.ToString(); this.txtRemark.Text = model.Remark; this.txtRoutes.Text = model.Routes; this.txtUserNum.Text = model.UserNum.ToString(); this.txtFactNum.Text = model.FactNum.ToString(); this.txtUpdateTime.Text = model.UpdateTime.ToString(); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(WebDemo.Model.WebDemo.BookTaskInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BookTaskInfo("); strSql.Append("BookID,ReadDate,BookCode,BookName,OperatorID,Remark,Routes,UserNum,FactNum,UpdateTime)"); strSql.Append(" values ("); strSql.Append("@BookID,@ReadDate,@BookCode,@BookName,@OperatorID,@Remark,@Routes,@UserNum,@FactNum,@UpdateTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@BookID", SqlDbType.Int, 4), new SqlParameter("@ReadDate", SqlDbType.VarChar, 50), new SqlParameter("@BookCode", SqlDbType.VarChar, 50), new SqlParameter("@BookName", SqlDbType.VarChar, 50), new SqlParameter("@OperatorID", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.VarChar, 100), new SqlParameter("@Routes", SqlDbType.VarChar, 500), new SqlParameter("@UserNum", SqlDbType.Int, 4), new SqlParameter("@FactNum", SqlDbType.Int, 4), new SqlParameter("@UpdateTime", SqlDbType.DateTime) }; parameters[0].Value = model.BookID; parameters[1].Value = model.ReadDate; parameters[2].Value = model.BookCode; parameters[3].Value = model.BookName; parameters[4].Value = model.OperatorID; parameters[5].Value = model.Remark; parameters[6].Value = model.Routes; parameters[7].Value = model.UserNum; parameters[8].Value = model.FactNum; parameters[9].Value = model.UpdateTime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.BookTaskInfo GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,BookID,ReadDate,BookCode,BookName,OperatorID,Remark,Routes,UserNum,FactNum,UpdateTime from BookTaskInfo "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; WebDemo.Model.WebDemo.BookTaskInfo model = new WebDemo.Model.WebDemo.BookTaskInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtBookID.Text)) { strErr += "BookID格式错误!\\n"; } if (this.txtReadDate.Text.Trim().Length == 0) { strErr += "ReadDate不能为空!\\n"; } if (this.txtBookCode.Text.Trim().Length == 0) { strErr += "BookCode不能为空!\\n"; } if (this.txtBookName.Text.Trim().Length == 0) { strErr += "BookName不能为空!\\n"; } if (!PageValidate.IsNumber(txtOperatorID.Text)) { strErr += "OperatorID格式错误!\\n"; } if (this.txtRemark.Text.Trim().Length == 0) { strErr += "Remark不能为空!\\n"; } if (this.txtRoutes.Text.Trim().Length == 0) { strErr += "Routes不能为空!\\n"; } if (!PageValidate.IsNumber(txtUserNum.Text)) { strErr += "UserNum格式错误!\\n"; } if (!PageValidate.IsNumber(txtFactNum.Text)) { strErr += "FactNum格式错误!\\n"; } if (!PageValidate.IsDateTime(txtUpdateTime.Text)) { strErr += "UpdateTime格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int BookID = int.Parse(this.txtBookID.Text); string ReadDate = this.txtReadDate.Text; string BookCode = this.txtBookCode.Text; string BookName = this.txtBookName.Text; int OperatorID = int.Parse(this.txtOperatorID.Text); string Remark = this.txtRemark.Text; string Routes = this.txtRoutes.Text; int UserNum = int.Parse(this.txtUserNum.Text); int FactNum = int.Parse(this.txtFactNum.Text); DateTime UpdateTime = DateTime.Parse(this.txtUpdateTime.Text); WebDemo.Model.WebDemo.BookTaskInfo model = new WebDemo.Model.WebDemo.BookTaskInfo(); model.BookID = BookID; model.ReadDate = ReadDate; model.BookCode = BookCode; model.BookName = BookName; model.OperatorID = OperatorID; model.Remark = Remark; model.Routes = Routes; model.UserNum = UserNum; model.FactNum = FactNum; model.UpdateTime = UpdateTime; WebDemo.BLL.WebDemo.BookTaskInfo bll = new WebDemo.BLL.WebDemo.BookTaskInfo(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }