public string GetFormResult(Fast.EB.WKF.ExternalUtility.ApplyTask applyTask)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(applyTask.CurrentDocXML);
CTB_HR_ASSESS_SEVRICEUCO l_sevrice = new CTB_HR_ASSESS_SEVRICEUCO();
//簽核中需要同意才進入
if (applyTask.SignResult == Fast.EB.WKF.Engine.SignResult.Approve)
{
string l_strSMID = "";
XmlNodeList sequenceCode = xmlDoc.SelectNodes("/Form/FormFieldValue//FieldValue/Item");
if (sequenceCode != null)
{
foreach (XmlNode xmlN in sequenceCode)
{
DataRow l_row = l_sevrice.NewRow();
l_row["NAME"] = xmlN.Attributes["NAME"].Value;
l_row["FUNC_NAME"] = xmlN.Attributes["FUNC_NAME"].Value;
l_row["TITLE_NAME"] = xmlN.Attributes["TITLE_NAME"].Value;
l_row["ACCOUNT"] = xmlN.Attributes["ACCOUNT"].Value;
l_strSMID = xmlN.Attributes["ACCOUNT"].Value;
l_row["CREATE_DATE"] = xmlN.Attributes["CREATE_DATE"].Value;
l_row["RANK_Y"] = xmlN.Attributes["RANK_Y"].Value;
l_row["MEMO"] = xmlN.Attributes["MEMO"].Value;
l_row["GUID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='GUID']").Attributes["fieldValue"].Value;
l_row["GROUP_NAME"] = Current.User.GroupName;
l_row["SMID"] = Current.Account;
l_row["SIGNER"] = Current.Name;
l_row["EDIT_DATE"] = DateTime.Today.ToString("yyyy/MM/dd");
l_row["TASK_ID"] = applyTask.TaskId;
l_row["SITE_CODE"] = applyTask.SiteCode;
int l_int月份 = DateTime.Today.Month;
if (l_int月份 > 9 || l_int月份 < 3)
{
l_row["ASSESS_TYPE"] = "年終";
}
else if (2 < l_int月份 && l_int月份 < 7)
{
l_row["ASSESS_TYPE"] = "端午";
}
else if (6 < l_int月份 && l_int月份 < 10)
{
l_row["ASSESS_TYPE"] = "中秋";
}
DataTable l_dt = l_sevrice.getDatsByID(l_strSMID, applyTask.SiteCode, applyTask.TaskId);
if (l_dt != null && l_dt.Rows.Count > 0)
{
l_sevrice.Update(l_row);
}
else
{
l_sevrice.Insert(l_row);
}
}
}
}
return("");
}
public string GetFormResult(Fast.EB.WKF.ExternalUtility.ApplyTask applyTask)
{
CTB_HR_NS_TempUCO l_Temp = new CTB_HR_NS_TempUCO();
//訂單需要同意才進入
if (applyTask.FormResult == Fast.EB.WKF.Engine.ApplyResult.UnKnow)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(applyTask.CurrentDocXML);
XmlNode node = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='NS_upload']/FieldValue");
string l_NS_GUID = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='NS_GUID']").Attributes["fieldValue"].Value;
DataTable l_dt = l_Temp.getData("");
for (int i = 0; i < l_dt.Rows.Count; i++)
{
string l_GUID = l_dt.Rows[i]["GUID"].ToString();
l_Temp.updateGUIDbyDate(l_NS_GUID, l_GUID);
}
}
//訂單否決刪除單子
else
{
l_Temp.DeletebyNS_GUID("");
}
return("");
}
public string GetFormResult(Fast.EB.WKF.ExternalUtility.ApplyTask applyTask)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(applyTask.CurrentDocXML);
CTB_HR_ASSESS_SEVRICEUCO l_sevrice = new CTB_HR_ASSESS_SEVRICEUCO();
XmlNodeList sequenceCode = xmlDoc.SelectNodes("/Form/FormFieldValue//FieldValue/Item");
if (sequenceCode != null)
{
foreach (XmlNode xmlN in sequenceCode)
{
DataRow l_row = l_sevrice.NewRow();
l_row["TITLE_NAME"] = xmlN.Attributes["TITLE_NAME"].Value;
l_row["FUNC_NAME"] = xmlN.Attributes["FUNC_NAME"].Value;
l_row["ACCOUNT"] = xmlN.Attributes["ACCOUNT"].Value;
l_row["NAME"] = xmlN.Attributes["NAME"].Value;
l_row["Total"] = xmlN.Attributes["Total"].Value;
l_row["RANK"] = xmlN.Attributes["RANK"].Value;
l_row["MEMO"] = xmlN.Attributes["MEMO"].Value;
l_row["SMID"] = xmlN.Attributes["SMID"].Value;
l_row["GROUP_NAME"] = xmlN.Attributes["GROUP_NAME"].Value;
string l_strSMID = xmlN.Attributes["SMID"].Value;
l_row["GUID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='GUID']").Attributes["fieldValue"].Value;
l_row["SITE_CODE"] = "S1";
l_row["SIGNER"] = Current.Name;
l_row["EDIT_DATE"] = DateTime.Today.ToString("yyyy/MM/dd");
l_row["TASK_ID"] = applyTask.TaskId;
if (_int月份 > 9 || _int月份 < 3)
{
l_row["Total_Y"] = xmlN.Attributes["Total_Y"].Value;
l_row["RANK_Y"] = xmlN.Attributes["RANK_Y"].Value;
l_row["ASSESS_TYPE"] = "年終";
l_row["YEAR"] = (Convert.ToInt32(DateTime.Today.Year.ToString()) - 1).ToString();
}
else if (2 < _int月份 && _int月份 < 7)
{
l_row["ASSESS_TYPE"] = "端午";
l_row["YEAR"] = DateTime.Today.Year.ToString();
}
else if (6 < _int月份 && _int月份 < 10)
{
l_row["ASSESS_TYPE"] = "中秋";
l_row["YEAR"] = DateTime.Today.Year.ToString();
}
DataTable l_dt = l_sevrice.getDatsByID(l_strSMID, applyTask.SiteCode, applyTask.TaskId);
if (l_dt != null && l_dt.Rows.Count > 0)
{
l_sevrice.UpdateByTASKID(l_row);
}
else
{
l_sevrice.Insert(l_row);
}
}
}
return("");
}
public string GetFormResult(Fast.EB.WKF.ExternalUtility.ApplyTask applyTask)
{
CTB_HR_Nuclear_Salary_UCO l_Nuclear_Salary_UCO = new CTB_HR_Nuclear_Salary_UCO();
CTB_HR_NS_TempUCO l_Temp = new CTB_HR_NS_TempUCO();
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(applyTask.CurrentDocXML);
XmlNode node = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='NS_upload']/FieldValue");
string l_NS_GUID = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='NS_GUID']").Attributes["fieldValue"].Value;
//訂單需要同意才進入
if (applyTask.FormResult == Fast.EB.WKF.Engine.ApplyResult.Adopt)
{
DataTable l_dt = l_Temp.getData(l_NS_GUID);
for (int i = 0; i < l_dt.Rows.Count; i++)
{
string l_strAccoiun = l_dt.Rows[i]["ACCOUNT"].ToString();
string l_US_GUID = l_Temp.getUS_GUIDbyACCOUNT(l_strAccoiun);
DataRow l_row = l_Nuclear_Salary_UCO.NewRow();
l_row["TASK_ID"] = applyTask.TaskId;
l_row["NS_GUID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='NS_GUID']").Attributes["fieldValue"].Value;
l_row["Creat_Date"] = DateTime.Today;
l_row["SINGER"] = Current.Name;
l_row["USER_GUID"] = l_US_GUID;
l_row["NS_Year"] = node.Attributes["NS_Year"].Value;
l_row["NS_Month"] = node.Attributes["NS_Month"].Value;
l_row["CLASS"] = l_dt.Rows[i]["CLASS"].ToString();
l_row["MOVE_DATE"] = l_dt.Rows[i]["MOVE_DATE"].ToString();
l_row["MOVE_TYPE"] = TurnWord(l_dt.Rows[i]["MOVE_TYPE"].ToString());
l_row["MEMO"] = l_dt.Rows[i]["MEMO"].ToString();
l_row["Group_Name"] = l_dt.Rows[i]["Group_Name"].ToString();
l_row["TITLE_NAME"] = l_dt.Rows[i]["TITLE_NAME"].ToString();
l_row["OPTION1"] = l_dt.Rows[i]["OPTION1"].ToString();
l_row["Base_Salary"] = l_dt.Rows[i]["Base_Salary"].ToString();
l_row["Food_Allowance"] = l_dt.Rows[i]["Food_Allowance"].ToString();
l_row["Full_Bonus"] = l_dt.Rows[i]["Full_Bonus"].ToString();
l_row["Position_Bonus"] = l_dt.Rows[i]["Position_Bonus"].ToString();
l_row["Learder_Bonus"] = l_dt.Rows[i]["Learder_Bonus"].ToString();
l_row["Skill_Bonus"] = l_dt.Rows[i]["Skill_Bonus"].ToString();
l_row["License_Bonus"] = l_dt.Rows[i]["License_Bonus"].ToString();
l_row["Experience_Bonus"] = l_dt.Rows[i]["Experience_Bonus"].ToString();
l_row["Other_Bonus"] = l_dt.Rows[i]["Other_Bonus"].ToString();
l_row["Bonus_Sum"] = l_dt.Rows[i]["Bonus_Sum"].ToString();
l_Nuclear_Salary_UCO.Insert(l_row);
}
}
//訂單否決刪除單子
else
{
l_Nuclear_Salary_UCO.Delete(applyTask.TaskId);
l_Temp.DeletebyNS_GUID(l_NS_GUID);
}
return("");
}
public string GetFormResult(Fast.EB.WKF.ExternalUtility.ApplyTask applyTask)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(applyTask.CurrentDocXML);
CTB_HR_PERTUCO l_pert = new CTB_HR_PERTUCO();
//訂單需要同意才進入
if (applyTask.FormResult == Fast.EB.WKF.Engine.ApplyResult.Adopt)
{
string l_str考核種類 = "";
XmlNodeList sequenceCode = xmlDoc.SelectNodes("/Form/FormFieldValue//FieldValue/Item");
if (sequenceCode != null)
{
foreach (XmlNode xmlN in sequenceCode)
{
DataRow l_row = l_pert.NewRow();
l_row["PERTNO"] = Guid.NewGuid().ToString();
l_row["GUID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='GUID']").Attributes["fieldValue"].Value;
l_row["SMID"] = xmlN.Attributes["ACCOUNT"].Value;
l_row["ASSESS_TYPE"] = "年終";
l_row["RANK_Y"] = xmlN.Attributes["RANK_Y"].Value;
l_str考核種類 = "年終";
l_row["EDIT_DATE"] = DateTime.Today.ToString("yyyy/MM/dd");
l_row["YEAR"] = (Convert.ToInt32(DateTime.Today.Year.ToString()) - 1).ToString();
l_row["TASK_ID"] = applyTask.TaskId;
string l_年度 = (Convert.ToInt32(DateTime.Today.Year.ToString()) - 1).ToString();
DataTable l_dt = l_pert.check(xmlN.Attributes["ACCOUNT"].Value, l_str考核種類, l_年度);
if (l_dt != null && l_dt.Rows.Count > 0)
{
return("");
}
else
{
l_pert.Insert(l_row);
}
}
}
}
//訂單否決刪除單子
else
{
//刪除明細檔
CTB_HR_ASSESS_SEVRICEUCO l_SEVRICE = new CTB_HR_ASSESS_SEVRICEUCO();
l_SEVRICE.DeletebyReject(applyTask.TaskId);
}
return("");
}
public string GetFormResult(Fast.EB.WKF.ExternalUtility.ApplyTask applyTask)
{
CTB_REW_StaffPresentCarUCO SPC = new CTB_REW_StaffPresentCarUCO();
CTB_HR_GROUPUCO GROUPUCO = new CTB_HR_GROUPUCO();
if (applyTask.FormResult == Fast.EB.WKF.Engine.ApplyResult.Adopt)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(applyTask.CurrentDocXML);
DataRow l_row = SPC.NewRow();
l_row["TASK_ID"] = applyTask.TaskId;
l_row["GUID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='GUID']").Attributes["fieldValue"].Value;
l_row["Date"] = DateTime.Today;
l_row["PresentAccount"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='PresentAccount']").Attributes["fieldValue"].Value;
string PresentAccount = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='PresentAccount']").Attributes["fieldValue"].Value;
l_row["PresentUnit"] = GROUPUCO.getGroupIDbySMID(PresentAccount, "", "");
l_row["PresentName"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='PresentName']").Attributes["fieldValue"].Value;
l_row["BuyType"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='BuyType']").Attributes["fieldValue"].Value;
XmlNode node = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='StaffPresentCar']/FieldValue");
l_row["Orderno"] = node.Attributes["Orderno"].Value;
l_row["Plate"] = node.Attributes["Plate"].Value;
l_row["CarName"] = node.Attributes["CarName"].Value;
l_row["CustomerName"] = node.Attributes["CustomerName"].Value;
l_row["EngNo"] = node.Attributes["EngNo"].Value;
l_row["StaffAccount"] = node.Attributes["StaffAccount"].Value;
string ACCOUNT = node.Attributes["StaffAccount"].Value;
//l_row["StaffName"] = node.Attributes["StaffName"].Value;
l_row["StaffName"] = GROUPUCO.getNamebySMID(ACCOUNT);
l_row["Unit"] = GROUPUCO.getGroupIDbySMID(ACCOUNT, "", "");
SPC.Insert(l_row);
}
//訂單否決刪除單子
else
{
SPC.Delete(applyTask.TaskId);
}
return("");
}
public string GetFormResult(Fast.EB.WKF.ExternalUtility.ApplyTask applyTask)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(applyTask.CurrentDocXML);
CTB_HR_OffDuty_UCO OffDutyUCO = new CTB_HR_OffDuty_UCO();
XmlNode node = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='OffDutyPaper']/FieldValue");
//表單需要起單就進入
if (applyTask.FormResult == Fast.EB.WKF.Engine.ApplyResult.UnKnow)
{
DataRow dr = OffDutyUCO.NewRow();
dr["Sid"] = Guid.NewGuid().ToString();
dr["EmpNo"] = node.Attributes["EMPNO"].Value;
dr["Name"] = node.Attributes["NAME"].Value;
dr["Unit"] = node.Attributes["UNIT"].Value;
dr["Title"] = node.Attributes["TITLE"].Value;
dr["OnDutyDate"] = node.Attributes["ONDUTYDATE"].Value;
dr["OffDutyDate"] = node.Attributes["OFFDUTYDATE"].Value;
dr["Phone"] = node.Attributes["PHONE"].Value;
dr["CellPhone"] = node.Attributes["CELLPHONE"].Value;
dr["Address"] = node.Attributes["ADDRESS"].Value;
dr["Reason"] = node.Attributes["REASON"].Value;
string memo = "";
for (int i = 1; i <= 10; i++)
{
if (node.Attributes["CB" + i].Value.Equals("true"))
{
memo += i + "_";
}
}
dr["Memo"] = memo;
OffDutyUCO.InsertData(dr);
}
return("");
}
public string GetFormResult(Fast.EB.WKF.ExternalUtility.ApplyTask applyTask)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(applyTask.CurrentDocXML);
CTB_HR_OffDuty_UCO OffDutyUCO = new CTB_HR_OffDuty_UCO();
XmlNode node = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='OffDutyPaper']/FieldValue");
//訂單需要同意才進入
if (applyTask.FormResult == Fast.EB.WKF.Engine.ApplyResult.Adopt)
{
}
else
{
string l_EMPNO = node.Attributes["EMPNO"].Value;
OffDutyUCO.DeleteData(l_EMPNO);
}
return("");
}
public string GetFormResult(Fast.EB.WKF.ExternalUtility.ApplyTask applyTask)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(applyTask.CurrentDocXML);
CTB_HR_PERTUCO l_pert = new CTB_HR_PERTUCO();
//訂單需要同意才進入
if (applyTask.FormResult == Fast.EB.WKF.Engine.ApplyResult.Adopt)
{
string l_str考核種類 = "";
DataRow l_row = l_pert.NewRow();
l_row["PERTNO"] = Guid.NewGuid().ToString();
l_row["GUID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='GUID']").Attributes["fieldValue"].Value;
string l_strTaskid = applyTask.TaskId;
CTB_HR_ASSESS_ASSISTAN_MANAGERUCO l_MANAGER = new CTB_HR_ASSESS_ASSISTAN_MANAGERUCO();
DataTable dt = l_MANAGER.getlast(l_strTaskid);
l_row["SMID"] = dt.Rows[0]["SMID"].ToString();
string l_strSMID = dt.Rows[0]["SMID"].ToString();
l_row["RANK"] = dt.Rows[0]["RANK"].ToString();
l_row["RANK_Y"] = dt.Rows[0]["RANK_Y"].ToString();
int l_int月份 = DateTime.Today.Month;
if (l_int月份 > 9 || l_int月份 < 3)
{
l_row["ASSESS_TYPE"] = "年終";
l_str考核種類 = "年終";
}
else if (2 < l_int月份 && l_int月份 < 7)
{
l_row["ASSESS_TYPE"] = "端午";
l_str考核種類 = "端午";
}
else if (6 < l_int月份 && l_int月份 < 10)
{
l_row["ASSESS_TYPE"] = "中秋";
l_str考核種類 = "中秋";
}
l_row["Form_TYPE"] = "副理級以上";
l_row["EDIT_DATE"] = DateTime.Today.ToString("yyyy/MM/dd");
l_row["YEAR"] = DateTime.Today.Year.ToString();
l_row["TASK_ID"] = applyTask.TaskId;
string l_年度 = DateTime.Today.Year.ToString();
DataTable l_dt = l_pert.check(l_strSMID, l_str考核種類, l_年度);
if (l_dt != null && l_dt.Rows.Count > 0)
{
return("");
}
else
{
l_pert.Insert(l_row);
}
}
//訂單否決刪除單子
else
{
//刪除明細檔
CTB_HR_ASSESS_ASSISTAN_MANAGERUCO l_MANAGER = new CTB_HR_ASSESS_ASSISTAN_MANAGERUCO();
l_MANAGER.DeletebyReject(applyTask.TaskId);
}
return("");
}
public string GetFormResult(Fast.EB.WKF.ExternalUtility.ApplyTask applyTask)
{
//<Form formVersionId="86bd41c0-7a8f-4c16-b0cb-08b84da7f0e1">
// <FormFieldValue>
// <FieldItem fieldId="Assess-Compettent" fieldValue="WKF121000001" realValue="" />
// <FieldItem fieldId="Competent" ConditionValue="" realValue="">
// <FieldValue KPI_Performance="" KPI_Ploy="" KPI_Improve=""
//Communication="" Attitude="" Cooperation="" Subordinate="" Risk=""
//CS="" Staff_Car="" total="" grade="" />
// </FieldItem>
// </FormFieldValue>
//</Form>
if (applyTask.SignResult == Fast.EB.WKF.Engine.SignResult.Approve) //簽核中需要同意才進入
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(applyTask.CurrentDocXML);
XmlNode node = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Competent']/FieldValue");
CTB_HR_ASSESS_COMPTENT_DETAILUCO l_detail = new CTB_HR_ASSESS_COMPTENT_DETAILUCO();
DataRow row = l_detail.NewRow();
row["GUID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='GUID']").Attributes["fieldValue"].Value;
//自訂欄位的寫法
row["SMID"] = node.Attributes["SMID"].Value;
row["KPI_Performance"] = node.Attributes["KPI_Performance"].Value;
row["KPI_Ploy"] = node.Attributes["KPI_Ploy"].Value;
row["KPI_Improve"] = node.Attributes["KPI_Improve"].Value;
row["Communication"] = node.Attributes["Communication"].Value;
row["Attitude"] = node.Attributes["Attitude"].Value;
row["Cooperation"] = node.Attributes["Cooperation"].Value;
row["Subordinate"] = node.Attributes["Subordinate"].Value;
row["Risk"] = node.Attributes["Risk"].Value;
row["CS"] = node.Attributes["CS"].Value;
if (String.IsNullOrEmpty(node.Attributes["Staff_Car"].Value))
{
node.Attributes["Staff_Car"].Value = "0";
}
row["Staff_Car"] = node.Attributes["Staff_Car"].Value;
row["TOTAL"] = node.Attributes["Total"].Value;
row["RANK_Y"] = node.Attributes["RANK_Y"].Value;
row["SIGNER"] = Current.Name;
row["TASK_ID"] = applyTask.TaskId;
row["SITE_CODE"] = applyTask.SiteCode;
row["EDIT_DATE"] = DateTime.Today.ToString("yyyy/MM/dd");
int l_int月份 = DateTime.Today.Month;
if (l_int月份 > 9 || l_int月份 < 3)
{
row["ASSESS_TYPE"] = "年終";
}
else if (2 < l_int月份 && l_int月份 < 7)
{
row["ASSESS_TYPE"] = "端午";
}
else if (6 < l_int月份 && l_int月份 < 10)
{
row["ASSESS_TYPE"] = "中秋";
}
DataTable l_dt = l_detail.getDatsByID(applyTask.TaskId, applyTask.SiteCode);
if (l_dt != null && l_dt.Rows.Count > 0)
{
l_detail.UpdateByTASKID(row);
}
else
{
l_detail.Insert(row);
}
//xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Competent']").InnerXml = "";
//AssessCompetentPO po = new AssessCompetentPO();
//po.UpdateCurrentDoc(applyTask.TaskId, xmlDoc.OuterXml);
}
return("");
}
public string GetFormResult(Fast.EB.WKF.ExternalUtility.ApplyTask applyTask)
{
CTB_HR_Nuclear_Salary_UCO l_Nuclear_Salary_UCO = new CTB_HR_Nuclear_Salary_UCO();
//訂單需要同意才進入
if (applyTask.FormResult == Fast.EB.WKF.Engine.ApplyResult.Adopt)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(applyTask.CurrentDocXML);
XmlNode node = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Nuclear_Salary']/FieldValue");
DataRow l_row = l_Nuclear_Salary_UCO.NewRow();
l_row["TASK_ID"] = applyTask.TaskId;
l_row["NS_GUID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='NS_GUID']").Attributes["fieldValue"].Value;
l_row["Creat_Date"] = DateTime.Today;
l_row["SINGER"] = Current.Name;
//自訂欄位的寫法
l_row["USER_GUID"] = node.Attributes["USER_GUID"].Value;
l_row["CLASS"] = node.Attributes["CLASS"].Value;
l_row["MOVE_DATE"] = node.Attributes["MOVE_DATE"].Value;
l_row["MOVE_TYPE"] = node.Attributes["MOVE_TYPE"].Value;
string l_MOVE_TYPE = node.Attributes["MOVE_TYPE"].Value;
l_row["MEMO"] = node.Attributes["MEMO"].Value;
l_row["NS_Year"] = node.Attributes["NS_Year"].Value;
l_row["NS_Month"] = node.Attributes["NS_Month"].Value;
if (l_MOVE_TYPE == "N")
{
l_row["Labor_Protectoin"] = node.Attributes["Labor_Protectoin"].Value;
l_row["Health_Insurance"] = node.Attributes["Health_Insurance"].Value;
l_row["Labor_Pension"] = node.Attributes["Labor_Pension"].Value;
l_row["Group_Insurance"] = node.Attributes["Group_Insurance"].Value;
l_row["Buraden_Sum"] = node.Attributes["Buraden_Sum"].Value;
}
else if (l_MOVE_TYPE == "M")
{
l_row["Posting_Year"] = node.Attributes["Posting_Year"].Value;
l_row["Posting_Number"] = node.Attributes["Posting_Number"].Value;
}
else if (l_MOVE_TYPE == "O")
{
l_row["Other_Move"] = node.Attributes["Other_Move"].Value;
}
l_row["Group_Name"] = node.Attributes["Group_Name"].Value;
l_row["TITLE_NAME"] = node.Attributes["TITLE_NAME"].Value;
l_row["OPTION1"] = node.Attributes["OPTION1"].Value;
l_row["Base_Salary"] = node.Attributes["Base_Salary"].Value;
l_row["Food_Allowance"] = node.Attributes["Food_Allowance"].Value;
l_row["Full_Bonus"] = node.Attributes["Full_Bonus"].Value;
l_row["Position_Bonus"] = node.Attributes["Position_Bonus"].Value;
l_row["Learder_Bonus"] = node.Attributes["Learder_Bonus"].Value;
l_row["Skill_Bonus"] = node.Attributes["Skill_Bonus"].Value;
l_row["License_Bonus"] = node.Attributes["License_Bonus"].Value;
l_row["Experience_Bonus"] = node.Attributes["Experience_Bonus"].Value;
l_row["Other_Bonus"] = node.Attributes["Other_Bonus"].Value;
l_row["Bonus_Sum"] = node.Attributes["Bonus_Sum"].Value;
l_Nuclear_Salary_UCO.Insert(l_row);
}
//訂單否決刪除單子
else
{
l_Nuclear_Salary_UCO.Delete(applyTask.TaskId);
}
return("");
}
public string GetFormResult(Fast.EB.WKF.ExternalUtility.ApplyTask applyTask)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(applyTask.CurrentDocXML);
CTB_HR_ASSESS_GENERALUCO l_General = new CTB_HR_ASSESS_GENERALUCO();
if (applyTask.SignResult == Fast.EB.WKF.Engine.SignResult.Approve) //簽核中需要同意才進入
{
DataRow row = l_General.NewRow();
row["GUID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='GUID']").Attributes["fieldValue"].Value;
//自訂欄位的寫法
row["SMID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["SMID"].Value;
row["EFFICIENCY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["EFFICIENCY"].Value;
row["PERFORMANCE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["PERFORMANCE"].Value;
row["ATTITUDE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["ATTITUDE"].Value;
row["PROVISION"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["PROVISION"].Value;
row["SPIRIT"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["SPIRIT"].Value;
row["TIDY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["TIDY"].Value;
row["COORDINATION"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["COORDINATION"].Value;
row["SPECIALTY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["SPECIALTY"].Value;
row["REACTION"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["REACTION"].Value;
row["Total"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["Total"].Value;
row["RANK"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["RANK"].Value;
row["SIGNER"] = Current.Name;
row["EDIT_DATE"] = DateTime.Today.ToString("yyyy/MM/dd");
row["TASK_ID"] = applyTask.TaskId;
row["SITE_CODE"] = applyTask.SiteCode;
int l_int月份 = DateTime.Today.Month;
//Current.User.GroupID 此為登入者的部門
//非年終不用進去
if (l_int月份 > 9 || l_int月份 < 3)
{
row["EFFICIENCY_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["EFFICIENCY_Y"].Value;
row["PERFORMANCE_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["PERFORMANCE_Y"].Value;
row["ATTITUDE_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["ATTITUDE_Y"].Value;
row["PROVISION_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["PROVISION_Y"].Value;
row["SPIRIT_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["SPIRIT_Y"].Value;
row["TIDY_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["TIDY_Y"].Value;
row["COORDINATION_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["COORDINATION_Y"].Value;
row["SPECIALTY_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["SPECIALTY_Y"].Value;
row["REACTION_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["REACTION_Y"].Value;
row["Staff_Car"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["Staff_Car"].Value;
row["Total_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["Total_Y"].Value;
row["RANK_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']/FieldValue").Attributes["RANK_Y"].Value;
row["ASSESS_TYPE"] = "年終";
}
else if (2 < l_int月份 && l_int月份 < 7)
{
row["ASSESS_TYPE"] = "端午";
}
else if (6 < l_int月份 && l_int月份 < 10)
{
row["ASSESS_TYPE"] = "中秋";
}
DataTable l_dt = l_General.getDatsByID(applyTask.TaskId, applyTask.SiteCode);
if (l_dt != null && l_dt.Rows.Count > 0)
{
l_General.UpdateByTASKID(row);
}
else
{
l_General.Insert(row);
}
//xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='General']").InnerXml = "";
//AssessCompetentPO po = new AssessCompetentPO();
//po.UpdateCurrentDoc(applyTask.TaskId, xmlDoc.OuterXml);
}
return("");
}
public string GetFormResult(Fast.EB.WKF.ExternalUtility.ApplyTask applyTask)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(applyTask.CurrentDocXML);
CTB_HR_ASSESS_ASSISTAN_MANAGERUCO l_MANAGER = new CTB_HR_ASSESS_ASSISTAN_MANAGERUCO();
//簽核中需要同意才進入
if (applyTask.SignResult == Fast.EB.WKF.Engine.SignResult.Approve)
{
DataRow row = l_MANAGER.NewRow();
row["GUID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='GUID']").Attributes["fieldValue"].Value;
//自訂欄位的寫法
row["SMID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["SMID"].Value;
row["KPI_Performance"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["KPI_Performance"].Value;
row["KPI_Ploy"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["KPI_Ploy"].Value;
row["KPI_Improve"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["KPI_Improve"].Value;
row["Cooperation"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["Cooperation"].Value;
row["Subordinate"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["Subordinate"].Value;
row["Risk"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["Risk"].Value;
row["Communication"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["Communication"].Value;
row["Attitude"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["Attitude"].Value;
row["Total"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["Total"].Value;
row["RANK"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["RANK"].Value;
row["SIGNER"] = Current.Name;
row["EDIT_DATE"] = DateTime.Today.ToString("yyyy/MM/dd");
row["TASK_ID"] = applyTask.TaskId;
row["SITE_CODE"] = applyTask.SiteCode;
int l_int月份 = DateTime.Today.Month;
//非年終不用進去
if (l_int月份 > 9 || l_int月份 < 3)
{
row["KPI_Performance_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["KPI_Performance_Y"].Value;
row["KPI_Ploy_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["KPI_Ploy_Y"].Value;
row["KPI_Improve_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["KPI_Improve_Y"].Value;
row["Cooperation_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["Cooperation_Y"].Value;
row["Subordinate_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["Subordinate_Y"].Value;
row["Risk_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["Risk_Y"].Value;
row["Communication_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["Communication_Y"].Value;
row["Attitude_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["Attitude_Y"].Value;
row["Staff_Car"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["Staff_Car"].Value;
row["Total_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["Total_Y"].Value;
row["RANK_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']/FieldValue").Attributes["RANK_Y"].Value;
row["ASSESS_TYPE"] = "年終";
}
else if (2 < l_int月份 && l_int月份 < 7)
{
row["ASSESS_TYPE"] = "端午";
}
else if (6 < l_int月份 && l_int月份 < 10)
{
row["ASSESS_TYPE"] = "中秋";
}
DataTable l_dt = l_MANAGER.getDatsByID(applyTask.TaskId, applyTask.SiteCode);
if (l_dt != null && l_dt.Rows.Count > 0)
{
l_MANAGER.UpdateByTASKID(row);
}
else
{
l_MANAGER.Insert(row);
}
//xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Assiatan_Manager']").InnerXml = "";
//AssessCompetentPO po = new AssessCompetentPO();
//po.UpdateCurrentDoc(applyTask.TaskId, xmlDoc.OuterXml);
}
return("");
}
public string GetFormResult(Fast.EB.WKF.ExternalUtility.ApplyTask applyTask)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(applyTask.CurrentDocXML);
CTB_HR_ASSESS_STAFF_UCO l_STAFF = new CTB_HR_ASSESS_STAFF_UCO();
if (applyTask.SignResult == Fast.EB.WKF.Engine.SignResult.Approve) //簽核中需要同意才進入
{
DataRow row = l_STAFF.NewRow();
row["GUID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='FormID']").Attributes["fieldValue"].Value;
//row["SMID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='SMID']").Attributes["fieldValue"].Value;
//自訂欄位的寫法
row["SMID"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["SMID"].Value;
row["KNOWLEDGE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["KNOWLEDGE"].Value;
row["FORCE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["FORCE"].Value;
row["SENSE"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["SENSE"].Value;
row["INTERGITY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["INTERGITY"].Value;
row["EXECUTION"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["EXECUTION"].Value;
row["ABILITY"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["ABILITY"].Value;
row["EQ"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["EQ"].Value;
row["Total"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["Total"].Value;
row["RANK"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["RANK"].Value;
row["SIGNER"] = Current.Name;
row["EDIT_DATE"] = DateTime.Today.ToString("yyyy/MM/dd");
row["TASK_ID"] = applyTask.TaskId;
row["SITE_CODE"] = applyTask.SiteCode;
int l_int月份 = DateTime.Today.Month;
//非年終不用進去
if (l_int月份 > 9 || l_int月份 < 3)
{
row["KNOWLEDGE_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["KNOWLEDGE_Y"].Value;
row["FORCE_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["FORCE_Y"].Value;
row["SENSE_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["SENSE_Y"].Value;
row["INTERGITY_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["INTERGITY_Y"].Value;
row["EXECUTION_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["EXECUTION_Y"].Value;
row["ABILITY_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["ABILITY_Y"].Value;
row["EQ_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["EQ_Y"].Value;
row["Staff_Car"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["Staff_Car"].Value;
row["Total_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["Total_Y"].Value;
row["RANK_Y"] = xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']/FieldValue").Attributes["RANK_Y"].Value;
row["ASSESS_TYPE"] = "年終";
}
else if (2 < l_int月份 && l_int月份 < 7)
{
row["ASSESS_TYPE"] = "端午";
}
else if (6 < l_int月份 && l_int月份 < 10)
{
row["ASSESS_TYPE"] = "中秋";
}
//row["DOC_NBR"] = applyTask.FormNumber;
DataTable l_dt = l_STAFF.getDatsByID(applyTask.TaskId, applyTask.SiteCode);
if (l_dt != null && l_dt.Rows.Count > 0)
{
l_STAFF.UpdateByTASKID(row);
}
else
{
l_STAFF.Insert(row);
}
//xmlDoc.SelectSingleNode("/Form/FormFieldValue/FieldItem[@fieldId='Staff']").InnerXml = "";
//AssessCompetentPO po = new AssessCompetentPO();
//po.UpdateCurrentDoc(applyTask.TaskId, xmlDoc.OuterXml);
}
return("");
}