private void PrepareDTable(string KeyCode)
{
DataTable _DT = ComExportToExcel.GetXYDetailDataTable(KeyCode);
IQueryable <V_Ware_Report_Stocks_Lens_Detail> _Rs = this.ObjectContext.V_Ware_Report_Stocks_Lens_Detail;
_Rs = _Rs.Where(item => item.WhCode + item.LensCode + item.F_LR == KeyCode);
bool _F_Read = false;
_Rs.ToList().ForEach(item =>
{
if (!@_F_Read)
{
_WhCode = item.WhCode;
_LensCode = item.LensCode;
_F_LR = item.F_LR;
var _RsLes = this.ObjectContext.V_B_Material_Lens.Where(it => it.LensCode == _LensCode).FirstOrDefault();
_F_CA = _RsLes == null ? false : _RsLes.F_CA == true;
_F_Read = true;
}
_DT.Rows.Add(item.SPH, item.CYL, item.X_ADD, item.Stocks);
});
var _DT2 = this.InitDataTable(_DT);
_DS.Tables.Add(_DT2);
}
private void PrepareBSDT(string KeyCode)
{
DataTable _DT = ComExportToExcel.GetXYDetailDataTable(_WhCode + _LensCode + _F_LR);
IQueryable <V_Ware_Stocks_Base_Lens_Detail> _Rs = this.ObjectContext.V_Ware_Stocks_Base_Lens_Detail;
_Rs = _Rs.Where(item => item.ID == KeyCode);
_Rs.ToList().ForEach(item =>
{
_DT.Rows.Add(item.SPH, item.CYL, item.X_ADD, item.Qty);
});
var _DT2 = this.InitBSDT(_DT);
_DS.Tables.Add(_DT2);
}
//
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);
}
//
private void PrepareXSPDDT(V_Sale_Order_PD model)
{
DataTable _DT = ComExportToExcel.GetXYDetailDataTable(model.BCode);
IQueryable <V_Sale_Order_PD_Detail> _Rs = this.ObjectContext.V_Sale_Order_PD_Detail;
_Rs = _Rs.Where(item => item.ID == model.ID);
_Rs.ToList().ForEach(item =>
{
_DT.Rows.Add(item.SPH, item.CYL, item.X_ADD, item.Qty);
});
var _DT2 = this.InitXSPDDT(_DT, model);
_DS.Tables.Add(_DT2);
}
//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);
}
//
private DataTable InitXSPDDT(DataTable _DT, V_Sale_Order_PD model)
{
DataTable _RST = new DataTable(model.BCode);
int _SumQty = ComExportToExcel.InitXYTable(_RST, _DT, _F_CA);
//内容
_RST.Rows[0][0] = "V2******批量/寄賣訂單******";
_RST.Rows[1][0] = "訂單日期:" + model.BDate.Value.GetMyShortDateStr();
_RST.Rows[2][0] = "訂單號:" + model.BCode + ";客戶訂單號:" + model.OBCode + ";制單:" + model.Maker;
_RST.Rows[3][0] = "客戶代碼:" + model.CusCode + "(" + model.CusName + ")";
_RST.Rows[4][0] = "訂單鏡種:" + model.LensCode + "(" + model.LensName + ")" + (model.F_LR == "" ? "" : ";鏡片:" + model.F_LR);
_RST.Rows[5][0] = "流水號:" + model.SN;
_RST.Rows[6][0] = "特別說明:" + model.Notes;
_RST.Rows[7][0] = "備註:" + model.Remark;
return(_RST);
}
private DataTable InitBSDT(DataTable _DT)
{
DataTable _RST = new DataTable(_DT.TableName.GetCorrectXlsName());
int _SumQty = ComExportToExcel.InitXYTable(_RST, _DT, _F_CA);
//内容
_RST.Rows[0][0] = "******鏡片基本庫存******";
_RST.Rows[1][0] = "製作日期:" + ComDateTime.LongDateTime;
_RST.Rows[2][0] = "倉庫:" + _WhCode;
if (_F_LR == "")
{
_RST.Rows[3][0] = "鏡種:" + _LensCode;
}
else
{
_RST.Rows[3][0] = "鏡種:" + _LensCode + "[" + _F_LR + "]";
}
_RST.Rows[4][0] = "總數:" + _SumQty.ToString();
return(_RST);
}
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);
}
