예제 #1
0
        //儲存日報數量紀錄
        public void saveItemRow(FormCollection f)
        {
            SYS_USER u = (SYS_USER)Session["user"];

            log.Debug("projectId=" + Request["txtProjectId"] + ",prjUid=" + Request["txtPrjUid"] + ",ReportId=" + Request["reportID"]);
            log.Debug("form Data ItemId=" + Request["planItemId"]);
            log.Debug("form Data Qty=planItemQty" + Request["planItemQty"]);

            string projectid      = Request["txtProjectId"];
            int    prjuid         = int.Parse(Request["txtPrjUid"]);
            string strWeather     = Request["selWeather"];
            string strSummary     = Request["txtSummary"];
            string strSenceUser   = Request["txtSenceUser"];
            string strSupervision = Request["txtSupervision"];
            string strOwner       = Request["txtOwner"];
            string strRptDate     = Request["reportDate"];

            DailyReport newDailyRpt = new DailyReport();

            PLAN_DALIY_REPORT RptHeader = new PLAN_DALIY_REPORT();

            RptHeader.PROJECT_ID       = projectid;
            RptHeader.WEATHER          = strWeather;
            RptHeader.SUMMARY          = strSummary;
            RptHeader.SCENE_USER_NAME  = strSenceUser;
            RptHeader.SUPERVISION_NAME = strSupervision;
            RptHeader.OWNER_NAME       = strOwner;
            newDailyRpt.dailyRpt       = RptHeader;
            RptHeader.REPORT_DATE      = DateTime.Parse(strRptDate);
            //取得日報編號
            SerialKeyService snService = new SerialKeyService();

            if (null == Request["reportID"] || "" == Request["reportID"])
            {
                RptHeader.REPORT_ID      = snService.getSerialKey(planService.KEY_ID);
                RptHeader.CREATE_DATE    = DateTime.Now;
                RptHeader.CREATE_USER_ID = u.USER_ID;
            }
            else
            {
                RptHeader.REPORT_ID      = Request["ReportID"];
                RptHeader.CREATE_DATE    = DateTime.Parse(Request["txtCreateDate"]);
                RptHeader.CREATE_USER_ID = Request["txtCreateUserId"];
                RptHeader.MODIFY_DATE    = DateTime.Now;
                RptHeader.MODIFY_USER_ID = u.USER_ID;
            }

            //建立專案任務資料 (結構是支援多項任務,僅先使用一筆)
            newDailyRpt.lstRptTask = new List <PLAN_DR_TASK>();
            PLAN_DR_TASK RptTask = new PLAN_DR_TASK();

            RptTask.PROJECT_ID = projectid;
            RptTask.PRJ_UID    = prjuid;
            RptTask.REPORT_ID  = RptHeader.REPORT_ID;
            newDailyRpt.lstRptTask.Add(RptTask);
            //處理料件
            newDailyRpt.lstRptItem = new List <PLAN_DR_ITEM>();
            if (null != Request["planItemId"])
            {
                string[] aryPlanItem      = Request["planItemId"].Split(',');
                string[] aryPlanItemQty   = Request["planItemQty"].Split(',');
                string[] aryAccumulateQty = Request["accumulateQty"].Split(',');

                log.Debug("count ItemiD=" + aryPlanItem.Length + ",qty=" + aryPlanItemQty.Length);
                newDailyRpt.lstRptItem = new List <PLAN_DR_ITEM>();
                for (int i = 0; i < aryPlanItem.Length; i++)
                {
                    PLAN_DR_ITEM item = new PLAN_DR_ITEM();
                    item.PLAN_ITEM_ID = aryPlanItem[i];
                    item.PROJECT_ID   = projectid;
                    item.REPORT_ID    = RptHeader.REPORT_ID;
                    if ("" != aryPlanItemQty[i])
                    {
                        item.FINISH_QTY = decimal.Parse(aryPlanItemQty[i]);
                    }
                    if ("" != aryAccumulateQty[i])
                    {
                        item.LAST_QTY = decimal.Parse(aryAccumulateQty[i]);
                    }
                    newDailyRpt.lstRptItem.Add(item);
                }
            }
            //處理出工資料
            newDailyRpt.lstWokerType4Show = new List <PLAN_DR_WORKER>();
            if (null != Request["txtSupplierId"])
            {
                ///出工廠商
                string[] arySupplier = Request["txtSupplierId"].Split(',');
                ///出工人數
                string[] aryWorkerQty = Request["txtWorkerQty"].Split(',');
                ///備註
                string[] aryRemark = Request["txtRemark"].Split(',');
                for (int i = 0; i < arySupplier.Length; i++)
                {
                    PLAN_DR_WORKER item = new PLAN_DR_WORKER();
                    item.REPORT_ID   = RptHeader.REPORT_ID;
                    item.SUPPLIER_ID = arySupplier[i];
                    log.Debug("Supplier Info=" + item.SUPPLIER_ID);
                    if ("" != aryWorkerQty[i].Trim())
                    {
                        item.WORKER_QTY = decimal.Parse(aryWorkerQty[i]);
                        newDailyRpt.lstWokerType4Show.Add(item);
                    }
                    item.REMARK = aryRemark[i];
                }
                log.Debug("count WorkerD=" + arySupplier.Length);
            }
            //處理點工資料
            newDailyRpt.lstTempWoker4Show = new List <PLAN_DR_TEMPWORK>();
            if (null != Request["txtTempWorkSupplierId"])
            {
                string[] aryTempSupplier       = Request["txtTempWorkSupplierId"].Split(',');
                string[] aryTempWorkerQty      = Request["txtTempWorkerQty"].Split(',');
                string[] aryTempChargeSupplier = Request["txtChargeSupplierId"].Split(',');
                string[] aryTempWarkRemark     = Request["txtTempWorkRemark"].Split(',');
                string[] aryDoc = Request["doc"].Split(',');
                for (int i = 0; i < aryTempSupplier.Length; i++)
                {
                    PLAN_DR_TEMPWORK item = new PLAN_DR_TEMPWORK();
                    item.REPORT_ID   = RptHeader.REPORT_ID;
                    item.SUPPLIER_ID = aryTempSupplier[i];
                    item.CHARGE_ID   = aryTempChargeSupplier[i];
                    ///處理工人名單檔案
                    log.Debug("File Count=" + Request.Files.Count);
                    if (Request.Files[i].ContentLength > 0)
                    {
                        //存檔路徑
                        var    fileName     = Path.GetFileName(Request.Files[i].FileName);
                        string reportFolder = ContextService.strUploadPath + "\\" + projectid + "\\DailyReport\\";
                        //check 資料夾是否存在
                        string folder = reportFolder + RptHeader.REPORT_ID;
                        ZipFileCreator.CreateDirectory(folder);
                        var path = Path.Combine(folder, fileName);
                        Request.Files[i].SaveAs(path);
                        item.DOC = "DailyReport\\" + RptHeader.REPORT_ID + "\\" + fileName;
                        log.Debug("Upload Sign List File:" + Request.Files[i].FileName);
                    }
                    else
                    {
                        item.DOC = aryDoc[i];
                        log.Error("Not Upload Sign List File!Exist File=" + item.DOC);
                    }
                    log.Debug("Supplier Info=" + item.SUPPLIER_ID);
                    if ("" != aryTempWorkerQty[i].Trim())
                    {
                        item.WORKER_QTY = decimal.Parse(aryTempWorkerQty[i]);
                        newDailyRpt.lstTempWoker4Show.Add(item);
                    }
                    item.REMARK = aryTempWarkRemark[i];
                }
            }
            //處理機具資料
            newDailyRpt.lstRptWorkerAndMachine = new List <PLAN_DR_WORKER>();
            string[] aryMachineType = f["MachineKeyid"].Split(',');
            string[] aryMachineQty  = f["planMachineQty"].Split(',');
            for (int i = 0; i < aryMachineType.Length; i++)
            {
                PLAN_DR_WORKER item = new PLAN_DR_WORKER();
                item.REPORT_ID   = RptHeader.REPORT_ID;
                item.WORKER_TYPE = "MACHINE";
                item.PARA_KEY_ID = aryMachineType[i];
                if ("" != aryMachineQty[i])
                {
                    item.WORKER_QTY = decimal.Parse(aryMachineQty[i]);
                    newDailyRpt.lstRptWorkerAndMachine.Add(item);
                }
            }
            log.Debug("count MachineD=" + f["MachineKeyid"] + ",WorkerQty=" + f["planMachineQty"]);
            //處理重要事項資料
            newDailyRpt.lstRptNote = new List <PLAN_DR_NOTE>();
            string[] aryNote = f["planNote"].Split(',');
            for (int i = 0; i < aryNote.Length; i++)
            {
                PLAN_DR_NOTE item = new PLAN_DR_NOTE();
                item.REPORT_ID = RptHeader.REPORT_ID;
                if ("" != aryNote[i].Trim())
                {
                    item.SORT   = i + 1;
                    item.REMARK = aryNote[i].Trim();
                    newDailyRpt.lstRptNote.Add(item);
                }
            }
            //註記任務是否完成
            if (null == Request["taskDone"])
            {
                newDailyRpt.isDoneFlag = false;
            }
            else
            {
                newDailyRpt.isDoneFlag = true;
            }
            log.Debug("count Note=" + f["planNote"]);
            string msg = planService.createDailyReport(newDailyRpt);

            Response.Redirect("~/ProjectPlan/dailyReport/" + projectid);
            //ProjectPlan/dailyReport/P00061
        }
        public ActionResult AddItem(FormCollection f)
        {
            var inquiry = new topmeperp.Models.PLAN_SUP_INQUIRY();
            var formID  = Request["formID"];
            var order   = new topmeperp.Models.PLAN_CERT_ORDER();

            SerialKeyService snoservice = new SerialKeyService();
            string           ordKey     = snoservice.getSerialKey("EST");

            using (var context = new topmepEntities())
            {
                string sql;
                inquiry = context.PLAN_SUP_INQUIRY.SqlQuery("SELECT * FROM PLAN_SUP_INQUIRY WHERE INQUIRY_FORM_ID = '" + formID + "'").ToList().First();
                sql     = "INSERT INTO PLAN_CERT_ORDER (CERT_ORD_ID,INQUIRY_FORM_ID,SUPPLIER_ID,PROJECT_ID,CREATE_DATE) " +
                          "VALUES('" + ordKey + "','" + inquiry.INQUIRY_FORM_ID + "-" + ordKey + "','" + inquiry.SUPPLIER_ID + "','" + inquiry.PROJECT_ID + "','" + DateTime.Now.ToString() + "')";
                try
                {
                    //order.CERT_ORD_ID = "test";
                    //order.INQUIRY_FORM_ID = inquiry.INQUIRY_FORM_ID.ToString();
                    //order.SUPPLIER_ID = inquiry.SUPPLIER_ID.ToString();
                    //order.PROJECT_ID = inquiry.PROJECT_ID.ToString();
                    //context.PLAN_CERT_ORDER.Add(order);
                    context.Database.ExecuteSqlCommand(sql);
                    context.SaveChanges();
                }
                catch (Exception e)
                {
                    Console.Write(e.StackTrace);
                }

                var qty          = Request["qty"];
                var plan_item_id = Request["plan_item_id"];
                var type         = Request["type"];
                var subType      = Request["subType"];
                var itemID       = Request["itemID"];
                var desc         = Request["desc"];

                int[]    nums          = Array.ConvertAll(qty.Split(','), int.Parse);
                string[] plan_item_ids = plan_item_id.Split(',');
                string[] types         = type.Split(',');
                string[] subTypes      = subType.Split(',');
                string[] itemIDs       = itemID.Split(',');
                string[] descs         = desc.Split(',');

                //var test = new PLAN_CERT_ORDER_ITEM { CERT_ORD_ITEM_ID = generate_id(), ORDER_QTY = nums[0] };
                var test2 = new PLAN_CERT_ORDER_ITEM {
                    CERT_ORD_ITEM_ID = generate_id(), ORDER_QTY = nums[1]
                };

                //string sql = "INSERT INTO PLAN_CERT_ORDER_ITEM (CERT_ORD_ITEM_ID,ORDER_QTY) VALUES(28," + "10" + ")";
                try
                {
                    for (int i = 0; i < nums.Length; i++)
                    {
                        context.PLAN_CERT_ORDER_ITEM.Add(new PLAN_CERT_ORDER_ITEM
                        {
                            CERT_ORD_ITEM_ID = generate_id(),
                            CERT_ORD_ID      = ordKey,
                            TYPE_CODE        = types[i],
                            SUB_TYPE_CODE    = subTypes[i],
                            ITEM_ID          = itemIDs[i],
                            ITEM_DESC        = descs[i],
                            ORDER_QTY        = nums[i],
                            PLAN_ITEM_ID     = plan_item_ids[i]
                        });
                        string updateSql = "UPDATE PLAN_SUP_INQUIRY_ITEM SET ACCUMULATE_QTY = ACCUMULATE_QTY + "
                                           + nums[i] + " WHERE INQUIRY_FORM_ID = '" + formID + "' and PLAN_ITEM_ID = '" + plan_item_ids[i] + "'";
                        context.Database.ExecuteSqlCommand(updateSql);
                    }
                    //context.PLAN_CERT_ORDER_ITEM.Add(test2);
                    //var x=0;
                    //context.Database.ExecuteSqlCommand(sql);
                    context.SaveChanges();
                }
                catch (Exception e)
                {
                    Console.Write(e.StackTrace);
                }



                //generate random 64 int ID
                long testID = generate_id();

                string orderinfo = "{CERT_OrderID: " + order.CERT_ORD_ID + " FormID: " + inquiry.INQUIRY_FORM_ID + " Supplier: " + inquiry.SUPPLIER_ID + " ProjID: " + inquiry.PROJECT_ID;
                //return "Item added in " + formID + "\n" + nums[0] + ", " + nums[1] + sql+"\n("+testID+":"+ordKey+")"+plan_item_ids[0];
                return(RedirectToAction("Index/" + inquiry.PROJECT_ID));
            }
        }