public void PrintExcel(List <ZSL_BCS303_BS> list)
{
IWorkbook excel = new HSSFWorkbook(); //创建.xls文件
ISheet sheet = excel.CreateSheet("sheet1"); //创建sheet
IRow row = sheet.CreateRow(0);//创建行对象，填充表头
string[] headStr = { "物料凭证", "项目", "年度", "条码", "下层码", "托数", "托数量", "箱数", "物料编码", "物料描述", "工厂", "库存地点", "库存地点描述", "采购订单", "项目", "批次", "销售订单", "项目", "供应商编码", "简称", "过账日期", "工艺", "设备(模)号", "材料厂家" };
for (int i = 0; i < headStr.Length; i++)
{
row.CreateCell(i).SetCellValue(headStr[i]);
}
//填充内容，j从1开始，屏蔽掉第一列，循环读取
for (int i = 0; i < ChoiceList.Count; i++)
{
row = sheet.CreateRow(i + 1);
ZSL_BCS303_BS node = ChoiceList[i];
string[] content = { node.MBLNR, node.ZEILE, node.MJAHR, node.TM, node.XCZJTM, node.TS.ToString(), node.MENGE, node.XS.ToString(), node.MATNR, node.MAKTX, node.WERKS, node.LGORT, node.LGOBE, node.EBELN, node.EBELP, node.CHARG, node.MAT_KDAUF, node.MAT_KDPOS, node.LIFNR, node.SORTL, node.BUDAT, node.GY, node.SBH, node.CLCJ };
for (int j = 0; j < content.Length; j++)
{
row.CreateCell(j).SetCellValue(content[j]);
}
}
////写入文件
//string DesktopPath = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);
//string path = DesktopPath + @"\委外库存标识信息Excel" + DateTime.Now.ToString("yyyyMMdd") + ".xls";
////string path = DesktopPath + @"\委外库存标识" + DateTime.Now.ToShortDateString() + ".xls";
////string path = DesktopPath + @"\1.xls";
//FileStream xlsfile = new FileStream(path, FileMode.OpenOrCreate);
//excel.Write(xlsfile);
//xlsfile.Close();
SaveFileDialog Sfd = new SaveFileDialog();
Sfd.Filter = "Excel文件(*.xls)|*.xls";
Sfd.FileName = "物流入库导出";
if (Sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
FileStream file3 = new FileStream(Sfd.FileName, FileMode.Create);
excel.Write(file3);
file3.Close();
MessageBox.Show("成功导出为Excel！");
}
//MessageBox.Show("Excel文件已导出到桌面", "提示");
}
public void PrintExcel(List <ZSL_BCS303_BS> list)
{
IWorkbook excel = new XSSFWorkbook(); //创建.xls文件
ISheet sheet = excel.CreateSheet("sheet1"); //创建sheet
IRow row = sheet.CreateRow(0); //创建行对象，填充表头
string[] headStr = q(Msg_Type.fieldwlkcArr).Split(','); //{ "物料凭证", "项目", "年度", "条码", "下层码", "托数", "托数量", "箱数", "物料编码", "物料描述", "工厂", "库存地点", "库存地点描述", "采购订单", "项目", "批次", "销售订单","项目", "供应商编码", "简称", "过账日期", "工艺", "设备(模)号", "材料厂家" };
for (int i = 0; i < headStr.Length; i++)
{
row.CreateCell(i).SetCellValue(headStr[i]);
}
//填充内容，j从1开始，屏蔽掉第一列，循环读取
for (int i = 0; i < ChoiceList.Count; i++)
{
row = sheet.CreateRow(i + 1);
ZSL_BCS303_BS node = ChoiceList[i];
string[] content = { node.MBLNR, node.ZEILE, node.MJAHR, node.TM, node.XCZJTM, node.TS.ToString(), node.MENGE, node.XS.ToString(), node.MATNR, node.MAKTX, node.WERKS, node.LGORT, node.LGOBE, node.EBELN, node.EBELP, node.CHARG, node.MAT_KDAUF, node.MAT_KDPOS, node.LIFNR, node.SORTL, node.BUDAT, node.GY, node.SBH, node.CLCJ };
for (int j = 0; j < content.Length; j++)
{
row.CreateCell(j).SetCellValue(content[j]);
}
}
SaveFileDialog Sfd = new SaveFileDialog();
Sfd.Filter = "Excel文件(*.xlsx)|*.xlsx";
Sfd.FileName = q(Msg_Type.titlewlrkdc) + DateTime.Now.ToString("yyyyMMddHHmmss");//"物流入库导出"
if (Sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
FileStream file3 = new FileStream(Sfd.FileName, FileMode.Create);
excel.Write(file3);
file3.Close();
//MessageBox.Show("成功导出为Excel！");
ShowMeg(q(Msg_Type.msgexportsuccess));
}
//MessageBox.Show("Excel文件已导出到桌面", "提示");
}
public frmBindXCM(ZSL_BCS303_BS list, int rowindex)
{
InitializeComponent();
BomdataGridView.AutoGenerateColumns = false;
dataGridView2.AutoGenerateColumns = false;
RowIndex = rowindex;
XCList = new List <UI.Model.MES.MES_WLKCBSService.ZSL_BCS303_BS>();
BindList = new List <MES_TM_TMINFO_LIST>();
ZSL_BCS303_BS = list;
wlpzlabel.Text = q(Msg_Type.titlewlpzxmnd) + list.MBLNR + "/" + list.ZEILE + "/" + list.MJAHR; //"物料凭证/项目/年度:"
wlxxlabel.Text = q(Msg_Type.titlewlxx) + list.MATNR + "/" + list.MAKTX; //"物料信息:"
gyslabel.Text = q(Msg_Type.titlegysxx) + list.LIFNR + "/" + list.SORTL; //"供应商信息:"
cglabel.Text = q(Msg_Type.titlepo) + list.EBELN + "/" + list.EBELP; //"采购订单/项目:"
ZSL_BCS303_BS model = new UI.Model.MES.MES_WLKCBSService.ZSL_BCS303_BS();
model.MBLNR = list.MBLNR;
model.XCBS = list.XCBS;
model.MJAHR = list.MJAHR;
model.LINE_ID = list.LINE_ID;
model.LIFNR = list.LIFNR;
ZBCFUN_PURBS_READ res1 = ServicModel.MES_WLKCBS.GET_WLPZ_ZJ(model, getToken());;
if (res1.MES_RETURN.TYPE.Equals("S"))
{
XCList = res1.ET_PURBS.ToList();
for (int i = 0; i < res1.ET_PURBS.Length; i++)
{
res1.ET_PURBS[i].MATNR = res1.ET_PURBS[i].MATNR + "/" + res1.ET_PURBS[i].MAKTX;
}
BomdataGridView.DataSource = res1.ET_PURBS;
}
else
{
ShowMeg(res1.MES_RETURN.MESSAGE);
}
MES_TM_TMINFO tmmodel = new MES_TM_TMINFO();
string[] xcmArr = list.XCZJTM.Split(',');
for (int j = 0; j < xcmArr.Length; j++)
{
tmmodel.TM = xcmArr[j];
SELECT_MES_TM_TMINFO_BYTM res = ServicModel.TM_TMINFO.SELECT_BYTM(tmmodel, 0, getToken());
if (res.MES_RETURN.TYPE.Equals("S"))
{
for (int i = 0; i < res.MES_TM_TMINFO_LIST.Length; i++)
{
BindList.Add(res.MES_TM_TMINFO_LIST[i]);
}
for (int i = 0; i < BindList.Count; i++)
{
BindList[i].XH = i + 1;
BindList[i].WLMS = BindList[i].WLH + "/" + BindList[i].WLMS;
}
dataGridView2.DataSource = new List <MES_TM_TMINFO_LIST>();
dataGridView2.DataSource = BindList;
dataGridView2.ClearSelection();
}
}
}
public ZBCFUN_PURBS_READ GET_WLPZ_ZJ(ZSL_BCS303_BS IS_PURBS, string ptoken)
{
return(client.GET_WLPZ_ZJ(IS_PURBS, ptoken));
}
