예제 #1
0
        /// <summary>
        /// 生产物料清单
        /// </summary>
        private void btnPrint_Click(object sender, EventArgs e)
        {
            string slipNumbers = "";

            foreach (DataGridViewRow dr in dgvData.Rows)
            {
                if (CConvert.ToBoolean(dr.Cells["CHK"].Value))
                {
                    slipNumbers += "'" + CConvert.ToString(dr.Cells["SLIP_NUMBER"].Value) + "',";
                }
            }
            if (slipNumbers.Length > 0)
            {
                slipNumbers = slipNumbers.Substring(0, slipNumbers.Length - 1);
            }
            else
            {
                MessageBox.Show("请先选择订单。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }

            SaveFileDialog sf = new SaveFileDialog();

            sf.FileName = "HD_BOM_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
            sf.Filter   = "(文件)|*.xls;*.xlsx";

            if (sf.ShowDialog(this) == DialogResult.OK)
            {
                DataTable dt = bProduce.GetBomList(slipNumbers).Tables[0];
                int       i  = 1;
                _bomDt.Rows.Clear();
                DataRow dr = null;
                foreach (DataRow row in dt.Rows)
                {
                    dr          = _bomDt.NewRow();
                    dr["序号"]    = i++;
                    dr["规格/参数"] = row["CODE"];
                    dr["名称"]    = row["NAME"];
                    dr["数量"]    = CConvert.ToDecimal(row["QUANTITY"]);
                    dr["备注"]    = "";
                    _bomDt.Rows.Add(dr);
                }
                CExport.DataTableToExcel_BOM(sf.FileName, _bomDt);
                MessageBox.Show("导出完成。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }