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