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