private void button10_Click(object sender, EventArgs e)
{
string ErrorMsg = string.Empty;
BILWeb.SyncService.ParamaterField_Func tfunc = new ParamaterField_Func();
tfunc.Sync(20, "2019-04-11", "FY2-DB6-1909010012", -1, ref ErrorMsg, "ERP", -1, null);
}
private void button2_Click(object sender, EventArgs e)
{
string ErrorMsg = string.Empty;
BILWeb.SyncService.ParamaterField_Func tfunc = new ParamaterField_Func();
tfunc.Sync(99, "2019-04-11", "106394002B", -1, ref ErrorMsg, "ERP", -1, null);
//PFunc.Sync(99, "2019-08-11", string.Empty, -1, ref ErrorMsg, "ERP", -1, null);
}
protected override bool Sync(T_QualityInfo model, ref string strErrMsg)
{
ParamaterField_Func tfunc = new ParamaterField_Func();
return(tfunc.Sync(model.StockType, "", model.ErpVoucherNo, model.VoucherType, ref strErrMsg, "ERP", -1, null));
}
public bool ImportExcel(int StockType, UserInfo user, DataSet HeadDS, DataSet DetailDS, ref string strError)
{
string strKey = string.Empty;
string HeadJson = string.Empty;
string DetailJson = string.Empty;
StringBuilder jsonString = new StringBuilder();
jsonString.Append("{\"Result\":\"TRUE\",\"ErrMsg\":null,\"RecordList\": [");
for (int i = 0; i < HeadDS.Tables["Sheet1"].Rows.Count; i++)
{
DataSet ImportDS = new DataSet();
DataTable TableHead = new DataTable();
TableHead = HeadDS.Tables["Sheet1"].Clone();
//添加行到新的dataset
TableHead.Rows.Add(HeadDS.Tables["Sheet1"].Rows[i].ItemArray);
ImportDS.Tables.Add(TableHead);
if (i > 0)
{
jsonString.Append(",");
}
jsonString.Append("{");
jsonString.Append("\"WmsVoucherType\":");
jsonString.Append("\"" + HeadDS.Tables["Sheet1"].Rows[i]["WmsVoucherType"].ToString() + "\"");
jsonString.Append(",");
HeadJson = JSONHelper.DateSetObjectToJson(ImportDS).Replace("Sheet1", "Head");
jsonString.Append(HeadJson.Replace("Head", "\"Head\""));
jsonString.Append(",");
strKey = HeadDS.Tables["Sheet1"].Rows[i][0].ToString();
DataTable TableDetail = new DataTable();
TableDetail = DetailDS.Tables["Sheet2"].Clone();
for (int j = 0; j < DetailDS.Tables["Sheet2"].Rows.Count; j++)
{
if (strKey.CompareTo(DetailDS.Tables["Sheet2"].Rows[j][0].ToString()) == 0)
{
TableDetail.Rows.Add(DetailDS.Tables["Sheet2"].Rows[j].ItemArray);
}
}
DataSet ImportDetailDS = new DataSet();
ImportDetailDS.Tables.Add(TableDetail);
DetailJson = JSONHelper.DateSetListToJson(ImportDetailDS).Replace("Sheet2", "Detail");
jsonString.Append(DetailJson.Replace("Detail", "\"Detail\""));
jsonString.Append("}");
}
jsonString.Append("]}");
ParamaterField_Func pfunc = new ParamaterField_Func();
return(pfunc.GetExcelmport(StockType, jsonString.ToString(), "ERP", ref strError));
}
