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("");
}
