/// <summary> /// 从PO集合得到PO信息数据集 /// </summary> /// <param name="dtPO"></param> /// <returns></returns> DataTable CreateSAPPOData(DataTable dtPO) { DataTable dt = new DataTable(); dt.Columns.Add("PONumber"); dt.Columns.Add("CurrentPAD"); dt.Columns.Add("NewPAD"); dt.Columns.Add("SupplierName"); dt.Columns.Add("SADweek"); dt.Columns.Add("SADyear"); dt.Columns.Add("OMU"); dt.Columns.Add("PADweek"); dt.Columns.Add("PADyear"); dt.Columns.Add("OSP"); dt.Columns.Add("ValueForStory"); dt.Columns.Add("IsNeedApprove"); dt.Columns.Add("IsSuccess"); dt.Columns.Add("PoQty"); dt.Columns.Add("StyleNumber"); // StringBuilder sb = new StringBuilder(); foreach (DataRow drPO in dtPO.Rows) { SapCommonPADChangeRequest sapcommonpad = new SapCommonPADChangeRequest(); string sPONO = drPO[0].ToString(); string sNewPAD = drPO[1].ToString(); if (sapcommonpad.SapSearchPAD(sPONO)) { DataRow dr = dt.NewRow(); dr["PONumber"] = sPONO; dr["CurrentPAD"] = Convert.ToDateTime(sapcommonpad.PAD).ToString("MM\\/dd\\/yyyy"); dr["SupplierName"] = sapcommonpad.SupplierName; dr["SADweek"] = sapcommonpad.SADweek; dr["SADyear"] = sapcommonpad.SADyear; dr["OMU"] = sapcommonpad.OMU; dr["PADweek"] = sapcommonpad.PADweek; dr["PADyear"] = sapcommonpad.PADyear; dr["OSP"] = sapcommonpad.OSP; dr["ValueForStory"] = sapcommonpad.ValueForStory; dr["IsNeedApprove"] = sapcommonpad.Delivered; dr["IsSuccess"] = 0; dr["NewPAD"] = sNewPAD; dr["PoQty"] = sapcommonpad.SPOQTY; dr["StyleNumber"] = sapcommonpad.STYLENUMBER; dt.Rows.Add(dr); } else { if (sb.Length > 0) { sb.Append("\\n"); } sb.Append("Can not find "); sb.Append(sPONO); } } if (sb.Length > 0) { DisplayMessage(sb.ToString()); } return dt; }
/// <summary> /// 从PO集合得到PO信息数据集 /// </summary> /// <param name="dtPO"></param> /// <returns></returns> DataTable CreateSAPPOData(DataTable dtPO) { DataTable dt = new DataTable(); dt.Columns.Add("PONO"); dt.Columns.Add("Date"); dt.Columns.Add("PAD"); dt.Columns.Add("SupplierName"); dt.Columns.Add("SADweek"); dt.Columns.Add("SADyear"); dt.Columns.Add("OMU"); dt.Columns.Add("PADweek"); dt.Columns.Add("PADyear"); dt.Columns.Add("OSP"); dt.Columns.Add("ValueForStory"); dt.Columns.Add("IsNeedApprove"); dt.Columns.Add("IsSuccess"); dt.Columns.Add("PoQty"); dt.Columns.Add("StyleNumber"); List<string> listStr = new List<string>(); StringBuilder sb = new StringBuilder(); foreach (DataRow drPO in dtPO.Rows) { string sPONO = drPO[0].ToString().Trim() ;///去重复 if (listStr.Contains(sPONO)) { continue; } listStr.Add(sPONO); SapCommonPADChangeRequest sapcommonpad = new SapCommonPADChangeRequest(); if (sapcommonpad.SapSearchPAD(sPONO)) { DataRow dr = dt.NewRow(); dr["PONO"] = sPONO.Trim(); dr["Date"] = drPO[1].ToString(); dr["PAD"] = Convert.ToDateTime(sapcommonpad.PAD).ToString("MM\\/dd\\/yyyy"); dr["SupplierName"] = sapcommonpad.SupplierName.Trim(); dr["SADweek"] = sapcommonpad.SADweek.Trim(); dr["SADyear"] = sapcommonpad.SADyear.Trim(); dr["OMU"] = sapcommonpad.OMU.Trim(); dr["PADweek"] = sapcommonpad.PADweek.Trim(); dr["PADyear"] = sapcommonpad.PADyear.Trim(); dr["OSP"] = sapcommonpad.OSP.Trim(); dr["ValueForStory"] = sapcommonpad.ValueForStory.Trim(); dr["IsNeedApprove"] = sapcommonpad.Delivered; dr["IsSuccess"] = 0; dr["PoQty"] = sapcommonpad.SPOQTY.Trim(); int iStyleNO = 0; int.TryParse(sapcommonpad.STYLENUMBER,out iStyleNO); dr["StyleNumber"] = iStyleNO.ToString();// sapcommonpad.STYLENUMBER; dt.Rows.Add(dr); } else { if (sb.Length > 0) { sb.Append("\\n"); } sb.Append("Can not find "); sb.Append(sPONO); } } if (sb.Length > 0) { DisplayMessage(sb.ToString()); } return dt; }