/// <summary> /// 保存按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string strRowID = hfFormID.Text; Model.Base_GoodsCategory GoodsCategory = new Model.Base_GoodsCategory { GoodsCategoryCode = this.txtGoodsCategoryCode.Text.Trim(), GoodsCategoryName = this.txtGoodsCategoryName.Text.Trim(), Remark = txtRemark.Text.Trim() }; if (string.IsNullOrEmpty(strRowID)) { GoodsCategory.GoodsCategoryId = SQLHelper.GetNewID(typeof(Model.Base_GoodsCategory)); BLL.GoodsCategoryService.AddGoodsCategory(GoodsCategory); BLL.LogService.AddSys_Log(this.CurrUser, GoodsCategory.GoodsCategoryCode, GoodsCategory.GoodsCategoryId, BLL.Const.GoodsCategoryMenuId, BLL.Const.BtnAdd); } else { GoodsCategory.GoodsCategoryId = strRowID; BLL.GoodsCategoryService.UpdateGoodsCategory(GoodsCategory); BLL.LogService.AddSys_Log(this.CurrUser, GoodsCategory.GoodsCategoryCode, GoodsCategory.GoodsCategoryId, BLL.Const.GoodsCategoryMenuId, BLL.Const.BtnModify); } this.SimpleForm1.Reset(); // 重新绑定表格,并点击当前编辑或者新增的行 BindGrid(); PageContext.RegisterStartupScript(String.Format("F('{0}').selectRow('{1}');", Grid1.ClientID, GoodsCategory.GoodsCategoryId)); }
/// <summary> /// 根据主键删除物资类别 /// </summary> /// <param name="GoodsCategoryId"></param> public static void DeleteGoodsCategoryById(string GoodsCategoryId) { Model.SUBHSSEDB db = Funs.DB; Model.Base_GoodsCategory GoodsCategory = db.Base_GoodsCategory.FirstOrDefault(e => e.GoodsCategoryId == GoodsCategoryId); if (GoodsCategory != null) { db.Base_GoodsCategory.DeleteOnSubmit(GoodsCategory); db.SubmitChanges(); } }
/// <summary> /// 修改物资类别 /// </summary> /// <param name="GoodsCategory"></param> public static void UpdateGoodsCategory(Model.Base_GoodsCategory GoodsCategory) { Model.SUBHSSEDB db = Funs.DB; Model.Base_GoodsCategory newGoodsCategory = db.Base_GoodsCategory.FirstOrDefault(e => e.GoodsCategoryId == GoodsCategory.GoodsCategoryId); if (newGoodsCategory != null) { newGoodsCategory.GoodsCategoryCode = GoodsCategory.GoodsCategoryCode; newGoodsCategory.GoodsCategoryName = GoodsCategory.GoodsCategoryName; newGoodsCategory.Remark = GoodsCategory.Remark; db.SubmitChanges(); } }
/// <summary> /// 添加物资类别 /// </summary> /// <param name="GoodsCategory"></param> public static void AddGoodsCategory(Model.Base_GoodsCategory GoodsCategory) { Model.SUBHSSEDB db = Funs.DB; Model.Base_GoodsCategory newGoodsCategory = new Model.Base_GoodsCategory { GoodsCategoryId = GoodsCategory.GoodsCategoryId, GoodsCategoryCode = GoodsCategory.GoodsCategoryCode, GoodsCategoryName = GoodsCategory.GoodsCategoryName, Remark = GoodsCategory.Remark }; db.Base_GoodsCategory.InsertOnSubmit(newGoodsCategory); db.SubmitChanges(); }