protected void lbAdd_Click(object sender, EventArgs e) { String itemid = Request["itemid"].ToString(); t_GZL_Item item = BLL.Application.GZL.GzlManagement.getItemById(Convert.ToInt32(itemid)); if (BLL.Application.GZL.CG.PurchaseManagement.getPurchaseFormCountByItemGuid((Guid)item.itemGuid) == 0) { t_Form_Purchase form = new t_Form_Purchase(); form.applyDept = item.deptId; form.applyUserId = (int)Session["userid"]; form.applyDate = item.ApplyDate; form.itemGuid = item.itemGuid; form.totalPrice = 0; BLL.Application.GZL.CG.PurchaseManagement.createFormPurchase(form); } try { t_Form_Purchase form = BLL.Application.GZL.CG.PurchaseManagement.getPurchaseFormByItemGuid((Guid)item.itemGuid); t_Form_Purchase_Items items = new t_Form_Purchase_Items(); items.formId = form.formId; items.itemName = tbZCName.Text; items.sortId = Convert.ToInt16(tbSortNo.Text); items.type = tbType.Text; items.price = Convert.ToDouble(tbPrice.Text); items.needNumber = Convert.ToInt16(tbNeedAmont.Text); items.number = Convert.ToInt16(tbNeedAmont.Text); items.totalPrice = items.price * items.number; items.memo = tbMemo.Text; BLL.Application.GZL.CG.PurchaseManagement.insertFormPurchaseItems(items,form); databind(); } catch (Exception ex) { lbMessage.Text = "添加错误:" + ex.Message; } }
public static bool createFormPurchase(t_Form_Purchase form) { using (DataClassesEduDataContext dc = new DataClassesEduDataContext()) { dc.t_Form_Purchase.InsertOnSubmit(form); dc.SubmitChanges(); return true; } }
public static bool updateFormReason(t_Form_Purchase form) { using (DataClassesEduDataContext dc = new DataClassesEduDataContext()) { t_Form_Purchase f = dc.t_Form_Purchase.Where(t => t.formId == form.formId).Single(); f.applyReason = form.applyReason; dc.SubmitChanges(); return true; } }
public static bool saveFormReason(String itemid,int userid,String reason) { using (DataClassesEduDataContext dc = new DataClassesEduDataContext()) { t_GZL_Item item = dc.t_GZL_Item.Where(i => i.ItemId == Convert.ToInt32(itemid)).Single(); var forms = dc.t_Form_Purchase.Where(f => f.itemGuid == item.itemGuid); if(forms.Count() == 0) { t_Form_Purchase form = new t_Form_Purchase(); form.applyDept = item.deptId; form.applyUserId = userid; form.applyDate = item.ApplyDate; form.applyReason = reason; dc.t_Form_Purchase.InsertOnSubmit(form); }else { t_Form_Purchase form = dc.t_Form_Purchase.Where(f => f.itemGuid == item.itemGuid).Single(); form.applyReason = reason; } dc.SubmitChanges(); return true; } }
public static bool insertFormPurchaseItems(t_Form_Purchase_Items items,t_Form_Purchase form) { using (DataClassesEduDataContext dc = new DataClassesEduDataContext()) { t_Form_Purchase f = dc.t_Form_Purchase.Where(u => u.formId == form.formId).Single(); f.totalPrice = f.totalPrice + items.totalPrice; dc.t_Form_Purchase_Items.InsertOnSubmit(items); dc.SubmitChanges(); return true; } }