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