public void ImportItem(modVQuotationDetail mod) { _action = "NEW"; dtpFormDate.Value = DateTime.Today; dtpRequireDate.Value = DateTime.Today; txtId.Text = "0"; //txtCustOrderNo.Text = mod.CustOrderNo; txtCurrency.Text = mod.Currency; txtCustName.Tag = mod.CustId; txtCustName.Text = mod.CustName; dalCustomerList dalcust = new dalCustomerList(); modCustomerList modcust = dalcust.GetItem(mod.CustId, out Util.emsg); if (modcust != null) { txtPayMethod.Text = modcust.PayMethod; txtSalesMan.Text = modcust.SalesMan; } txtUnitNo.Text = mod.UnitNo; txtQty.Text = mod.Qty.ToString(); txtPrice.Text = mod.Price.ToString(); txtProductName.Tag = mod.ProductId; txtProductName.Text = mod.ProductName; txtSize.Text = "1"; txtRemark.Text = mod.Remark; status4.Image = null; }
private void toolExport_Click(object sender, EventArgs e) { if (DBGrid.CurrentRow == null) { return; } IList <modExcelRangeData> list = new List <modExcelRangeData>(); modQuotationForm mod = (modQuotationForm)DBGrid.CurrentRow.DataBoundItem; BindingCollection <modQuotationDetail> listdetail = _dal.GetDetail(mod.FormId, out Util.emsg); dalCustomerList dalcust = new dalCustomerList(); modCustomerList modcust = dalcust.GetItem(mod.CustId, out Util.emsg); //list.Add(new modExcelRangeData(clsLxms.GetParameterValue("COMPANY_NAME"), "B1", "J1")); list.Add(new modExcelRangeData("电话/TEL: " + clsLxms.GetParameterValue("COMPANY_TEL") + " 传真/FAX: " + clsLxms.GetParameterValue("COMPANY_FAX") + " 联系人/Contact Person: " + mod.ContactPerson, "A4", "I4")); //list.Add(new modExcelRangeData("公司地址:" + clsLxms.GetParameterValue("COMPANY_ADDR"), "B3", "J3")); list.Add(new modExcelRangeData(modcust.FullName, "B6", "B6")); list.Add(new modExcelRangeData("TEL: " + modcust.Linkman + " " + modcust.Tel, "B7", "B7")); list.Add(new modExcelRangeData("单号Invoice No.: " + mod.No, "H6", "H6")); list.Add(new modExcelRangeData(mod.FormDate.ToString("yyyy/MM/dd"), "I8", "I8")); for (int i = 0; i < listdetail.Count; i++) { modQuotationDetail 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.Mny), "H" + col, "H" + col)); list.Add(new modExcelRangeData(modd.Remark, "I" + col, "I" + col)); } clsExport.ExportByTemplate(list, "报价单", 1, 20, 10, 1); }
private void mnuAddTrace_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; if (DBGrid.CurrentRow == null) { return; } modCustomerList mod = (modCustomerList)DBGrid.CurrentRow.DataBoundItem; EditCustomerLog frm = new EditCustomerLog(); frm.AddItem(mod.CustId, mod.CustName); if (frm.ShowDialog() == DialogResult.OK) { LoadTraceInfo(mod.CustId); } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } finally { this.Cursor = Cursors.Default; } }
private void btnCust_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; MTN_CUSTOMER_LIST frm = new MTN_CUSTOMER_LIST(); frm.SelectVisible = true; if (frm.ShowDialog() == DialogResult.OK) { dalCustomerList dal = new DAL.dalCustomerList(); modCustomerList mod = dal.GetItem(Util.retValue1, out Util.emsg); if (mod != null) { txtCustName.Tag = mod.CustId; txtCustName.Text = mod.CustName; txtCurrency.Text = mod.Currency; } } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } finally { this.Cursor = Cursors.Default; } }
protected override bool Delete() { if (DBGrid.CurrentRow == null) { return(false); } modCustomerList mod = (modCustomerList)DBGrid.CurrentRow.DataBoundItem; bool ret = _dal.Delete(mod, out Util.emsg); if (ret) { LoadData(); } return(ret); }
protected void LoadData() { try { this.Cursor = Cursors.WaitCursor; string custlist = string.Empty; if (lstCustomer.SelectedItems.Count > 0 && lstCustomer.SelectedItems.Count < lstCustomer.Items.Count) { for (int i = 0; i < lstCustomer.SelectedItems.Count; i++) { modCustomerList mod = (modCustomerList)lstCustomer.SelectedItems[i]; if (i == 0) { custlist = mod.CustId; } else { custlist += "," + mod.CustId; } } } BindingCollection <modVQuotationDetail> list = _dal.GetVDetail(custlist, string.Empty, string.Empty, txtProductName.Text.Trim(), dtpFrom.Text, dtpTo.Text, out Util.emsg); DBGrid.DataSource = list; decimal sum = 0; if (list == null || list.Count == 0) { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(clsTranslate.TranslateString("No data found!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } StatusLabel1.Text = "共 0 行数据, 合计金额为: " + string.Format("{0:C2}", sum); } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { this.Cursor = Cursors.Default; } }
private void AddHeader(string sheetname, int pagerows, int iCopy, string custid, ref IList <modExcelRangeData> list) { dalCustomerList dalcust = new dalCustomerList(); modCustomerList modcust = dalcust.GetItem(custid, out Util.emsg); switch (sheetname) { case "蓝图对帐单": list.Add(new modExcelRangeData(modcust.FullName, "B" + ((iCopy * pagerows) + 6).ToString(), "B" + ((iCopy * pagerows) + 6).ToString())); list.Add(new modExcelRangeData(modcust.Tel, "I" + ((iCopy * pagerows) + 6).ToString(), "J" + ((iCopy * pagerows) + 6).ToString())); list.Add(new modExcelRangeData(modcust.Fax, "I" + ((iCopy * pagerows) + 7).ToString(), "J" + ((iCopy * pagerows) + 7).ToString())); list.Add(new modExcelRangeData(DateTime.Today.ToString("yyyy-MM-dd"), "I" + ((iCopy * pagerows) + 8).ToString(), "J" + ((iCopy * pagerows) + 8).ToString())); break; case "威廉姆对帐单": list.Add(new modExcelRangeData(clsLxms.GetParameterValue("COMPANY_NAME") + "\r\n" + dtpTo.Value.ToString("yyyy") + "年" + dtpTo.Value.ToString("MM") + "月份对帐单", "A" + ((iCopy * pagerows) + 1).ToString(), "L" + ((iCopy * pagerows) + 1).ToString())); list.Add(new modExcelRangeData(clsLxms.GetParameterValue("COMPANY_NAME"), "C" + ((iCopy * pagerows) + 2).ToString(), "C" + ((iCopy * pagerows) + 2).ToString())); list.Add(new modExcelRangeData(clsLxms.GetParameterValue("COMPANY_TEL"), "C" + ((iCopy * pagerows) + 3).ToString(), "C" + ((iCopy * pagerows) + 3).ToString())); list.Add(new modExcelRangeData(clsLxms.GetParameterValue("COMPANY_FAX"), "C" + ((iCopy * pagerows) + 4).ToString(), "C" + ((iCopy * pagerows) + 4).ToString())); list.Add(new modExcelRangeData("联系人:" + clsLxms.GetParameterValue("COMPANY_LINKMAN"), "H" + ((iCopy * pagerows) + 2).ToString(), "K" + ((iCopy * pagerows) + 2).ToString())); break; case "深科达对帐单": list.Add(new modExcelRangeData(dtpTo.Value.ToString("yyyy") + "年" + dtpTo.Value.ToString("MM") + "月", "D" + ((iCopy * pagerows) + 6).ToString(), "D" + ((iCopy * pagerows) + 6).ToString())); list.Add(new modExcelRangeData("From:" + clsLxms.GetParameterValue("COMPANY_NAME"), "H" + ((iCopy * pagerows) + 1).ToString(), "J" + ((iCopy * pagerows) + 2).ToString())); list.Add(new modExcelRangeData("联系人:" + clsLxms.GetParameterValue("COMPANY_LINKMAN"), "H" + ((iCopy * pagerows) + 2).ToString(), "J" + ((iCopy * pagerows) + 2).ToString())); list.Add(new modExcelRangeData("电话:" + clsLxms.GetParameterValue("COMPANY_TEL"), "H" + ((iCopy * pagerows) + 3).ToString(), "J" + ((iCopy * pagerows) + 3).ToString())); list.Add(new modExcelRangeData("传真:" + clsLxms.GetParameterValue("COMPANY_FAX"), "H" + ((iCopy * pagerows) + 4).ToString(), "J" + ((iCopy * pagerows) + 4).ToString())); break; default: list.Add(new modExcelRangeData(clsLxms.GetParameterValue("COMPANY_NAME"), "A" + ((iCopy * pagerows) + 2).ToString(), "J" + ((iCopy * pagerows) + 2).ToString())); list.Add(new modExcelRangeData("TEL:" + clsLxms.GetParameterValue("COMPANY_TEL") + " Fax:" + clsLxms.GetParameterValue("COMPANY_FAX"), "A" + ((iCopy * pagerows) + 3).ToString(), "J" + ((iCopy * pagerows) + 3).ToString())); list.Add(new modExcelRangeData("公司地址:" + clsLxms.GetParameterValue("COMPANY_ADDR"), "A" + ((iCopy * pagerows) + 4).ToString(), "J" + ((iCopy * pagerows) + 4).ToString())); list.Add(new modExcelRangeData(modcust.FullName, "B" + ((iCopy * pagerows) + 6).ToString(), "D" + ((iCopy * pagerows) + 6).ToString())); list.Add(new modExcelRangeData(dtpFrom.Value.ToString("yyyy-MM-dd"), "F" + ((iCopy * pagerows) + 6).ToString(), "H" + ((iCopy * pagerows) + 6).ToString())); list.Add(new modExcelRangeData(dtpTo.Value.ToString("yyyy-MM-dd"), "J" + ((iCopy * pagerows) + 6).ToString(), "J" + ((iCopy * pagerows) + 6).ToString())); list.Add(new modExcelRangeData(modcust.Tel, "B" + ((iCopy * pagerows) + 7).ToString(), "D" + ((iCopy * pagerows) + 7).ToString())); list.Add(new modExcelRangeData(modcust.Fax, "F" + ((iCopy * pagerows) + 7).ToString(), "H" + ((iCopy * pagerows) + 7).ToString())); list.Add(new modExcelRangeData(modcust.Linkman, "J" + ((iCopy * pagerows) + 7).ToString(), "J" + ((iCopy * pagerows) + 7).ToString())); break; } }
private void btnCust_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; MTN_CUSTOMER_LIST frm = new MTN_CUSTOMER_LIST(); frm.SelectVisible = true; if (frm.ShowDialog() == DialogResult.OK) { dalCustomerList dal = new DAL.dalCustomerList(); modCustomerList mod = dal.GetItem(Util.retValue1, out Util.emsg); if (mod != null) { txtCustName.Tag = mod.CustId; txtCustName.Text = mod.CustName; txtPayMethod.Text = mod.PayMethod; txtSalesMan.Text = mod.SalesMan; txtNo.Text = _dal.GetNewNo(dtpFormDate.Value, mod.CustId); txtCurrency.Text = mod.Currency; if (mod.NeedInvoice == 1) { cboReceiveStatus.SelectedIndex = 0; cboInvoiceStatus.SelectedIndex = 1; } else { cboReceiveStatus.SelectedIndex = 1; cboInvoiceStatus.SelectedIndex = 0; } } } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } finally { this.Cursor = Cursors.Default; } }
private void mnuCustomerLog_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; if (DBGrid.CurrentRow == null) { return; } modCustomerList mod = (modCustomerList)DBGrid.CurrentRow.DataBoundItem; dalCustomerLog dallog = new dalCustomerLog(); BindingCollection <modCustomerLog> listlog = dallog.GetIList(mod.CustId, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, out Util.emsg); if (listlog != null && listlog.Count > 0) { frmViewList frm = new frmViewList(); frm.InitViewList(clsTranslate.TranslateString("Customer Log"), listlog); frm.ShowDialog(); } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(clsTranslate.TranslateString("No data found!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } finally { this.Cursor = Cursors.Default; } }
private void DBGrid_SelectionChanged(object sender, EventArgs e) { if (DBGrid.CurrentRow != null) { modCustomerList mod = (modCustomerList)DBGrid.CurrentRow.DataBoundItem; txtCustId.Text = mod.CustId; txtCustName.Text = mod.CustName; txtFullName.Text = mod.FullName; cboStatus.SelectedIndex = Convert.ToInt32(mod.Status); cboCustType.SelectedValue = mod.CustType; cboCustLevel.SelectedValue = mod.CustLevel; txtNo.Text = mod.No; cboCurrency.SelectedValue = mod.Currency; txtLinkman.Text = mod.Linkman; txtTel.Text = mod.Tel; txtFax.Text = mod.Fax; txtAddr.Text = mod.Addr; txtEMail.Text = mod.EMail; txtQQ.Text = mod.QQ; txtRemark.Text = mod.Remark; txtShipmentAddr.Text = mod.ShipAddr; txtIncorporator.Text = mod.Incorporator; txtProductType.Text = mod.ProductType; txtCompanySize.Text = mod.CompanySize; txtPaymentMethod.Text = mod.PayMethod; txtCheckAccountDate.Text = mod.CheckAccountDate; txtAccountBank.Text = mod.AccountBank; txtAccountNo.Text = mod.AccountNo; cboSalesMan.SelectedValue = mod.SalesMan; cboNeedInvoice.SelectedIndex = mod.NeedInvoice; cboShipmentTemplete.SelectedValue = mod.ShipmentTemplete; //FindText = mod.CustId; LoadTraceInfo(mod.CustId); } else { Util.EmptyFormBox(this); DBGridTrace.DataSource = null; } }
protected override bool Save() { try { this.Cursor = Cursors.WaitCursor; if (string.IsNullOrEmpty(txtCustId.Text.Trim())) { MessageBox.Show(clsTranslate.TranslateString("cust id") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtCustId.Focus(); return(false); } if (string.IsNullOrEmpty(txtCustName.Text.Trim())) { MessageBox.Show(clsTranslate.TranslateString("cust name") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtCustName.Focus(); return(false); } if (cboCustType.SelectedIndex == -1) { MessageBox.Show(clsTranslate.TranslateString("Cust type") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboCustType.Focus(); return(false); } if (cboCustLevel.SelectedIndex == -1) { MessageBox.Show(clsTranslate.TranslateString("Cust level") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboCustLevel.Focus(); return(false); } if (cboCurrency.SelectedIndex == -1) { MessageBox.Show(clsTranslate.TranslateString("Currency") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboCurrency.Focus(); return(false); } if (cboNeedInvoice.SelectedIndex == -1) { MessageBox.Show(clsTranslate.TranslateString("Need invoice") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboNeedInvoice.Focus(); return(false); } if (string.IsNullOrEmpty(txtCustName.Text.Trim())) { MessageBox.Show(clsTranslate.TranslateString("Cust name") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtCustName.Focus(); return(false); } if (string.IsNullOrEmpty(txtFullName.Text.Trim())) { MessageBox.Show(clsTranslate.TranslateString("Full name") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtFullName.Focus(); return(false); } if (string.IsNullOrEmpty(txtNo.Text.Trim())) { MessageBox.Show(clsTranslate.TranslateString("Ship no") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtNo.Focus(); return(false); } if (Util.IsChina(txtNo.Text.Trim())) { MessageBox.Show(clsTranslate.TranslateString("No") + clsTranslate.TranslateString(" can not be chinese!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtNo.Focus(); return(false); } if (cboSalesMan.SelectedIndex == -1) { MessageBox.Show(clsTranslate.TranslateString("Sales man") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboSalesMan.Focus(); return(false); } if (!string.IsNullOrEmpty(txtEMail.Text.Trim())) { if (!Util.IsEmailAddr(txtEMail.Text.Trim())) { MessageBox.Show(clsTranslate.TranslateString("EMail") + clsTranslate.TranslateString(" is not a valid one!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtEMail.Focus(); return(false); } } int? status = cboStatus.SelectedIndex; modCustomerList mod = new modCustomerList(); mod.CustId = txtCustId.Text.Trim(); mod.CustName = txtCustName.Text.Trim(); mod.FullName = txtFullName.Text.Trim(); mod.Status = status; mod.NeedInvoice = cboNeedInvoice.SelectedIndex; mod.CustType = cboCustType.SelectedValue.ToString(); mod.CustLevel = cboCustLevel.SelectedValue.ToString(); mod.No = txtNo.Text.Trim().Replace("*", ""); mod.Currency = cboCurrency.SelectedValue.ToString(); mod.Linkman = txtLinkman.Text.Trim(); mod.Tel = txtTel.Text.Trim(); mod.Fax = txtFax.Text.Trim(); mod.Addr = txtAddr.Text.Trim(); mod.ShipAddr = txtShipmentAddr.Text.Trim(); mod.EMail = txtEMail.Text.Trim(); mod.QQ = txtQQ.Text.Trim(); mod.Remark = txtRemark.Text.Trim(); mod.Incorporator = txtIncorporator.Text.Trim(); mod.ProductType = txtProductType.Text.Trim(); mod.CompanySize = txtCompanySize.Text.Trim(); mod.PayMethod = txtPaymentMethod.Text.Trim(); mod.CheckAccountDate = txtCheckAccountDate.Text.Trim(); mod.AccountBank = txtAccountBank.Text.Trim(); mod.AccountNo = txtAccountNo.Text.Trim(); mod.SalesMan = cboSalesMan.SelectedValue.ToString(); mod.ShipmentTemplete = cboShipmentTemplete.SelectedValue.ToString(); mod.UpdateUser = Util.UserId; bool ret = false; if (_status == 1) { if (_dal.Exists(mod, out Util.emsg)) { if (MessageBox.Show(Util.emsg + "\r\n\r\n您要继续添加此客户吗?", clsTranslate.TranslateString("Confirm"), MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { ret = _dal.Insert(mod, out Util.emsg); } } else { ret = _dal.Insert(mod, out Util.emsg); } } else if (_status == 2) { ret = _dal.Update(txtCustId.Text, mod, out Util.emsg); } if (ret) { Util.ChangeStatus(this, true); DBGrid.Enabled = true; DBGridTrace.Enabled = true; tvLeft.SelectedNode = tvLeft.Nodes[0]; LoadData(); FindText = mod.FullName; //Find(); } return(ret); } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } finally { this.Cursor = Cursors.Default; } }
protected override void Find() { if (DBGrid.CurrentRow == null) { return; } for (int i = 0; i < DBGrid.Rows.Count; i++) { DBGrid.Rows[i].Visible = true; } int startindex = 0; if (DBGrid.CurrentRow.Index < DBGrid.RowCount - 1) { startindex = DBGrid.CurrentRow.Index + 1; } string[] finds = FindText.ToUpper().Split('*'); string flag = clsLxms.GetParameterValue("HIDE_NOT_MATCH_PRODUCT"); if (flag == "F") //不隐藏不匹配的 { bool find = false; for (int i = startindex; i < DBGrid.Rows.Count; i++) { bool found = true; modCustomerList mod = (modCustomerList)DBGrid.Rows[i].DataBoundItem; for (int j = 0; j < finds.Length; j++) { if (mod.FullName.IndexOf(finds[j]) < 0) { found = false; } } if (found) { DBGrid.CurrentCell = DBGrid.Rows[i].Cells[0]; DBGrid_SelectionChanged(null, null); find = true; return; } } if (!find) { for (int i = 0; i < DBGrid.Rows.Count; i++) { bool found = true; modCustomerList mod = (modCustomerList)DBGrid.Rows[i].DataBoundItem; for (int j = 0; j < finds.Length; j++) { if (mod.FullName.IndexOf(finds[j]) < 0) { found = false; } } if (found) { DBGrid.CurrentCell = DBGrid.Rows[i].Cells[0]; DBGrid_SelectionChanged(null, null); find = true; return; } } } } else //隐藏不匹配的 { DBGrid.CurrentCell = null; for (int i = 0; i < DBGrid.Rows.Count; i++) { bool found = true; modCustomerList mod = (modCustomerList)DBGrid.Rows[i].DataBoundItem; for (int j = 0; j < finds.Length; j++) { if (mod.FullName.IndexOf(finds[j]) < 0) { found = false; break; } } if (found) { DBGrid.Rows[i].Visible = true; } else { DBGrid.Rows[i].Visible = false; } } } }
private void DBGrid_DoubleClick(object sender, EventArgs e) { if (DBGrid.CurrentRow == null) { return; } string statuslist = "9"; if (chkNotAudit.Checked) { statuslist += ",0"; } if (chkAudited.Checked) { statuslist += ",1"; } string paystatuslist = string.Empty; if (chkPay0.Checked) { paystatuslist += ",0"; } if (chkPay1.Checked) { paystatuslist += ",1"; } string invoicestatuslist = string.Empty; if (chkInvoice0.Checked) { invoicestatuslist += ",0"; } if (chkInvoice1.Checked) { invoicestatuslist += ",1"; } if (chkInvoice2.Checked) { invoicestatuslist += ",2"; } string custlist = string.Empty; if (lstCustomer.SelectedItems.Count > 0 && lstCustomer.SelectedItems.Count < lstCustomer.Items.Count) { for (int i = 0; i < lstCustomer.SelectedItems.Count; i++) { modCustomerList mod = (modCustomerList)lstCustomer.SelectedItems[i]; if (i == 0) { custlist = mod.CustId; } else { custlist += "," + mod.CustId; } } } BindingCollection <modSalesDesignForm> list = new BindingCollection <modSalesDesignForm>(); if (DBGrid.CurrentRow.Index == DBGrid.RowCount - 1) { list = _dal.GetIList(statuslist, cboFormType.SelectedValue.ToString(), custlist, string.Empty, string.Empty, string.Empty, string.Empty, paystatuslist, invoicestatuslist, dtpFrom.Text, dtpTo.Text, out Util.emsg); } else { modSalesDesignSummary moditem = (modSalesDesignSummary)DBGrid.CurrentRow.DataBoundItem; list = _dal.GetIList(string.Empty, moditem.FormType, moditem.CustId, string.Empty, string.Empty, string.Empty, string.Empty, paystatuslist, invoicestatuslist, dtpFrom.Text, dtpTo.Text, out Util.emsg); } if (list != null && list.Count > 0) { frmViewList frm = new frmViewList(); frm.InitViewList(clsTranslate.TranslateString("Sales Shipment Detail"), list); frm.ShowDialog(); } }
protected void LoadData() { try { this.Cursor = Cursors.WaitCursor; string emsg = string.Empty; string statuslist = "9"; if (chkNotAudit.Checked) { statuslist += ",0"; } if (chkAudited.Checked) { statuslist += ",1"; } string custlist = string.Empty; if (lstCustomer.SelectedItems.Count > 0 && lstCustomer.SelectedItems.Count < lstCustomer.Items.Count) { for (int i = 0; i < lstCustomer.SelectedItems.Count; i++) { modCustomerList mod = (modCustomerList)lstCustomer.SelectedItems[i]; if (i == 0) { custlist = mod.CustId; } else { custlist += "," + mod.CustId; } } } DBGrid.toolCancelFrozen_Click(null, null); BindingCollection <modSalesManMny> list = _dal.GetSalesManMny(statuslist, string.Empty, custlist, string.Empty, cboSalesMan.SelectedValue.ToString(), txtProductName.Text.Trim(), dtpFrom.Text, dtpTo.Text, out emsg); DBGrid.DataSource = list; if (list != null && list.Count > 0) { AddComboBoxColumns(); GetDetailSum(); ShowColor(); DBGrid.Columns["Qty"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DBGrid.Columns["Price"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DBGrid.Columns["SumMny"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DBGrid.Columns["SalesManMny"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DBGrid.Columns["PaidSalesMny"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DBGrid.ReadOnly = false; DBGrid.Columns["SalesManMny"].DefaultCellStyle.ForeColor = Color.Red; DBGrid.Columns["PaidSalesMny"].DefaultCellStyle.ForeColor = Color.Red; DBGrid.Columns["SalesManMny"].ReadOnly = false; DBGrid.Columns["PaidSalesMny"].ReadOnly = false; } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(clsTranslate.TranslateString("No data found!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } StatusLabel1.Text = "共 0 行数据, 合计金额为: " + string.Format("{0:C2}", 0); } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { this.Cursor = Cursors.Default; } }
public void Import(int id) { try { this.Cursor = Cursors.WaitCursor; _action = "NEW"; FillControl.FillDesignType(cboDesignType, false); FillControl.FillReceiveStatus(cboReceiveStatus, false); FillControl.FillInvoiceStatus(cboInvoiceStatus, false); dalCustomerOrderList dal = new dalCustomerOrderList(); modCustomerOrderList mod = dal.GetItem(id, out Util.emsg); if (mod != null) { txtId.Text = "0"; dtpFormDate.Value = DateTime.Today; //cboDesignType.SelectedValue = mod.FormType; txtCustOrderNo.Text = mod.CustOrderNo; txtNo.Text = _dal.GetNewNo(dtpFormDate.Value, mod.CustId); txtCurrency.Text = mod.Currency; txtCustName.Tag = mod.CustId; txtCustName.Text = mod.CustName; txtPayMethod.Text = mod.PayMethod; txtSalesMan.Text = mod.SalesMan; txtUnitNo.Text = mod.UnitNo; txtQty.Text = mod.Qty.ToString(); txtMny.Text = (mod.Qty * mod.Price).ToString(); txtSalesManMny.Text = "0"; txtProductName.Text = mod.ProductName; txtRemark.Text = mod.Remark; txtInvoiceMny.Text = "0"; dalCustomerList dalcust = new DAL.dalCustomerList(); modCustomerList modcust = dalcust.GetItem(mod.CustId, out Util.emsg); if (modcust != null) { //txtCustName.Tag = modcust.CustId; //txtCustName.Text = modcust.CustName; //txtPayMethod.Text = modcust.txtPayMethod; //txtSalesMan.Text = modcust.SalesMan; //txtCurrency.Text = mod.Currency; if (modcust.NeedInvoice == 1) { cboReceiveStatus.SelectedIndex = 0; cboInvoiceStatus.SelectedIndex = 1; } else { cboReceiveStatus.SelectedIndex = 1; cboInvoiceStatus.SelectedIndex = 0; } } status4.Image = null; toolSave.Visible = true; Util.ChangeStatus(this, false); txtId.ReadOnly = true; toolSave.Enabled = true; cboReceiveStatus.Enabled = true; cboInvoiceStatus.Enabled = true; cboAccountNo.Enabled = true; txtInvoiceMny.ReadOnly = false; txtInvoiceNo.ReadOnly = false; btnUpdate.Enabled = true; btnReceiveDate.Enabled = true; } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } finally { this.Cursor = Cursors.Default; } }
protected void LoadData() { try { this.Cursor = Cursors.WaitCursor; string statuslist = "9"; if (chkNotAudit.Checked) { statuslist += ",0"; } if (chkAudited.Checked) { statuslist += ",1"; } string paystatuslist = string.Empty; if (chkPay0.Checked) { paystatuslist += ",0"; } if (chkPay1.Checked) { paystatuslist += ",1"; } string invoicestatuslist = string.Empty; if (chkInvoice0.Checked) { invoicestatuslist += ",0"; } if (chkInvoice1.Checked) { invoicestatuslist += ",1"; } if (chkInvoice2.Checked) { invoicestatuslist += ",2"; } string custlist = string.Empty; if (lstCustomer.SelectedItems.Count > 0 && lstCustomer.SelectedItems.Count < lstCustomer.Items.Count) { for (int i = 0; i < lstCustomer.SelectedItems.Count; i++) { modCustomerList mod = (modCustomerList)lstCustomer.SelectedItems[i]; if (i == 0) { custlist = mod.CustId; } else { custlist += "," + mod.CustId; } } } BindingCollection <modSalesDesignSummary> list = _dal.GetSalesDesignSummary(statuslist, cboFormType.SelectedValue.ToString(), custlist, string.Empty, cboSalesMan.SelectedValue.ToString(), paystatuslist, invoicestatuslist, dtpFrom.Text, dtpTo.Text, out Util.emsg); DBGrid.DataSource = list; if (list == null && !string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (list.Count > 0) { decimal sum = 0; foreach (modSalesDesignSummary mod in list) { sum += Convert.ToDecimal(mod.AdFlag) * mod.SumMny; } StatusLabel1.Text = "共 " + list.Count.ToString() + " 行数据, 合计金额为: " + string.Format("{0:C2}", sum); DBGrid.Columns["Qty"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DBGrid.Columns["SumMny"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DBGrid.AlternatingRowsDefaultCellStyle.BackColor = Color.Empty; DBGrid.Rows[DBGrid.RowCount - 1].DefaultCellStyle.BackColor = frmOptions.ALTERNATING_BACKCOLOR; } ShowColor(); } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { this.Cursor = Cursors.Default; } }
private void toolExport_Click(object sender, EventArgs e) { if (DBGrid.CurrentRow == null) { return; } IList <modExcelRangeData> list = new List <modExcelRangeData>(); decimal summny = 0; string custid = string.Empty; string custorderno = string.Empty; dalProductList dalpdt = new dalProductList(); if (DBGrid.SelectedRows.Count == 0) { for (int i = 0; i < DBGrid.RowCount; i++) { if (DBGrid.Rows[i].Visible) { modCustomerOrderList modd = (modCustomerOrderList)DBGrid.Rows[i].DataBoundItem; if (string.IsNullOrEmpty(custid)) { dalCustomerList dalcust = new dalCustomerList(); modCustomerList modcust = dalcust.GetItem(modd.CustId, out Util.emsg); custid = modd.CustId; custorderno = modd.CustOrderNo; list.Add(new modExcelRangeData(modcust.FullName, "B6", "E6")); list.Add(new modExcelRangeData(modd.CustOrderNo, "I6", "I6")); list.Add(new modExcelRangeData(modd.FormDate.ToString("yyyy年MM月dd日"), "I7", "I7")); } else { if (custid != modd.CustId) { MessageBox.Show("您所选的订单必须属于同一个客户!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (custorderno != modd.CustOrderNo) { if (MessageBox.Show("您所选的订单不是同一个订单编号,是否要继续?", clsTranslate.TranslateString("Confirm"), MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button2) == DialogResult.No) { return; } } } string col = (10 + i).ToString().Trim(); 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)); summny = modd.Qty * modd.Price; } } list.Add(new modExcelRangeData("金额大写:" + clsMoney.ConvertToMoney(Convert.ToDouble(summny)), "A23", "I23")); list.Add(new modExcelRangeData(string.Format("{0:C2}", summny), "H22", "H22")); } else { for (int i = 0; i < DBGrid.SelectedRows.Count; i++) { if (DBGrid.SelectedRows[i].Visible) { modCustomerOrderList modd = (modCustomerOrderList)DBGrid.SelectedRows[i].DataBoundItem; if (string.IsNullOrEmpty(custid)) { dalCustomerList dalcust = new dalCustomerList(); modCustomerList modcust = dalcust.GetItem(modd.CustId, out Util.emsg); custid = modd.CustId; custorderno = modd.CustOrderNo; list.Add(new modExcelRangeData(modcust.FullName, "B6", "E6")); list.Add(new modExcelRangeData(modd.CustOrderNo, "I6", "I6")); list.Add(new modExcelRangeData(modd.FormDate.ToString("yyyy年MM月dd日"), "I7", "I7")); } else { if (custid != modd.CustId) { MessageBox.Show("您所选的订单必须属于同一个客户!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (custorderno != modd.CustOrderNo) { if (MessageBox.Show("您所选的订单不是同一个订单编号,是否要继续?", clsTranslate.TranslateString("Confirm"), MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button2) == DialogResult.No) { return; } } } string col = (10 + i).ToString().Trim(); 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)); summny = modd.Qty * modd.Price; } } list.Add(new modExcelRangeData("金额大写:" + clsMoney.ConvertToMoney(Convert.ToDouble(summny)), "A23", "I23")); list.Add(new modExcelRangeData(string.Format("{0:C2}", summny), "H22", "H22")); } clsExport.ExportByTemplate(list, "购销合同", 1, 38, 9, 1); }
protected void LoadData() { try { this.Cursor = Cursors.WaitCursor; string statuslist = "9"; if (chkNotAudit.Checked) { statuslist += ",0"; } if (chkAudited.Checked) { statuslist += ",1"; } string paystatuslist = string.Empty; if (chkPay0.Checked) { paystatuslist += ",0"; } if (chkPay1.Checked) { paystatuslist += ",1"; } string invoicestatuslist = string.Empty; if (chkInvoice0.Checked) { invoicestatuslist += ",0"; } if (chkInvoice1.Checked) { invoicestatuslist += ",1"; } if (chkInvoice2.Checked) { invoicestatuslist += ",2"; } string custlist = string.Empty; if (lstCustomer.SelectedItems.Count > 0 && lstCustomer.SelectedItems.Count < lstCustomer.Items.Count) { for (int i = 0; i < lstCustomer.SelectedItems.Count; i++) { modCustomerList mod = (modCustomerList)lstCustomer.SelectedItems[i]; if (i == 0) { custlist = mod.CustId; } else { custlist += "," + mod.CustId; } } } BindingCollection <modVSalesShipmentDetail> list = _dal.GetVDetail(statuslist, cboShipType.SelectedValue.ToString(), custlist, string.Empty, txtInvNo.Text.Trim(), txtCustOrderNo.Text.Trim(), cboSalesMan.SelectedValue.ToString(), paystatuslist, invoicestatuslist, string.Empty, string.Empty, txtProductName.Text.Trim(), dtpFrom.Text, dtpTo.Text, out Util.emsg); DBGrid.DataSource = list; decimal sum = 0; if (list != null && list.Count > 0) { foreach (modVSalesShipmentDetail mod in list) { sum += mod.Qty * mod.Price * Convert.ToDecimal(mod.AdFlag); } ShowColor(); StatusLabel1.Text = "共 " + list.Count.ToString() + " 行数据, 合计金额为: " + string.Format("{0:C2}", sum); } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(clsTranslate.TranslateString("No data found!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } StatusLabel1.Text = "共 0 行数据, 合计金额为: " + string.Format("{0:C2}", sum); } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } 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>(); 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; } } }