/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.BookInfo DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.BookInfo model = new WebDemo.Model.WebDemo.BookInfo(); if (row != null) { if (row["BookID"] != null && row["BookID"].ToString() != "") { model.BookID = int.Parse(row["BookID"].ToString()); } if (row["DeptIDs"] != null) { model.DeptIDs = row["DeptIDs"].ToString(); } if (row["BookName"] != null) { model.BookName = row["BookName"].ToString(); } if (row["WorkerID"] != null && row["WorkerID"].ToString() != "") { model.WorkerID = int.Parse(row["WorkerID"].ToString()); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } if (row["BookCode"] != null) { model.BookCode = row["BookCode"].ToString(); } if (row["Routes"] != null) { model.Routes = row["Routes"].ToString(); } if (row["ReadDay"] != null && row["ReadDay"].ToString() != "") { model.ReadDay = int.Parse(row["ReadDay"].ToString()); } if (row["ReadType"] != null && row["ReadType"].ToString() != "") { model.ReadType = int.Parse(row["ReadType"].ToString()); } if (row["UserNum"] != null && row["UserNum"].ToString() != "") { model.UserNum = int.Parse(row["UserNum"].ToString()); } if (row["UpdateTime"] != null && row["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString()); } if (row["AutoReadBeginDate"] != null) { model.AutoReadBeginDate = row["AutoReadBeginDate"].ToString(); } if (row["AutoReadEndDate"] != null) { model.AutoReadEndDate = row["AutoReadEndDate"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.BookInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BookInfo set "); strSql.Append("DeptIDs=@DeptIDs,"); strSql.Append("BookName=@BookName,"); strSql.Append("WorkerID=@WorkerID,"); strSql.Append("Remark=@Remark,"); strSql.Append("BookCode=@BookCode,"); strSql.Append("Routes=@Routes,"); strSql.Append("ReadDay=@ReadDay,"); strSql.Append("ReadType=@ReadType,"); strSql.Append("UserNum=@UserNum,"); strSql.Append("UpdateTime=@UpdateTime,"); strSql.Append("AutoReadBeginDate=@AutoReadBeginDate,"); strSql.Append("AutoReadEndDate=@AutoReadEndDate"); strSql.Append(" where BookID=@BookID"); SqlParameter[] parameters = { new SqlParameter("@DeptIDs", SqlDbType.VarChar, 500), new SqlParameter("@BookName", SqlDbType.VarChar, 50), new SqlParameter("@WorkerID", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.VarChar, 200), new SqlParameter("@BookCode", SqlDbType.VarChar, 50), new SqlParameter("@Routes", SqlDbType.VarChar, 500), new SqlParameter("@ReadDay", SqlDbType.Int, 4), new SqlParameter("@ReadType", SqlDbType.Int, 4), new SqlParameter("@UserNum", SqlDbType.Int, 4), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@AutoReadBeginDate", SqlDbType.VarChar, 10), new SqlParameter("@AutoReadEndDate", SqlDbType.VarChar, 10), new SqlParameter("@BookID", SqlDbType.Int, 4) }; parameters[0].Value = model.DeptIDs; parameters[1].Value = model.BookName; parameters[2].Value = model.WorkerID; parameters[3].Value = model.Remark; parameters[4].Value = model.BookCode; parameters[5].Value = model.Routes; parameters[6].Value = model.ReadDay; parameters[7].Value = model.ReadType; parameters[8].Value = model.UserNum; parameters[9].Value = model.UpdateTime; parameters[10].Value = model.AutoReadBeginDate; parameters[11].Value = model.AutoReadEndDate; parameters[12].Value = model.BookID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(WebDemo.Model.WebDemo.BookInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BookInfo("); strSql.Append("DeptIDs,BookName,WorkerID,Remark,BookCode,Routes,ReadDay,ReadType,UserNum,UpdateTime,AutoReadBeginDate,AutoReadEndDate)"); strSql.Append(" values ("); strSql.Append("@DeptIDs,@BookName,@WorkerID,@Remark,@BookCode,@Routes,@ReadDay,@ReadType,@UserNum,@UpdateTime,@AutoReadBeginDate,@AutoReadEndDate)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@DeptIDs", SqlDbType.VarChar, 500), new SqlParameter("@BookName", SqlDbType.VarChar, 50), new SqlParameter("@WorkerID", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.VarChar, 200), new SqlParameter("@BookCode", SqlDbType.VarChar, 50), new SqlParameter("@Routes", SqlDbType.VarChar, 500), new SqlParameter("@ReadDay", SqlDbType.Int, 4), new SqlParameter("@ReadType", SqlDbType.Int, 4), new SqlParameter("@UserNum", SqlDbType.Int, 4), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@AutoReadBeginDate", SqlDbType.VarChar, 10), new SqlParameter("@AutoReadEndDate", SqlDbType.VarChar, 10) }; parameters[0].Value = model.DeptIDs; parameters[1].Value = model.BookName; parameters[2].Value = model.WorkerID; parameters[3].Value = model.Remark; parameters[4].Value = model.BookCode; parameters[5].Value = model.Routes; parameters[6].Value = model.ReadDay; parameters[7].Value = model.ReadType; parameters[8].Value = model.UserNum; parameters[9].Value = model.UpdateTime; parameters[10].Value = model.AutoReadBeginDate; parameters[11].Value = model.AutoReadEndDate; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
private void ShowInfo(int BookID) { WebDemo.BLL.WebDemo.BookInfo bll = new WebDemo.BLL.WebDemo.BookInfo(); WebDemo.Model.WebDemo.BookInfo model = bll.GetModel(BookID); this.lblBookID.Text = model.BookID.ToString(); this.lblDeptIDs.Text = model.DeptIDs; this.lblBookName.Text = model.BookName; this.lblWorkerID.Text = model.WorkerID.ToString(); this.lblRemark.Text = model.Remark; this.lblBookCode.Text = model.BookCode; this.lblRoutes.Text = model.Routes; this.lblReadDay.Text = model.ReadDay.ToString(); this.lblReadType.Text = model.ReadType.ToString(); this.lblUserNum.Text = model.UserNum.ToString(); this.lblUpdateTime.Text = model.UpdateTime.ToString(); this.lblAutoReadBeginDate.Text = model.AutoReadBeginDate; this.lblAutoReadEndDate.Text = model.AutoReadEndDate; }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.BookInfo GetModel(int BookID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 BookID,DeptIDs,BookName,WorkerID,Remark,BookCode,Routes,ReadDay,ReadType,UserNum,UpdateTime,AutoReadBeginDate,AutoReadEndDate from BookInfo "); strSql.Append(" where BookID=@BookID"); SqlParameter[] parameters = { new SqlParameter("@BookID", SqlDbType.Int, 4) }; parameters[0].Value = BookID; WebDemo.Model.WebDemo.BookInfo model = new WebDemo.Model.WebDemo.BookInfo(); 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(this.txtDeptIDs.Text.Trim().Length==0) { strErr+="DeptIDs不能为空!\\n"; } if(this.txtBookName.Text.Trim().Length==0) { strErr+="BookName不能为空!\\n"; } if(!PageValidate.IsNumber(txtWorkerID.Text)) { strErr+="WorkerID格式错误!\\n"; } if(this.txtRemark.Text.Trim().Length==0) { strErr+="Remark不能为空!\\n"; } if(this.txtBookCode.Text.Trim().Length==0) { strErr+="BookCode不能为空!\\n"; } if(this.txtRoutes.Text.Trim().Length==0) { strErr+="Routes不能为空!\\n"; } if(!PageValidate.IsNumber(txtReadDay.Text)) { strErr+="ReadDay格式错误!\\n"; } if(!PageValidate.IsNumber(txtReadType.Text)) { strErr+="ReadType格式错误!\\n"; } if(!PageValidate.IsNumber(txtUserNum.Text)) { strErr+="UserNum格式错误!\\n"; } if(!PageValidate.IsDateTime(txtUpdateTime.Text)) { strErr+="UpdateTime格式错误!\\n"; } if(this.txtAutoReadBeginDate.Text.Trim().Length==0) { strErr+="AutoReadBeginDate不能为空!\\n"; } if(this.txtAutoReadEndDate.Text.Trim().Length==0) { strErr+="AutoReadEndDate不能为空!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } string DeptIDs=this.txtDeptIDs.Text; string BookName=this.txtBookName.Text; int WorkerID=int.Parse(this.txtWorkerID.Text); string Remark=this.txtRemark.Text; string BookCode=this.txtBookCode.Text; string Routes=this.txtRoutes.Text; int ReadDay=int.Parse(this.txtReadDay.Text); int ReadType=int.Parse(this.txtReadType.Text); int UserNum=int.Parse(this.txtUserNum.Text); DateTime UpdateTime=DateTime.Parse(this.txtUpdateTime.Text); string AutoReadBeginDate=this.txtAutoReadBeginDate.Text; string AutoReadEndDate=this.txtAutoReadEndDate.Text; WebDemo.Model.WebDemo.BookInfo model=new WebDemo.Model.WebDemo.BookInfo(); model.DeptIDs=DeptIDs; model.BookName=BookName; model.WorkerID=WorkerID; model.Remark=Remark; model.BookCode=BookCode; model.Routes=Routes; model.ReadDay=ReadDay; model.ReadType=ReadType; model.UserNum=UserNum; model.UpdateTime=UpdateTime; model.AutoReadBeginDate=AutoReadBeginDate; model.AutoReadEndDate=AutoReadEndDate; WebDemo.BLL.WebDemo.BookInfo bll=new WebDemo.BLL.WebDemo.BookInfo(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","add.aspx"); }