private void btnBrand_Click(object sender, EventArgs e) { frmSingleSelect frm = new frmSingleSelect(); ArrayList arr = _dal.GetBrandList(out Util.emsg); frm.InitData("请选择品牌:", arr, ComboBoxStyle.DropDown); if (frm.ShowDialog() == DialogResult.OK) { txtBrand.Text = Util.retValue1; } }
private void toolImport_Click(object sender, EventArgs e) { try { frmSelectGrid frmsel = new frmSelectGrid(); frmSingleSelect frms = new frmSingleSelect(); frms.InitData("请选择导入方式:", "客户订单,采购单", "客户订单", ComboBoxStyle.DropDownList); if (frms.ShowDialog() == DialogResult.OK) { switch (Util.retValue1) { case "客户订单": dalCustomerOrderList dalorder = new dalCustomerOrderList(); BindingCollection <modCustomerOrderList> listorder = dalorder.GetIList(false, string.Empty, string.Empty, string.Empty, string.Empty, DateTime.Today.AddDays(-30).ToString("MM-dd-yyyy"), string.Empty, out Util.emsg); if (listorder != null) { frmsel.InitViewList("请选择要导入的客户订单号:", listorder); if (frmsel.ShowDialog() == DialogResult.OK) { EditSalesShipment frm = new EditSalesShipment(); frm.ImportItem(Util.retValue1, frmSelectGrid.selectionlist); if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } break; case "采购单": dalPurchaseList dal = new dalPurchaseList(); BindingCollection <modPurchaseList> list = dal.GetIList(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, DateTime.Today.AddDays(-30).ToString("MM-dd-yyyy"), string.Empty, out Util.emsg); if (list != null) { frmsel.InitViewList("请选择要导入的采购单号:", list); if (frmsel.ShowDialog() == DialogResult.OK) { EditSalesShipment frm = new EditSalesShipment(); frm.ImportItem(Util.retValue1, frmSelectGrid.selectionlist); if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } break; } } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void toolNew_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; frmSingleSelect frmsingle = new frmSingleSelect(); frmsingle.InitData("请选择记帐凭证类别", "一般凭证,销售凭证,设计加工凭证,采购凭证,仓库进出,费用登记,收款凭证,付款凭证,其它应收凭证,其它应付凭证,生产凭证,支票承兑,固定资产增加,固定资产处理,固定资产评估,资产折旧,零库清理,价格调整,利润分配", ComboBoxStyle.DropDownList); if (frmsingle.ShowDialog() == DialogResult.OK) { frmSelectGrid frmsel = new frmSelectGrid(); EditAccCredenceList frm = new EditAccCredenceList(); switch (Util.retValue1) { case "销售凭证": dalSalesShipment dalss = new dalSalesShipment(); BindingCollection <modSalesShipment> listss = dalss.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg); if (listss != null && listss.Count > 0) { frmsel.InitViewList(Util.retValue1, listss); if (frmsel.ShowDialog() == DialogResult.OK) { if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist)) { if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } break; case "设计加工凭证": dalSalesDesignForm dalsd = new dalSalesDesignForm(); BindingCollection <modSalesDesignForm> listsd = dalsd.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg); if (listsd != null && listsd.Count > 0) { frmsel.InitViewList(Util.retValue1, listsd); if (frmsel.ShowDialog() == DialogResult.OK) { if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist)) { if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } break; case "采购凭证": dalPurchaseList dalpc = new dalPurchaseList(); BindingCollection <modPurchaseList> listpc = dalpc.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg); if (listpc != null && listpc.Count > 0) { frmsel.InitViewList(Util.retValue1, listpc); if (frmsel.ShowDialog() == DialogResult.OK) { if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist)) { if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } break; case "费用登记": dalAccExpenseForm dalexp = new dalAccExpenseForm(); BindingCollection <modAccExpenseForm> listexp = dalexp.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg); if (listexp != null && listexp.Count > 0) { frmsel.InitViewList(Util.retValue1, listexp); if (frmsel.ShowDialog() == DialogResult.OK) { if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist)) { if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } break; case "收款凭证": dalAccReceivableForm dalrec = new dalAccReceivableForm(); BindingCollection <modAccReceivableForm> listrec = dalrec.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg); if (listrec != null && listrec.Count > 0) { frmsel.InitViewList(Util.retValue1, listrec); if (frmsel.ShowDialog() == DialogResult.OK) { if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist)) { if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } break; case "付款凭证": dalAccPayableForm dalpay = new dalAccPayableForm(); BindingCollection <modAccPayableForm> listpay = dalpay.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg); if (listpay != null && listpay.Count > 0) { frmsel.InitViewList(Util.retValue1, listpay); if (frmsel.ShowDialog() == DialogResult.OK) { if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist)) { if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } break; case "其它应收凭证": dalAccOtherReceivableForm dalorec = new dalAccOtherReceivableForm(); BindingCollection <modAccOtherReceivableForm> listorec = dalorec.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg); if (listorec != null && listorec.Count > 0) { frmsel.InitViewList(Util.retValue1, listorec); if (frmsel.ShowDialog() == DialogResult.OK) { if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist)) { if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } break; case "其它应付凭证": dalAccOtherPayableForm dalopay = new dalAccOtherPayableForm(); BindingCollection <modAccOtherPayableForm> listopay = dalopay.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg); if (listopay != null && listopay.Count > 0) { frmsel.InitViewList(Util.retValue1, listopay); if (frmsel.ShowDialog() == DialogResult.OK) { if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist)) { if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } break; case "仓库进出": dalWarehouseInoutForm dalio = new dalWarehouseInoutForm(); BindingCollection <modWarehouseInoutForm> listio = dalio.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg); if (listio != null && listio.Count > 0) { frmsel.InitViewList(Util.retValue1, listio); if (frmsel.ShowDialog() == DialogResult.OK) { if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist)) { if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } break; case "生产凭证": dalProductionForm dalpdt = new dalProductionForm(); BindingCollection <modProductionForm> listpdt = dalpdt.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg); if (listpdt != null && listpdt.Count > 0) { frmsel.InitViewList(Util.retValue1, listpdt); if (frmsel.ShowDialog() == DialogResult.OK) { if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist)) { if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } break; case "支票承兑": dalAccCheckForm dalcheck = new dalAccCheckForm(); BindingCollection <modAccCheckForm> listcheck = dalcheck.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg); if (listcheck != null && listcheck.Count > 0) { frmsel.InitViewList(Util.retValue1, listcheck); if (frmsel.ShowDialog() == DialogResult.OK) { if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist)) { if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } break; case "固定资产增加": dalAssetAdd dalassetadd = new dalAssetAdd(); BindingCollection <modAssetAdd> listassetadd = dalassetadd.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg); if (listassetadd != null && listassetadd.Count > 0) { frmsel.InitViewList(Util.retValue1, listassetadd); if (frmsel.ShowDialog() == DialogResult.OK) { if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist)) { if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } break; case "固定资产处理": dalAssetSale dalassetsale = new dalAssetSale(); BindingCollection <modAssetSale> listassetsale = dalassetsale.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg); if (listassetsale != null && listassetsale.Count > 0) { frmsel.InitViewList(Util.retValue1, listassetsale); if (frmsel.ShowDialog() == DialogResult.OK) { if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist)) { if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } break; case "固定资产评估": dalAssetEvaluate dalassetevaluate = new dalAssetEvaluate(); BindingCollection <modAssetEvaluate> listassetevaluate = dalassetevaluate.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg); if (listassetevaluate != null && listassetevaluate.Count > 0) { frmsel.InitViewList(Util.retValue1, listassetevaluate); if (frmsel.ShowDialog() == DialogResult.OK) { if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist)) { if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } break; case "价格调整": dalPriceAdjustForm dalpaf = new dalPriceAdjustForm(); BindingCollection <modPriceAdjustForm> listpaf = dalpaf.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg); if (listpaf != null && listpaf.Count > 0) { frmsel.InitViewList(Util.retValue1, listpaf); if (frmsel.ShowDialog() == DialogResult.OK) { if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist)) { if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } break; case "零库清理": if (frm.AddItem(Util.retValue1, string.Empty)) { if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } break; case "利润分配": frm.AddItem(Util.retValue1, string.Empty); if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } break; default: frm.AddItem(Util.retValue1, string.Empty); if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } break; } } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } finally { this.Cursor = Cursors.Default; } }
private void toolImport_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; frmSelectGrid frmsel = new frmSelectGrid(); frmSingleSelect frms = new frmSingleSelect(); frms.InitData("请选择导入方式:", "采购订单,客户订单,EXCEL", "采购订单", ComboBoxStyle.DropDownList); if (frms.ShowDialog() == DialogResult.OK) { switch (Util.retValue1) { case "客户订单": dalPurchaseList dalorder = new dalPurchaseList(); BindingCollection <modCustomerOrderList> listorder = dalorder.GetImportOrderData(DateTime.Today.AddDays(-30).ToString("MM-dd-yyyy"), string.Empty, out Util.emsg); if (listorder != null) { frmsel.InitViewList("请选择要导入的客户订单号:", listorder); if (frmsel.ShowDialog() == DialogResult.OK) { EditPurchaseList frm = new EditPurchaseList(); frm.ImportOrder(frmSelectGrid.selectionlist); if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } break; case "采购订单": dalVendorOrderList dalpo = new dalVendorOrderList(); BindingCollection <modVendorOrderList> listpo = dalpo.GetIList(false, string.Empty, string.Empty, string.Empty, DateTime.Today.AddDays(-30).ToString("MM-dd-yyyy"), string.Empty, out Util.emsg); if (listpo != null) { frmsel.InitViewList("请选择要导入的采购订单号:", listpo); if (frmsel.ShowDialog() == DialogResult.OK) { EditPurchaseList frm = new EditPurchaseList(); frm.ImportPO(frmSelectGrid.selectionlist); if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } } break; case "EXCEL": OpenFileDialog ofd = new OpenFileDialog(); string inifolder = clsLxms.GetParameterValue("PURCHASE_IMPORT_PATH"); if (Directory.Exists(inifolder)) { ofd.InitialDirectory = clsLxms.GetParameterValue("PURCHASE_IMPORT_PATH"); } else { ofd.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); } ofd.Multiselect = true; //允许同时选择多个文件 ofd.Filter = "Excel文件|*.xls;*.xlsx"; ofd.RestoreDirectory = true; ofd.FilterIndex = 1; if (ofd.ShowDialog() == DialogResult.OK) { string[] files = ofd.FileNames; EditPurchaseList frm = new EditPurchaseList(); frm.Import(files); if (frm.ShowDialog() == DialogResult.OK) { LoadData(); } } break; } } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } finally { this.Cursor = Cursors.Default; } }
private void toolExport_Click(object sender, EventArgs e) { if (DBGrid.CurrentRow == null) { return; } frmSingleSelect frm = new frmSingleSelect(); frm.InitData("请选择导出单据类别:", "购销合同,采购订单", "购销合同", ComboBoxStyle.DropDownList); if (frm.ShowDialog() == DialogResult.OK) { IList <modExcelRangeData> list = new List <modExcelRangeData>(); modPurchaseList mod = (modPurchaseList)DBGrid.CurrentRow.DataBoundItem; BindingCollection <modPurchaseDetail> listdetail = _dal.GetDetail(mod.PurchaseId, out Util.emsg); switch (Util.retValue1) { case "采购订单": dalVendorList dalv = new dalVendorList(); modVendorList modv = dalv.GetItem(mod.VendorName, out Util.emsg); list.Add(new modExcelRangeData(clsLxms.GetParameterValue("COMPANY_NAME"), "A1", "I1")); list.Add(new modExcelRangeData("电话:" + clsLxms.GetParameterValue("COMPANY_TEL") + " 传真:" + clsLxms.GetParameterValue("COMPANY_FAX"), "A2", "I2")); list.Add(new modExcelRangeData(clsLxms.GetParameterValue("COMPANY_ADDR"), "A3", "I3")); list.Add(new modExcelRangeData(modv.VendorName, "C6", "E6")); list.Add(new modExcelRangeData(modv.Tel, "C7", "E7")); list.Add(new modExcelRangeData(modv.Fax, "C8", "E8")); list.Add(new modExcelRangeData(modv.Linkman, "C9", "E9")); list.Add(new modExcelRangeData(modv.Addr, "C10", "E10")); list.Add(new modExcelRangeData(mod.PurchaseNo, "G6", "I6")); list.Add(new modExcelRangeData(mod.PurchaseDate.ToString("yyyy年MM月dd日"), "G7", "I7")); list.Add(new modExcelRangeData(mod.UpdateUser, "G8", "I8")); list.Add(new modExcelRangeData(mod.txtPayMethod, "G9", "I9")); list.Add(new modExcelRangeData(mod.UpdateUser, "F38", "F38")); for (int i = 0; i < listdetail.Count; i++) { modPurchaseDetail modd = listdetail[i]; string col = (13 + i).ToString().Trim(); list.Add(new modExcelRangeData((i + 1).ToString(), "A" + col, "A" + col)); list.Add(new modExcelRangeData(modd.ProductName, "B" + col, "C" + col)); list.Add(new modExcelRangeData(modd.Brand, "D" + col, "D" + col)); list.Add(new modExcelRangeData(modd.UnitNo, "E" + col, "E" + col)); list.Add(new modExcelRangeData(modd.Qty.ToString(), "F" + col, "F" + col)); list.Add(new modExcelRangeData(string.Format("{0:C2}", modd.Price), "G" + col, "G" + col)); list.Add(new modExcelRangeData(string.Format("{0:C2}", modd.Qty * modd.Price), "H" + col, "H" + col)); list.Add(new modExcelRangeData(modd.Remark, "I" + col, "I" + col)); } clsExport.ExportByTemplate(list, "采购单", 1, 38, 9, 1); break; case "购销合同": list.Add(new modExcelRangeData(mod.VendorName, "B6", "E6")); list.Add(new modExcelRangeData(mod.PurchaseNo, "I6", "I6")); list.Add(new modExcelRangeData(mod.PurchaseDate.ToString("yyyy年MM月dd日"), "I7", "I7")); list.Add(new modExcelRangeData("金额大写:" + clsMoney.ConvertToMoney(Convert.ToDouble(mod.DetailSum + mod.OtherMny - mod.KillMny)), "A23", "I23")); list.Add(new modExcelRangeData(string.Format("{0:C2}", mod.DetailSum + mod.OtherMny - mod.KillMny), "H22", "H22")); for (int i = 0; i < listdetail.Count; i++) { modPurchaseDetail modd = listdetail[i]; string col = (10 + i).ToString().Trim(); //list.Add(new modExcelRangeData((i+1).ToString(), "A" + col, "A" + col)); list.Add(new modExcelRangeData(modd.ProductName, "B" + col, "B" + col)); list.Add(new modExcelRangeData(modd.Brand, "C" + col, "C" + col)); list.Add(new modExcelRangeData(modd.Qty.ToString(), "D" + col, "D" + col)); list.Add(new modExcelRangeData(modd.UnitNo, "E" + col, "E" + col)); list.Add(new modExcelRangeData(string.Format("{0:C2}", modd.Price), "G" + col, "G" + col)); list.Add(new modExcelRangeData(string.Format("{0:C2}", modd.Qty * modd.Price), "H" + col, "H" + col)); list.Add(new modExcelRangeData(modd.Remark, "I" + col, "I" + col)); } clsExport.ExportByTemplate(list, "购销合同", 1, 41, 9, 1); break; } } }
private void toolExport_Click(object sender, EventArgs e) { if (DBGrid.CurrentRow == null) { return; } frmSingleSelect frm = new frmSingleSelect(); frm.InitData("请选择导出单据类别:", "送货单,购销合同", "送货单", ComboBoxStyle.DropDownList); if (frm.ShowDialog() == DialogResult.OK) { IList <modExcelRangeData> list = new List <modExcelRangeData>(); modSalesShipment mod = (modSalesShipment)DBGrid.CurrentRow.DataBoundItem; BindingCollection <modSalesShipmentDetail> listdetail = _dal.GetDetail(mod.ShipId, out Util.emsg); dalCustomerList dalcust = new dalCustomerList(); modCustomerList modcust = dalcust.GetItem(mod.CustId, out Util.emsg); switch (Util.retValue1) { case "送货单": case "收营单": string company = clsLxms.GetParameterValue("COMPANY_NAME"); switch (company) { case "深圳市蓝图净化用品有限公司": list.Add(new modExcelRangeData("№ " + mod.ShipNo, "H6", "I6")); list.Add(new modExcelRangeData(modcust.FullName, "C7", "E7")); list.Add(new modExcelRangeData(modcust.Tel, "G7", "I7")); list.Add(new modExcelRangeData(modcust.Linkman, "C8", "E8")); list.Add(new modExcelRangeData(modcust.Fax, "G8", "I8")); list.Add(new modExcelRangeData(mod.ShipAddr, "C9", "I9")); list.Add(new modExcelRangeData(mod.CustOrderNo, "A13", "C13")); list.Add(new modExcelRangeData(modcust.PayMethod, "D13", "E13")); dalAdminEmployeeList dalemp = new dalAdminEmployeeList(); modAdminEmployeeList modemp = dalemp.GetItem(mod.SalesMan, out Util.emsg); if (modemp != null) { list.Add(new modExcelRangeData(modemp.EmployeeName, "F13", "F13")); } else { list.Add(new modExcelRangeData(mod.SalesMan, "F13", "F13")); } list.Add(new modExcelRangeData(mod.ShipDate.ToString("yyyy年MM月dd日"), "G13", "G13")); for (int i = 0; i < listdetail.Count; i++) { modSalesShipmentDetail modd = listdetail[i]; string col = (17 + i).ToString().Trim(); list.Add(new modExcelRangeData((i + 1).ToString(), "A" + col, "A" + col)); list.Add(new modExcelRangeData(modd.ProductName, "B" + col, "C" + col)); list.Add(new modExcelRangeData(modd.Specify, "D" + col, "D" + col)); list.Add(new modExcelRangeData(modd.Qty.ToString(), "E" + col, "E" + col)); list.Add(new modExcelRangeData(modd.UnitNo, "F" + col, "F" + col)); list.Add(new modExcelRangeData(modd.Price.ToString("#,##0.00"), "G" + col, "G" + col)); list.Add(new modExcelRangeData((modd.Qty * modd.Price).ToString("#,##0.00"), "H" + col, "H" + col)); list.Add(new modExcelRangeData(modd.Remark, "I" + col, "I" + col)); } clsExport.ExportByTemplate(list, "蓝图送货单", 1, 24, 10, 1); break; default: list.Add(new modExcelRangeData(clsLxms.GetParameterValue("COMPANY_NAME"), "A1", "L1")); list.Add(new modExcelRangeData("TEL:" + clsLxms.GetParameterValue("COMPANY_TEL") + " Fax:" + clsLxms.GetParameterValue("COMPANY_FAX"), "A2", "L2")); list.Add(new modExcelRangeData("公司地址:" + clsLxms.GetParameterValue("COMPANY_ADDR"), "A3", "L3")); if (mod.InvoiceStatus >= 1) { list.Add(new modExcelRangeData("S", "L4", "L4")); } list.Add(new modExcelRangeData(mod.ShipType, "E4", "I5")); list.Add(new modExcelRangeData(mod.CustOrderNo, "C4", "D4")); list.Add(new modExcelRangeData(modcust.FullName, "C5", "D5")); list.Add(new modExcelRangeData(mod.ShipAddr, "C6", "D6")); list.Add(new modExcelRangeData(modcust.Linkman + " " + modcust.Tel, "K4", "K4")); list.Add(new modExcelRangeData(mod.ShipNo, "K5", "K5")); list.Add(new modExcelRangeData(mod.ShipDate.ToString("yyyy年MM月dd日"), "K6", "K6")); list.Add(new modExcelRangeData("合计金额:" + clsMoney.ConvertToMoney(Convert.ToDouble(mod.DetailSum + mod.OtherMny - mod.KillMny)), "A16", "I17")); list.Add(new modExcelRangeData(string.Format("{0:C2}", mod.DetailSum + mod.OtherMny - mod.KillMny), "J16", "K16")); list.Add(new modExcelRangeData("付款方式:" + mod.PayMethod, "J17", "K17")); list.Add(new modExcelRangeData(Util.UserName, "K20", "K20")); for (int i = 0; i < listdetail.Count; i++) { modSalesShipmentDetail modd = listdetail[i]; string col = (8 + i).ToString().Trim(); list.Add(new modExcelRangeData((i + 1).ToString(), "A" + col, "A" + col)); list.Add(new modExcelRangeData(modd.ProductName, "B" + col, "D" + col)); list.Add(new modExcelRangeData(modd.UnitNo, "E" + col, "E" + col)); list.Add(new modExcelRangeData(modd.Qty.ToString(), "F" + col, "G" + col)); list.Add(new modExcelRangeData(string.Format("{0:C2}", modd.Price), "H" + col, "I" + col)); list.Add(new modExcelRangeData(string.Format("{0:C2}", modd.Qty * modd.Price), "J" + col, "J" + col)); list.Add(new modExcelRangeData(modd.Remark, "K" + col, "K" + col)); } clsExport.ExportByTemplate(list, "送货单", 1, 20, 11, 1); break; } break; case "购销合同": list.Add(new modExcelRangeData(modcust.FullName, "B6", "E6")); list.Add(new modExcelRangeData(mod.ShipNo, "I6", "I6")); list.Add(new modExcelRangeData(mod.ShipDate.ToString("yyyy年MM月dd日"), "I7", "I7")); list.Add(new modExcelRangeData("金额大写:" + clsMoney.ConvertToMoney(Convert.ToDouble(mod.DetailSum + mod.OtherMny - mod.KillMny)), "A23", "I23")); list.Add(new modExcelRangeData(string.Format("{0:C2}", mod.DetailSum + mod.OtherMny - mod.KillMny), "H22", "H22")); dalProductList dalpdt = new dalProductList(); for (int i = 0; i < listdetail.Count; i++) { modSalesShipmentDetail modd = listdetail[i]; string col = (10 + i).ToString().Trim(); //list.Add(new modExcelRangeData((i+1).ToString(), "A" + col, "A" + col)); list.Add(new modExcelRangeData(modd.ProductName, "B" + col, "B" + col)); modProductList modpdt = dalpdt.GetItem(modd.ProductId, out Util.emsg); if (modpdt != null) { list.Add(new modExcelRangeData(modpdt.Brand, "C" + col, "C" + col)); } list.Add(new modExcelRangeData(modd.Qty.ToString(), "D" + col, "D" + col)); list.Add(new modExcelRangeData(modd.UnitNo, "E" + col, "E" + col)); list.Add(new modExcelRangeData(string.Format("{0:C2}", modd.Price), "G" + col, "G" + col)); list.Add(new modExcelRangeData(string.Format("{0:C2}", modd.Qty * modd.Price), "H" + col, "H" + col)); list.Add(new modExcelRangeData(modd.Remark, "I" + col, "I" + col)); } clsExport.ExportByTemplate(list, "购销合同", 1, 38, 9, 1); break; } } }