private void SyncToPSI_delete(marketSampleActEntity ent)
{
var res2 = from x in dbcontext.Set <marketSalesShopEntity>() where x.SHOP_CODE.Equals(ent.SHOP_CODE) select x;
DateTime date = System.DateTime.Now;
string CREATE_DATE = date.ToString("yyyyMMddHHmmss");
DataSynchronizationLib.DataSetPopTableAdapters.JS5_S12_SALES_FILE_UPLOADTableAdapter fileAd = new JS5_S12_SALES_FILE_UPLOADTableAdapter();
// if (!isChange)
//{
JS5_S12_SALES_SAMPLE_UPTableAdapter sampleAd = new JS5_S12_SALES_SAMPLE_UPTableAdapter();
sampleAd.InsertQuery(ent.id, 1, ent.sales_No, CREATE_DATE, CREATE_DATE, "PSIadmin_APP@" + CREATE_DATE + "@APP", "PSIadmin_APP@" + CREATE_DATE + "@APP", 0, "FLNET"
, ent.SAMPLE_UP_NO, res2.First().CUSTOMER_CODE, res2.First().CUSTOMER_NAME, ent.SHOP_CODE, ent.SHOP_NAME, ent.PRODUCT_TYPE_CODE, ent.PRODUCT_TYPE_NAME, ent.MACHINE_MODEL_NO, ent.SN_NO, ent.SAMPLE_DATE.Value, "无", ent.id, 1, "PSIadmin_APP", date, date, ent.UP_TYPE_CODE, ent.UP_TYPE_NAME,
ent.SAMPLE_TYPE_CODE, ent.SAMPLE_TYPE_NAME, ent.SOURCE_SAMPLE_UP_NO, ent.PRODUCT_STATUS_CODE, ent.REMARK
);
QueriesTableAdapter tad = new QueriesTableAdapter();
String outMessage = "";
tad.SP_SALES_SAMPLE_UPLOAD("FLNET", ent.id, out outMessage);
if (!outMessage.Equals("OK"))
{
throw new Exception(outMessage);
}
}
//}
private void SyncToPSI(marketSampleActEntity ent, bool isChange)
{
var res2 = from x in dbcontext.Set <marketSalesShopEntity>() where x.SHOP_CODE.Equals(ent.SHOP_CODE) select x;
DateTime date = System.DateTime.Now;
string CREATE_DATE = date.ToString("yyyyMMddHHmmss");
DataSynchronizationLib.DataSetPopTableAdapters.JS5_S12_SALES_FILE_UPLOADTableAdapter fileAd = new JS5_S12_SALES_FILE_UPLOADTableAdapter();
// if (!isChange)
//{
JS5_S12_SALES_SAMPLE_UPTableAdapter sampleAd = new JS5_S12_SALES_SAMPLE_UPTableAdapter();
sampleAd.InsertQuery(ent.id, 1, ent.sales_No, CREATE_DATE, CREATE_DATE, "PSIadmin_APP@" + CREATE_DATE + "@APP", "PSIadmin_APP@" + CREATE_DATE + "@APP", 1, "FLNET"
, ent.SAMPLE_UP_NO, res2.First().CUSTOMER_CODE, res2.First().CUSTOMER_NAME, ent.SHOP_CODE, ent.SHOP_NAME, ent.PRODUCT_TYPE_CODE, ent.PRODUCT_TYPE_NAME, ent.MACHINE_MODEL_NO, ent.SN_NO, ent.SAMPLE_DATE.Value, "无", ent.id, 1, "PSIadmin_APP", date, date, ent.UP_TYPE_CODE, ent.UP_TYPE_NAME,
ent.SAMPLE_TYPE_CODE, ent.SAMPLE_TYPE_NAME, ent.SOURCE_SAMPLE_UP_NO, ent.PRODUCT_STATUS_CODE, ent.REMARK
);
if (ent.file_ids != null && !ent.file_ids.Equals(""))
{
string[] fileids = ent.file_ids.Split(",".ToCharArray());
string physical_path = System.DateTime.Now.ToString("yyyyMM");
foreach (string fileid in fileids)
{
//写入发票信息
fileAd.InsertQuery(System.Guid.NewGuid().ToString(), fileid + ".jpg", ent.sales_No, System.DateTime.Now, ent.sales_No, System.DateTime.Now, 1, "jpg", 0, "", fileid + ".jpg", physical_path, "", "P13056", ent.id, "PDG1351", "001", "样品照片", ent.id,
"Normal", "正常", 1, "PSIadmin_APP", date, date);
}
}
QueriesTableAdapter tad = new QueriesTableAdapter();
String outMessage = "";
tad.SP_SALES_SAMPLE_UPLOAD("FLNET", ent.id, out outMessage);
if (!outMessage.Equals("OK"))
{
throw new Exception(outMessage);
}
}
