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 static void setBRANCHs(DropDownList ddl)
{
CPetitionUCO CPetitionUCO = new CPetitionUCO();
DataTable dt = CPetitionUCO.QueryBranchDatas();
for (int i = 0; i < dt.Rows.Count; i++)
{
ddl.Items.Add(new ListItem(dt.Rows[i]["GROUP_NAME"].ToString(), dt.Rows[i]["GROUP_ID"].ToString()));
}
ddl.Items.Insert(0, new ListItem("", ""));
}
public static DDLObject[] getBRANCHs()
{
List <DDLObject> results = new List <DDLObject>();
CPetitionUCO CPetitionUCO = new CPetitionUCO();
DataTable dt = CPetitionUCO.QueryBranchDatas();
for (int i = 0; i < dt.Rows.Count; i++)
{
results.Add(new DDLObject()
{
ID = dt.Rows[i]["GROUP_ID"].ToString(), Name = dt.Rows[i]["GROUP_NAME"].ToString()
});
}
//results.Add(new DDLObject() { ID = "01", Name = "北高" });
//results.Add(new DDLObject() { ID = "02", Name = "屏東" });
//results.Add(new DDLObject() { ID = "03", Name = "九如" });
//results.Add(new DDLObject() { ID = "04", Name = "麟洛" });
//results.Add(new DDLObject() { ID = "05", Name = "小港" });
//results.Add(new DDLObject() { ID = "06", Name = "Test" });
//results.Add(new DDLObject() { ID = "07", Name = "AAAA" });
return(results.ToArray());
}
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("");
}