protected void btnAdd_Click(object sender, EventArgs e)
{
string ErrorMessage = String.Empty;
if (String.IsNullOrEmpty(txtCateName.Text))
{
ErrorMessage += "分类名称不可为空";
}
if (!String.IsNullOrEmpty(ErrorMessage))
{
MessageBox.Show(this, ErrorMessage);
return;
}
MagicCategoryModel model = new MagicCategoryModel();
MagicCategoryModel ParentModel = bll.GetModel(ParentID);
model.CategoryID = CommDataHelper.GetNewSerialNum(AppType.MagicWorld);
model.CategoryLevel = ParentModel == null?0:ParentModel.CategoryLevel + 1;
model.CategoryName = txtCateName.Text;
model.CategoryPath = ParentModel == null?model.CategoryID.ToString() : ParentModel.CategoryPath + "/" + model.CategoryID;
model.IsHide = chkIsHide.Checked;
model.ParentID = ParentID;
model.ShowOrder = model.CategoryID;
model.Status = 0;
bll.Add(model);
MessageBox.Show(this, "添加成功！");
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script type=\"text/javascript\">window.parent.location=window.parent.location+'?_=" + DateTime.Now.Ticks + "'</script>");
}
private void BindData()
{
MagicCategoryModel model = bll.GetModel(CategoryID);
txtCateName.Text = model.CategoryName;
chkIsHide.Checked = model.IsHide;
}
protected void BindData()
{
if (CategoryID != -1)
{
MagicCategoryBll CategoryBll = new MagicCategoryBll();
MagicCategoryModel Category = CategoryBll.GetModel(CategoryID);
TextBox_Category.Text = Category.CategoryName;
}
else
{
throw new Exception("未选择分类");
}
}
private MagicCategoryModel BindModel(DataRow row)
{
MagicCategoryModel model = new MagicCategoryModel();
model.CategoryID = Convert.ToInt32(row["categoryid"]);
model.CategoryLevel = Convert.ToInt32(row["categorylevel"]);
model.CategoryName = Convert.ToString(row["categoryname"]);
model.CategoryPath = Convert.ToString(row["categorypath"]);
model.IsHide = Convert.ToBoolean(row["ishide"]);
model.ParentID = Convert.ToInt32(row["parentid"]);
model.ShowOrder = Convert.ToInt32(row["showorder"]);
model.Status = Convert.ToInt32(row["status"]);
return(model);
}
public void Update(MagicCategoryModel model)
{
DbCommand Command = dbw.GetStoredProcCommand("UP_mwCategory_Update");
dbw.AddInParameter(Command, "@CategoryID", DbType.Int32, model.CategoryID);
dbw.AddInParameter(Command, "@CategoryName", DbType.String, model.CategoryName);
dbw.AddInParameter(Command, "@CategoryPath", DbType.String, model.CategoryPath);
dbw.AddInParameter(Command, "@Status", DbType.Int16, model.Status);
dbw.AddInParameter(Command, "@IsHide", DbType.Boolean, model.IsHide);
dbw.AddInParameter(Command, "@CategoryLevel", DbType.Int32, model.CategoryLevel);
dbw.AddInParameter(Command, "@ParentID", DbType.Int32, model.ParentID);
dbw.AddInParameter(Command, "@ShowOrder", DbType.Int32, model.ShowOrder);
dbw.ExecuteNonQuery(Command);
}
public MagicCategoryModel GetModel(int CategoryID)
{
DbCommand Command = dbr.GetStoredProcCommand("UP_mwCategory_Get");
dbr.AddInParameter(Command, "@CategoryID", DbType.Int32, CategoryID);
DataTable dt = dbr.ExecuteDataSet(Command).Tables[0];
MagicCategoryModel model = null;
if (dt.Rows.Count > 0)
{
model = BindModel(dt.Rows[0]);
}
return(model);
}
protected void BindData()
{
if (CategoryID != -1)
{
MagicCategoryBll CategoryBll = new MagicCategoryBll();
MagicCategoryModel Category = CategoryBll.GetModel(CategoryID);
TextBox_Category.Text = Category.CategoryName;
DropDown_Usage.DataSource = DataTableUtil.GetEnumKeyValue(typeof(SecondhandProductUsageCondition));
DropDown_Usage.DataTextField = "key";
DropDown_Usage.DataValueField = "value";
DropDown_Usage.DataBind();
}
else
{
throw new Exception("未选择分类");
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
string ErrorMessage = String.Empty;
if (String.IsNullOrEmpty(txtCateName.Text))
{
ErrorMessage += "分类名称不可为空";
}
if (!String.IsNullOrEmpty(ErrorMessage))
{
MessageBox.Show(this, ErrorMessage);
return;
}
MagicCategoryModel model = bll.GetModel(CategoryID);
model.CategoryName = txtCateName.Text;
model.IsHide = chkIsHide.Checked;
bll.Update(model);
MessageBox.Show(this, "修改成功！");
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script type=\"text/javascript\">window.parent.location=window.parent.location+'?_=" + DateTime.Now.Ticks + "'</script>");
}
private void BindData()
{
MagicCategoryModel model = bll.GetModel(ParentID);
txtParentCate.Text = model == null?"无从属父类":model.CategoryName;
}
private void Intialize()
{
MagicCategoryModel model = InitialCategoryID == -1 ? null : bll.GetModel(InitialCategoryID);
BindCategory(0, 1, model == null ? null : model.CategoryPath);
}
public void Update(MagicCategoryModel model)
{
dal.Update(model);
}
public void Add(MagicCategoryModel model)
{
dal.Add(model);
}
