protected void btnAdd_Click(object sender, EventArgs e) { string BrandId = this.txtBrandId.Text; string Name = this.txtName.Text; string Descn = this.txtDescn.Text; string CategoryId = DropCategory.SelectedValue; Maticsoft.Model.Brand model = new Maticsoft.Model.Brand(); model.BrandId = BrandId; model.Name = Name; model.Descn = Descn; model.CategoryId = CategoryId; Maticsoft.BLL.Products.Brand bll = new Maticsoft.BLL.Products.Brand(); if (bll.Exists(BrandId)) { lblMsg.Visible = true; lblMsg.Text = "±àºÅÒѾ´æÔÚ£¡"; } else { bll.Add(model); if (chkAddContinue.Checked) { Response.Redirect("Add.aspx"); } else { Response.Redirect("index.aspx"); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Brand GetModel(string BrandId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from P_Brand "); strSql.Append(" where BrandId=@BrandId"); SqlParameter[] parameters = { new SqlParameter("@BrandId", SqlDbType.VarChar) }; parameters[0].Value = BrandId; Maticsoft.Model.Brand model = new Maticsoft.Model.Brand(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); model.BrandId = BrandId; if (ds.Tables[0].Rows.Count > 0) { model.Name = ds.Tables[0].Rows[0]["Name"].ToString(); model.Descn = ds.Tables[0].Rows[0]["Descn"].ToString(); model.CategoryId = ds.Tables[0].Rows[0]["CategoryId"].ToString(); return(model); } else { return(null); } }
private void ShowInfo(string BrandId) { Maticsoft.BLL.Products.Brand bll = new Maticsoft.BLL.Products.Brand(); Maticsoft.Model.Brand model = bll.GetModel(BrandId); this.lblBrandId.Text = model.BrandId; this.txtName.Text = model.Name; this.txtDescn.Text = model.Descn; this.Label1.Text = model.CategoryId; }
protected void btnAdd_Click(object sender, EventArgs e) { string BrandId = this.lblBrandId.Text; string Name = this.txtName.Text; string Descn = this.txtDescn.Text; Maticsoft.Model.Brand model = new Maticsoft.Model.Brand(); model.CategoryId = Label1.Text; model.BrandId = BrandId; model.Name = Name; model.Descn = Descn; Maticsoft.BLL.Products.Brand bll = new Maticsoft.BLL.Products.Brand(); bll.Update(model); Response.Redirect("index.aspx"); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(Maticsoft.Model.Brand model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into P_Brand("); strSql.Append("BrandId,Name,Descn,CategoryId)"); strSql.Append(" values ("); strSql.Append("@BrandId,@Name,@Descn,@CategoryId)"); SqlParameter[] parameters = { new SqlParameter("@BrandId", SqlDbType.VarChar, 20), new SqlParameter("@Name", SqlDbType.VarChar, 80), new SqlParameter("@Descn", SqlDbType.VarChar, 255), new SqlParameter("@CategoryId", SqlDbType.VarChar, 20) }; parameters[0].Value = model.BrandId; parameters[1].Value = model.Name; parameters[2].Value = model.Descn; parameters[3].Value = model.CategoryId; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Maticsoft.Model.Brand model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update P_Brand set "); strSql.Append("Name=@Name,"); strSql.Append("Descn=@Descn,"); strSql.Append("CategoryId=@CategoryId"); strSql.Append(" where BrandId=@BrandId"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.VarChar, 80), new SqlParameter("@Descn", SqlDbType.VarChar, 255), new SqlParameter("@BrandId", SqlDbType.VarChar, 20), new SqlParameter("@CategoryId", SqlDbType.VarChar, 20) }; parameters[0].Value = model.Name; parameters[1].Value = model.Descn; parameters[2].Value = model.BrandId; parameters[3].Value = model.CategoryId; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public Maticsoft.Model.Brand GetModel(string BrandId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from P_Brand "); strSql.Append(" where BrandId=@BrandId"); SqlParameter[] parameters = { new SqlParameter("@BrandId", SqlDbType.VarChar)}; parameters[0].Value = BrandId; Maticsoft.Model.Brand model = new Maticsoft.Model.Brand(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); model.BrandId = BrandId; if (ds.Tables[0].Rows.Count > 0) { model.Name = ds.Tables[0].Rows[0]["Name"].ToString(); model.Descn = ds.Tables[0].Rows[0]["Descn"].ToString(); model.CategoryId = ds.Tables[0].Rows[0]["CategoryId"].ToString(); return model; } else { return null; } }