public static string getJOBTitle(string user_guid)
{
COrderUCO COrderUCO = new COrderUCO();
DataTable dt = COrderUCO.QueryDatasByGuid(user_guid);
if (dt.Rows.Count > 0)
{
return(dt.Rows[0]["TITLE_NAME"].ToString());
}
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("");
}
