//PDExport
public IQueryable <V_Sale_Order_PD> GetV_Sale_Order_PDBillForExport(string dbCode, int lgIndex, string fName, string iD)
{
this.CreateSerialNum(dbCode, lgIndex, iD);
var _RS = this.ObjectContext.V_Sale_Order_PD.Where(it => it.ID == iD).FirstOrDefault();
_WhCode = _RS.WhCode;
_LensCode = _RS.LensCode;
_F_LR = _RS.F_LR;
var _RSLens = this.ObjectContext.V_B_Material_Lens.Where(it => it.LensCode == _LensCode).FirstOrDefault();
_F_CA = _RSLens == null ? false : _RSLens.F_CA == true;
this.PrepareXSPDDT(_RS);
ComExportToExcel.Export(_DS, fName);
return(null);
}
//
public IQueryable <V_Ware_Stocks_Base_Lens> GetV_Ware_Stocks_Base_LensForExport(string dbCode, int lgIndex, string fName, List <string> items)
{
items.ForEach(item =>
{
var _RS = this.ObjectContext.V_Ware_Stocks_Base_Lens.Where(it => it.ID == item).FirstOrDefault();
_WhCode = _RS.WhCode;
_LensCode = _RS.LensCode;
_F_LR = _RS.F_LR;
var _RSLens = this.ObjectContext.V_B_Material_Lens.Where(it => it.LensCode == _LensCode).FirstOrDefault();
_F_CA = _RSLens == null ? false : _RSLens.F_CA == true;
this.PrepareBSDT(item);
});
ComExportToExcel.Export(_DS, fName);
return(null);
}
public IQueryable <V_Ware_Report_Stocks_Lens_XY> GetV_Ware_Report_Stocks_Lens_XYListExport(string dbCode, int lgIndex, string fName, List <string> items)
{
this.ObjectContext.ChangeDataBase(dbCode);
if (items[0] != "WhCode")
{
items.ForEach(item1 =>
{
this.PrepareDTable(item1);
});
}
else
{
var _WhCode = items[1];
var _RsWhCode = this.ObjectContext.V_Ware_Report_Stocks_Lens_Detail.Where(it => it.WhCode == _WhCode);
_RsWhCode.GroupBy(it => new { it.LensCode, it.F_LR }).ToList().ForEach(it =>
{
this.PrepareDTable(_WhCode + it.Key.LensCode + it.Key.F_LR);
});
}
ComExportToExcel.Export(_DS, fName);
return(null);
}