/// <summary> /// 設定標單品項查詢條件 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult ManageProjectItem(string id) { //傳入專案編號, InquiryFormService service = new InquiryFormService(); logger.Info("start project id=" + id); //取得專案基本資料fc TND_PROJECT p = service.getProjectById(id); ViewBag.id = p.PROJECT_ID; ViewBag.projectName = p.PROJECT_NAME; SelectListItem empty = new SelectListItem(); empty.Value = ""; empty.Text = ""; List <SelectListItem> selectMain = UtilService.getMainSystem(id, service); // selectMain.Add(empty); ViewBag.SystemMain = selectMain; List <SelectListItem> selectSub = UtilService.getSubSystem(id, service); //selectSub.Add(empty); ViewBag.SystemSub = selectSub; //設定查詢條件 return(View()); }
/// <summary> /// Project_item 註記刪除 /// </summary> /// <param name="itemid"></param> /// <returns></returns> public String delProjectItem(string itemid) { InquiryFormService service = new InquiryFormService(); string msg = "更新成功!!"; logger.Info("del project item by id=" + itemid); int i = service.changeProjectItem(itemid, "Y"); return(msg + "(" + i + ")"); }
/// <summary> /// 取得標單品項詳細資料 /// </summary> /// <param name="itemid"></param> /// <returns></returns> public string getProjectItem(string itemid) { InquiryFormService service = new InquiryFormService(); logger.Info("get project item by id=" + itemid); //TND_PROJECT_ITEM item = service.getProjectItem.getUser(userid); System.Web.Script.Serialization.JavaScriptSerializer objSerializer = new System.Web.Script.Serialization.JavaScriptSerializer(); string itemJson = objSerializer.Serialize(service.getProjectItem(itemid)); logger.Info("project item info=" + itemJson); return(itemJson); }
/// <summary> /// 取得標單明細資料 /// </summary> /// <param name="form"></param> /// <returns></returns> public ActionResult ShowProejctItems(FormCollection form) { InquiryFormService service = new InquiryFormService(); logger.Info("start project id=" + Request["id"] + ",TypeCode1=" + Request["typeCode1"] + ",typecode2=" + Request["typeCode2"] + ",SystemMain=" + Request["SystemMain"] + ",Sytem Sub=" + Request["SystemSub"]); logger.Debug("Exception check=" + Request["chkEx"]); List <TND_PROJECT_ITEM> lstItems = service.getProjectItem(Request["chkEx"], Request["id"], Request["typeCode1"], Request["typeCode2"], Request["SystemMain"], Request["SystemSub"], Request["selDelFlag"]); //logger.Debug("TEST:使用壓力:≥7kg/c㎡G"); //foreach (var p in lstItems) //{ // logger.Debug("PK=" + p.PROJECT_ITEM_ID + ",ITEM_DESC=" + p.ITEM_DESC + ",excel row=" + p.EXCEL_ROW_ID); //} ViewBag.Result = "共幾" + lstItems.Count + "筆資料"; return(PartialView(lstItems)); }
public static List <SelectListItem> getMainSystem(string id, InquiryFormService service) { //取得主系統資料 List <SelectListItem> selectMain = new List <SelectListItem>(); foreach (string itm in service.getSystemMain(id)) { log.Debug("Main System=" + itm); SelectListItem selectI = new SelectListItem(); selectI.Value = itm; selectI.Text = itm; if (null != itm && "" != itm) { selectMain.Add(selectI); } } return(selectMain); }
public static List <SelectListItem> getSubSystem(string id, InquiryFormService service) { //取得次系統資料 List <SelectListItem> selectSub = new List <SelectListItem>(); foreach (string itm in service.getSystemSub(id)) { logger.Debug("Sub System=" + itm); SelectListItem selectI = new SelectListItem(); selectI.Value = itm; selectI.Text = itm; if (null != itm && "" != itm) { selectSub.Add(selectI); } } return(selectSub); }
/// <summary> /// 新增或更新Project_item 資料 /// </summary> /// <param name="form"></param> /// <returns></returns> public String addProjectItem(FormCollection form) { logger.Info("form:" + form.Count); string msg = "更新成功!!"; TND_PROJECT_ITEM item = new TND_PROJECT_ITEM(); item.PROJECT_ID = form["project_id"]; item.PROJECT_ITEM_ID = form["project_item_id"]; item.ITEM_ID = form["item_id"]; item.ITEM_DESC = form["item_desc"]; item.ITEM_UNIT = form["item_unit"]; try { item.ITEM_QUANTITY = decimal.Parse(form["item_quantity"]); } catch (Exception ex) { logger.Error(item.PROJECT_ITEM_ID + " not quattity:" + ex.Message); } try { item.ITEM_UNIT_PRICE = decimal.Parse(form["item_unit_price"]); } catch (Exception ex) { logger.Error(item.PROJECT_ITEM_ID + " not unit price:" + ex.Message); } item.ITEM_REMARK = form["item_remark"]; if (form["type_code_1"].Trim() != "") { item.TYPE_CODE_1 = form["type_code_1"]; } else { item.TYPE_CODE_1 = null; } if (form["type_code_2"].Trim() != "") { item.TYPE_CODE_2 = form["type_code_2"]; } else { item.TYPE_CODE_2 = null; } item.SYSTEM_MAIN = form["system_main"]; item.SYSTEM_SUB = form["system_sub"]; item.DEL_FLAG = form["selDelFlag"]; try { item.EXCEL_ROW_ID = long.Parse(form["excel_row_id"]); } catch (Exception ex) { logger.Error(item.PROJECT_ITEM_ID + " not exce row id:" + ex.Message); } SYS_USER loginUser = (SYS_USER)Session["user"]; item.MODIFY_USER_ID = loginUser.USER_ID; item.MODIFY_DATE = DateTime.Now; InquiryFormService service = new InquiryFormService(); int i = 0; string strFlag = form["flag"].Trim(); if (strFlag.Equals("addAfter")) { i = service.addProjectItemAfter(item); } else { i = service.updateProjectItem(item); } if (i == 0) { msg = service.message; } return(msg); }