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