/// <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;
}