private void ShowInfo() { YueDuLibrary.BLL.Library bll = new YueDuLibrary.BLL.Library(); YueDuLibrary.Model.Library model = bll.GetModel(); this.txtlibarayName.Text = model.libarayName; this.txtcurator.Text = model.curator; this.txttel.Text = model.tel; this.txtAddresss.Text = model.Addresss; this.txtemail.Text = model.email; this.txturl.Text = model.url; this.txtcreateDate.Text = model.createDate.ToString(); this.txtremark.Text = model.remark; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(YueDuLibrary.Model.Library model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Library set "); strSql.Append("libarayName=@libarayName,"); strSql.Append("curator=@curator,"); strSql.Append("tel=@tel,"); strSql.Append("Addresss=@Addresss,"); strSql.Append("email=@email,"); strSql.Append("url=@url,"); strSql.Append("createDate=@createDate,"); strSql.Append("remark=@remark"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@libarayName", SqlDbType.VarChar, 50), new SqlParameter("@curator", SqlDbType.VarChar, 20), new SqlParameter("@tel", SqlDbType.VarChar, 20), new SqlParameter("@Addresss", SqlDbType.VarChar, 100), new SqlParameter("@email", SqlDbType.VarChar, 100), new SqlParameter("@url", SqlDbType.VarChar, 100), new SqlParameter("@createDate", SqlDbType.DateTime), new SqlParameter("@remark", SqlDbType.Text) }; parameters[0].Value = model.libarayName; parameters[1].Value = model.curator; parameters[2].Value = model.tel; parameters[3].Value = model.Addresss; parameters[4].Value = model.email; parameters[5].Value = model.url; parameters[6].Value = model.createDate; parameters[7].Value = model.remark; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public YueDuLibrary.Model.Library DataRowToModel(DataRow row) { YueDuLibrary.Model.Library model = new YueDuLibrary.Model.Library(); if (row != null) { if (row["libarayName"] != null) { model.libarayName = row["libarayName"].ToString(); } if (row["curator"] != null) { model.curator = row["curator"].ToString(); } if (row["tel"] != null) { model.tel = row["tel"].ToString(); } if (row["Addresss"] != null) { model.Addresss = row["Addresss"].ToString(); } if (row["email"] != null) { model.email = row["email"].ToString(); } if (row["url"] != null) { model.url = row["url"].ToString(); } if (row["createDate"] != null && row["createDate"].ToString() != "") { model.createDate = DateTime.Parse(row["createDate"].ToString()); } if (row["remark"] != null) { model.remark = row["remark"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(YueDuLibrary.Model.Library model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Library("); strSql.Append("libarayName,curator,tel,Addresss,email,url,createDate,remark)"); strSql.Append(" values ("); strSql.Append("@libarayName,@curator,@tel,@Addresss,@email,@url,@createDate,@remark)"); SqlParameter[] parameters = { new SqlParameter("@libarayName", SqlDbType.VarChar, 50), new SqlParameter("@curator", SqlDbType.VarChar, 20), new SqlParameter("@tel", SqlDbType.VarChar, 20), new SqlParameter("@Addresss", SqlDbType.VarChar, 100), new SqlParameter("@email", SqlDbType.VarChar, 100), new SqlParameter("@url", SqlDbType.VarChar, 100), new SqlParameter("@createDate", SqlDbType.DateTime), new SqlParameter("@remark", SqlDbType.Text) }; parameters[0].Value = model.libarayName; parameters[1].Value = model.curator; parameters[2].Value = model.tel; parameters[3].Value = model.Addresss; parameters[4].Value = model.email; parameters[5].Value = model.url; parameters[6].Value = model.createDate; parameters[7].Value = model.remark; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public YueDuLibrary.Model.Library GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 libarayName,curator,tel,Addresss,email,url,createDate,remark from Library "); strSql.Append(" where "); SqlParameter[] parameters = { }; YueDuLibrary.Model.Library model = new YueDuLibrary.Model.Library(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtlibarayName.Text.Trim().Length == 0) { strErr += "libarayName不能为空!\\n"; } if (this.txtcurator.Text.Trim().Length == 0) { strErr += "curator不能为空!\\n"; } if (this.txttel.Text.Trim().Length == 0) { strErr += "tel不能为空!\\n"; } if (this.txtAddresss.Text.Trim().Length == 0) { strErr += "Addresss不能为空!\\n"; } if (this.txtemail.Text.Trim().Length == 0) { strErr += "email不能为空!\\n"; } if (this.txturl.Text.Trim().Length == 0) { strErr += "url不能为空!\\n"; } if (!PageValidate.IsDateTime(txtcreateDate.Text)) { strErr += "createDate格式错误!\\n"; } if (this.txtremark.Text.Trim().Length == 0) { strErr += "remark不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string libarayName = this.txtlibarayName.Text; string curator = this.txtcurator.Text; string tel = this.txttel.Text; string Addresss = this.txtAddresss.Text; string email = this.txtemail.Text; string url = this.txturl.Text; DateTime createDate = DateTime.Parse(this.txtcreateDate.Text); string remark = this.txtremark.Text; YueDuLibrary.Model.Library model = new YueDuLibrary.Model.Library(); model.libarayName = libarayName; model.curator = curator; model.tel = tel; model.Addresss = Addresss; model.email = email; model.url = url; model.createDate = createDate; model.remark = remark; YueDuLibrary.BLL.Library bll = new YueDuLibrary.BLL.Library(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }