public DataSetStanby.V_SALES_TRANS_APP_QUERYDataTable GetSalesActualList(DateTime startDate, DateTime endDate, string GOODS_TYPE_CODE, string salesNO, string queryType2)
{
DataSetStanby.V_SALES_TRANS_APP_QUERYDataTable table = new DataSetStanby.V_SALES_TRANS_APP_QUERYDataTable();
DataSynchronizationStanbyLib.DataSetStanbyTableAdapters.V_SALES_TRANS_APP_QUERYTableAdapter ad = new DataSynchronizationStanbyLib.DataSetStanbyTableAdapters.V_SALES_TRANS_APP_QUERYTableAdapter();
if (queryType2.Equals("1"))
{
table = ad.GetDataBy(startDate, endDate, GOODS_TYPE_CODE, salesNO);
}
else if (queryType2.Equals("2"))
{
var shopList = shopRepository.getShopBySalesNo(salesNO);
foreach (var shop in shopList)
{
var tempTable = ad.GetDataByShop(startDate, endDate, GOODS_TYPE_CODE, shop.SHOP_CODE);
foreach (DataSetStanby.V_SALES_TRANS_APP_QUERYRow row in tempTable)
{
if (table.Where(p => p.ID.Equals(row.ID)).Count() <= 0)
{
table.AddV_SALES_TRANS_APP_QUERYRow(row.ID, row.TRANS_NO, row.EMPLOYEE_ID, row.CH_REPORT_NAME, row.JOB_CODE, row.SALES_DATE, row.MACHINE_MODEL_NO, row.SALES_QTY,
row.SALES_PRICE, row.SALES_AMOUNT, row.T_TYPEID, row.T_TYPENAME, row.T_BUID, row.T_BUNAME, row.SHOP_CODE, row.SHOP_NAME, row.CUSTOMER_CODE,
row.CUSTOMER_NAME, row.GOODS_TYPE_CODE, row.GOODS_TYPE_NAME, row.TRANS_TYPE_CODE, row.TRANS_TYPE_NAME, row.CREATOR_ID,
row.CREATE_DATE, row.INVOICE_FLAG, row.CONSUMER_NAME, row.CONSUMER_PHONE_NO, row.INVOICE_STATUS_NAME, row.UNQUALIFIED_REASON_NAME, row.INVOICE_STATUS_CODE, row.UNQUALIFIED_REASON_CODE, row.BOARD_FLAG, row.BRAND_CODE, row.TVSIZE, row.T_TVSIZEID, row.ACT_NO, row.ACT_NAME
, row.SEX, row.SEX_NAME, row.AREA_ID, row.ADDR, row.AGE_PERIOD_ID, row.AGE_PERIOD_NAME, row.CH_NO, row.SN_NO, row.BRAND_NAME, row.LOCK_TYPE_CODE, row.LOCK_TYPE_NAME);
}
}
}
}
return(table);
}
public DataSetStanby.V_SALES_TRANS_APP_QUERYDataTable GetSalesActualList(DateTime startDate, DateTime endDate, string GOODS_TYPE_CODE, string salesNO)
{
DataSynchronizationStanbyLib.DataSetStanbyTableAdapters.V_SALES_TRANS_APP_QUERYTableAdapter ad = new DataSynchronizationStanbyLib.DataSetStanbyTableAdapters.V_SALES_TRANS_APP_QUERYTableAdapter();
return(ad.GetDataBy(startDate, endDate, GOODS_TYPE_CODE, salesNO));
}
