private void btnVendor_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
MTN_VENDOR_LIST frm = new MTN_VENDOR_LIST();
frm.SelectVisible = true;
if (frm.ShowDialog() == DialogResult.OK)
{
dalVendorList dal = new DAL.dalVendorList();
modVendorList mod = dal.GetItem(Util.retValue1, out Util.emsg);
if (mod != null)
{
txtVendorName.Text = mod.VendorName;
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 void Find()
{
for (int i = 0; i < DBGrid.Rows.Count; i++)
{
modVendorList mod = (modVendorList)DBGrid.Rows[i].DataBoundItem;
if (mod.VendorName.CompareTo(FindText) == 0)
{
DBGrid.CurrentCell = DBGrid.Rows[i].Cells[0];
DBGrid_SelectionChanged(null, null);
return;
}
}
}
/// <summary>
/// get all vendorlist
/// <summary>
/// <param name=statuslist>statuslist</param>
/// <param name=storelist>storelist</param>
/// <param name=vendortype>vendortype</param>
/// <param name=out emsg>return error message</param>
///<returns>details of all vendorlist</returns>
public BindingCollection <modVendorList> GetIList(string statuslist, string vendortype, out string emsg)
{
try
{
string statuswhere = string.Empty;
if (!string.IsNullOrEmpty(statuslist) && statuslist.CompareTo("ALL") != 0)
{
statuswhere = "and a.status in ('" + statuslist.Replace(",", "','") + "') ";
}
string vendortypewhere = string.Empty;
if (!string.IsNullOrEmpty(vendortype))
{
vendortypewhere = "and a.vendor_type = '" + vendortype + "' ";
}
BindingCollection <modVendorList> modellist = new BindingCollection <modVendorList>();
//Execute a query to read the categories
string sql = "select a.vendor_name,a.vendor_type,a.status,a.currency,a.no,a.linkman,a.tel,a.fax,a.addr,a.remark,a.need_invoice,a.update_user,a.update_time "
+ "from vendor_list a where 1=1 " + statuswhere + vendortypewhere + " order by a.vendor_name";
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
modVendorList model = new modVendorList();
model.VendorName = dalUtility.ConvertToString(rdr["vendor_name"]);
model.VendorType = dalUtility.ConvertToString(rdr["vendor_type"]);
model.Status = dalUtility.ConvertToInt(rdr["status"]);
model.Currency = dalUtility.ConvertToString(rdr["currency"]);
model.No = dalUtility.ConvertToString(rdr["no"]);
model.Linkman = dalUtility.ConvertToString(rdr["linkman"]);
model.Tel = dalUtility.ConvertToString(rdr["tel"]);
model.Fax = dalUtility.ConvertToString(rdr["fax"]);
model.Addr = dalUtility.ConvertToString(rdr["addr"]);
model.Remark = dalUtility.ConvertToString(rdr["remark"]);
model.NeedInvoice = dalUtility.ConvertToInt(rdr["need_invoice"]);
model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
modellist.Add(model);
}
}
emsg = null;
return(modellist);
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
/// <summary>
/// get all vendorlist
/// <summary>
/// <param name=currentPage>currentPage</param>
/// <param name=pagesize>pagesize</param>
/// <param name=vendorname>vendorname</param>
/// <param name=out emsg>return error message</param>
///<returns>details of all vendorlist</returns>
public BindingCollection <modVendorList> GetIList(int currentPage, int pagesize, string vendorname, out string emsg)
{
try
{
string vendornamewhere = string.Empty;
if (!string.IsNullOrEmpty(vendorname))
{
vendornamewhere = "and product_name like '" + vendorname + "%' ";
}
int startindex = (currentPage - 1) * pagesize + 1;
int endindex = currentPage * pagesize;
BindingCollection <modVendorList> modellist = new BindingCollection <modVendorList>();
//Execute a query to read the categories
string sql = "select row_number() over(order by vendor_name) as rn,a.vendor_name,a.vendor_type,a.status,a.currency,a.no,a.linkman,a.tel,a.fax,a.addr,a.remark,a.need_invoice,a.update_user,a.update_time "
+ "from vendor_list a where 1=1 " + vendornamewhere;
string sql2 = "select count(1) from (" + sql + ") t";
sql = string.Format("select * from (" + sql + ") t where rn>='{0}' and rn<='{1}'", startindex, endindex);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
modVendorList model = new modVendorList();
model.VendorName = dalUtility.ConvertToString(rdr["vendor_name"]);
model.VendorType = dalUtility.ConvertToString(rdr["vendor_type"]);
model.Status = dalUtility.ConvertToInt(rdr["status"]);
model.Currency = dalUtility.ConvertToString(rdr["currency"]);
model.No = dalUtility.ConvertToString(rdr["no"]);
model.Linkman = dalUtility.ConvertToString(rdr["linkman"]);
model.Tel = dalUtility.ConvertToString(rdr["tel"]);
model.Fax = dalUtility.ConvertToString(rdr["fax"]);
model.Addr = dalUtility.ConvertToString(rdr["addr"]);
model.Remark = dalUtility.ConvertToString(rdr["remark"]);
model.NeedInvoice = dalUtility.ConvertToInt(rdr["need_invoice"]);
model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
modellist.Add(model);
}
}
emsg = SqlHelper.ExecuteScalar(sql2).ToString();
return(modellist);
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
private void DBGrid_SelectionChanged(object sender, EventArgs e)
{
if (DBGrid.CurrentRow != null)
{
modVendorList mod = (modVendorList)DBGrid.CurrentRow.DataBoundItem;
txtVendorName.Text = mod.VendorName;
cboVendorType.SelectedValue = mod.VendorType;
cboStatus.SelectedIndex = Convert.ToInt32(mod.Status);
cboCurrency.SelectedValue = mod.Currency;
txtNo.Text = mod.No;
txtLinkman.Text = mod.Linkman;
txtTel.Text = mod.Tel;
txtFax.Text = mod.Fax;
txtAddr.Text = mod.Addr;
txtRemark.Text = mod.Remark;
cboNeedInvoice.SelectedIndex = mod.NeedInvoice;
FindText = mod.VendorName;
}
}
/// <summary>
/// get table record
/// <summary>
/// <param name=vendorname>vendorname</param>
/// <param name=out emsg>return error message</param>
///<returns>get a record detail of vendorlist</returns>
public modVendorList GetItem(string vendorname, out string emsg)
{
try
{
//Execute a query to read the categories
string sql = string.Format("select a.vendor_name,a.vendor_type,a.status,a.currency,a.no,a.linkman,a.tel,a.fax,a.addr,a.remark,a.need_invoice,a.update_user,a.update_time "
+ "from vendor_list a where 1=1 and a.vendor_name='{0}' order by vendor_name", vendorname);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
if (rdr.Read())
{
modVendorList model = new modVendorList();
model.VendorName = dalUtility.ConvertToString(rdr["vendor_name"]);
model.VendorType = dalUtility.ConvertToString(rdr["vendor_type"]);
model.Status = dalUtility.ConvertToInt(rdr["status"]);
model.Currency = dalUtility.ConvertToString(rdr["currency"]);
model.No = dalUtility.ConvertToString(rdr["no"]);
model.Linkman = dalUtility.ConvertToString(rdr["linkman"]);
model.Tel = dalUtility.ConvertToString(rdr["tel"]);
model.Fax = dalUtility.ConvertToString(rdr["fax"]);
model.Addr = dalUtility.ConvertToString(rdr["addr"]);
model.Remark = dalUtility.ConvertToString(rdr["remark"]);
model.NeedInvoice = dalUtility.ConvertToInt(rdr["need_invoice"]);
model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
emsg = null;
return(model);
}
else
{
emsg = "Error on read data";
return(null);
}
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
/// <summary>
/// update a vendorlist
/// <summary>
/// <param name=vendorname>vendorname</param>
/// <param name=mod>model object of vendorlist</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Update(string vendorname, modVendorList mod, out string emsg)
{
try
{
string sql = string.Format("update vendor_list set vendor_type='{0}',status={1},linkman='{2}',tel='{3}',fax='{4}',addr='{5}',remark='{6}',update_user='******',update_time=getdate(), need_invoice={8},no='{9}' where vendor_name='{10}'", mod.VendorType, mod.Status, mod.Linkman, mod.Tel, mod.Fax, mod.Addr, mod.Remark, mod.UpdateUser, mod.NeedInvoice, mod.No, vendorname);
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
emsg = null;
return(true);
}
else
{
emsg = "Unknown error when ExecuteNonQuery!";
return(false);
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(false);
}
}
/// <summary>
/// insert a vendorlist
/// <summary>
/// <param name=mod>model object of vendorlist</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Insert(modVendorList mod, out string emsg)
{
try
{
string sql = string.Format("insert into vendor_list(vendor_name,vendor_type,status,linkman,tel,fax,addr,remark,update_user,update_time,start_time,need_invoice,no,currency"
+ ")values('{0}','{1}',{2},'{3}','{4}','{5}','{6}','{7}','{8}',getdate(),getdate(),{9},'{10}','{11}')", mod.VendorName, mod.VendorType, mod.Status, mod.Linkman, mod.Tel, mod.Fax, mod.Addr, mod.Remark, mod.UpdateUser, mod.NeedInvoice, mod.No, mod.Currency);
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
emsg = null;
return(true);
}
else
{
emsg = "Unknown error when ExecuteNonQuery!";
return(false);
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(false);
}
}
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 vendorlist = string.Empty;
if (lstVendor.SelectedItems.Count > 0 && lstVendor.SelectedItems.Count < lstVendor.Items.Count)
{
for (int i = 0; i < lstVendor.SelectedItems.Count; i++)
{
modVendorList mod = (modVendorList)lstVendor.SelectedItems[i];
if (i == 0)
{
vendorlist = mod.VendorName;
}
else
{
vendorlist += "," + mod.VendorName;
}
}
}
BindingCollection <modVPurchaseDetail> list = _dal.GetVDetail(statuslist, cboPurchaseType.SelectedValue.ToString(), vendorlist, string.Empty, txtInvNo.Text.Trim(), paystatuslist, invoicestatuslist, string.Empty, string.Empty, txtProductName.Text.Trim(), string.Empty, dtpFrom.Text, dtpTo.Text, out Util.emsg);
DBGrid.DataSource = list;
decimal sum = 0;
if (list != null && list.Count > 0)
{
foreach (modVPurchaseDetail mod in list)
{
sum += mod.Qty * mod.Price;
}
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 mnuNewVendorOrderList_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (DBGrid.CurrentRow == null)
{
return;
}
string selectionlist = string.Empty;
dalVendorList dalvendor = new dalVendorList();
BindingCollection <modVendorList> listvendor = dalvendor.GetIList("1", string.Empty, out Util.emsg);
if (listvendor != null)
{
frmSingleSelect frm = new frmSingleSelect();
frm.InitViewList("请选择供应商", listvendor, "VendorName", "VendorName", ComboBoxStyle.DropDown);
if (frm.ShowDialog() == DialogResult.OK)
{
modVendorList modvendor = dalvendor.GetItem(Util.retValue1, out Util.emsg);
BindingCollection <modVendorOrderList> list = new BindingCollection <modVendorOrderList>();
if (DBGrid.SelectedRows.Count == 0)
{
modCustomerOrderList modco = (modCustomerOrderList)DBGrid.CurrentRow.DataBoundItem;
modVendorOrderList mod = new modVendorOrderList();
mod.Id = 0;
mod.FormDate = DateTime.Today;
mod.RequireDate = DateTime.Today;
//mod.VendorOrderNo = modco.CustOrderNo;
mod.Remark = modco.CustName + ": " + modco.CustOrderNo;
mod.VendorName = Util.retValue1;
mod.PayMethod = string.Empty;
mod.PurchaseMan = Util.UserId;
mod.ProductId = modco.ProductId;
mod.ProductName = modco.ProductName;
if (clsLxms.GetProductSizeFlag(mod.ProductId) == 0)
{
mod.Size = 1;
}
else
{
mod.Size = modco.Size;
}
mod.Currency = modvendor.Currency;
mod.UnitNo = modco.UnitNo;
mod.Qty = modco.Qty;
mod.Price = 0;
mod.UpdateUser = Util.UserId;
list.Add(mod);
}
else
{
for (int i = 0; i < DBGrid.SelectedRows.Count; i++)
{
if (DBGrid.SelectedRows[i].Visible)
{
modCustomerOrderList modco = (modCustomerOrderList)DBGrid.SelectedRows[i].DataBoundItem;
modVendorOrderList mod = new modVendorOrderList();
mod.Id = 0;
mod.FormDate = DateTime.Today;
mod.RequireDate = DateTime.Today;
//mod.VendorOrderNo = modco.CustOrderNo;
mod.Remark = modco.CustName + ": " + modco.CustOrderNo;
mod.VendorName = Util.retValue1;
mod.PayMethod = string.Empty;
mod.PurchaseMan = Util.UserId;
mod.ProductId = modco.ProductId;
mod.ProductName = modco.ProductName;
if (clsLxms.GetProductSizeFlag(mod.ProductId) == 0)
{
mod.Size = 1;
}
else
{
mod.Size = modco.Size;
}
mod.Currency = modvendor.Currency;
mod.UnitNo = modco.UnitNo;
mod.Qty = modco.Qty;
mod.Price = 0;
mod.UpdateUser = Util.UserId;
list.Add(mod);
}
}
}
VendorOrderImport frmImport = new VendorOrderImport();
frmImport.InitViewList(list);
frmImport.ShowDialog();
}
}
}
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 LoadData()
{
if (prepared == false)
{
return;
}
if (DBGrid.CurrentRow == null)
{
return;
}
switch (cboBookType.SelectedIndex)
{
case 0: //应收
modCustomerSimpleList modCust = (modCustomerSimpleList)DBGrid.CurrentRow.DataBoundItem;
dalAccReceivableList dalRec = new dalAccReceivableList();
BindingCollection <modReceivableBook> listRec = dalRec.GetReceivableBook(modCust.CustId, dtpFrom.Value, dtpTo.Value, out Util.emsg);
DBGrid2.DataSource = listRec;
break;
case 1: //应付
modVendorList modVendor = (modVendorList)DBGrid.CurrentRow.DataBoundItem;
dalAccPayableList dalPay = new dalAccPayableList();
BindingCollection <modPayableBook> listPay = dalPay.GetPayableBook(modVendor.VendorName, dtpFrom.Value, dtpTo.Value, out Util.emsg);
DBGrid2.DataSource = listPay;
break;
case 2: //其它应收
modOtherReceivableObject modObjRec = (modOtherReceivableObject)DBGrid.CurrentRow.DataBoundItem;
dalAccOtherReceivable dalORec = new dalAccOtherReceivable();
BindingCollection <modOtherReceivableBook> listORec = dalORec.GetOtherReceivableBook(modObjRec.ObjectName, dtpFrom.Value, dtpTo.Value, out Util.emsg);
DBGrid2.DataSource = listORec;
break;
case 3: //其它应付
modOtherPayableObject modObjPay = (modOtherPayableObject)DBGrid.CurrentRow.DataBoundItem;
dalAccOtherPayable dalOPay = new dalAccOtherPayable();
BindingCollection <modOtherPayableBook> listOPay = dalOPay.GetOtherPayableBook(modObjPay.ObjectName, dtpFrom.Value, dtpTo.Value, out Util.emsg);
DBGrid2.DataSource = listOPay;
break;
case 4: //现金银行
modAccBankAccount modCash = (modAccBankAccount)DBGrid.CurrentRow.DataBoundItem;
dalAccReport dalCash = new dalAccReport();
BindingCollection <modAccCredenceBook> listCash = dalCash.GetCashAndBankBook(modCash.AccountNo, dtpFrom.Value, dtpTo.Value, out Util.emsg);
DBGrid2.DataSource = listCash;
break;
}
for (int i = 0; i < DBGrid2.RowCount; i++)
{
if (DBGrid2.Rows[i].Cells["AccSeq"].Value.ToString() == "本月合计")
{
DBGrid2.Rows[i].DefaultCellStyle.ForeColor = Color.Red;
}
}
if (DBGrid2.RowCount > 0)
{
DBGrid2.Columns[0].Visible = false;
DBGrid2.Columns["StartMny"].Width = 120;
DBGrid2.Columns["AddingMny"].Width = 120;
DBGrid2.Columns["PaidMny"].Width = 120;
DBGrid2.Columns["EndMny"].Width = 120;
DBGrid2.Columns["StartMny"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
DBGrid2.Columns["AddingMny"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
DBGrid2.Columns["PaidMny"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
DBGrid2.Columns["EndMny"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
}
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 vendorlist = string.Empty;
if (lstVendor.SelectedItems.Count > 0 && lstVendor.SelectedItems.Count < lstVendor.Items.Count)
{
for (int i = 0; i < lstVendor.SelectedItems.Count; i++)
{
modVendorList mod = (modVendorList)lstVendor.SelectedItems[i];
if (i == 0)
{
vendorlist = mod.VendorName;
}
else
{
vendorlist += "," + mod.VendorName;
}
}
}
BindingCollection <modPurchaseSummary> list = _dal.GetPurchaseSummary(statuslist, cboPurchaseType.SelectedValue.ToString(), vendorlist, 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 (modPurchaseSummary mod in list)
{
sum += Convert.ToDecimal(mod.AdFlag) * (mod.DetailSum + mod.OtherMny - mod.KillMny);
}
ShowColor();
StatusLabel1.Text = "共 " + list.Count.ToString() + " 行数据， 合计金额为: " + string.Format("{0:C2}", sum);
DBGrid.Columns["DetailSum"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
DBGrid.Columns["OtherMny"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
DBGrid.Columns["KillMny"].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;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
this.Cursor = Cursors.Default;
}
}
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 vendorlist = string.Empty;
if (lstVendor.SelectedItems.Count > 0 && lstVendor.SelectedItems.Count < lstVendor.Items.Count)
{
for (int i = 0; i < lstVendor.SelectedItems.Count; i++)
{
modVendorList mod = (modVendorList)lstVendor.SelectedItems[i];
if (i == 0)
{
vendorlist = mod.VendorName;
}
else
{
vendorlist += "," + mod.VendorName;
}
}
}
BindingCollection <modVPurchaseDetail> list = new BindingCollection <modVPurchaseDetail>();
if (DBGrid.CurrentRow.Index == DBGrid.RowCount - 1)
{
list = _dal.GetVDetail(statuslist, cboPurchaseType.SelectedValue.ToString(), vendorlist, string.Empty, string.Empty, paystatuslist, invoicestatuslist, string.Empty, string.Empty, string.Empty, string.Empty, dtpFrom.Text, dtpTo.Text, out Util.emsg);
}
else
{
modPurchaseSummary moditem = (modPurchaseSummary)DBGrid.CurrentRow.DataBoundItem;
list = _dal.GetVDetail(string.Empty, moditem.PurchaseType, moditem.VendorName, string.Empty, string.Empty, paystatuslist, invoicestatuslist, moditem.Currency, string.Empty, string.Empty, string.Empty, dtpFrom.Text, dtpTo.Text, out Util.emsg);
}
if (list != null && list.Count > 0)
{
frmViewList frm = new frmViewList();
frm.InitViewList(clsTranslate.TranslateString("Purchase List"), list);
frm.ShowDialog();
}
}
private void toolImport_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
frmSingleSelect frm = new frmSingleSelect();
dalVendorList dalvendor = new dalVendorList();
BindingCollection <modVendorList> listvendor = dalvendor.GetIList("1", string.Empty, out Util.emsg);
if (listvendor != null)
{
frm.InitViewList("请选择供应商", listvendor, "VendorName", "VendorName", ComboBoxStyle.DropDown);
if (frm.ShowDialog() == DialogResult.OK)
{
modVendorList modvendor = dalvendor.GetItem(Util.retValue1, out Util.emsg);
frmSelectGrid frmsel = new frmSelectGrid();
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)
{
BindingCollection <modVendorOrderList> list = new BindingCollection <modVendorOrderList>();
dalCustomerOrderList dalco = new dalCustomerOrderList();
BindingCollection <modCustomerOrderList> listco = dalco.GetIList(frmSelectGrid.selectionlist, out Util.emsg);
foreach (modCustomerOrderList modco in listco)
{
modVendorOrderList mod = new modVendorOrderList();
mod.Id = 0;
mod.FormDate = DateTime.Today;
mod.RequireDate = DateTime.Today;
//mod.VendorOrderNo = modco.CustOrderNo;
mod.Remark = modco.CustName + ": " + modco.CustOrderNo;
mod.VendorName = Util.retValue1;
mod.PayMethod = string.Empty;
mod.PurchaseMan = Util.UserId;
mod.ProductId = modco.ProductId;
mod.ProductName = modco.ProductName;
if (clsLxms.GetProductSizeFlag(mod.ProductId) == 0)
{
mod.Size = 1;
}
else
{
mod.Size = modco.Size;
}
mod.Currency = modvendor.Currency;
mod.UnitNo = modco.UnitNo;
mod.Qty = modco.Qty;
mod.Price = 0;
mod.UpdateUser = Util.UserId;
list.Add(mod);
}
VendorOrderImport frmImport = new VendorOrderImport();
frmImport.InitViewList(list);
if (frmImport.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
protected override bool Save()
{
try
{
this.Cursor = Cursors.WaitCursor;
if (string.IsNullOrEmpty(txtVendorName.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("vendor name") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtVendorName.Focus();
return(false);
}
if (cboVendorType.SelectedIndex == -1)
{
MessageBox.Show(clsTranslate.TranslateString("vendor type") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
cboVendorType.Focus();
return(false);
}
if (Util.IsChina(txtNo.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("Purchase no") + clsTranslate.TranslateString(" can not be chinese!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtNo.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);
}
modVendorList mod = new modVendorList();
mod.VendorName = txtVendorName.Text.Trim();
mod.VendorType = cboVendorType.Text;
mod.Status = cboStatus.SelectedIndex;
mod.Currency = cboCurrency.SelectedValue.ToString();
mod.No = txtNo.Text.Trim().Replace("*", "");
mod.Linkman = txtLinkman.Text.Trim();
mod.Tel = txtTel.Text.Trim();
mod.Fax = txtFax.Text.Trim();
mod.Addr = txtAddr.Text.Trim();
mod.Remark = txtRemark.Text.Trim();
mod.NeedInvoice = cboNeedInvoice.SelectedIndex;
mod.UpdateUser = Util.UserId;
bool ret = false;
if (_status == 1)
{
ret = _dal.Insert(mod, out Util.emsg);
}
else if (_status == 2)
{
ret = _dal.Update(txtVendorName.Text, mod, out Util.emsg);
}
if (ret)
{
Util.ChangeStatus(this, true);
DBGrid.Enabled = true;
LoadData();
FindText = mod.VendorName;
Find();
}
return(ret);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
finally
{
this.Cursor = Cursors.Default;
}
}
