public ActionResult Create(TND_PROJECT_FORM qf)
{
//取得專案編號
log.Info("Project Id:" + Request["prjId"]);
//取得專案名稱
log.Info("Project Name:" + Request["prjId"]);
//取得使用者勾選品項ID
log.Info("item_list:" + Request["chkItem"]);
string[] lstItemId = Request["chkItem"].ToString().Split(',');
log.Info("select count:" + lstItemId.Count());
var i = 0;
for (i = 0; i < lstItemId.Count(); i++)
{
log.Info("item_list return No.:" + lstItemId[i]);
}
//建立空白詢價單
log.Info("create new form template");
TnderProjectService s = new TnderProjectService();
SYS_USER u = (SYS_USER)Session["user"];
qf.FORM_NAME = Request["formname"];
qf.PROJECT_ID = Request["prjId"];
qf.CREATE_ID = u.USER_ID;
qf.CREATE_DATE = DateTime.Now;
qf.OWNER_NAME = u.USER_NAME;
qf.OWNER_EMAIL = u.EMAIL;
qf.OWNER_TEL = u.TEL + "-" + u.TEL_EXT;
qf.OWNER_FAX = u.FAX;
TND_PROJECT_FORM_ITEM item = new TND_PROJECT_FORM_ITEM();
string fid = s.newForm(qf, lstItemId);
return(Redirect("SinglePrjForm/" + fid));
}
//更新廠商詢價單資料
public String RefreshPrjForm(string id, 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();
fm.ISWAGE = "N";
if (null != form.Get("isWage"))
{
fm.ISWAGE = form.Get("isWage");
}
fm.SUPPLIER_ID = form.Get("supplier").Trim();
fm.DUEDATE = Convert.ToDateTime(form.Get("inputdateline"));
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.CONTACT_NAME = form.Get("inputcontact").Trim();
fm.CONTACT_EMAIL = form.Get("inputemail").Trim();
fm.FORM_ID = form.Get("inputformnumber").Trim();
fm.FORM_NAME = form.Get("formname").Trim();
fm.CREATE_ID = form.Get("createid").Trim();
try
{
fm.CREATE_DATE = Convert.ToDateTime(form.Get("createdate"));
}
catch (Exception ex)
{
log.Error(ex.StackTrace);
}
fm.MODIFY_ID = loginUser.USER_ID;
fm.MODIFY_DATE = DateTime.Now;
string formid = form.Get("inputformnumber").Trim();
string[] lstItemId = form.Get("formitemid").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 j = 0; j < lstItemId.Count(); j++)
{
TND_PROJECT_FORM_ITEM item = new TND_PROJECT_FORM_ITEM();
item.FORM_ITEM_ID = int.Parse(lstItemId[j]);
if (lstRemark[j].ToString() == "")
{
item.ITEM_REMARK = null;
}
else
{
item.ITEM_REMARK = lstRemark[j];
}
if (lstPrice[j].ToString() == "")
{
item.ITEM_UNIT_PRICE = null;
}
else
{
item.ITEM_UNIT_PRICE = decimal.Parse(lstPrice[j]);
}
log.Debug("Item No=" + item.FORM_ITEM_ID + "Remark =" + item.ITEM_REMARK + "Price =" + item.ITEM_UNIT_PRICE);
lstItem.Add(item);
}
int i = service.refreshSupplierForm(formid, fm, lstItem);
if (i == 0)
{
msg = service.message;
}
else
{
msg = "更新供應商詢價單成功，FORM_ID =" + formid;
}
log.Info("Request: FORM_ID = " + formid + "FORM_NAME =" + form["formname"] + "SUPPLIER_NAME =" + form["supplier"]);
return(msg);
}
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);
}
