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