private void SPMAfterSend_DBIO(SPMTaskVariables SPMTaskVars, EFFormFields FormFields, ref IInterfaceHandleResult HandleResult, SPMRoutingVariable RoutingVariable, SPMVariables Variables)
{
try
{
string stepName = (string)SPMTaskVars.ReadDatum("STEPNAME");
int caseID = int.Parse((string)(SPMTaskVars.ReadDatum("CASEID")));
switch (RoutingVariable.Key)
{
//if Reject,Post Back To SAP
case SPMRoutingVariableKey.spm_Return:
try
{
PostBackToSAP(SPMTaskVars, FormFields, Variables, "R");
oStandard.UpdateFormStatus(caseID, "Reject");
}
catch (Exception ex)
{
HandleResult.IsSuccess = false;
HandleResult.CustomMessage = ex.Message;
}
break;
case SPMRoutingVariableKey.spm_Jump:
string curDOA = FormFields["txtDOA".ToUpper()].Replace("<1;", "<").Replace(">1;", ">");
string curStep = SPMAppLine.GetCurrentStep(curDOA);
//最後一關結束 將結果拋到DB中 並更新STATUS欄位為 Approve
if (curStep == "*")
{
try
{
// IF APPROVE ,POST BACK TO SAP and Update Form Status Approve
PostBackToSAP(SPMTaskVars, FormFields, Variables, "A");
oStandard.UpdateFormStatus(caseID, "Approve");
}
catch (Exception ex)
{
HandleResult.IsSuccess = false;
HandleResult.CustomMessage = ex.Message;
}
}
break;
}
}
catch (Exception e)
{
HandleResult.IsSuccess = false;
HandleResult.CustomMessage = e.Message;
}
}
/// <summary>
/// 單據狀態咨詢回寫SAP
/// </summary>
/// <param name="SPMTaskVars"></param>
/// <param name="FormFields"></param>
/// <param name="handlerType"></param>
private void PostBackToSAP(SPMTaskVariables SPMTaskVars, EFFormFields FormFields, SPMVariables Variables, string handlerType)
{
GDS_Helper oStandard = new GDS_Helper();
string sCurLogonID = (string)(SPMTaskVars.ReadDatum("SYS_LOGONID"));
int CASEID = int.Parse((string)(SPMTaskVars.ReadDatum("CASEID")));
string StatusMark = string.Empty;
string APROV = string.Empty;
switch (handlerType)
{
case "R":
string sMemo = System.Web.HttpUtility.UrlDecode(Variables[SPMVariableKey.Opinion]);
StatusMark = "Reject by:" + sCurLogonID + "(" + sMemo + ")";
APROV = "R";
break;
case "A":
StatusMark = "Approve by:" + sCurLogonID;
APROV = "A";
break;
default:
StatusMark = "Error";
break;
}
//退簽原因長度防呆
if (StatusMark.Length > 255)
{
StatusMark = StatusMark.Substring(0, 255);
}
//簡繁轉換
StatusMark = ConvertChinese(StatusMark, "Big5");
try
{
//By 主單號 UPDATE Flag and StatusRemark
oStandard.UpdateGDSQueue(CASEID, StatusMark, APROV);
}
catch (Exception)
{
//trace
//DBIO.RecordTraceLog("C", "NG", DOAHandler);
//throw;
}
}
public override void SPMStepActivity(SPMSubmitMethod SubmitMethod, SPMTaskVariables SPMTaskVars, SPMVariables Variables, EFFormFields FormFields, string NewStepName, ref IInterfaceHandleResult HandleResult)
{
base.SPMStepActivity(SubmitMethod, SPMTaskVars, Variables, FormFields, NewStepName, ref HandleResult);
}
//Abort
public override void SPMRecallProcess(SPMSubmitMethod SubmitMethod, SPMTaskVariables SPMTaskVars, SPMVariables Variables, EFFormFields FormFields, ref IInterfaceHandleResult HandleResult)
{
base.SPMRecallProcess(SubmitMethod, SPMTaskVars, Variables, FormFields, ref HandleResult);
}
// Code for 'after send'
public override void SPMAfterSend(SPMSubmitMethod SubmitMethod, SPMTaskVariables SPMTaskVars, SPMVariables Variables, SPMRoutingVariable RoutingVariable, EFFormFields FormFields, ref IInterfaceHandleResult HandleResult)
{
string caseid = System.Web.HttpUtility.UrlDecode(Variables[SPMVariableKey.CaseId]);
if (RoutingVariable != null)
{
string sRoutingData = string.Empty;
switch (RoutingVariable.Key)
{
case SPMRoutingVariableKey.spm_Return:
sRoutingData = RoutingVariable.Data;
break;
case SPMRoutingVariableKey.spm_Jump:
sRoutingData = RoutingVariable.Data;
break;
}
}
//// Business logic
if (SubmitMethod != SPMSubmitMethod.CreateNewCase)
{
SPMAfterSend_DBIO(SPMTaskVars, FormFields, ref HandleResult, RoutingVariable);
}
else
{
////////1.待签核关卡及签核人写DB
NPIMgmt oNPIMgmt = new NPIMgmt(oUIControls.lblSite.Text, oUIControls.lblBu.Text);
NPI_Standard oStandard = oNPIMgmt.InitialLeaveMgmt();
Dictionary <string, object> result = oStandard.RecordDOAHandler(caseid, oUIControls.txtFormNo.Text, oUIControls.lblBu.Text, oUIControls.cmbPlant.SelectedItem.Text, oUIControls.cmbPhase.SelectedItem.Text);
if (!(bool)result["Result"])
{
HandleResult.IsSuccess = false;
HandleResult.CustomMessage = (string)result["ErrMsg"];
}
else
{
StringBuilder sbLayout = new StringBuilder();
if (oUIControls.cmbLayout.SelectedItems.Count > 0)
{
foreach (SelectedListItem li in oUIControls.cmbLayout.SelectedItems)
{
sbLayout.AppendFormat("{0},", li.Text);
}
}
Model_NPI_APP_MAIN_HIS oModel_Main = new Model_NPI_APP_MAIN_HIS();
oModel_Main._DOC_NO = oUIControls.txtFormNo.Text.Trim();
oModel_Main._BU = oUIControls.lblBu.Text;
oModel_Main._BUILDING = oUIControls.cmbPlant.SelectedItem.Text;
oModel_Main._APPLY_DATE = oUIControls.txtDate.Text;
oModel_Main._APPLY_USERID = oPara.LoginId.Trim();
oModel_Main._MODEL_NAME = oUIControls.txtModel.Text;
oModel_Main._CUSTOMER = oUIControls.txtCustomer.Text;
oModel_Main._PRODUCT_TYPE = oUIControls.cbProductType.SelectedItem.Text;
oModel_Main._LAYOUT = sbLayout.ToString().TrimEnd(',');
oModel_Main._PHASE = oUIControls.cmbPhase.SelectedItem.Text;
oModel_Main._NEXTSTAGE_DATE = oUIControls.txtNextStage_BeginDate.SelectedDate.ToString("yyyy/MM/dd");
oModel_Main._NPI_PM = oUIControls.txtPM.Text;
oModel_Main._SALES_OWNER = oUIControls.txtSales.Text;
oModel_Main._RD_ENGINEER = oUIControls.txtRD.Text;
oModel_Main._REMARK = oUIControls.txtNotes.Text;
oModel_Main._CASEID = oPara.CaseId.ToString();
oModel_Main._UPDATE_USERID = oPara.LoginId;
oModel_Main._STATUS = "Pending";
oModel_Main._PMLOC = oUIControls.cmbPM.SelectedItem.Text.Trim();
oModel_Main._PMEXT = oUIControls.txtPMExt.Text.Trim();
oModel_Main._RDLOC = oUIControls.cmbRD.SelectedItem.Text.Trim();
oModel_Main._RDEXT = oUIControls.txtRDExt.Text.Trim();
oModel_Main._SALESLOC = oUIControls.cmbSales.SelectedItem.Text.Trim();
oModel_Main._SALESEXT = oUIControls.txtSalesExt.Text.Trim();
result = oStandard.RecordOperation_NPIMain(oModel_Main, Status_Operation.ADD);
//result = "true";
if (!(bool)result["Result"])
{
HandleResult.IsSuccess = false;
HandleResult.CustomMessage = (string)result["ErrMsg"];
}
}
}
base.SPMAfterSend(SubmitMethod, SPMTaskVars, Variables, RoutingVariable, FormFields, ref HandleResult);
}
// Code for 'before send'
public override void SPMBeforeSend(SPMSubmitMethod SubmitMethod, SPMTaskVariables SPMTaskVars, SPMVariables Variables, SPMRoutingVariable RoutingVariable, ref EFFormFields FormFields, ref IInterfaceHandleResult HandleResult)
{
if (RoutingVariable != null)
{
switch (RoutingVariable.Key)
{
case SPMRoutingVariableKey.spm_Return:
string value = RoutingVariable.Data;
break;
}
}
base.SPMBeforeSend(SubmitMethod, SPMTaskVars, Variables, RoutingVariable, ref FormFields, ref HandleResult);
}
// Fill SPM Variable
public override void PrepareSPMVariables(SPMSubmitMethod SubmitMethod, SPMProcessMethod ProcessMethod, SPMTaskVariables SPMTaskVars, ref SPMVariables Variables, ref SPMRoutingVariable RoutingVariable, ref string strSPMUid, string strMemo, string strNotesForNextApprover, EFFormFields FormFields, ref IInterfaceHandleResult HandleResult, ref string SuccessMessage)
{
bool isError = false;
string stepName = string.Empty;
string errorMsg = string.Empty;
string FormNo = FormFields["txtFormNo".ToUpper()];
string Applicant = oPara.LoginId;
Variables.Add(SPMVariableKey.Subject, "[NPIReport_Application] [" + FormNo + "] By [" + Applicant + "]");
string Approver = string.Empty;
NPIMgmt oMgmt = new NPIMgmt(oUIControls.lblSite.Text, oUIControls.lblBu.Text);
//NPIMgmt oMgmt = new NPIMgmt("CZ1","HIS");
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
if (SubmitMethod == SPMSubmitMethod.CreateNewCase)
{
DataTable dtDOAHandler = oModel_NPI_DOA_HandlerInfo._HANDLER;
if (dtDOAHandler.Rows.Count > 0)
{
DataRow dr = dtDOAHandler.Rows[0];
string step_name = dr["STEP_NAME"].ToString();
string handler = dr["HANDLER"].ToString();
RoutingVariable = new SPMRoutingVariable(SPMRoutingVariableKey.spm_NextHandler, step_name + "(" + handler + ")");
}
else
{
HandleResult.IsSuccess = false;
HandleResult.CustomMessage = "無法獲取下一關簽核人信息,請聯絡系統管理員!";
}
}
if (SubmitMethod == SPMSubmitMethod.HandleCase_Approve)
{
Dictionary <string, object> result = new Dictionary <string, object>();
stepName = (string)SPMTaskVars.ReadDatum("STEPNAME");
int caseID = int.Parse((string)(SPMTaskVars.ReadDatum("CASEID")));
////获取待签核关卡及签核人资讯
result = oStandard.GetNextStepAndHandler_NPI(caseID, FormNo, stepName, oUIControls.cmbPlant.SelectedItem.Text, oUIControls.cmbPhase.SelectedItem.Text);
if (!(bool)result["Result"])//无法找到签核关卡资讯,显示ERROR
{
HandleResult.IsSuccess = false;
HandleResult.CustomMessage = (string)result["ErrMsg"];
}
else
{
try
{
RoutingVariable = new SPMRoutingVariable(SPMRoutingVariableKey.spm_Jump, (string)result["SPMRoutingVariable"]);
}
catch (Exception ex)
{
HandleResult.IsSuccess = false;
HandleResult.CustomMessage = "DOA Error:" + ex.Message;
}
if (RoutingVariable == null)
{
HandleResult.IsSuccess = false;
HandleResult.CustomMessage = "Error: get RoutingVariable fail";
}
}
}
base.PrepareSPMVariables(SubmitMethod, ProcessMethod, SPMTaskVars, ref Variables, ref RoutingVariable, ref strSPMUid, strMemo, strNotesForNextApprover, FormFields, ref HandleResult, ref SuccessMessage);
}
// Fill SPM's EFFormFieldData
public override void PrepareEFFormFields(SPMSubmitMethod SubmitMethod, SPMProcessMethod ProcessMethod, SPMTaskVariables TaskVars, ref EFFormFields FormFields, ref IInterfaceHandleResult HandleResult, object oContainer, IUIShadow UIShadow, ref string ApplicantInfo)
{
NPIGating_HISUIShadow lUIControls = (NPIGating_HISUIShadow)UIShadow;
FormFields.SetOrAdd("txtFormNo".ToUpper(), lUIControls.txtFormNo.Text);
FormFields.SetOrAdd("txtSite".ToUpper(), lUIControls.lblSite.Text);
FormFields.SetOrAdd("txtBu".ToUpper(), lUIControls.lblBu.Text);
FormFields.SetOrAdd("txtBuilding".ToUpper(), lUIControls.cmbPlant.SelectedItem.Text);
base.PrepareEFFormFields(SubmitMethod, ProcessMethod, TaskVars, ref FormFields, ref HandleResult, oContainer, UIShadow, ref ApplicantInfo);
}
// Fill SPM's EFFormFieldData
public override void PrepareEFFormFields(SPMSubmitMethod SubmitMethod, SPMProcessMethod ProcessMethod, SPMTaskVariables TaskVars, ref EFFormFields FormFields, ref IInterfaceHandleResult HandleResult, object oContainer, IUIShadow UIShadow, ref string ApplicantInfo)
{
GDSExceptionHandlingUIShadow lUIControls = (GDSExceptionHandlingUIShadow)UIShadow;
//基本資料
FormFields.SetOrAdd("txtLogonID".ToUpper(), lUIControls.txtLogonID.Text);
FormFields.SetOrAdd("txtName".ToUpper(), lUIControls.txtName.Text);
FormFields.SetOrAdd("txtPlant".ToUpper(), lUIControls.txtPlant.Text);
FormFields.SetOrAdd("txtDept".ToUpper(), lUIControls.txtDept.Text);
FormFields.SetOrAdd("txtEMail".ToUpper(), lUIControls.txtEMail.Text);
FormFields.SetOrAdd("txtExtNO".ToUpper(), lUIControls.txtExtNO.Text);
FormFields.SetOrAdd("txtRDocNo".ToUpper(), lUIControls.txtRDocNo.Text);
FormFields.SetOrAdd("txtDocNo".ToUpper(), lUIControls.txtDocNo.Text);
FormFields.SetOrAdd("txtCostCenter".ToUpper(), lUIControls.txtCostCenter.Text);
FormFields.SetOrAdd("txtDepartment".ToUpper(), lUIControls.txtDepartment.Text);
FormFields.SetOrAdd("txtApplication".ToUpper(), lUIControls.txtApplication.Text);
FormFields.SetOrAdd("txtMaterial".ToUpper(), lUIControls.txtMaterial.Text);
FormFields.SetOrAdd("txtReturnQuantity".ToUpper(), lUIControls.txtReturnQuantity.Text);
FormFields.SetOrAdd("txtReason".ToUpper(), lUIControls.txtReason.Text);
FormFields.SetOrAdd("txtRemark".ToUpper(), lUIControls.txtRemark.Text);
FormFields.SetOrAdd("txtReturn".ToUpper(), lUIControls.txtReturn.Text);
FormFields.SetOrAdd("txtIADocNo".ToUpper(), lUIControls.txtIADocNo.Text);
FormFields.SetOrAdd("txtI6DocNo".ToUpper(), lUIControls.txtI6DocNo.Text);
FormFields.SetOrAdd("txtZEILE".ToUpper(), lUIControls.txtZEILE.Text);
FormFields.SetOrAdd("txtAmount".ToUpper(), lUIControls.txtAmount.Text);
//SOURCE DATA
FormFields.SetOrAdd("txtHead".ToUpper(), lUIControls.txtHead.Text);
FormFields.SetOrAdd("txtDetail".ToUpper(), lUIControls.txtDetail.Text);
FormFields.SetOrAdd("txtDOA".ToUpper(), lUIControls.txtDOA.Text);
FormFields.SetOrAdd("txtWERKS".ToUpper(), lUIControls.txtWERKS.Text);
FormFields.SetOrAdd("txtAPTYP".ToUpper(), lUIControls.txtAPTYP.Text);
base.PrepareEFFormFields(SubmitMethod, ProcessMethod, TaskVars, ref FormFields, ref HandleResult, oContainer, UIShadow, ref ApplicantInfo);
}
public override void Print(int iTaskId, SPMTaskVariables SPMTaskVars, EFFormFields FormFields, object oContainer, IUIShadow UIShadow)
{
base.Print(iTaskId, SPMTaskVars, FormFields, oContainer, UIShadow);
}
// Code for 'after send'
public override void SPMAfterSend(SPMSubmitMethod SubmitMethod, SPMTaskVariables SPMTaskVars, SPMVariables Variables, SPMRoutingVariable RoutingVariable, EFFormFields FormFields, ref IInterfaceHandleResult HandleResult)
{
if (SubmitMethod != SPMSubmitMethod.CreateNewCase)
{
SPMAfterSend_DBIO(SPMTaskVars, FormFields, ref HandleResult, RoutingVariable, Variables);
}
else
{
GDS_Helper oStandard = new GDS_Helper();
string CASEID = System.Web.HttpUtility.UrlDecode(Variables[SPMVariableKey.CaseId]); //CASEID
string Werks = oUIControls.txtWERKS.Text;
string DocNo = oUIControls.txtDocNo.Text; //主單號
string RDocNo = oUIControls.txtRDocNo.Text; //Link 單號
string CostCenter = oUIControls.txtCostCenter.Text; //成本中心
string Department = oUIControls.txtDepartment.Text; //部門
string Application = oUIControls.txtApplication.Text; //申請人
string ZEILE = oUIControls.txtZEILE.Text; //ITEM
string Material = oUIControls.txtMaterial.Text; //料號
string ReturnQuantity = oUIControls.txtReturnQuantity.Text; //退料數量
string Reason = oUIControls.txtReason.Text; //退料原因
string Remark = oUIControls.txtRemark.Text; //備註
string Return = oUIControls.txtReturn.Text; //條件FLAG Flag為Y才符合條件
string IADocNo = oUIControls.txtIADocNo.Text; //關聯IA單
string I6DocNo = oUIControls.txtI6DocNo.Text; //關聯I6單
string Amount = oUIControls.txtAmount.Text; //金額
string Settingxml = oUIControls.txtDOA.Text; //Setting
try
{
//Insert Submit之後數據到DB中
oStandard.Insert_Begin(Werks, DocNo, RDocNo, CostCenter, Department, Application, ZEILE, Material, ReturnQuantity, Return, Reason, Remark, IADocNo, I6DocNo, "In Process", double.Parse(Amount), Settingxml, int.Parse(CASEID));
//將Submit後的狀態 W(In Process)回傳給SAP Begin關卡直接回傳
oStandard.PostBackToSAP(int.Parse(CASEID));
}
catch (Exception ex)
{
//有異常 刪除已經Insert的資料
oStandard.DeleteFormNo(int.Parse(CASEID));
HandleResult.IsSuccess = false;
HandleResult.CustomMessage = ex.Message;
}
}
base.SPMAfterSend(SubmitMethod, SPMTaskVars, Variables, RoutingVariable, FormFields, ref HandleResult);
}
// Code for 'before send'
public override void SPMBeforeSend(SPMSubmitMethod SubmitMethod, SPMTaskVariables SPMTaskVars, SPMVariables Variables, SPMRoutingVariable RoutingVariable, ref EFFormFields FormFields, ref IInterfaceHandleResult HandleResult)
{
base.SPMBeforeSend(SubmitMethod, SPMTaskVars, Variables, RoutingVariable, ref FormFields, ref HandleResult);
}
// Fill SPM Variable
public override void PrepareSPMVariables(SPMSubmitMethod SubmitMethod, SPMProcessMethod ProcessMethod, SPMTaskVariables SPMTaskVars, ref SPMVariables Variables, ref SPMRoutingVariable RoutingVariable, ref string strSPMUid, string strMemo, string strNotesForNextApprover, EFFormFields FormFields, ref IInterfaceHandleResult HandleResult, ref string SuccessMessage)
{
if (SubmitMethod == SPMSubmitMethod.CreateNewCase)
{
GDS_Helper oStandard = new GDS_Helper();
StringBuilder ErrMsg = new StringBuilder();
//string stepName = (string)(SPMTaskVars.ReadDatum("STEPNAME"));
string curDOA = oUIControls.txtDOA.Text;
string plant = oUIControls.txtWERKS.Text;
string apType = oUIControls.txtAPTYP.Text;
DOA spmDOA = new DOA();
string sApplicant = oUIControls.txtApplication.Text.Trim();
//獲取 表頭及表身DATA
string formDetail = oUIControls.txtDetail.Text.Trim().Replace("<1;", "<").Replace(">1;", ">");
string formHead = oUIControls.txtHead.Text.Trim().Replace("<1;", "<").Replace(">1;", ">");
DataTable dtHead = LiteOn.GDS.Utility.Tools.BuildHeadTable();
System.IO.StringReader reader = new System.IO.StringReader(formHead);
dtHead.ReadXml(reader);
System.IO.StringReader reader2 = new System.IO.StringReader(formDetail);
DataTable dtDetail = LiteOn.GDS.Utility.Tools.BuildDetailTable();
dtDetail.ReadXml(reader2);
try
{
//抓取第一關簽核人
DOAHandler = spmDOA.GetStepHandler(sApplicant, curDOA, dtHead, dtDetail, true);
Variables.Add(SPMVariableKey.Subject, "[部門領料_應退未退---測試] [" + FormFields["txtDocNo".ToUpper()] + "]");
RoutingVariable = new SPMRoutingVariable(SPMRoutingVariableKey.spm_Jump, "DOA(" + DOAHandler._sHandler + ")");
}
catch (Exception ex)
{
HandleResult.IsSuccess = false;
HandleResult.CustomMessage = ex.Message;
}
}
else
{
try
{
if (DOAHandler._sEndFlag == "N")
{
//簽核人防呆檢查
if (DOAHandler._sHandler.Length == 0)
{
HandleResult.IsSuccess = false;
HandleResult.CustomMessage = "Operation fail(server or network is busy now), pls refresh this page and try again";
}
else
{
RoutingVariable = new SPMRoutingVariable(SPMRoutingVariableKey.spm_Jump, "DOA(" + DOAHandler._sHandler + ")");
// 20121105 Add QX NA
if (DOAHandler._cc.Length > 0)
{
Variables.Add(SPMVariableKey.NextCC, DOAHandler._cc);
}
// 20121105 End QX NA
}
}
else
{
RoutingVariable = new SPMRoutingVariable(SPMRoutingVariableKey.spm_Jump, "End");
}
// DBIO.RecordTraceLog("D", "OK", DOAHandler);
}
catch (Exception)
{
DBIO.RecordTraceLog("D", "NG", DOAHandler);
throw;
}
}
base.PrepareSPMVariables(SubmitMethod, ProcessMethod, SPMTaskVars, ref Variables, ref RoutingVariable, ref strSPMUid, strMemo, strNotesForNextApprover, FormFields, ref HandleResult, ref SuccessMessage);
}
public override void SPMStepComplete(SPMSubmitMethod SubmitMethod, SPMTaskVariables SPMTaskVars, SPMVariables Variables, EFFormFields FormFields, string CompletedStepName, ref IInterfaceHandleResult HandleResult)
{
base.SPMStepComplete(SubmitMethod, SPMTaskVars, Variables, FormFields, CompletedStepName, ref HandleResult);
}
protected void SetMainValue(NPIGating_HISUIShadow lUIControls, SPMTaskVariables SPMTaskVars, EFFormFields FormFields)
{
string caseid = SPMTaskVars.ReadDatum("CASEID").ToString();
string Site = FormFields["txtSite".ToUpper()];
string Bu = "HIS";
NPIMgmt oNPIMgmt = new NPIMgmt(Site, Bu);
NPI_Standard oStandard = oNPIMgmt.InitialLeaveMgmt();
DataTable dt = oStandard.GetMasterInfoHIS(caseid);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
oUIControls.txtFormNo.Text = dr["DOC_NO"].ToString();
oUIControls.txtCustomer.Text = dr["CUSTOMER"].ToString();
oUIControls.txtDate.Text = dr["APPLY_DATE"].ToString();
oUIControls.txtNotes.Text = dr["REMARK"].ToString();
oUIControls.cmbPhase.Text = dr["PHASE"].ToString();
oUIControls.cmbPlant.Text = dr["BUILDING"].ToString();
oUIControls.cbProductType.SelectedItem.Text = dr["PRODUCT_TYPE"].ToString();
oUIControls.txtModel.Text = dr["MODEL_NAME"].ToString();
oUIControls.cmbLayout.Text = dr["LAYOUT"].ToString();
oUIControls.txtPM.Text = dr["NPI_PM"].ToString();
oUIControls.txtRD.Text = dr["RD_ENGINEER"].ToString();
oUIControls.txtSales.Text = dr["SALES_OWNER"].ToString();
oUIControls.txtNextStage_BeginDate.Text = dr["NEXTSTAGE_DATE"].ToString();
oUIControls.cmbPM.SelectedItem.Text = dr["PM_LOC"].ToString();
oUIControls.txtPMExt.Text = dr["PM_EXT"].ToString();
oUIControls.cmbRD.SelectedItem.Text = dr["RD_LOC"].ToString();
oUIControls.txtRDExt.Text = dr["RD_EXT"].ToString();
oUIControls.cmbSales.SelectedItem.Text = dr["SALES_LOC"].ToString();
oUIControls.txtSalesExt.Text = dr["SALES_EXT"].ToString();
}
}
public override void SPM_SendError(SPMSubmitMethod SubmitMethod, SPMTaskVariables SPMTaskVars, SPMVariables Variables, SPMRoutingVariable RoutingVariable, EFFormFields FormFields, IInterfaceHandleResult HandleResult)
{
string strExceptionFrom = HandleResult.ExceptionFrom;
string strErrorMessage = HandleResult.CustomMessage;
base.SPM_SendError(SubmitMethod, SPMTaskVars, Variables, RoutingVariable, FormFields, HandleResult);
}
private void ShowRecord(GDSExceptionHandlingUIShadow lUIControls, EFFormFields FormFields, string type, int caseId, SPMTaskVariables SPMTaskVars)
{
string caseid = SPMTaskVars.ReadDatum("CASEID").ToString();
string stepName = (string)(SPMTaskVars.ReadDatum("STEPNAME"));
GDS_Helper oStandard = new GDS_Helper();
if (stepName != "Begin")
{
#region 抓取 異常單資料 並綁定到控件中
DataTable dt = oStandard.GetMaster_Exception(int.Parse(caseid));//加載 異常單主表資料
if (dt.Rows.Count > 0)
{
#region 數據加載
DataRow dr = dt.Rows[0];
oUIControls.txtDocNo.Text = dr["MBLNR"].ToString(); //主單號
oUIControls.txtRDocNo.Text = dr["MBLNR_A"].ToString(); //Link 單號
oUIControls.txtCostCenter.Text = dr["KOSTL"].ToString(); //成本中心
oUIControls.txtDepartment.Text = dr["ABTEI"].ToString(); //部門
oUIControls.txtApplication.Text = dr["Applicant"].ToString(); //LoginID
oUIControls.txtReturn.Text = dr["RTNIF"].ToString(); // Return Flag
oUIControls.txtWERKS.Text = dr["WERKS"].ToString(); //廠別
oUIControls.txtMaterial.Text = dr["MATNR"].ToString(); //料號
oUIControls.txtZEILE.Text = dr["ZEILE"].ToString(); //料號對應的ITEM
oUIControls.txtAmount.Text = dr["Amount"].ToString(); //金額
oUIControls.txtIADocNo.Text = dr["IADocNo"].ToString(); //關聯IA單
oUIControls.txtI6DocNo.Text = dr["I6DocNo"].ToString(); //關聯I6單
oUIControls.txtReason.Text = dr["Reason"].ToString(); //REASON
oUIControls.txtRemark.Text = dr["Remark"].ToString(); //REMARK
oUIControls.txtReturnQuantity.Text = dr["MENGE"].ToString(); //RETURN 數量
oUIControls.txtDOA.Text = dr["Settingxml"].ToString(); //Settingxml
#endregion
#region 控件顯示
oUIControls.btnLink.Hidden = true;
oUIControls.frmUserInfo.Hidden = true;
oUIControls.txtDocNo.ReadOnly = true;
oUIControls.txtRDocNo.ReadOnly = true;
oUIControls.txtCostCenter.ReadOnly = true;
oUIControls.txtDepartment.ReadOnly = true;
oUIControls.txtApplication.ReadOnly = true;
oUIControls.txtReturn.ReadOnly = true;
oUIControls.txtMaterial.ReadOnly = true;
oUIControls.txtZEILE.ReadOnly = true;
oUIControls.txtAmount.ReadOnly = true;
oUIControls.txtIADocNo.ReadOnly = true;
oUIControls.txtI6DocNo.ReadOnly = true;
oUIControls.txtReason.ReadOnly = true;
oUIControls.txtRemark.ReadOnly = true;
oUIControls.txtReturnQuantity.ReadOnly = true;
#endregion
}
#endregion
#region 通過異常單的Link單號 抓取正常單中的Head和Detail
DataTable dtHead = oStandard.GetdtHead(oUIControls.txtRDocNo.Text.Trim());
DataTable dtDetail = oStandard.GetdtDetail(oUIControls.txtRDocNo.Text.Trim());
oUIControls.txtWERKS.Text = dtHead.Rows[0]["WERKS"].ToString(); //廠別
oUIControls.txtAPTYP.Text = dtHead.Rows[0]["APTYP"].ToString(); //單據類型
string xmlstrHead = oStandard.DataTableToXMLStr(dtHead);
oUIControls.txtHead.Text = xmlstrHead; //Head
string xmlstrDetail = oStandard.DataTableToXMLStr(dtDetail);
oUIControls.txtDetail.Text = xmlstrDetail; //Detail
//string tempWEKS = DOA.GetXMLConfigName(dtHead);//CALL FUNCTION獲取XML配置檔名
//SettingParser x = new SettingParser(tempWEKS, oUIControls.txtAPTYP.Text);//讀取XML配置檔信息
//oUIControls.txtDOA.Text = x.ApproveXML.Replace("<1;", "<").Replace(">1;", ">"); ;//抓取DOA的簽核邏輯
#endregion
}
}
