public string GetFormResult(ApplyTask applyTask) { string TC001 = null; string TC002 = null; string FORMID = null; string MODIFIER = null; string MOC = null; string PUR = null; XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); TC001 = applyTask.Task.CurrentDocument.Fields["TC001"].FieldValue.ToString().Trim(); TC002 = applyTask.Task.CurrentDocument.Fields["TC002"].FieldValue.ToString().Trim(); MOC = applyTask.Task.CurrentDocument.Fields["MOC"].FieldValue.ToString().Trim(); PUR = applyTask.Task.CurrentDocument.Fields["PUR"].FieldValue.ToString().Trim(); FORMID = applyTask.FormNumber; MODIFIER = applyTask.Task.Applicant.Account; ///核準 == Ede.Uof.WKF.Engine.ApplyResult.Adopt if (applyTask.SignResult == Ede.Uof.WKF.Engine.SignResult.Approve) { if (!string.IsNullOrEmpty(TC001) && !string.IsNullOrEmpty(TC002)) { //MOC或PUR,其中一欄不是空的,就將MOC+PUR回寫到ERP訂單 if (!string.IsNullOrEmpty(MOC) || !string.IsNullOrEmpty(PUR)) { UPDATECOPTCD(TC001, TC002, FORMID, MODIFIER, MOC, PUR); } } } return(""); }
public string GetFormResult(ApplyTask applyTask) { string FORMID = null; string MODIFIER = null; string TC001 = null; XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); TC001 = applyTask.Task.CurrentDocument.Fields["TC001"].FieldValue.ToString().Trim(); FORMID = applyTask.FormNumber; MODIFIER = applyTask.Task.Applicant.Account; ///表單核準後 if (applyTask.SignResult == Ede.Uof.WKF.Engine.SignResult.Approve) ///單一節點核準後 if applyTask.SignResult == Ede.Uof.WKF.Engine.SignResult.Approve) if (applyTask.SignResult == Ede.Uof.WKF.Engine.SignResult.Approve) { if (!string.IsNullOrEmpty(TC001)) { ADDSTORESCHECK(); } } return(""); }
public string GetFormResult(ApplyTask applyTask) { DATAQC QC = new DATAQC(); XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); QC.TaskId = applyTask.Task.TaskId; //檢查QCFrm002SN的欄位是否存在,存在才繼續 if (applyTask.Task.CurrentDocument.Fields["QCFrm002SN"] != null) { QC.QCFrm002SN = applyTask.Task.CurrentDocument.Fields["QCFrm002SN"].FieldValue.ToString().Trim(); QC.QCFrm002QCC = applyTask.Task.CurrentDocument.Fields["QCFrm002QCC"].FieldValue.ToString().Trim(); QC.QCFrm002PN = applyTask.Task.CurrentDocument.Fields["QCFrm002PN"].FieldValue.ToString().Trim(); if (applyTask.FormResult == Ede.Uof.WKF.Engine.ApplyResult.Adopt) { if (!string.IsNullOrEmpty(QC.TaskId)) { ADDTBFORMQC(QC); } } } return(""); }
public string GetFormResult(ApplyTask applyTask) { if (applyTask.FormResult == Fast.EB.WKF.Engine.ApplyResult.Adopt) { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); string ORDERNO = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["ORDERNO"].Value; CPetitionUCO petitionuco = new CPetitionUCO(); DataTable petitiondt = petitionuco.QueryPetition(ORDERNO); if (petitiondt.Rows.Count == 0) { throw new Exception("資料錯亂,請洽管理員!"); } DataRow row = petitiondt.Rows[0]; row["ORDERNO"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["ORDERNO"].Value; row["SMID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SMID"].Value; row["PET_TYPE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PET_TYPE"].Value; row["COM_NAME"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["COM_NAME"].Value; row["COM_PHONE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["COM_PHONE"].Value; row["COM_ADD"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["COM_ADD"].Value; row["COM_ID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["COM_ID"].Value; row["COM_DATE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["COM_DATE"].Value; row["PEO_NAME"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_NAME"].Value; row["PEO_SEX"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_SEX"].Value; row["PEO_ID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_ID"].Value; row["PEO_MERRY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_MERRY"].Value; row["PEO_PHONE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_PHONE"].Value; row["PEO_MOBILE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_MOBILE"].Value; row["PEO_BIRTHDAY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_BIRTHDAY"].Value; row["PEO_ADD"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_ADD"].Value; row["PEO_REPORT_ADD"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_REPORT_ADD"].Value; row["SER_NAME"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SER_NAME"].Value; row["SER_ADD"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SER_ADD"].Value; row["SER_YEAR"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SER_YEAR"].Value; row["SER_JOB"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SER_JOB"].Value; row["SER_PHONE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SER_PHONE"].Value; row["HOUSE_ADD"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["HOUSE_ADD"].Value; row["HOUSE_NUM"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["HOUSE_NUM"].Value; row["HOUSE_BUILD"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["HOUSE_BUILD"].Value; row["HOUSE_NAME"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["HOUSE_NAME"].Value; row["HOUSE_ID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["HOUSE_ID"].Value; row["CREDIT_MONEY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["CREDIT_MONEY"].Value; row["CREDIT_PHASES"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["CREDIT_PHASES"].Value; row["MONTH_MONEY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["MONTH_MONEY"].Value; row["SUBSIDIES_MONEY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SUBSIDIES_MONEY"].Value; row["PET_RATE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PET_RATE"].Value; row["PET_SEVERAL"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PET_SEVERAL"].Value; row["PET_MONEY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PET_MONEY"].Value; row["PET_SUBSIDIES"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PET_SUBSIDIES"].Value; row["PAY_TYPE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PAY_TYPE"].Value; row["CAR_REASON"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["CAR_REASON"].Value; row["CAR_USER"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["CAR_USER"].Value; row["PET_RESULT"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["MEMO"].Value; row["TASK_ID"] = applyTask.TaskId; row["DOC_NBR"] = applyTask.FormNumber; row["TASK_RESULT"] = (int)applyTask.FormResult; petitionuco.UpdatePETITIONAfterWKF(row); } return(""); }
public string GetFormResult(ApplyTask applyTask) { string MA001 = null; string MA033 = null; XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); MA001 = applyTask.Task.CurrentDocument.Fields["sd004"].FieldValue.ToString().Trim(); MA033 = applyTask.Task.CurrentDocument.Fields["sd010"].FieldValue.ToString().Trim(); ///核準 == Ede.Uof.WKF.Engine.ApplyResult.Adopt if (applyTask.SignResult == Ede.Uof.WKF.Engine.SignResult.Approve) { if (!string.IsNullOrEmpty(MA001) && !string.IsNullOrEmpty(MA033)) { UPDATECOPTMA(MA001, MA033); } } return(""); }
public string GetFormResult(ApplyTask applyTask) { if (applyTask.FormResult == Ede.Uof.WKF.Engine.ApplyResult.Adopt) { //ADD(); //20210915 品保-1001品質異常單,需判斷1002客訴異常單的品保判定(QCFrmQCC),若品保判斷異常成立才要追踨生產 if (applyTask.Task.CurrentDocument.Fields["QCFrm002QCC"].FieldValue.ToString().Trim().Equals("成立")) { OLDTASK_ID = applyTask.TaskId; ATTACH_ID = SEARCHATTACH_ID(OLDTASK_ID); ADDTB_WKF_EXTERNAL_TASK(applyTask); if (!string.IsNullOrEmpty(NEWTASK_ID) && !string.IsNullOrEmpty(ATTACH_ID)) { ADDATTACH_IDTONEWTASK_ID(NEWTASK_ID, ATTACH_ID); } } } return(""); //throw new NotImplementedException(); }
public string GetFormResult(ApplyTask applyTask) { DATAHREngFrm001 HREngFrm001 = new DATAHREngFrm001(); XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); HREngFrm001.TaskId = applyTask.Task.TaskId; HREngFrm001.HREngFrm001PIR = applyTask.Task.CurrentDocument.Fields["HREngFrm001PIR"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001OU = applyTask.Task.CurrentDocument.Fields["HREngFrm001OU"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001CN = applyTask.Task.CurrentDocument.Fields["HREngFrm001CN"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001SN = applyTask.Task.CurrentDocument.Fields["HREngFrm001SN"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001Date = applyTask.Task.CurrentDocument.Fields["HREngFrm001Date"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001User = applyTask.Task.CurrentDocument.Fields["HREngFrm001User"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001UsrDpt = applyTask.Task.CurrentDocument.Fields["HREngFrm001UsrDpt"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001Rank = applyTask.Task.CurrentDocument.Fields["HREngFrm001Rank"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001OutDate = applyTask.Task.CurrentDocument.Fields["HREngFrm001OutDate"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001Location = applyTask.Task.CurrentDocument.Fields["HREngFrm001Location"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001Agent = applyTask.Task.CurrentDocument.Fields["HREngFrm001Agent"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001Transp = applyTask.Task.CurrentDocument.Fields["HREngFrm001Transp"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001LicPlate = applyTask.Task.CurrentDocument.Fields["HREngFrm001LicPlate"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001Cause = applyTask.Task.CurrentDocument.Fields["HREngFrm001Cause"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001DefOutTime = applyTask.Task.CurrentDocument.Fields["HREngFrm001DefOutTime"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001FF = applyTask.Task.CurrentDocument.Fields["HREngFrm001FF"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001OutTime = applyTask.Task.CurrentDocument.Fields["HREngFrm001OutTime"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001DefBakTime = applyTask.Task.CurrentDocument.Fields["HREngFrm001DefBakTime"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001CH = applyTask.Task.CurrentDocument.Fields["HREngFrm001CH"].FieldValue.ToString().Trim(); HREngFrm001.HREngFrm001BakTime = applyTask.Task.CurrentDocument.Fields["HREngFrm001BakTime"].FieldValue.ToString().Trim(); if (HREngFrm001.HREngFrm001PIR.Equals("否")) { string account = HREngFrm001.HREngFrm001User; account = account.Substring(4, 6); HREngFrm001.CRADNO = SEARCHCARDNO(account); } else if (HREngFrm001.HREngFrm001PIR.Equals("是")) { string account = HREngFrm001.HREngFrm001CN; HREngFrm001.CRADNO = SEARCHCARDNO(account); HREngFrm001.HREngFrm001User = HREngFrm001.HREngFrm001OU + HREngFrm001.HREngFrm001CN; } if (applyTask.FormResult == Ede.Uof.WKF.Engine.ApplyResult.Adopt) { if (!string.IsNullOrEmpty(HREngFrm001.TaskId)) { ADDTKGAFFAIRSHREngFrm001(HREngFrm001); } } return(""); }
public string GetFormResult(ApplyTask applyTask) { DATAUOFGAFrm UOFGAFrm = new DATAUOFGAFrm(); XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); UOFGAFrm.TaskId = applyTask.Task.TaskId; UOFGAFrm.GAFrm004SN = applyTask.Task.CurrentDocument.Fields["GAFrm004SN"].FieldValue.ToString().Trim(); UOFGAFrm.GAFrm004SI = applyTask.Task.CurrentDocument.Fields["GAFrm004SI"].FieldValue.ToString().Trim(); UOFGAFrm.GAFrm004CM = applyTask.Task.CurrentDocument.Fields["GAFrm004CM"].FieldValue.ToString().Trim(); UOFGAFrm.GAFrm004OD = applyTask.Task.CurrentDocument.Fields["GAFrm004OD"].FieldValue.ToString().Trim(); UOFGAFrm.GAFrm004PS = applyTask.Task.CurrentDocument.Fields["GAFrm004PS"].FieldValue.ToString().Trim(); UOFGAFrm.GAFrm004PID = applyTask.Task.CurrentDocument.Fields["GAFrm004PID"].FieldValue.ToString().Trim(); UOFGAFrm.GAFrm004RD = applyTask.Task.CurrentDocument.Fields["GAFrm004RD"].FieldValue.ToString().Trim(); //針對DETAIL抓出來的資料作處理 foreach (XmlNode node in xmlDoc.SelectNodes("./Form/FormFieldValue/FieldItem[@fieldId='GAFrm004IT']/DataGrid/Row")) { UOFGAFrm.GAFrm004DN[ROWS] = node.SelectSingleNode("./Cell[@fieldId='GAFrm004DN']").Attributes["fieldValue"].Value; UOFGAFrm.GAFrm004NB[ROWS] = node.SelectSingleNode("./Cell[@fieldId='GAFrm004NB']").Attributes["fieldValue"].Value; UOFGAFrm.GAFrm004ID[ROWS] = node.SelectSingleNode("./Cell[@fieldId='GAFrm004ID']").Attributes["fieldValue"].Value; UOFGAFrm.GAFrm004ER[ROWS] = node.SelectSingleNode("./Cell[@fieldId='GAFrm004ER']").Attributes["fieldValue"].Value; UOFGAFrm.GAFrm004S0ND[ROWS] = node.SelectSingleNode("./Cell[@fieldId='GAFrm004S0ND']").Attributes["fieldValue"].Value; ROWS = ROWS + 1; } ///1a31c995-f2e1-40cc-9cb9-6079aca2a242 副總 正式 ///3adb6f7a-98b5-42e5-8dfb-21a9e3f680ae 葉志剛 正式 ///b6f50a95-17ec-47f2-b842-4ad12512b431 健洲 正式 ///0077c97a-8699-4688-be7e-ea1ecb960145 葉志剛 test /// //表單核準後 //if (applyTask.FormResult == Ede.Uof.WKF.Engine.ApplyResult.Adopt) //指定某人 if (applyTask.Task.CurrentSite.CurrentNode.ActualSignerId == "1a31c995-f2e1-40cc-9cb9-6079aca2a242" && applyTask.Task.CurrentSite.SiteResult == Ede.Uof.WKF.Engine.ApplyResult.Adopt) { if (!string.IsNullOrEmpty(UOFGAFrm.TaskId)) { ADDTKGAFFAIRSUOFGAFrm(UOFGAFrm); } } return(""); }
public string GetFormResult(ApplyTask applyTask) { if (applyTask.FormResult == Ede.Uof.WKF.Engine.ApplyResult.Adopt) { ADDFORMB(applyTask); } return(""); //throw new NotImplementedException(); }
public string GetFormResult(ApplyTask applyTask) { //每次簽核時,簽準過後 if (applyTask.SignResult == Ede.Uof.WKF.Engine.SignResult.Approve) { UPDATE_TB_WKF_TASK(applyTask); } return(""); //throw new NotImplementedException(); }
public string GetFormResult(ApplyTask applyTask) { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); string l_GUID = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='FormID']").Attributes["fieldValue"].Value; string l_SMID = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["SMID"].Value; string l_type = ""; int l_int月份 = DateTime.Today.Month; if (l_int月份 > 9 || l_int月份 < 3) { l_type = "年終"; } else if (2 < l_int月份 && l_int月份 < 7) { l_type = "端午"; } else if (6 < l_int月份 && l_int月份 < 10) { l_type = "中秋"; } string l_year = DateTime.Today.Year.ToString(); CTB_HR_ASSESS_STAFF_DETAILUCO l_detail = new CTB_HR_ASSESS_STAFF_DETAILUCO(); l_detail.updateGUID(l_GUID, l_SMID, l_type, l_year); ////判斷明細有資料列 //if (xmlDoc.SelectNodes("/Form/FormFieldValue/FieldItem[@fieldId='GUID']/DataGrid/Row") != null) //{ // //取得列 // XmlNodeList sequenceCode = xmlDoc.SelectNodes("/Form/FormFieldValue/FieldItem[@fieldId='GUID']/DataGrid/Row"); // //取得欄 // foreach (XmlNode xmlN in sequenceCode) // { // DataRow l_row = l_detail.NewRow(); // l_row["GUID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='FormID']").Attributes["fieldValue"].Value; // l_row["DEL_GUID"] = Guid.NewGuid(); // l_row["PLAN_DRAW"] = xmlN.SelectSingleNode("./Cell[@fieldId='PLAN_DRAW']").Attributes["fieldValue"].Value; // l_row["PLAN_TARGET"] = xmlN.SelectSingleNode("./Cell[@fieldId='PLAN_TARGET']").Attributes["fieldValue"].Value; // l_row["PLAN_KPI"] = xmlN.SelectSingleNode("./Cell[@fieldId='PLAN_KPI']").Attributes["fieldValue"].Value; // l_detail.Insert(l_row); // } //} return(""); }
public string GetFormResult(ApplyTask applyTask) { string TA001 = null; string TA002 = null; string FORMID = null; XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); TA001 = applyTask.Task.CurrentDocument.Fields["TA001"].FieldValue.ToString().Trim(); TA002 = applyTask.Task.CurrentDocument.Fields["TA002"].FieldValue.ToString().Trim(); FORMID = applyTask.FormNumber; ///核準 if (applyTask.FormResult == Ede.Uof.WKF.Engine.ApplyResult.Adopt) { if (!string.IsNullOrEmpty(TA001) && !string.IsNullOrEmpty(TA002)) { UPDATEPURTAB(TA001, TA002, FORMID); } } //作廢 else if (applyTask.FormResult == Ede.Uof.WKF.Engine.ApplyResult.Cancel) { if (!string.IsNullOrEmpty(TA001) && !string.IsNullOrEmpty(TA002)) { UPDATEPURTABCANCEL(TA001, TA002); } } //否決 else if (applyTask.FormResult == Ede.Uof.WKF.Engine.ApplyResult.Reject) { if (!string.IsNullOrEmpty(TA001) && !string.IsNullOrEmpty(TA002)) { UPDATEPURTABREJECT(TA001, TA002); } } //退簽 else if (applyTask.FormResult == Ede.Uof.WKF.Engine.ApplyResult.Return) { if (!string.IsNullOrEmpty(TA001) && !string.IsNullOrEmpty(TA002)) { UPDATEPURTABRETURN(TA001, TA002); } } return(""); }
public string GetFormResult(ApplyTask applyTask) { FORMID = applyTask.FormNumber; XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); DV01 = applyTask.Task.CurrentDocument.Fields["DV01"].FieldValue.ToString().Trim(); DV02 = applyTask.Task.CurrentDocument.Fields["DV02"].FieldValue.ToString().Trim(); DV03 = applyTask.Task.CurrentDocument.Fields["DV03"].FieldValue.ToString().Trim(); DV04 = ""; DV05 = applyTask.Task.CurrentDocument.Fields["DV05"].FieldValue.ToString().Trim(); DV06 = applyTask.Task.CurrentDocument.Fields["DV06"].FieldValue.ToString().Trim(); DV07 = applyTask.Task.CurrentDocument.Fields["DV07"].FieldValue.ToString().Trim(); DV08 = applyTask.Task.CurrentDocument.Fields["DV08"].FieldValue.ToString().Trim(); DV09 = applyTask.Task.CurrentDocument.Fields["DV09"].FieldValue.ToString().Trim(); DV10 = applyTask.Task.CurrentDocument.Fields["DV10"].FieldValue.ToString().Trim(); ISCLOSE = "N"; //DVV01 = applyTask.Task.CurrentDocument.Fields["DVV01"].FieldValue.ToString().Trim(); ///核準 == Ede.Uof.WKF.Engine.ApplyResult.Adopt if (applyTask.SignResult == Ede.Uof.WKF.Engine.SignResult.Approve) { if (!string.IsNullOrEmpty(FORMID)) { foreach (XmlNode node in xmlDoc.SelectNodes("./Form/FormFieldValue/FieldItem[@fieldId='DETAILS']/DataGrid/Row")) { DVV01 = node.SelectSingleNode("./Cell[@fieldId='DVV01']").Attributes["fieldValue"].Value; DVV02 = node.SelectSingleNode("./Cell[@fieldId='DVV02']").Attributes["fieldValue"].Value; DVV03 = node.SelectSingleNode("./Cell[@fieldId='DVV03']").Attributes["fieldValue"].Value; DVV04 = node.SelectSingleNode("./Cell[@fieldId='DVV04']").Attributes["fieldValue"].Value; DVV05 = node.SelectSingleNode("./Cell[@fieldId='DVV05']").Attributes["fieldValue"].Value; DVV06 = node.SelectSingleNode("./Cell[@fieldId='DVV06']").Attributes["fieldValue"].Value; DVV07 = node.SelectSingleNode("./Cell[@fieldId='DVV07']").Attributes["fieldValue"].Value; DVV08 = node.SelectSingleNode("./Cell[@fieldId='DVV08']").Attributes["fieldValue"].Value; ADDTBSAMPLE(FORMID, DV01, DV02, DV03, DV04, DV05, DV06, DV07, DV08, DV09, DV10, DVV01, DVV02, DVV03, DVV04, DVV05, DVV06, DVV07, DVV08, ISCLOSE); } } } return(""); }
public void UPDATETB_WKF_TASK(ApplyTask applyTask, string TA001, string TA002) { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); XmlElement att = (XmlElement)xmlDoc.SelectSingleNode("./Form/FormFieldValue/FieldItem[@fieldId='PURTAB']/FieldValue"); att.SetAttribute("TA001", TA001); att.SetAttribute("TA002", TA002); //string str = xmlDoc.OuterXml; string connectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ToString(); StringBuilder queryString = new StringBuilder(); queryString.AppendFormat(@" UPDATE [UOFTEST].dbo.TB_WKF_TASK SET CURRENT_DOC=@CURRENT_DOC WHERE TASK_ID=@TASK_ID "); try { using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString.ToString(), connection); command.Parameters.Add("@CURRENT_DOC", SqlDbType.NVarChar).Value = xmlDoc.OuterXml; command.Parameters.Add("@TASK_ID", SqlDbType.NVarChar).Value = applyTask.TaskId; command.Connection.Open(); int count = command.ExecuteNonQuery(); connection.Close(); connection.Dispose(); } } catch { } finally { } }
public string GetFormResult(ApplyTask applyTask) { if (applyTask.FormResult == Fast.EB.WKF.Engine.ApplyResult.Adopt) { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); CPERTUCO CPERTUCO = new CPERTUCO(); DataRow row = CPERTUCO.NewRow(); row["GUID"] = Guid.NewGuid().ToString(); row["ASSESS_TYPE"] = KDUOFLib.Utility.getASSESS_TYPE(DateTime.Today); row["SMID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='number']").Attributes["fieldValue"].Value.ToUpper(); row["PERFORMACE"] = Convert.ToInt32("0" + xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='PERT1']").Attributes["fieldValue"].Value); row["POLICY"] = Convert.ToInt32("0" + xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='PERT2']").Attributes["fieldValue"].Value); row["IMPROVEMENT"] = Convert.ToInt32("0" + xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='PERT3']").Attributes["fieldValue"].Value); row["TEAM"] = Convert.ToInt32("0" + xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='PERT4']").Attributes["fieldValue"].Value); row["NURTURE"] = Convert.ToInt32("0" + xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='PERT5']").Attributes["fieldValue"].Value); row["RISK"] = Convert.ToInt32("0" + xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='PERT6']").Attributes["fieldValue"].Value); row["COMMUNICATION"] = Convert.ToInt32("0" + xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='PERT7']").Attributes["fieldValue"].Value); row["ATTITUDE"] = Convert.ToInt32("0" + xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='PERT8']").Attributes["fieldValue"].Value); row["PERT"] = Convert.ToInt32("0" + xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='PERT']").Attributes["fieldValue"].Value); string l_strPERT_LEVEL1 = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='LEVEL1']").Attributes["fieldValue"].Value; row["PERT_LEVEL1"] = l_strPERT_LEVEL1.Substring(0, l_strPERT_LEVEL1.IndexOf("_")); try { string l_strPERT_LEVEL2 = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='LEVEL2']").Attributes["fieldValue"].Value; row["PERT_LEVEL2"] = l_strPERT_LEVEL2.Substring(0, l_strPERT_LEVEL2.IndexOf("@")); } catch { row["PERT_LEVEL2"] = ""; } try { string l_strPERT_LEVEL3 = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='LEVEL3']").Attributes["fieldValue"].Value; if (!String.IsNullOrEmpty(l_strPERT_LEVEL3)) { row["PERT_LEVEL3"] = l_strPERT_LEVEL3.Substring(0, l_strPERT_LEVEL3.IndexOf("@")); } } catch { row["PERT_LEVEL3"] = ""; } row["EDIT_DATE"] = DateTime.Today.ToString("yyyy/MM/dd"); row["PAPER_TYPE"] = KDUOFLib.Utility.getPAPER_TYPE(applyTask.Task.FormName); row["TASK_ID"] = applyTask.TaskId; row["DOC_NBR"] = applyTask.FormNumber; CPERTUCO.Insert(row); } return(""); }
public string GetFormResult(ApplyTask applyTask) { string TC001 = null; string TC002 = null; string FORMID = null; string MODIFIER = null; string MOC = null; string PUR = null; XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); TC001 = applyTask.Task.CurrentDocument.Fields["TC001"].FieldValue.ToString().Trim(); TC002 = applyTask.Task.CurrentDocument.Fields["TC002"].FieldValue.ToString().Trim(); MOC = applyTask.Task.CurrentDocument.Fields["MOC"].FieldValue.ToString().Trim(); PUR = applyTask.Task.CurrentDocument.Fields["PUR"].FieldValue.ToString().Trim(); FORMID = applyTask.FormNumber; MODIFIER = applyTask.Task.Applicant.Account; //指定簽核站是 生管-MOC if (applyTask.SiteCode.Equals("MOC")) { //簽核站簽核後 if (applyTask.SignResult == Ede.Uof.WKF.Engine.SignResult.Approve) { if (!string.IsNullOrEmpty(TC001) && !string.IsNullOrEmpty(TC002)) { UPDATECOPTCD(TC001, TC002, FORMID, MODIFIER, MOC, PUR); } } } /////核準 == Ede.Uof.WKF.Engine.ApplyResult.Adopt //if (applyTask.SignResult == Ede.Uof.WKF.Engine.SignResult.Approve) //{ // if (!string.IsNullOrEmpty(TC001) && !string.IsNullOrEmpty(TC002)) // { // UPDATECOPTCD(TC001, TC002, FORMID, MODIFIER, MOC, PUR); // } //} return(""); }
public string GetFormResult(ApplyTask applyTask) { string TA001 = null; string TA002 = null; XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); TA001 = applyTask.Task.CurrentDocument.Fields["PURTATA001"].FieldValue.ToString().Trim(); TA002 = applyTask.Task.CurrentDocument.Fields["PURTATA002"].FieldValue.ToString().Trim(); if (applyTask.FormResult == Ede.Uof.WKF.Engine.ApplyResult.Adopt) { if (!string.IsNullOrEmpty(TA001) && !string.IsNullOrEmpty(TA002)) { UPDATEPURTAB(TA001, TA002); } } return(""); }
public string GetFormResult(ApplyTask applyTask) { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); CSaleDocUCO SaleDocUCO = new CSaleDocUCO(); DataRow row = SaleDocUCO.NewRow(); row["ORDERNO"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["ORDERNO"].Value; row["INSURANCE_COM_ITEM"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["INSURANCE_COM_ITEM"].Value; row["INSURANCE_NUM"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["INSURANCE_NUM"].Value; row["OLDCAR"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["OLDCAR"].Value; row["INSURANCE_ITME"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["INSURANCE_ITME"].Value; row["INVOICE_FILE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["INVOICE_FILE"].Value; row["CREATE_DATE"] = DateTime.Today; row["CREATOR"] = Current.Account; row["STATUS"] = 0; row["DISCOUNT_MONEY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["DISCOUNT_MONEY"].Value; row["SUBSIDIES_MONEY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SUBSIDIES_MONEY"].Value; row["INVOICE_MONEY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["INVOICE_MONEY"].Value; SaleDocUCO.Insert(row); return(""); }
public string GetFormResult(ApplyTask applyTask) { DATAPROLOSAL PROLOSAL = new DATAPROLOSAL(); XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); PROLOSAL.TaskId = applyTask.Task.TaskId; PROLOSAL.GMOFrm001AVG6 = applyTask.Task.CurrentDocument.Fields["GMOFrm001AVG6"].FieldValue.ToString().Trim(); PROLOSAL.GMOFrm001SB = applyTask.Task.CurrentDocument.Fields["GMOFrm001SB"].FieldValue.ToString().Trim(); if (applyTask.FormResult == Ede.Uof.WKF.Engine.ApplyResult.Adopt) { if (!string.IsNullOrEmpty(PROLOSAL.TaskId)) { UPDATE_TB_WKF_TASK(PROLOSAL); } } return(""); }
public string GetFormResult(ApplyTask applyTask) { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); CPetitionUCO petitionuco = new CPetitionUCO(); DataRow row = petitionuco.NewRow(); row["ORDERNO"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["ORDERNO"].Value; row["SMID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SMID"].Value; row["PET_TYPE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PET_TYPE"].Value; row["TYPE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["TYPE"].Value; row["COM_NAME"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["COM_NAME"].Value; row["COM_PHONE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["COM_PHONE"].Value; row["COM_ADD"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["COM_ADD"].Value; row["COM_ID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["COM_ID"].Value; row["COM_DATE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["COM_DATE"].Value; row["PEO_NAME"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_NAME"].Value; row["PEO_SEX"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_SEX"].Value; row["PEO_ID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_ID"].Value; row["PEO_MERRY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_MERRY"].Value; row["PEO_PHONE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_PHONE"].Value; row["PEO_MOBILE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_MOBILE"].Value; row["PEO_BIRTHDAY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_BIRTHDAY"].Value; row["PEO_ADD"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_ADD"].Value; row["PEO_REPORT_ADD"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PEO_REPORT_ADD"].Value; row["SER_NAME"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SER_NAME"].Value; row["SER_ADD"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SER_ADD"].Value; row["SER_YEAR"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SER_YEAR"].Value; row["SER_JOB"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SER_JOB"].Value; row["SER_PHONE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SER_PHONE"].Value; row["HOUSE_ADD"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["HOUSE_ADD"].Value; row["HOUSE_NUM"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["HOUSE_NUM"].Value; row["HOUSE_BUILD"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["HOUSE_BUILD"].Value; row["HOUSE_NAME"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["HOUSE_NAME"].Value; row["HOUSE_ID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["HOUSE_ID"].Value; row["CREDIT_MONEY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["CREDIT_MONEY"].Value; row["CREDIT_PHASES"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["CREDIT_PHASES"].Value; row["MONTH_MONEY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["MONTH_MONEY"].Value; row["SUBSIDIES_MONEY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SUBSIDIES_MONEY"].Value; row["PET_RATE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PET_RATE"].Value; row["PET_SEVERAL"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PET_SEVERAL"].Value; row["PET_MONEY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PET_MONEY"].Value; row["PET_SUBSIDIES"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PET_SUBSIDIES"].Value; row["PAY_TYPE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PAY_TYPE"].Value; row["CAR_REASON"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["CAR_REASON"].Value; row["CAR_USER"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["CAR_USER"].Value; row["PET_RESULT"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["MEMO"].Value; row["STATUS"] = 0; row["CREATE_DATE"] = DateTime.Today; row["PET_COM"] = ""; //row["PET_BDATE"] = SqlDateTime.Null; //row["PET_EDATE"] = SqlDateTime.Null; //row["PET_SUPID"] = ""; //row["KD_SEND_DATE"] = SqlDateTime.Null; //row["KD_OUT_DATE"] = SqlDateTime.Null; //row["KD_IN_DATE"] = SqlDateTime.Null; //row["KD_NUM"] = ""; //row["CLOSE_TYPE"] = ""; //row["INVOICE"] = ""; //row["CLOSE_MEMO"] = ""; //row["TASK_RESULT"] = SqlString.Null; //row["DELETE_DATE"] = SqlDateTime.Null; //row["DELETER"] = ""; row["TASK_ID"] = applyTask.TaskId; row["DOC_NBR"] = applyTask.FormNumber; //row["TASK_RESULT"] = applyTask.SignResult; petitionuco.Insert(row); return(""); }
public void ADDTB_WKF_EXTERNAL_TASK(ApplyTask applyTask) { //要記得改成正式-1 //將applyTask轉成xml再取值,只取到文字的部份,不包含字型 XElement xe = XElement.Parse(applyTask.CurrentDocXML); XmlDocument xmlDoc = new XmlDocument(); //建立根節點 XmlElement Form = xmlDoc.CreateElement("Form"); //formVersionId Form.SetAttribute("formVersionId", ID); //urgentLevel Form.SetAttribute("urgentLevel", "2"); //加入節點底下 xmlDoc.AppendChild(Form); ////建立節點Applicant XmlElement Applicant = xmlDoc.CreateElement("Applicant"); Applicant.SetAttribute("account", applyTask.Task.Applicant.Account); Applicant.SetAttribute("groupId", applyTask.Task.Applicant.GroupId); Applicant.SetAttribute("jobTitleId", applyTask.Task.Applicant.JobTitleId); //加入節點底下 Form.AppendChild(Applicant); //建立節點 Comment XmlElement Comment = xmlDoc.CreateElement("Comment"); Comment.InnerText = "申請者意見"; //加入至節點底下 Applicant.AppendChild(Comment); //建立節點 XmlElement FormFieldValue = xmlDoc.CreateElement("FormFieldValue"); //加入至節點底下 Form.AppendChild(FormFieldValue); //建立節點FieldItem //QCFrm001SN 表單編號 XmlElement FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm001SN"); FieldItem.SetAttribute("fieldValue", ""); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //建立節點FieldItem //QCFrm001ASN 表單編號 FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm001ASN"); FieldItem.SetAttribute("fieldValue", applyTask.Task.FormNumber); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //日期QCFrm002Date>QCFrm001Date FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm001Date"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm002Date"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //申請者 QCFrm002User> QCFrmB001User FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm001User"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm002User"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //部門 QCFrm002Dept> QCFrm001Dept FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm001Dept"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm002Dept"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //職級 QCFrm002Rank> QCFrm001Rank FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm001Rank"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm002Rank"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //供應商/部門單位 QCFrm002CU> QCFrm001CUST FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm001CUST"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm002CU"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //批號 QCFrm002PNO> QCFrm001PNO FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm001PNO"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm002PNO"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //品號 QCFrm002CN> QCFrm001CN FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm001CN"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm002CN"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //品名 QCFrm002PRD> QCFrm001PRD FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm001PRD"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm002PRD"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //受理日期 QCFrm002RDate> QCFrm001RDate FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm001RDate"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm002RDate"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //製造日期 QCFrm002MD> QCFrm001MD FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm001MD"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm002MD"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //有效日期 QCFrm002ED> QCFrm001ND FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm001ND"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm002ED"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //原因分析 QCFrm002Cmf> QCFrm001RCA FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002Cmf"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm002Cmf"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //原因分析 QCFrm002Abn > QCFrm002Abn FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002Abn"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm002Abn"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //原因 QCFrm002Abns FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002Abns"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm002Abns"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", applyTask.Task.CurrentDocument.Fields["QCFrm002Abns"].RealValue.ToString().Trim()); FieldItem.SetAttribute("customValue", applyTask.Task.CurrentDocument.Fields["QCFrm002Abns"].CustomValue.ToString().Trim()); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //用ADDTACK,直接啟動起單 ADDTACK(Form); ////ADD TO DB //string connectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ToString(); //StringBuilder queryString = new StringBuilder(); ////要記得改成正式-2 ////UOFTEST //// //queryString.AppendFormat(@" INSERT INTO [UOFTEST].dbo.TB_WKF_EXTERNAL_TASK // (EXTERNAL_TASK_ID,FORM_INFO,STATUS) // VALUES (NEWID(),@XML,2) // "); //////UOF ////// ////queryString.AppendFormat(@" INSERT INTO [UOF].dbo.TB_WKF_EXTERNAL_TASK //// (EXTERNAL_TASK_ID,FORM_INFO,STATUS) //// VALUES (NEWID(),@XML,2) //// "); //try //{ // using (SqlConnection connection = new SqlConnection(connectionString)) // { // SqlCommand command = new SqlCommand(queryString.ToString(), connection); // command.Parameters.Add("@XML", SqlDbType.NVarChar).Value = Form.OuterXml; // command.Connection.Open(); // int count = command.ExecuteNonQuery(); // connection.Close(); // connection.Dispose(); // } //} //catch //{ //} //finally //{ //} }
public void ADDFORMB(ApplyTask applyTask) { XmlDocument xmlDoc = new XmlDocument(); //建立根節點 XmlElement Form = xmlDoc.CreateElement("Form"); Form.SetAttribute("formVersionId", "147858fd-6a3d-4cea-8cee-f1f786245921"); Form.SetAttribute("urgentLevel", "2"); //加入節點底下 xmlDoc.AppendChild(Form); //建立節點 XmlElement Applicant = xmlDoc.CreateElement("Applicant"); Applicant.SetAttribute("account", applyTask.Task.Applicant.Account); Applicant.SetAttribute("groupId", applyTask.Task.Applicant.GroupId); Applicant.SetAttribute("jobTitleId", applyTask.Task.Applicant.JobTitleId); //加入節點底下 Form.AppendChild(Applicant); //建立節點 XmlElement Comment = xmlDoc.CreateElement("Comment"); Comment.InnerText = "申請者意見"; //加入至節點底下 Applicant.AppendChild(Comment); //建立節點 XmlElement FormFieldValue = xmlDoc.CreateElement("FormFieldValue"); //加入至節點底下 Form.AppendChild(FormFieldValue); //建立節點 XmlElement FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "B01"); FieldItem.SetAttribute("fieldValue", ""); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //建立節點 FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "B02"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["A02"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //ADD TO DB string connectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ToString(); StringBuilder queryString = new StringBuilder(); queryString.AppendFormat(@" INSERT INTO [UOFTEST].dbo.TB_WKF_EXTERNAL_TASK"); queryString.AppendFormat(@" (EXTERNAL_TASK_ID,FORM_INFO,STATUS)"); queryString.AppendFormat(@" VALUES (NEWID(),@XML,2)"); queryString.AppendFormat(@" "); try { using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString.ToString(), connection); command.Parameters.Add("@XML", SqlDbType.NVarChar).Value = Form.OuterXml; command.Connection.Open(); int count = command.ExecuteNonQuery(); connection.Close(); connection.Dispose(); } } catch { } finally { } }
public void UPDATE_TB_WKF_TASK(ApplyTask applyTask) { //<FieldItem fieldId="GMOFrm001BSC" enableSearch="True" fillerName="葉志剛" fillerUserGuid="0077c97a-8699-4688-be7e-ea1ecb960145" fillerAccount="120002" fillSiteId="ec110e59-c14e-45ac-8c16-a82060cfb697"> //<Form formVersionId="77eb3223-97ce-4b5c-a536-1fa032561d4f"> //<Applicant userGuid="0077c97a-8699-4688-be7e-ea1ecb960145" account="120002" name="葉志剛" /> // <FormFieldValue> // <FieldItem fieldId="GMOFrm001BSC" enableSearch="True" fillerName="葉志剛" fillerUserGuid="0077c97a-8699-4688-be7e-ea1ecb960145" fillerAccount="120002" fillSiteId="ec110e59-c14e-45ac-8c16-a82060cfb697"> // <DataGrid> // <Row order="0"> // <Cell fieldId="GMOFrm001BF1" fieldValue="40" realValue="" customValue="" enableSearch="True" /> // <Cell fieldId="GMOFrm001CB" fieldValue="20" realValue="" customValue="" enableSearch="True" /> // <Cell fieldId="GMOFrm001RG" fieldValue="15" realValue="" customValue="" enableSearch="True" /> // <Cell fieldId="GMOFrm001CR" fieldValue="15" realValue="" customValue="" enableSearch="True" /> // <Cell fieldId="GMOFrm001SF" fieldValue="10" realValue="" customValue="" enableSearch="True" /> // <Cell fieldId="GMOFrm001TO" fieldValue="100" realValue="" customValue="" enableSearch="True" /> // <Cell fieldId="GMOFrm001PU" fieldValue="林忠輝(120023)" realValue="<UserSet><Element type='user'> <userId>858fd300-93c6-4a4b-a69a-c5ff125f71e4</userId></Element></UserSet>
" customValue="" enableSearch="True" /> // </Row> // </DataGrid> // </FieldItem> // </FormFieldValue> //</Form> //針對不同的簽核站點做判斷 //要在表單設計的簽核卡設定SiteCode if (applyTask.SiteCode != "FINAL") { //建立根節點 XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); //計算Row有幾筆 XmlElement xmlElem = xmlDoc.DocumentElement;//獲取根節點 int rowscounts = xmlDoc.SelectNodes("./Form/FormFieldValue/FieldItem[@fieldId='GMOFrm001BSC']/DataGrid/Row").Count; //建立節點Row,把rowscounts+1 //Row XmlElement Row = xmlDoc.CreateElement("Row"); Row.SetAttribute("order", (rowscounts).ToString()); //建立節點Row //Row GMOFrm001BF1 XmlElement Cell = xmlDoc.CreateElement("Cell"); Cell.SetAttribute("fieldId", "GMOFrm001BF1"); Cell.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["GMOFrm001SC1"].FieldValue.ToString().Trim()); Cell.SetAttribute("realValue", ""); Cell.SetAttribute("customValue", ""); Cell.SetAttribute("enableSearch", "True"); //Row Row.AppendChild(Cell); //建立節點Row //Row GMOFrm001CB Cell = xmlDoc.CreateElement("Cell"); Cell.SetAttribute("fieldId", "GMOFrm001CB"); Cell.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["GMOFrm001SC2"].FieldValue.ToString().Trim()); Cell.SetAttribute("realValue", ""); Cell.SetAttribute("customValue", ""); Cell.SetAttribute("enableSearch", "True"); //Row Row.AppendChild(Cell); //建立節點Row //Row GMOFrm001RG Cell = xmlDoc.CreateElement("Cell"); Cell.SetAttribute("fieldId", "GMOFrm001RG"); Cell.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["GMOFrm001SC3"].FieldValue.ToString().Trim()); Cell.SetAttribute("realValue", ""); Cell.SetAttribute("customValue", ""); Cell.SetAttribute("enableSearch", "True"); //Row Row.AppendChild(Cell); //建立節點Row //Row GMOFrm001CR Cell = xmlDoc.CreateElement("Cell"); Cell.SetAttribute("fieldId", "GMOFrm001CR"); Cell.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["GMOFrm001SC4"].FieldValue.ToString().Trim()); Cell.SetAttribute("realValue", ""); Cell.SetAttribute("customValue", ""); Cell.SetAttribute("enableSearch", "True"); //Row Row.AppendChild(Cell); //建立節點Row //Row GMOFrm001SF Cell = xmlDoc.CreateElement("Cell"); Cell.SetAttribute("fieldId", "GMOFrm001SF"); Cell.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["GMOFrm001SC5"].FieldValue.ToString().Trim()); Cell.SetAttribute("realValue", ""); Cell.SetAttribute("customValue", ""); Cell.SetAttribute("enableSearch", "True"); //Row Row.AppendChild(Cell); //Row GMOFrm001TO Cell = xmlDoc.CreateElement("Cell"); Cell.SetAttribute("fieldId", "GMOFrm001TO"); Cell.SetAttribute("fieldValue", (Convert.ToInt32(applyTask.Task.CurrentDocument.Fields["GMOFrm001SC1"].FieldValue.ToString().Trim()) + Convert.ToInt32(applyTask.Task.CurrentDocument.Fields["GMOFrm001SC2"].FieldValue.ToString().Trim()) + Convert.ToInt32(applyTask.Task.CurrentDocument.Fields["GMOFrm001SC3"].FieldValue.ToString().Trim()) + Convert.ToInt32(applyTask.Task.CurrentDocument.Fields["GMOFrm001SC4"].FieldValue.ToString().Trim()) + Convert.ToInt32(applyTask.Task.CurrentDocument.Fields["GMOFrm001SC5"].FieldValue.ToString().Trim())).ToString()); Cell.SetAttribute("realValue", ""); Cell.SetAttribute("customValue", ""); Cell.SetAttribute("enableSearch", "True"); //Row Row.AppendChild(Cell); //建立節點Row //Row GMOFrm001PU Cell = xmlDoc.CreateElement("Cell"); Cell.SetAttribute("fieldId", "GMOFrm001PU"); Cell.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["GMOFrm001SCU"].FieldValue.ToString().Trim()); Cell.SetAttribute("realValue", ""); Cell.SetAttribute("customValue", ""); Cell.SetAttribute("enableSearch", "True"); //Row Row.AppendChild(Cell); //建立節點Row XmlNode DataGrid = xmlDoc.SelectSingleNode("./Form/FormFieldValue/FieldItem[@fieldId='GMOFrm001BSC']/DataGrid"); DataGrid.AppendChild(Row); //GMOFrm001SC1=null XmlElement FieldItem = (XmlElement)xmlDoc.SelectSingleNode("./Form/FormFieldValue/FieldItem[@fieldId='GMOFrm001SC1']"); FieldItem.SetAttribute("fieldValue", null); //GMOFrm001SC2=null FieldItem = (XmlElement)xmlDoc.SelectSingleNode("./Form/FormFieldValue/FieldItem[@fieldId='GMOFrm001SC2']"); FieldItem.SetAttribute("fieldValue", null); //GMOFrm001SC3=null FieldItem = (XmlElement)xmlDoc.SelectSingleNode("./Form/FormFieldValue/FieldItem[@fieldId='GMOFrm001SC3']"); FieldItem.SetAttribute("fieldValue", null); //GMOFrm001SC4=null FieldItem = (XmlElement)xmlDoc.SelectSingleNode("./Form/FormFieldValue/FieldItem[@fieldId='GMOFrm001SC4']"); FieldItem.SetAttribute("fieldValue", null); //GMOFrm001SC5=null FieldItem = (XmlElement)xmlDoc.SelectSingleNode("./Form/FormFieldValue/FieldItem[@fieldId='GMOFrm001SC5']"); FieldItem.SetAttribute("fieldValue", null); //GMOFrm001SCU=null FieldItem = (XmlElement)xmlDoc.SelectSingleNode("./Form/FormFieldValue/FieldItem[@fieldId='GMOFrm001SCU']"); FieldItem.SetAttribute("fieldValue", null); //UPDATE_TB_WKF_TASK string connectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ToString(); StringBuilder queryString = new StringBuilder(); ////UOFTEST //queryString.AppendFormat(@" UPDATE [UOFTEST].dbo.TB_WKF_TASK // SET CURRENT_DOC=@XML // WHERE TASK_ID=@TASK_ID // "); //UOF queryString.AppendFormat(@" UPDATE [UOF].dbo.TB_WKF_TASK SET CURRENT_DOC=@XML WHERE TASK_ID=@TASK_ID "); try { using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString.ToString(), connection); command.Parameters.Add("@XML", SqlDbType.NVarChar).Value = xmlDoc.OuterXml; command.Parameters.Add("@TASK_ID", SqlDbType.NVarChar).Value = applyTask.TaskId; command.Connection.Open(); int count = command.ExecuteNonQuery(); connection.Close(); connection.Dispose(); } } catch { } finally { } } }
public void ADDTB_WKF_EXTERNAL_TASK(ApplyTask applyTask) { //要記得改成正式-1 //將applyTask轉成xml再取值,只取到文字的部份,不包含字型 XElement xe = XElement.Parse(applyTask.CurrentDocXML); XmlDocument xmlDoc = new XmlDocument(); //建立根節點 XmlElement Form = xmlDoc.CreateElement("Form"); //formVersionId Form.SetAttribute("formVersionId", ID); //urgentLevel Form.SetAttribute("urgentLevel", "2"); //加入節點底下 xmlDoc.AppendChild(Form); ////建立節點Applicant XmlElement Applicant = xmlDoc.CreateElement("Applicant"); Applicant.SetAttribute("account", applyTask.Task.Applicant.Account); Applicant.SetAttribute("groupId", applyTask.Task.Applicant.GroupId); Applicant.SetAttribute("jobTitleId", applyTask.Task.Applicant.JobTitleId); //加入節點底下 Form.AppendChild(Applicant); //建立節點 Comment XmlElement Comment = xmlDoc.CreateElement("Comment"); Comment.InnerText = "申請者意見"; //加入至節點底下 Applicant.AppendChild(Comment); //建立節點 XmlElement FormFieldValue = xmlDoc.CreateElement("FormFieldValue"); //加入至節點底下 Form.AppendChild(FormFieldValue); //建立節點FieldItem //QCFrm002SN 表單編號 XmlElement FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002SN"); FieldItem.SetAttribute("fieldValue", ""); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //建立節點FieldItem //QCFrm002SFNO 表單編號 FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002SFNO"); FieldItem.SetAttribute("fieldValue", applyTask.Task.FormNumber); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003Date > QCFrm002Date FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002Date"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003Date"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003User > QCFrm002User FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002User"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003User"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003Dept > QCFrm002Dept FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002Dept"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003Dept"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003Rank > QCFrm002Rank FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002Rank"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003Rank"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003CUST > QCFrm002CUST FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002CUST"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003CUST"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003TEL > QCFrm002TEL FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002TEL"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003TEL"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003Add > QCFrm002Add FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002Add"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003Add"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003CU > QCFrm002CU FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002CU"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003CU"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003PNO > QCFrm002PNO FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002PNO"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003PNO"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003CN > QCFrm002CN FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002CN"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003CN"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003RDate > QCFrm002RDate FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002RDate"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003RDate"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003PRD > QCFrm002PRD FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002PRD"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003PRD"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003PKG > QCFrm002PKG FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002PKG"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003PKG"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003MD > QCFrm002MD FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002MD"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003MD"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003ED > QCFrm002ED FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002ED"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003ED"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003OD > QCFrm002OD FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002OD"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003OD"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003BP > QCFrm002BP FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002BP"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003BP"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003Prove > QCFrm002Prove FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002Prove"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003Prove"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003Abns > QCFrm002Abns FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002Abns"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003Abns"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003Range > QCFrm002Range FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002Range"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003Range"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003RP > QCFrm002RP FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002RP"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003RP"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003RD > QCFrm002RD FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002RD"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003RD"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003Abn > QCFrm002Abn FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002Abn"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003Abn"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm003Process > QCFrm002Process FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002Process"); FieldItem.SetAttribute("fieldValue", applyTask.Task.CurrentDocument.Fields["QCFrm003Process"].FieldValue.ToString().Trim()); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm002QCR FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002QCR"); FieldItem.SetAttribute("fieldValue", "品保建議回覆內容"); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm002ProcessR FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002ProcessR"); FieldItem.SetAttribute("fieldValue", "業務對外回覆"); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm002QCC FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002QCC"); FieldItem.SetAttribute("fieldValue", "成立"); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm002RCAU FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002RCAU"); FieldItem.SetAttribute("fieldValue", "必填"); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm002PRRD FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002PRRD"); FieldItem.SetAttribute("fieldValue", DateTime.Now.ToString("yyyyMMdd")); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //QCFrm002Cmf FieldItem = xmlDoc.CreateElement("FieldItem"); FieldItem.SetAttribute("fieldId", "QCFrm002Cmf"); FieldItem.SetAttribute("fieldValue", "品保初判"); FieldItem.SetAttribute("realValue", ""); FieldItem.SetAttribute("enableSearch", "True"); FieldItem.SetAttribute("fillerName", applyTask.Task.Applicant.UserName); FieldItem.SetAttribute("fillerUserGuid", applyTask.Task.Applicant.UserGUID); FieldItem.SetAttribute("fillerAccount", applyTask.Task.Applicant.Account); FieldItem.SetAttribute("fillSiteId", ""); //加入至members節點底下 FormFieldValue.AppendChild(FieldItem); //用ADDTACK,直接啟動起單 ADDTACK(Form); ////ADD TO DB //string connectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ToString(); //StringBuilder queryString = new StringBuilder(); ////要記得改成正式-2 ////UOFTEST //// //queryString.AppendFormat(@" INSERT INTO [UOFTEST].dbo.TB_WKF_EXTERNAL_TASK // (EXTERNAL_TASK_ID,FORM_INFO,STATUS) // VALUES (NEWID(),@XML,2) // "); //////UOF ////// ////queryString.AppendFormat(@" INSERT INTO [UOF].dbo.TB_WKF_EXTERNAL_TASK //// (EXTERNAL_TASK_ID,FORM_INFO,STATUS) //// VALUES (NEWID(),@XML,2) //// "); //try //{ // using (SqlConnection connection = new SqlConnection(connectionString)) // { // SqlCommand command = new SqlCommand(queryString.ToString(), connection); // command.Parameters.Add("@XML", SqlDbType.NVarChar).Value = Form.OuterXml; // command.Connection.Open(); // int count = command.ExecuteNonQuery(); // connection.Close(); // connection.Dispose(); // } //} //catch //{ //} //finally //{ //} }
public string GetFormResult(ApplyTask applyTask) { DATACOPMA COPMA = new DATACOPMA(); XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); //MA001 = applyTask.Task.CurrentDocument.Fields["MA001"].FieldValue.ToString().Trim(); //MA002 = applyTask.Task.CurrentDocument.Fields["MA002"].FieldValue.ToString().Trim(); XmlNode node = xmlDoc.SelectSingleNode("./Form/FormFieldValue/FieldItem/FieldValue"); COPMA.COMPANY = "TK"; COPMA.CREATOR = node.Attributes["MA016"].Value; COPMA.USR_GROUP = "106000"; COPMA.CREATE_DATE = DateTime.Now.ToString("yyyyMMdd"); COPMA.MODIFIER = ""; COPMA.MODI_DATE = DateTime.Now.ToString("yyyyMMdd"); COPMA.FLAG = "1"; COPMA.CREATE_TIME = DateTime.Now.ToString("HH:mm:ss"); COPMA.MODI_TIME = DateTime.Now.ToString("HH:mm:ss"); COPMA.TRANS_TYPE = "P001"; COPMA.TRANS_NAME = "COPI01"; COPMA.sync_date = ""; COPMA.sync_time = ""; COPMA.sync_count = "0"; COPMA.sync_mark = ""; COPMA.DataUser = ""; COPMA.DataGroup = "106000"; COPMA.MA001 = node.Attributes["MA001"].Value; COPMA.MA002 = node.Attributes["MA002"].Value; COPMA.MA003 = node.Attributes["MA003"].Value; COPMA.MA004 = node.Attributes["MA004"].Value; COPMA.MA005 = node.Attributes["MA005"].Value; COPMA.MA006 = node.Attributes["MA006"].Value; COPMA.MA007 = ""; COPMA.MA008 = node.Attributes["MA008"].Value; COPMA.MA009 = node.Attributes["MA009"].Value; COPMA.MA010 = node.Attributes["MA010"].Value; COPMA.MA011 = node.Attributes["MA011"].Value; COPMA.MA012 = node.Attributes["MA012"].Value; COPMA.MA013 = node.Attributes["MA013"].Value; COPMA.MA014 = node.Attributes["MA014"].Value; COPMA.MA015 = node.Attributes["MA015"].Value; COPMA.MA016 = node.Attributes["MA016"].Value; COPMA.MA017 = node.Attributes["MA017"].Value; COPMA.MA018 = node.Attributes["MA018"].Value; COPMA.MA019 = node.Attributes["MA019"].Value; COPMA.MA020 = ""; COPMA.MA021 = ""; COPMA.MA022 = ""; COPMA.MA023 = node.Attributes["MA023"].Value; COPMA.MA024 = ""; COPMA.MA025 = node.Attributes["MA025"].Value; COPMA.MA026 = ""; COPMA.MA027 = node.Attributes["MA027"].Value; COPMA.MA028 = node.Attributes["MA028"].Value; COPMA.MA029 = ""; COPMA.MA030 = ""; COPMA.MA031 = node.Attributes["MA031"].Value; COPMA.MA032 = node.Attributes["MA032"].Value; COPMA.MA033 = node.Attributes["MA033"].Value; COPMA.MA034 = node.Attributes["MA034"].Value; COPMA.MA035 = node.Attributes["MA035"].Value; COPMA.MA036 = node.Attributes["MA036"].Value; COPMA.MA037 = node.Attributes["MA037"].Value; COPMA.MA038 = node.Attributes["MA038"].Value; COPMA.MA039 = node.Attributes["MA039"].Value; COPMA.MA040 = node.Attributes["MA040"].Value; COPMA.MA041 = node.Attributes["MA041"].Value; COPMA.MA042 = node.Attributes["MA042"].Value; COPMA.MA043 = node.Attributes["MA043"].Value; COPMA.MA044 = node.Attributes["MA044"].Value; COPMA.MA045 = node.Attributes["MA045"].Value; COPMA.MA046 = node.Attributes["MA046"].Value; COPMA.MA047 = node.Attributes["MA047"].Value; COPMA.MA048 = node.Attributes["MA048"].Value; COPMA.MA049 = node.Attributes["MA049"].Value; COPMA.MA050 = ""; COPMA.MA051 = ""; COPMA.MA052 = ""; COPMA.MA053 = ""; COPMA.MA054 = ""; COPMA.MA055 = ""; COPMA.MA056 = ""; COPMA.MA057 = ""; COPMA.MA058 = ""; COPMA.MA059 = node.Attributes["MA059"].Value; COPMA.MA060 = node.Attributes["MA060"].Value; COPMA.MA061 = node.Attributes["MA061"].Value; COPMA.MA062 = ""; COPMA.MA063 = ""; COPMA.MA064 = ""; COPMA.MA065 = ""; COPMA.MA066 = node.Attributes["MA066"].Value; COPMA.MA067 = "0"; COPMA.MA068 = ""; COPMA.MA069 = ""; COPMA.MA070 = ""; COPMA.MA071 = node.Attributes["MA071"].Value; COPMA.MA072 = ""; COPMA.MA073 = ""; COPMA.MA074 = ""; COPMA.MA075 = node.Attributes["MA075"].Value; COPMA.MA076 = node.Attributes["MA076"].Value; COPMA.MA077 = ""; COPMA.MA078 = ""; COPMA.MA079 = ""; COPMA.MA080 = ""; COPMA.MA081 = ""; COPMA.MA082 = ""; COPMA.MA083 = node.Attributes["MA083"].Value; COPMA.MA084 = node.Attributes["MA084"].Value; COPMA.MA085 = node.Attributes["MA085"].Value; COPMA.MA086 = node.Attributes["MA086"].Value; COPMA.MA087 = node.Attributes["MA087"].Value; COPMA.MA088 = node.Attributes["MA088"].Value; COPMA.MA089 = node.Attributes["MA089"].Value; COPMA.MA090 = node.Attributes["MA090"].Value; COPMA.MA091 = node.Attributes["MA091"].Value; COPMA.MA092 = node.Attributes["MA092"].Value; COPMA.MA093 = node.Attributes["MA093"].Value; COPMA.MA094 = node.Attributes["MA094"].Value; COPMA.MA095 = node.Attributes["MA095"].Value; COPMA.MA096 = node.Attributes["MA096"].Value; COPMA.MA097 = node.Attributes["MA097"].Value; COPMA.MA098 = node.Attributes["MA098"].Value; COPMA.MA099 = node.Attributes["MA099"].Value; COPMA.MA100 = node.Attributes["MA100"].Value; COPMA.MA101 = node.Attributes["MA101"].Value; COPMA.MA102 = node.Attributes["MA102"].Value; COPMA.MA103 = node.Attributes["MA103"].Value; COPMA.MA104 = ""; COPMA.MA105 = ""; COPMA.MA106 = node.Attributes["MA015"].Value; COPMA.MA107 = ""; COPMA.MA108 = ""; COPMA.MA109 = ""; COPMA.MA110 = ""; COPMA.MA111 = ""; COPMA.MA112 = ""; COPMA.MA113 = "0"; COPMA.MA114 = "0"; COPMA.MA115 = ""; COPMA.MA116 = ""; COPMA.MA117 = ""; COPMA.MA118 = ""; COPMA.MA119 = ""; COPMA.MA120 = ""; COPMA.MA121 = ""; COPMA.MA122 = ""; COPMA.MA123 = ""; COPMA.MA124 = ""; COPMA.MA125 = "0"; COPMA.MA126 = "0"; COPMA.MA127 = node.Attributes["MA127"].Value; COPMA.MA128 = ""; COPMA.MA129 = ""; COPMA.MA130 = ""; COPMA.MA131 = ""; COPMA.MA132 = node.Attributes["MA132"].Value; COPMA.MA133 = node.Attributes["MA133"].Value; COPMA.MA134 = ""; COPMA.MA135 = ""; COPMA.MA136 = ""; COPMA.MA137 = ""; COPMA.MA138 = "0"; COPMA.MA139 = ""; COPMA.MA140 = ""; COPMA.MA141 = "0"; COPMA.MA142 = ""; COPMA.MA143 = ""; COPMA.MA144 = ""; COPMA.MA145 = "0"; COPMA.MA146 = ""; COPMA.MA147 = node.Attributes["MA147"].Value; COPMA.MA148 = node.Attributes["MA148"].Value; COPMA.MA149 = node.Attributes["MA149"].Value; COPMA.MA150 = node.Attributes["MA150"].Value; COPMA.MA151 = "0"; COPMA.MA152 = "0"; COPMA.MA153 = "0"; COPMA.MA154 = "0"; COPMA.MA155 = ""; COPMA.MA156 = ""; COPMA.MA157 = ""; COPMA.MA158 = ""; COPMA.MA159 = ""; COPMA.MA160 = ""; COPMA.MA161 = "Y"; COPMA.MA162 = node.Attributes["MA162"].Value; COPMA.MA163 = ""; COPMA.UDF01 = ""; COPMA.UDF02 = node.Attributes["UDF02"].Value; COPMA.UDF03 = ""; COPMA.UDF04 = ""; COPMA.UDF05 = ""; COPMA.UDF06 = "0"; COPMA.UDF07 = "0"; COPMA.UDF08 = "0"; COPMA.UDF09 = "0"; COPMA.UDF10 = "0"; if (applyTask.FormResult == Ede.Uof.WKF.Engine.ApplyResult.Adopt) { if (!string.IsNullOrEmpty(COPMA.MA001) && !string.IsNullOrEmpty(COPMA.MA002)) { ADDTKCOPMA(COPMA); } } return(""); }
public string GetFormResult(ApplyTask applyTask) { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); CSpecialsaleUCO specialsaleUCO = new CSpecialsaleUCO(); DataRow row = specialsaleUCO.NewRow(); string ORDERNO = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["ORDERNO"].Value; row["ORDERNO"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["ORDERNO"].Value; row["INSURANCE_TYPE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["INSURANCE_TYPE"].Value; row["SPECIAL_TYPE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SPECIAL_TYPE"].Value; row["APPLY_NUM"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["APPLY_NUM"].Value; row["DISCOUNT"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["DISCOUNT"].Value; row["PAY_TYPE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["PAY_TYPE"].Value; row["BIG_TYPE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["BIG_TYPE"].Value; row["MEMO"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["MEMO"].Value; row["CREATE_DATE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["CREATE_DATE"].Value; row["CREATOR"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["Smid"].Value; row["STATUS"] = 0; row["TASK_ID"] = applyTask.TaskId; row["DOC_NBR"] = applyTask.FormNumber; row["SPECIAL_MONEY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["HARDCOVER_PRICE"].Value; try { specialsaleUCO.Insert(row); } catch { } string rdoAPPLY_TYPE = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["rdoAPPLY_TYPE"].Value; string SPECIAL_TYPE = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SPECIAL_TYPE"].Value; double APPLY_NUM_month = 0; try { APPLY_NUM_month = getApplyNum(xmlDoc, SPECIAL_TYPE, rdoAPPLY_TYPE); } catch { } if ("0".Equals(row["BIG_TYPE"].ToString()))//不是大口建材加入判斷 { //20131002 新增須限制超過條件之單據 if (Convert.ToInt32(row["APPLY_NUM"]) > APPLY_NUM_month) { CSpecialCntUCO CSpecialCntUCO = new CSpecialCntUCO(); string l_strBranch = ORDERNO.Substring(1, 2); string l_SaleDay = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SaleDay"].Value; DateTime SaleDay = DateTime.Today; if (!String.IsNullOrEmpty(l_SaleDay)) { SaleDay = Convert.ToDateTime(l_SaleDay); } DataTable specialcnt = CSpecialCntUCO.QueryDatasByBranch(l_strBranch, SaleDay); DataRow row_cnt = specialcnt.Rows[0]; row_cnt["CNT_NOW"] = Convert.ToInt32(row_cnt["CNT_NOW"]) + 1; CSpecialCntUCO.Update(row_cnt); } } //因預設值有問題,故強制修改成值 2013/05/24 振益 xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='is_up']").Attributes["fieldValue"].Value = "否"; xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='type']").Attributes["fieldValue"].Value = "准"; xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='last']").Attributes["fieldValue"].Value = "准"; //2015/03/05 需給室的新需求 CSpecialCntUCO CSpecialCntUCO2 = new CSpecialCntUCO(); string l_saledate = CSpecialCntUCO2.QueryDate(ORDERNO); DateTime l_date = DateTime.Now; DateTime dt = DateTime.ParseExact(l_saledate, "yyyy/MM/dd HH:mm", null); TimeSpan ts = l_date - dt; //TimeSpan為時間的幅度 string l_money = ""; if (ts.Days < 7) { l_money = "1500"; } else { l_money = "1000"; } xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='money']").Attributes["fieldValue"].Value = l_money; xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='part_num']").Attributes["fieldValue"].Value = "0"; applyTask.Task.UpdateCurrentDoc(applyTask.TaskId, xmlDoc.OuterXml); return(""); }
public string GetFormResult(ApplyTask applyTask) { // <Form formVersionId="181f6479-a6e4-409b-820a-9a151e338f74"> // <FormFieldValue> // <FieldItem fieldId="NO" fieldValue="" realValue="" /> // <FieldItem fieldId="data" ConditionValue="" realValue=""> // <FieldValue ORDERNO="F03001000301" INSURANCE_TYPE="0" SPECIAL_TYPE="0" APPLY_NUM="6" DISCOUNT="6" PAY_TYPE="0" BIG_TYPE="2" MEMO="666" /> // </FieldItem> // </FormFieldValue> //</Form> XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); string ORDERNO = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["ORDERNO"].Value; CSpecialsaleUCO CSpecialsaleUCO = new CSpecialsaleUCO(); CPartUCO CPartUCO = new CPartUCO(); string SPECIAL_MONEY = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["HARDCOVER_PRICE"].Value; string SUPPORT_TYPE = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='type']").Attributes["fieldValue"].Value; string LAST_MONTH = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='last']").Attributes["fieldValue"].Value; string SUPPORT_MONEY = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='money']").Attributes["fieldValue"].Value; double CAR_PRICE = Convert.ToDouble(xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["CAR_PRICE"].Value); double APPLY_NUM = Convert.ToDouble(xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["APPLY_NUM"].Value); double HARDCOVER_PRICE = Convert.ToDouble(xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["HARDCOVER_PRICE"].Value); string SPECIAL_TYPE = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SPECIAL_TYPE"].Value; DateTime SaleDay = DateTime.Today; string rdoAPPLY_TYPE = ""; try { rdoAPPLY_TYPE = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["rdoAPPLY_TYPE"].Value; if (!String.IsNullOrEmpty(xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SaleDay"].Value)) { SaleDay = Convert.ToDateTime(xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["SaleDay"].Value); } } catch { } double APPLY_NUM_month = 0; string BIG_TYPE = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["BIG_TYPE"].Value; if (applyTask.FormResult == Fast.EB.WKF.Engine.ApplyResult.Adopt) { //新增兩個欄位同意申請%數與配件同意總金額 double M_NUM = 0; int PART_NUM = 0; switch (SUPPORT_TYPE) { case "大口批售": SUPPORT_TYPE = "1"; break; case "僅核發交車獎金": SUPPORT_TYPE = "2"; break; case "員工購車": SUPPORT_TYPE = "3"; break; case "全不計": SUPPORT_TYPE = "4"; break; case "一般": SUPPORT_TYPE = "5"; break; //20130517 將僅核發交車獎金改成不准,一般改成准 way case "准": SUPPORT_TYPE = "5"; break; case "不准": SUPPORT_TYPE = "2"; break; } switch (LAST_MONTH) { case "准": LAST_MONTH = "0"; break; case "不准": LAST_MONTH = "1"; break; } try { //M_NUM = Convert.ToDouble(xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='m_num']").Attributes["fieldValue"].Value) / 100; M_NUM = Convert.ToDouble(xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["M_APPLY_NUM"].Value) / 100; PART_NUM = Convert.ToInt32(xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='part_num']").Attributes["fieldValue"].Value); } catch { } DataTable specialsaledt = CSpecialsaleUCO.QueryCSpecialsaleDatas(ORDERNO); if (specialsaledt.Rows.Count == 0) { throw new Exception("無特販申請資料,請重新確認!"); } DataRow row = specialsaledt.Rows[0]; row["TASK_ID"] = applyTask.TaskId; row["DOC_NBR"] = applyTask.FormNumber; row["TASK_RESULT"] = (int)applyTask.FormResult; row["SUPPORT_TYPE"] = Convert.ToInt32(SUPPORT_TYPE); row["LAST_MONTH"] = Convert.ToInt32(LAST_MONTH); row["SUPPORT_MONEY"] = Convert.ToInt32(SUPPORT_MONEY); try { row["SPECIAL_MONEY"] = Convert.ToInt32(SPECIAL_MONEY); } catch { row["SPECIAL_MONEY"] = 0; } //地擔可能修改%數,故結案時在驗算一次 row["M_APPLY_NUM"] = M_NUM; row["SPECIAL_TYPE"] = SPECIAL_TYPE; row["PART_MONEY"] = PART_NUM; //舊表單無M_NUM欄位,故沿用舊算法 20120110 way if (M_NUM <= 0) { M_NUM = APPLY_NUM; } //空車:0或精裝:1 if ("0".Equals(SPECIAL_TYPE)) { row["DISCOUNT"] = ((Convert.ToInt32((CAR_PRICE * M_NUM)) / 100) * 100).ToString("N0"); //可摺車架 = 空車*精裝%數 PS:取值至百位數 } else if ("1".Equals(SPECIAL_TYPE)) { //可摺車架 = (空車+精裝)*精裝%數 PS:取值至百位數 row["DISCOUNT"] = ((Convert.ToInt32(((CAR_PRICE + HARDCOVER_PRICE) * M_NUM)) / 100) * 100).ToString("N0"); } CSpecialsaleUCO.Update(row); } else//若表單狀態不為同意則刪除資料避免無法申請 { CSpecialsaleUCO.Delete(ORDERNO); //刪除特販也要刪除配件資料 CPartUCO.DeletePartDatasByOrderNo(ORDERNO); if (!String.IsNullOrEmpty(rdoAPPLY_TYPE)) { if ("0".Equals(BIG_TYPE)) { //20131002 新增須限制超過條件之單據,若作廢或不同意單據則須扣回 APPLY_NUM_month = getApplyNum(xmlDoc, SPECIAL_TYPE, rdoAPPLY_TYPE); if (APPLY_NUM > APPLY_NUM_month) { CSpecialCntUCO CSpecialCntUCO = new CSpecialCntUCO(); string l_strBranch = ORDERNO.Substring(1, 2); DataTable specialcnt = CSpecialCntUCO.QueryDatasByBranch(l_strBranch, SaleDay); DataRow row_cnt = specialcnt.Rows[0]; row_cnt["CNT_NOW"] = Convert.ToInt32(row_cnt["CNT_NOW"]) - 1; CSpecialCntUCO.Update(row_cnt); } } } return(""); } return(""); }
public string GetFormResult(ApplyTask applyTask) { int ROWS = 1; StringBuilder PURTBSB = new StringBuilder(); DATAPURTA DataPURTA = new DATAPURTA(); DATAPURTB DataPURTB = new DATAPURTB(); XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); //找出最後的簽核者 account = xmlDoc.SelectSingleNode("./Form/Applicant").Attributes["account"].Value; //MA001 = applyTask.Task.CurrentDocument.Fields["MA001"].FieldValue.ToString().Trim(); //MA002 = applyTask.Task.CurrentDocument.Fields["MA002"].FieldValue.ToString().Trim(); //針對主檔抓出來的資料作處理 XmlNode node = xmlDoc.SelectSingleNode("./Form/FormFieldValue/FieldItem[@fieldId='PURTAB']"); DataPURTA.TaskId = applyTask.Task.TaskId; DataPURTA.COMPANY = "TK"; DataPURTA.CREATOR = node.SelectSingleNode("FieldValue").Attributes["NAME"].Value; DataPURTA.USR_GROUP = node.SelectSingleNode("FieldValue").Attributes["DEP"].Value; DataPURTA.CREATE_DATE = DateTime.Now.ToString("yyyyMMdd"); DataPURTA.MODIFIER = account; DataPURTA.MODI_DATE = DateTime.Now.ToString("yyyyMMdd"); DataPURTA.FLAG = "1"; DataPURTA.CREATE_TIME = DateTime.Now.ToString("HH:mm:dd"); DataPURTA.MODI_TIME = DateTime.Now.ToString("HH:mm:dd"); DataPURTA.TRANS_TYPE = "P001"; DataPURTA.TRANS_NAME = "PURI05"; DataPURTA.sync_date = ""; DataPURTA.sync_time = ""; DataPURTA.sync_mark = ""; DataPURTA.sync_count = "0"; DataPURTA.DataUser = ""; DataPURTA.DataGroup = node.SelectSingleNode("FieldValue").Attributes["DEP"].Value; DataPURTA.TA001 = "A311"; DataPURTA.TA002 = FINDMAXPURTATA002("A311", node.SelectSingleNode("FieldValue").Attributes["TA003"].Value); DataPURTA.TA003 = node.SelectSingleNode("FieldValue").Attributes["TA003"].Value; DataPURTA.TA004 = node.SelectSingleNode("FieldValue").Attributes["DEP"].Value; DataPURTA.TA005 = applyTask.Task.TaskId; DataPURTA.TA006 = node.SelectSingleNode("FieldValue").Attributes["COMMENT"].Value; DataPURTA.TA007 = "N"; DataPURTA.TA008 = "0"; DataPURTA.TA009 = "9"; DataPURTA.TA010 = "20"; DataPURTA.TA011 = "0"; DataPURTA.TA012 = node.SelectSingleNode("FieldValue").Attributes["NAME"].Value; DataPURTA.TA013 = node.SelectSingleNode("FieldValue").Attributes["TA003"].Value; DataPURTA.TA014 = account; DataPURTA.TA015 = "0"; DataPURTA.TA016 = "N"; DataPURTA.TA017 = "0"; DataPURTA.TA018 = ""; DataPURTA.TA019 = ""; DataPURTA.TA020 = "0"; DataPURTA.TA021 = ""; DataPURTA.TA022 = ""; DataPURTA.TA023 = "0"; DataPURTA.TA024 = "0"; DataPURTA.TA025 = ""; DataPURTA.TA026 = ""; DataPURTA.TA027 = ""; DataPURTA.TA028 = ""; DataPURTA.TA029 = ""; DataPURTA.TA030 = "0"; DataPURTA.TA031 = ""; DataPURTA.TA032 = "0"; DataPURTA.TA033 = ""; DataPURTA.TA034 = ""; DataPURTA.TA035 = ""; DataPURTA.TA036 = "0"; DataPURTA.TA037 = "0"; DataPURTA.TA038 = "0"; DataPURTA.TA039 = "0"; DataPURTA.TA040 = "0"; DataPURTA.TA041 = ""; DataPURTA.TA042 = ""; DataPURTA.TA043 = ""; DataPURTA.TA044 = ""; DataPURTA.TA045 = ""; DataPURTA.TA046 = ""; DataPURTA.UDF01 = ""; DataPURTA.UDF02 = ""; DataPURTA.UDF03 = ""; DataPURTA.UDF04 = ""; DataPURTA.UDF05 = ""; DataPURTA.UDF06 = "0"; DataPURTA.UDF07 = "0"; DataPURTA.UDF08 = "0"; DataPURTA.UDF09 = "0"; DataPURTA.UDF10 = "0"; //針對DETAIL抓出來的資料作處理 foreach (XmlNode nodeDetail in xmlDoc.SelectNodes("./Form/FormFieldValue/FieldItem[@fieldId='PURTAB']/FieldValue/Item")) { DataPURTB.COMPANY = DataPURTA.COMPANY; DataPURTB.CREATOR = DataPURTA.CREATOR; DataPURTB.USR_GROUP = DataPURTA.USR_GROUP; DataPURTB.CREATE_DATE = DataPURTA.CREATE_DATE; DataPURTB.MODIFIER = DataPURTA.MODIFIER; DataPURTB.MODI_DATE = DataPURTA.MODI_DATE; DataPURTB.FLAG = DataPURTA.FLAG; DataPURTB.CREATE_TIME = DataPURTA.CREATE_TIME; DataPURTB.MODI_TIME = DataPURTA.MODI_TIME; DataPURTB.TRANS_TYPE = DataPURTA.TRANS_TYPE; DataPURTB.TRANS_NAME = DataPURTA.TRANS_NAME; DataPURTB.sync_date = DataPURTA.sync_date; DataPURTB.sync_time = DataPURTA.sync_time; DataPURTB.sync_mark = DataPURTA.sync_mark; DataPURTB.sync_count = DataPURTA.sync_count; DataPURTB.DataUser = DataPURTA.DataUser; DataPURTB.DataGroup = DataPURTA.DataGroup; DataPURTB.TB001 = "A311"; DataPURTB.TB002 = DataPURTA.TA002; DataPURTB.TB003 = ROWS.ToString().PadLeft(4, '0'); DataPURTB.TB004 = nodeDetail.Attributes["品號"].Value; DataPURTB.TB009 = nodeDetail.Attributes["數量"].Value; DataPURTB.TB011 = nodeDetail.Attributes["需求日"].Value; DataPURTB.TB012 = nodeDetail.Attributes["單身備註"].Value; DataPURTB.TB024 = nodeDetail.Attributes["單身備註"].Value; PURTBSB.Append(SETADDPURDTB(DataPURTB)); PURTBSB.AppendLine(); ROWS = ROWS + 1; } if (applyTask.FormResult == Ede.Uof.WKF.Engine.ApplyResult.Adopt) { if (!string.IsNullOrEmpty(DataPURTA.TA001) && !string.IsNullOrEmpty(DataPURTA.TA002)) { UPDATETB_WKF_TASK(applyTask, DataPURTA.TA001, DataPURTA.TA002); INSERTINTOPURTAB(DataPURTA, PURTBSB, applyTask.FormNumber); } } return(""); }
public string GetFormResult(ApplyTask applyTask) { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); COrderUCO COrderUCO = new COrderUCO(); //訂單需要同意才進入 if (applyTask.FormResult == Fast.EB.WKF.Engine.ApplyResult.Adopt) { DataRow row = COrderUCO.NewRow(); row["f_orderno"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='f_orderno']").Attributes["fieldValue"].Value; row["f_unit"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='f_unit']").Attributes["fieldValue"].Value; row["f_EMP"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='f_EMP']").Attributes["fieldValue"].Value; row["f_empid"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='f_empid']").Attributes["fieldValue"].Value; row["f_phone"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='f_phone']").Attributes["fieldValue"].Value; row["f_title"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='f_title']").Attributes["fieldValue"].Value; row["f_editday"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='f_editday']").Attributes["fieldValue"].Value; row["f_memo"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='f_memo']").Attributes["fieldValue"].Value; //以下為自訂表單設計寫法 //row["f_editday"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["f_editday"].Value; //row["f_memo"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='data']/FieldValue").Attributes["f_memo"].Value; row["TASK_ID"] = applyTask.TaskId; row["DOC_NBR"] = applyTask.FormNumber; // <Form formVersionId="9bb3b460-be3a-4c64-966b-d96f51994c13"> // <FormFieldValue> // <FieldItem fieldId="f_orderno" fieldValue="" realValue="" /> // <FieldItem fieldId="f_editday" fieldValue="2012/06/26" realValue="" fillerName="柯美如" fillerUserGuid="3946ad43-b66f-4abd-a6a6-84a755080f1d" fillerAccount="EA001" fillSiteId="" /> // <FieldItem fieldId="f_empid" fieldValue="柯美如" realValue="" /> // <FieldItem fieldId="f_unit" fieldValue="資訊室" realValue="435b7eb3-1f24-0d16-42e3-2841ad415fe9,資訊室,False" /> // <FieldItem fieldId="det" fillerName="柯美如" fillerUserGuid="3946ad43-b66f-4abd-a6a6-84a755080f1d" fillerAccount="EA001" fillSiteId=""> // <DataGrid> // <Row order="0"> // <Cell fieldId="f_proname" fieldValue="其他" realValue="" /> // <Cell fieldId="f_amount" fieldValue="1" realValue="" /> // <Cell fieldId="f_reason" fieldValue="測試" realValue="" /> // </Row> // </DataGrid> // </FieldItem> // <FieldItem fieldId="f_memo" fieldValue="" realValue="" fillerName="柯美如" fillerUserGuid="3946ad43-b66f-4abd-a6a6-84a755080f1d" fillerAccount="EA001" fillSiteId="" /> // </FormFieldValue> //</Form> double l_dou總額 = 0; double l_dou數量 = 0; COrderdetailUCO COrderdetailUCO = new COrderdetailUCO(); string l_str名稱 = ""; //判斷明細有資料列 if (xmlDoc.SelectNodes("/Form/FormFieldValue/FieldItem[@fieldId='det']/DataGrid/Row") != null) { //取得列 XmlNodeList sequenceCode = xmlDoc.SelectNodes("/Form/FormFieldValue/FieldItem[@fieldId='det']/DataGrid/Row"); //取得欄 foreach (XmlNode xmlN in sequenceCode) { DataRow l_row = COrderdetailUCO.NewRow(); l_row["f_proname"] = xmlN.SelectSingleNode("./Cell[@fieldId='f_proname']").Attributes["fieldValue"].Value;; l_str名稱 = l_row["f_proname"].ToString(); double l_dou單價 = probyname(l_str名稱); l_row["f_amount"] = xmlN.SelectSingleNode("./Cell[@fieldId='f_amount']").Attributes["fieldValue"].Value; l_dou數量 = Convert.ToDouble(l_row["f_amount"]); l_row["f_reason"] = xmlN.SelectSingleNode("./Cell[@fieldId='f_reason']").Attributes["fieldValue"].Value; l_row["f_orderno"] = row["f_orderno"]; l_row["f_price"] = l_dou單價; l_dou總額 += (l_dou單價 * l_dou數量); COrderdetailUCO.Insert(l_row); } } row["f_total"] = l_dou總額; COrderUCO.Insert(row); } return(""); }
public string GetFormResult(ApplyTask applyTask) { string FORMID = null; string TA001 = null; string TA002 = null; string TA006 = null; string TB003 = null; string TB004 = null; string TB009 = null; string TB011 = null; string TB012 = null; string ADDSQL = null; ////找到明細的XML物件 //XElement xe = XElement.Parse(applyTask.CurrentDocXML); //var nodes = (from xl in xe.Element("FormFieldValue").Elements("FieldItem") // where xl.Attribute("fieldId").Value == "TB" // select xl).FirstOrDefault(); ////找出PO_DETAIL的所有ROW集合 //foreach (var node in nodes.Element("DataGrid").Elements("Row")) //{ // //找出所有ROW的CELL // var cells = node.Elements("Cell"); // var PO_ITEM01的值 = cells.Where(p => p.Attribute("fieldId").Value == "PO_ITEM01").FirstOrDefault().Attribute("fieldValue"); // var MATERIAL_011的值 = cells.Where(p => p.Attribute("fieldId").Value == "MATERIAL_01").FirstOrDefault().Attribute("fieldValue"); // //........以此類推 //} ///核準 if (applyTask.FormResult == Ede.Uof.WKF.Engine.ApplyResult.Adopt) { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(applyTask.CurrentDocXML); FORMID = applyTask.FormNumber; TA001 = applyTask.Task.CurrentDocument.Fields["TA001"].FieldValue.ToString().Trim(); TA002 = applyTask.Task.CurrentDocument.Fields["TA002"].FieldValue.ToString().Trim(); TA006 = applyTask.Task.CurrentDocument.Fields["TA006"].FieldValue.ToString().Trim(); //針對DETAIL抓出來的資料作處理 Ede.Uof.WKF.Design.FieldDataGrid grid = applyTask.Task.CurrentDocument.Fields["TB"] as Ede.Uof.WKF.Design.FieldDataGrid; foreach (var row in grid.FieldDataGridValue.RowValueList) { foreach (var cell in row.CellValueList) { if (cell.fieldId == "TB003") { TB003 = cell.fieldValue; } if (cell.fieldId == "TB004") { TB004 = cell.fieldValue; } if (cell.fieldId == "TB009") { TB009 = cell.fieldValue; } if (cell.fieldId == "TB011") { TB011 = cell.fieldValue; } if (cell.fieldId == "TB012") { TB012 = cell.fieldValue; } } if (!string.IsNullOrEmpty(FORMID) && !string.IsNullOrEmpty(TA001) && !string.IsNullOrEmpty(TA002)) { ADDSQL = ADDSQL + SETPURTATBUOFCHANGE(FORMID, TA001, TA002, TA006, TB003, TB004, TB009, TB011, TB012); ADDSQL = ADDSQL + " "; } } ADDPURTATBUOFCHANGE(FORMID, TA001, TA002, ADDSQL); } return(""); }