public ActionResult AddSupplier(TND_SUPPLIER sup) { log.Info("create supplier process! supplier =" + sup.ToString()); SupplierManage supplierService = new SupplierManage(); SYS_USER u = (SYS_USER)Session["user"]; string message = ""; //1.新增供應商 if (sup.SUPPLIER_ID == "" || sup.SUPPLIER_ID == null) { //新增供應商編號 supplierService.newSupplier(sup); message = "輸入供應商基本資料 ! 若有聯絡人請先新增完聯絡人資料,再輸入供應商資料"; } TempData["result"] = message; return(Redirect("Create?id=" + sup.SUPPLIER_ID)); }
public String UpdatePrjForm(FormCollection form) { log.Info("form:" + form.Count); string msg = ""; // 取得供應商詢價單資料 TND_PROJECT_FORM fm = new TND_PROJECT_FORM(); SYS_USER loginUser = (SYS_USER)Session["user"]; fm.PROJECT_ID = form.Get("projectid").Trim(); //廠商資料 if (null != form.Get("supplier") && "" != form.Get("supplier")) { fm.SUPPLIER_ID = Request["supplier"].Substring(7).Trim(); if (form.Get("inputdateline") != "") { fm.DUEDATE = Convert.ToDateTime(form.Get("inputdateline")); } TND_SUPPLIER s = service.getSupplierInfo(form.Get("supplier").Substring(0, 7).Trim()); fm.CONTACT_NAME = s.CONTACT_NAME; fm.CONTACT_EMAIL = s.CONTACT_EMAIL; } //業務區塊 fm.FORM_ID = form.Get("inputformnumber").Trim(); fm.OWNER_NAME = form.Get("inputowner").Trim(); fm.OWNER_TEL = form.Get("inputphone").Trim(); fm.OWNER_FAX = form.Get("inputownerfax").Trim(); fm.OWNER_EMAIL = form.Get("inputowneremail").Trim(); fm.FORM_NAME = form.Get("formname").Trim(); fm.ISWAGE = "N"; if (null != form.Get("isWage")) { fm.ISWAGE = form.Get("isWage").Trim(); } fm.CREATE_ID = loginUser.USER_ID; fm.CREATE_DATE = DateTime.Now; //明細區塊 string[] lstItemId = form.Get("formitemid").Split(','); log.Info("select count:" + lstItemId.Count()); var j = 0; for (j = 0; j < lstItemId.Count(); j++) { log.Info("item_list return No.:" + lstItemId[j]); } string fid = service.addNewSupplierForm(fm, lstItemId); string[] lstProjectItem = form.Get("project_item_id").Split(','); string[] lstPrice = form.Get("formunitprice").Split(','); string[] lstRemark = form.Get("remark").Split(','); List <TND_PROJECT_FORM_ITEM> lstItem = new List <TND_PROJECT_FORM_ITEM>(); for (int i = 0; i < lstItemId.Count(); i++) { TND_PROJECT_FORM_ITEM item = new TND_PROJECT_FORM_ITEM(); item.PROJECT_ITEM_ID = lstProjectItem[i]; if (lstRemark[i].ToString() == "") { item.ITEM_REMARK = null; } else { item.ITEM_REMARK = lstRemark[i]; } if (lstPrice[i].ToString() == "") { item.ITEM_UNIT_PRICE = null; } else { item.ITEM_UNIT_PRICE = decimal.Parse(lstPrice[i]); } log.Debug("Project Item Id=" + item.PROJECT_ITEM_ID + ", Price =" + item.ITEM_UNIT_PRICE); lstItem.Add(item); } int k = service.refreshSupplierFormItem(fid, lstItem); //產生廠商詢價單實體檔案 //service.getInqueryForm(fid); //InquiryFormToExcel poi = new InquiryFormToExcel(); //poi.exportExcel(service.formInquiry, service.formInquiryItem, false); if (fid == "") { msg = service.message; } else { msg = "新增詢價單成功"; } log.Info("Request:FORM_NAME=" + form["formname"]); return(msg); }
//更新供應商資料 public String RefreshSupplier(string id, FormCollection form) { log.Info("form:" + form.Count); string msg = ""; // 取得供應商資料 TND_SUPPLIER sup = new TND_SUPPLIER(); sup.SUPPLIER_ID = form.Get("supplierid").Trim(); sup.COMPANY_NAME = form.Get("company_name").Trim(); sup.COMPANY_ID = form.Get("company_id").Trim(); sup.CONTACT_ADDRESS = form.Get("contact_address").Trim(); sup.REGISTER_ADDRESS = form.Get("register_address").Trim(); sup.TYPE_MAIN = form.Get("type_main").Trim(); try { sup.TYPE_SUB = int.Parse(form.Get("type_sub").Trim()); } catch (Exception ex) { log.Error(ex.StackTrace); } sup.SUPPLY_NOTE = form.Get("supply_note").Trim(); SupplierManage supplierService = new SupplierManage(); string supplierid = form.Get("supplierid").Trim(); if (form.Get("contactid") != null && "" != form.Get("contactid")) { string[] lstItemId = form.Get("contactid").Split(','); string[] lstName = form.Get("contactname").Split(','); string[] lstTel = form.Get("contacttel").Split(','); string[] lstFax = form.Get("contactfax").Split(','); string[] lstMobile = form.Get("contactmobil").Split(','); string[] lstEmail = form.Get("contactemail").Split(','); string[] lstRemark = form.Get("contactremark").Split(','); List <TND_SUP_CONTACT_INFO> lstItem = new List <TND_SUP_CONTACT_INFO>(); for (int j = 0; j < lstItemId.Count(); j++) { TND_SUP_CONTACT_INFO item = new TND_SUP_CONTACT_INFO(); item.CONTACT_ID = int.Parse(lstItemId[j]); item.CONTACT_NAME = lstName[j]; item.CONTACT_TEL = lstTel[j]; item.CONTACT_FAX = lstFax[j]; item.CONTACT_MOBIL = lstMobile[j]; item.CONTACT_EMAIL = lstEmail[j]; item.REMARK = lstRemark[j]; lstItem.Add(item); } int i = supplierService.updateSupplier(supplierid, sup, lstItem); if (i == 0) { msg = supplierService.message; } else { msg = "更新/新增供應商資料成功,SUPPLIER_ID =" + supplierid; } log.Info("Request: SUPPLIER_ID = " + supplierid + "CONTACT_ID =" + form["contact_id"]); return(msg); } int k = supplierService.updateOnlySupplier(supplierid, sup); if (k == 0) { msg = supplierService.message; } else { msg = "更新/新增供應商資料成功,SUPPLIER_ID =" + supplierid; } log.Info("Request: SUPPLIER_ID = " + supplierid + "CONTACT_ID =" + form["contact_id"]); return(msg); }