//
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);
}