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>"); }
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); }
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; }