public ActionResult EditForTask(TND_TASKASSIGN taskassign) { log.Info("update task assign:task_id=" + taskassign.TASK_ID); string message = ""; TnderProjectService service = new TnderProjectService(); SYS_USER u = UtilService.GetUserInfoFromSession(Session); taskassign.MODIFY_ID = u.USER_ID; taskassign.MODIFY_DATE = DateTime.Now; if (taskassign.FINISH_DATE.ToString() == "") { taskassign.FINISH_DATE = DateTime.Now; } //當任務類型無輸入值時,將View返回頁面同時帶入錯誤訊息 if (taskassign.TASK_TYPE == null) { log.Info("updates fail"); ViewBag.ErrorMessage = "修改不成功,請重新輸入任務類型,此欄位不可為空白!!"; return(View(taskassign)); } service.updateTask(taskassign); message = "任務分派資料修改成功,任務類型為 " + taskassign.TASK_TYPE; ViewBag.result = message; return(View(taskassign)); }
public ActionResult Logout() { SYS_USER u = UtilService.GetUserInfoFromSession(Session); log.Info(u.USER_ID + " Logout!!"); Session.Clear();//["UserService"] = null; return(View("Index")); }
public ActionResult Task(string id) { log.Info("task assign page!!"); ViewBag.projectid = id; TnderProjectService service = new TnderProjectService(); TND_PROJECT p = service.getProjectById(id); ViewBag.projectName = p.PROJECT_NAME; SYS_USER u = UtilService.GetUserInfoFromSession(Session); ViewBag.createid = u.USER_ID; return(View()); }
/// <summary> /// 上載現有標單資料 /// </summary> public string uploadProjectItem(HttpPostedFileBase file1) { string projectid = Request["id"]; log.Debug("ProjectID=" + projectid + ",Upload ProjectItem=" + file1.FileName); TnderProjectService service = new TnderProjectService(); service.getProjectById(projectid); SYS_USER u = UtilService.GetUserInfoFromSession(Session); if (null != file1 && file1.ContentLength != 0) { try { //2.解析Excel log.Info("Parser Excel data:" + file1.FileName); //2.1 將上傳檔案存檔 var fileName = Path.GetFileName(file1.FileName); var path = Path.Combine(ContextService.strUploadPath + "/" + projectid, fileName); log.Info("save excel file:" + path); file1.SaveAs(path); //2.2 解析Excel 檔案 //poiservice.ConvertDataForTenderProject(prj.PROJECT_ID, (int)prj.START_ROW_NO); ProjectItem2Excel poiservice = new ProjectItem2Excel(); poiservice.InitializeWorkbook(path); poiservice.ConvertDataForTenderProject(projectid); //2.3 記錄錯誤訊息 // < button type = "button" class="btn btn-primary" onclick="location.href='@Url.Action("ManagePlanItem","Plan", new { id = @Model.tndProject.PROJECT_ID})'; ">標單明細</button> //2.4 log.Info("Delete Project_Item By Project ID"); service.delAllItemByProject(); //2.5 log.Info("Add All Project_ITEM to DB"); service.refreshProjectItem(poiservice.lstProjectItem); } catch (Exception ex) { log.Error(ex.StackTrace); return(ex.Message); } } if (service.strMessage != null) { return(service.strMessage); } else { return("匯入成功!!"); } }
//更新任務分派資料 public String refreshTaskItem(FormCollection form) { log.Info("form:" + form.Count); string msg = "修改任務分派資料成功!!"; TND_TASKASSIGN item = new TND_TASKASSIGN(); item.PROJECT_ID = form["prjid"]; if (null != form["task_id"] && form["task_id"] != "") { item.TASK_ID = Int64.Parse(form["task_id"]); } item.USER_ID = form["userId"]; item.TASK_TYPE = form["taskType"]; item.TASK_ITEM = form["taskItem"]; item.REMARK = form["taskRemark"]; if (null != form["finishDate"] && form["finishDate"] != "") { item.FINISH_DATE = Convert.ToDateTime(form.Get("finishDate")); } item.CREATE_DATE = DateTime.Now; UserService us = new UserService(); SYS_USER u = UtilService.GetUserInfoFromSession(Session); item.CREATE_ID = u.USER_ID; item.MODIFY_ID = u.USER_ID; item.MODIFY_DATE = DateTime.Now; TnderProjectService service = new TnderProjectService(); int i = service.updateTask(item); if (i == 0) { msg = service.message; } return(msg); }
//新增任務分派資料 public String AddTaskAssign(FormCollection form) { log.Info("form:" + form.Count); string msg = "新增任務分派資料成功!!"; TND_TASKASSIGN leader = new TND_TASKASSIGN(); TND_TASKASSIGN costing = new TND_TASKASSIGN(); TND_TASKASSIGN map = new TND_TASKASSIGN(); leader.PROJECT_ID = form["project_id"]; costing.PROJECT_ID = form["project_id"]; map.PROJECT_ID = form["project_id"]; leader.TASK_TYPE = "主辦"; costing.TASK_TYPE = "成控"; map.TASK_TYPE = "圖算"; if (form["leader_user_id"] != "") { leader.USER_ID = form["leader_user_id"]; } if (form["leader_task_item"] != "") { leader.TASK_ITEM = form["leader_task_item"]; } if (form["leader_remark"] != "") { leader.REMARK = form["leader_remark"]; } if (form["leader_finish_date"] != "") { leader.FINISH_DATE = Convert.ToDateTime(form.Get("leader_finish_date")); } if (form["costing_user_id"] != "") { costing.USER_ID = form["costing_user_id"]; } if (form["costing_task_item"] != "") { costing.TASK_ITEM = form["costing_task_item"]; } if (form["costing_remark"] != "") { costing.REMARK = form["costing_remark"]; } if (form["costing_finish_date"] != "") { costing.FINISH_DATE = Convert.ToDateTime(form.Get("costing_finish_date")); } if (form["map_user_id"] != "") { map.USER_ID = form["map_user_id"]; } if (form["map_task_item"] != "") { map.TASK_ITEM = form["map_task_item"]; } if (form["map_remark"] != "") { map.REMARK = form["map_remark"]; } if (form["map_finish_date"] != "") { map.FINISH_DATE = Convert.ToDateTime(form.Get("map_finish_date")); } UserService us = new UserService(); SYS_USER u = UtilService.GetUserInfoFromSession(Session); SYS_USER uInfo = us.GetUserInfo(u.USER_ID); leader.CREATE_ID = uInfo.USER_ID; leader.CREATE_DATE = DateTime.Now; costing.CREATE_ID = uInfo.USER_ID; costing.CREATE_DATE = DateTime.Now; map.CREATE_ID = uInfo.USER_ID; map.CREATE_DATE = DateTime.Now; List <TND_TASKASSIGN> taskAssign = new List <TND_TASKASSIGN>(); taskAssign.Add(leader); taskAssign.Add(costing); taskAssign.Add(map); TnderProjectService service = new TnderProjectService(); int i = service.refreshTask(taskAssign); if (i == 0) { msg = service.message; } return(msg); }
public ActionResult uploadPlanItem(TND_PROJECT prj, HttpPostedFileBase file) { //1.取得專案編號 string projectid = Request["projectid"]; log.Info("Upload plan items for projectid=" + projectid); TnderProjectService service = new TnderProjectService(); SYS_USER u = UtilService.GetUserInfoFromSession(Session); string message = ""; //修改專案狀態 prj.PROJECT_ID = projectid; prj.STATUS = "專案執行"; prj.PROJECT_NAME = Request["projectname"]; prj.ENG_NAME = Request["engname"]; prj.CONTRUCTION_NAME = Request["contructionname"]; prj.LOCATION = Request["location"]; prj.OWNER_NAME = Request["ownername"]; prj.CONTACT_NAME = Request["contactname"]; prj.CONTACT_TEL = Request["contecttel"]; prj.CONTACT_FAX = Request["contactfax"]; prj.CONTACT_EMAIL = Request["contactemail"]; prj.DUE_DATE = Convert.ToDateTime(Request["duedate"]); prj.SCHDL_OFFER_DATE = Convert.ToDateTime(Request["schdlofferdate"]); if (Request["starrowno"] != null || " " != Request["starrowno"]) { prj.START_ROW_NO = int.Parse(Request["starrowno"]); } //prj.WAGE_MULTIPLIER = decimal.Parse(Request["wage"]); prj.EXCEL_FILE_NAME = Request["excelfilename"]; prj.OWNER_USER_ID = Request["owneruserid"]; prj.CREATE_USER_ID = Request["createdid"]; prj.CREATE_DATE = Convert.ToDateTime(Request["createddate"]); prj.MODIFY_USER_ID = u.USER_ID; prj.MODIFY_DATE = DateTime.Now; service.updateProject(prj); message = "專案進入執行階段:" + prj.PROJECT_ID + "<br/>"; if (null != file && file.ContentLength != 0) { //2.解析Excel log.Info("Parser Excel data:" + file.FileName); //2.1 將上傳檔案存檔 var fileName = Path.GetFileName(file.FileName); ZipFileCreator.CreateDirectory(ContextService.strUploadPath + "/" + projectid); var path = Path.Combine(ContextService.strUploadPath + "/" + projectid, fileName); log.Info("save excel file:" + path); file.SaveAs(path); //2.2 解析Excel 檔案 ProjectItemFromExcel poiservice = new ProjectItemFromExcel(); poiservice.InitializeWorkbook(path); poiservice.ConvertDataForPlan(projectid); //2.3 記錄錯誤訊息 message = message + "得標標單品項:共" + poiservice.lstPlanItem.Count + "筆資料,"; message = message + "<a target=\"_blank\" href=\"/Plan/ManagePlanItem?id=" + projectid + "\"> 標單明細檢視畫面單</a><br/>" + poiservice.errorMessage; // < button type = "button" class="btn btn-primary" onclick="location.href='@Url.Action("ManagePlanItem","Plan", new { id = @Model.tndProject.PROJECT_ID})'; ">標單明細</button> //2.4 log.Info("Delete PLAN_ITEM By Project ID"); service.delAllItemByPlan(); //2.5 log.Info("Add All PLAN_ITEM to DB"); service.refreshPlanItem(poiservice.lstPlanItem); } TempData["result"] = message;//Plan/ManagePlanItem/P00023 //return RedirectToAction() return(RedirectToAction("ManagePlanItem/" + projectid, "Plan")); }
/// <summary> /// 新增或更新Project_item 資料 /// </summary> /// <param name="form"></param> /// <returns></returns> public String addProjectItem(FormCollection form) { log.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) { log.Error(item.PROJECT_ITEM_ID + " not quattity:" + ex.Message); } try { item.ITEM_UNIT_PRICE = decimal.Parse(form["item_unit_price"]); } catch (Exception ex) { log.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) { log.Error(item.PROJECT_ITEM_ID + " not exce row id:" + ex.Message); } SYS_USER loginUser = UtilService.GetUserInfoFromSession(Session); 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); }
public ActionResult Create(TND_PROJECT prj, HttpPostedFileBase file) { log.Info("create project process! project =" + prj.ToString()); TnderProjectService service = new TnderProjectService(); SYS_USER u = UtilService.GetUserInfoFromSession(Session); string message = ""; //1.更新或新增專案基本資料 if (prj.PROJECT_ID == "" || prj.PROJECT_ID == null) { //新增專案 prj.CREATE_USER_ID = u.USER_ID; prj.OWNER_USER_ID = u.USER_ID; prj.CREATE_DATE = DateTime.Now; service.newProject(prj); message = "建立專案:" + service.project.PROJECT_ID + "<br/>"; } else { //修改專案基本資料 prj.MODIFY_USER_ID = u.USER_ID; prj.MODIFY_DATE = DateTime.Now; service.updateProject(prj); message = "專案基本資料修改:" + prj.PROJECT_ID + "<br/>"; } //若使用者有上傳標單資料,則增加標單資料 if (null != file && file.ContentLength != 0) { //2.解析Excel log.Info("Parser Excel data:" + file.FileName); //2.1 設定Excel 檔案名稱 prj.EXCEL_FILE_NAME = file.FileName; //2.2 將上傳檔案存檔 var fileName = Path.GetFileName(file.FileName); ZipFileCreator.CreateDirectory(ContextService.strUploadPath + "/" + prj.PROJECT_ID); var path = Path.Combine(ContextService.strUploadPath + "/" + prj.PROJECT_ID, fileName); log.Info("save excel file:" + path); file.SaveAs(path); try { //2.2 解析Excel 檔案 ProjectItemFromExcel poiservice = new ProjectItemFromExcel(); poiservice.InitializeWorkbook(path); poiservice.ConvertDataForTenderProject(prj.PROJECT_ID, (int)prj.START_ROW_NO); //2.3 記錄錯誤訊息 message = message + "標單品項:共" + poiservice.lstProjectItem.Count + "筆資料,"; message = message + "<a target=\"_blank\" href=\"/Tender/ManageProjectItem?id=" + prj.PROJECT_ID + "\"> 標單明細檢視畫面單</a><br/>" + poiservice.errorMessage; //2.4 log.Info("Delete TND_PROJECT_ITEM By Project ID"); service.delAllItemByProject(); //2.5 log.Info("Add All TND_PROJECT_ITEM to DB"); service.refreshProjectItem(poiservice.lstProjectItem); } catch (Exception ex) { log.Error("Error Message:" + ex.Message + "." + ex.StackTrace); message = ex.Message; } } ViewBag.projectId = service.project.PROJECT_ID; ViewBag.result = message; return(View(service.project)); }