/// <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");
}
