/// <summary> /// 对象实体绑定数据 /// </summary> public NoName.NetShop.Model.CategoryModel ReaderBind(IDataReader dataReader) { NoName.NetShop.Model.CategoryModel model = new NoName.NetShop.Model.CategoryModel(); object ojb; ojb = dataReader["CateId"]; if (ojb != null && ojb != DBNull.Value) { model.CateId = (int)ojb; } model.CateName = dataReader["CateName"].ToString(); model.CatePath = dataReader["CatePath"].ToString(); ojb = dataReader["Status"]; if (ojb != null && ojb != DBNull.Value) { model.Status = (int)ojb; } model.PriceRange = dataReader["PriceRange"].ToString(); ojb = dataReader["IsHide"]; if (ojb != null && ojb != DBNull.Value) { model.IsHide = (bool)ojb; } ojb = dataReader["CateLevel"]; if (ojb != null && ojb != DBNull.Value) { model.CateLevel = (int)ojb; } return(model); }
private void ShowInfo(int CateId) { NoName.NetShop.BLL.CategoryModelBll bll = new NoName.NetShop.BLL.CategoryModelBll(); NoName.NetShop.Model.CategoryModel model = bll.GetModel(CateId); this.lblCateName.Text = model.CateName; this.lblCatePath.Text = model.CatePath; this.lblStatus.Text = model.Status.ToString(); this.lblPriceRange.Text = model.PriceRange; this.chkIsHide.Checked = model.IsHide; this.lblCateLevel.Text = model.CateLevel.ToString(); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(NoName.NetShop.Model.CategoryModel model) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("UP_pdCategory_Update"); db.AddInParameter(dbCommand, "CateId", DbType.Int32, model.CateId); db.AddInParameter(dbCommand, "CateName", DbType.AnsiString, model.CateName); db.AddInParameter(dbCommand, "CatePath", DbType.AnsiString, model.CatePath); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); db.AddInParameter(dbCommand, "PriceRange", DbType.AnsiString, model.PriceRange); db.AddInParameter(dbCommand, "IsHide", DbType.Boolean, model.IsHide); db.AddInParameter(dbCommand, "CateLevel", DbType.Byte, model.CateLevel); db.ExecuteNonQuery(dbCommand); }
protected void btnAdd_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtCateName.Text == "") { strErr += "CateName不能为空!\\n"; } if (this.txtCatePath.Text == "") { strErr += "CatePath不能为空!\\n"; } if (!PageValidate.IsNumber(txtStatus.Text)) { strErr += "Status不是数字!\\n"; } if (this.txtPriceRange.Text == "") { strErr += "PriceRange不能为空!\\n"; } if (!PageValidate.IsNumber(txtCateLevel.Text)) { strErr += "CateLevel不是数字!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string CateName = this.txtCateName.Text; string CatePath = this.txtCatePath.Text; int Status = int.Parse(this.txtStatus.Text); string PriceRange = this.txtPriceRange.Text; bool IsHide = this.chkIsHide.Checked; int CateLevel = int.Parse(this.txtCateLevel.Text); NoName.NetShop.Model.CategoryModel model = new NoName.NetShop.Model.CategoryModel(); model.CateName = CateName; model.CatePath = CatePath; model.Status = Status; model.PriceRange = PriceRange; model.IsHide = IsHide; model.CateLevel = CateLevel; NoName.NetShop.BLL.CategoryModelBll bll = new NoName.NetShop.BLL.CategoryModelBll(); bll.Update(model); }
protected void btnAdd_Click(object sender, EventArgs e) { string strErr=""; if(this.txtCateName.Text =="") { strErr+="CateName����Ϊ�գ�\\n"; } if(this.txtCatePath.Text =="") { strErr+="CatePath����Ϊ�գ�\\n"; } if(!PageValidate.IsNumber(txtStatus.Text)) { strErr+="Status�������֣�\\n"; } if(this.txtPriceRange.Text =="") { strErr+="PriceRange����Ϊ�գ�\\n"; } if(!PageValidate.IsNumber(txtCateLevel.Text)) { strErr+="CateLevel�������֣�\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } string CateName=this.txtCateName.Text; string CatePath=this.txtCatePath.Text; int Status=int.Parse(this.txtStatus.Text); string PriceRange=this.txtPriceRange.Text; bool IsHide=this.chkIsHide.Checked; int CateLevel=int.Parse(this.txtCateLevel.Text); NoName.NetShop.Model.CategoryModel model=new NoName.NetShop.Model.CategoryModel(); model.CateName=CateName; model.CatePath=CatePath; model.Status=Status; model.PriceRange=PriceRange; model.IsHide=IsHide; model.CateLevel=CateLevel; NoName.NetShop.BLL.CategoryModelBll bll=new NoName.NetShop.BLL.CategoryModelBll(); bll.Update(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public NoName.NetShop.Model.CategoryModel GetModel(int CateId) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("UP_pdCategory_GetModel"); db.AddInParameter(dbCommand, "CateId", DbType.Int32, CateId); NoName.NetShop.Model.CategoryModel model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// ����ʵ������� /// </summary> public NoName.NetShop.Model.CategoryModel ReaderBind(IDataReader dataReader) { NoName.NetShop.Model.CategoryModel model=new NoName.NetShop.Model.CategoryModel(); object ojb; ojb = dataReader["CateId"]; if(ojb != null && ojb != DBNull.Value) { model.CateId=(int)ojb; } model.CateName=dataReader["CateName"].ToString(); model.CatePath=dataReader["CatePath"].ToString(); ojb = dataReader["Status"]; if(ojb != null && ojb != DBNull.Value) { model.Status=(int)ojb; } model.PriceRange=dataReader["PriceRange"].ToString(); ojb = dataReader["IsHide"]; if(ojb != null && ojb != DBNull.Value) { model.IsHide=(bool)ojb; } ojb = dataReader["CateLevel"]; if(ojb != null && ojb != DBNull.Value) { model.CateLevel=(int)ojb; } return model; }