/// <summary> /// 数据更新到SAP /// </summary> /// <param name="sWorkFlowNO"></param> /// <returns></returns> bool UpdateToSAP(string sWorkFlowNO) { bool isOK = true; StringBuilder sbErrorInfo = new StringBuilder(); StringBuilder sbSucessInfo = new StringBuilder(); foreach (RepeaterItem item in RepeaterPOData.Items) { HiddenField HiddenFieldstoredelivery = item.FindControl("HiddenFieldstoredelivery") as HiddenField; if (HiddenFieldstoredelivery.Value == "True") { continue; } Label LabelPAD = item.FindControl("LabelPAD") as Label; CADateTimeControl CADateTimeFrom = item.FindControl("CADateTimeFrom") as CADateTimeControl; HiddenField HiddenFieldIsSuccess = item.FindControl("HiddenFieldIsSuccess") as HiddenField; if (HiddenFieldIsSuccess.Value == "1") { continue; } if (Convert.ToDateTime(LabelPAD.Text.Trim()) < Convert.ToDateTime(CADateTimeFrom.SelectedDate)) { Label LabelPONO = item.FindControl("LabelPONO") as Label; string sPONO = LabelPONO.Text.Trim(); SapCommonPADChangeRequest sapcommonpad = new SapCommonPADChangeRequest(); if (!sapcommonpad.SapUpdatePAD(LabelPONO.Text.ToString(), Convert.ToDateTime(CADateTimeFrom.SelectedDate).ToString("yyyy-MM-dd")))//更新到 SAP失败 { sbErrorInfo.Append(string.Concat("Update ", sPONO, " to SAP failed,error info:", sapcommonpad.ErrorMsg.Replace("'", "‘").Replace("\\n", " "), "\\n")); } else { sbSucessInfo.Append(string.Concat("\\nUpdate ", sPONO, " to SAP success")); HiddenFieldIsSuccess.Value = "1"; sapcommonpad.UpdateItemSapStatus(sPONO, sWorkFlowNO); CADateTimeFrom.Enabled = false; } } } if (sbErrorInfo.Length > 0) { sbErrorInfo.Append("\\nPlease contact IT form further help!"); DisplayMessage(string.Concat("There are some errors occoured:\\n" + sbErrorInfo.ToString(), sbSucessInfo.ToString())); isOK = false; } return isOK; }
/// <summary> /// sWorkflowNo /// </summary> /// <param name="sWorkflowNo"></param> /// <param name="dt"></param> /// <returns></returns> string UpdatePAD(string sWorkflowNo, DataTable dt) { StringBuilder sbErrorInfo = new StringBuilder(); foreach (DataRow dr in dt.Rows) { if (dr["NewPAD"] == null || dr["NewPAD"].ToString().Trim().Length == 0) { continue; } string sPONO = dr["PONO"].ToString(); string sPAD = dr["NewPAD"].ToString(); SapCommonPADChangeRequest sapcommonpad = new SapCommonPADChangeRequest(); if (!sapcommonpad.SapUpdatePAD(sPONO, Convert.ToDateTime(sPAD).ToString("yyyy-MM-dd"))) { sbErrorInfo.Append(string.Concat("Update ", sPONO, " to SAP failed,error info:", sapcommonpad.ErrorMsg.Replace("'", "‘").Replace("\n", " "), "\\n")); } else { UpdateItemPADState(sWorkflowNo, sPONO,true); } } return sbErrorInfo.ToString(); }
/// <summary> /// 数据更新到SAP /// </summary> /// <param name="sWorkFlowNO"></param> /// <returns></returns> bool UpdateToSAP(string sWorkFlowNO) { bool IsAllSeccuss = true; if (RepeaterPOData.Items.Count == 0) { return true; } StringBuilder sbErrorInfo = new StringBuilder(); StringBuilder sbSucessInfo = new StringBuilder(); foreach (RepeaterItem item in RepeaterPOData.Items) { Label LabelNewPAD = item.FindControl("LabelNewPAD") as Label; DropDownList DDLApproveStatus = item.FindControl("DDLApproveStatus") as DropDownList; if (DDLApproveStatus.SelectedValue == "1") { Label LabelPONO = item.FindControl("LabelPONO") as Label; string sPONO = LabelPONO.Text.Trim(); SapCommonPADChangeRequest sapcommonpad = new SapCommonPADChangeRequest(); HiddenField HiddenFieldIsSuccess = item.FindControl("HiddenFieldIsSuccess") as HiddenField; if (HiddenFieldIsSuccess.Value == "1") { continue; } if (!sapcommonpad.SapUpdatePAD(LabelPONO.Text.ToString(), Convert.ToDateTime(LabelNewPAD.Text.Trim()).ToString("yyyy-MM-dd")))//更新到 SAP失败 { IsAllSeccuss = false; sbErrorInfo.Append(string.Concat("Update ", sPONO, " to SAP failed,error info:", sapcommonpad.ErrorMsg.Replace("'", "‘").Replace("\n", " "), "\\n")); } else { sbSucessInfo.Append(string.Concat("\\nUpdate ", sPONO, " to SAP success")); HiddenFieldIsSuccess.Value = "1"; bool isApprove = DDLApproveStatus.SelectedValue == "1" ? true : false; sapcommonpad.UpdateItemSapStatus(sPONO, sWorkFlowNO); } } } if (sbErrorInfo.Length > 0) { sbErrorInfo.Append("\\nPlease contact IT for further help!"); DisplayMessage(string.Concat("There are some errors occoured:\\n" + sbErrorInfo.ToString(), sbSucessInfo.ToString())); CommonUtil.logError(sbErrorInfo.ToString()); } UpdateItemApprove(); return IsAllSeccuss; }