private void mnuPurchaseList_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (DBGrid.CurrentRow == null)
{
return;
}
modVendorOrderList mod = (modVendorOrderList)DBGrid.CurrentRow.DataBoundItem;
dalPurchaseList dal = new dalPurchaseList();
BindingCollection <modVPurchaseDetail> list = dal.GetVDetail(string.Empty, string.Empty, string.Empty, mod.VendorName, mod.VendorOrderNo, string.Empty, string.Empty, string.Empty, string.Empty, mod.ProductId, string.Empty, string.Empty, string.Empty, out Util.emsg);
if (list != null && list.Count > 0)
{
frmViewList frm = new frmViewList();
frm.InitViewList(clsTranslate.TranslateString("Purchase List"), list);
frm.ShowDialog();
}
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;
}
}
public void CopyItem(modVendorOrderList mod)
{
try
{
this.Cursor = Cursors.WaitCursor;
_action = "NEW";
txtId.Text = "0";
dtpFormDate.Value = mod.FormDate;
dtpRequireDate.Value = mod.RequireDate;
txtVendorOrderNo.Text = mod.VendorOrderNo;
txtCurrency.Text = mod.Currency;
txtVendorName.Text = mod.VendorName;
txtPayMethod.Text = mod.PayMethod;
txtPurchaseMan.Text = mod.PurchaseMan;
txtUnitNo.Text = mod.UnitNo;
//txtQty.Text = mod.Qty.ToString();
//txtPrice.Text = mod.Price.ToString();
//txtProductName.Tag = mod.ProductId;
//txtProductName.Text = mod.ProductName;
//txtSize.Text = mod.Size.ToString();
txtRemark.Text = mod.Remark;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void toolDel_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (DBGrid.CurrentRow == null)
{
return;
}
if (MessageBox.Show(clsTranslate.TranslateString("Do you really want to delete it?"), clsTranslate.TranslateString("Confirm"), MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
modVendorOrderList mod = _dal.GetItem(Convert.ToInt32(DBGrid.CurrentRow.Cells[0].Value), out Util.emsg);
bool ret = _dal.Delete(mod.Id, out Util.emsg);
if (ret)
{
LoadData();
}
else
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void mnuCopyItem_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (DBGrid.CurrentRow == null)
{
return;
}
modVendorOrderList mod = (modVendorOrderList)DBGrid.CurrentRow.DataBoundItem;
EditVendorOrderList frm = new EditVendorOrderList();
frm.CopyItem(mod);
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
/// <summary>
/// get table record
/// <summary>
/// <param name=id>id</param>
/// <param name=out emsg>return error message</param>
///<returns>get a record detail of vendororderlist</returns>
public modVendorOrderList GetItem(int id, out string emsg)
{
try
{
//Execute a query to read the categories
string sql = string.Format("select id,vendor_name,vendor_order_no,form_date,require_date,pay_method,purchase_man,product_id,product_name,specify,size,unit_no,qty,price,remark,currency,update_user,update_time from vendor_order_list where id={0} order by id", id);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
if (rdr.Read())
{
modVendorOrderList model = new modVendorOrderList();
model.Id = dalUtility.ConvertToInt(rdr["id"]);
model.VendorName = dalUtility.ConvertToString(rdr["vendor_name"]);
model.VendorOrderNo = dalUtility.ConvertToString(rdr["vendor_order_no"]);
model.FormDate = dalUtility.ConvertToDateTime(rdr["form_date"]);
model.RequireDate = dalUtility.ConvertToDateTime(rdr["require_date"]);
model.PayMethod = dalUtility.ConvertToString(rdr["pay_method"]);
model.PurchaseMan = dalUtility.ConvertToString(rdr["purchase_man"]);
model.ProductId = dalUtility.ConvertToString(rdr["product_id"]);
model.ProductName = dalUtility.ConvertToString(rdr["product_name"]);
model.Specify = dalUtility.ConvertToString(rdr["specify"]);
model.Size = dalUtility.ConvertToDecimal(rdr["size"]);
model.UnitNo = dalUtility.ConvertToString(rdr["unit_no"]);
model.Qty = dalUtility.ConvertToDecimal(rdr["qty"]);
model.SumMny = model.Qty * model.Price;
model.ReceivedQty = GetReceivedQty(model.VendorName, model.VendorOrderNo, model.ProductId);
model.Differ = model.Qty - model.ReceivedQty;
model.Price = dalUtility.ConvertToDecimal(rdr["price"]);
model.Remark = dalUtility.ConvertToString(rdr["remark"]);
model.Currency = dalUtility.ConvertToString(rdr["currency"]);
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>
/// get all vendororderlist
/// <summary>
/// <param name=incfinished>incfinished</param>
/// <param name=custid>custid</param>
/// <param name=vendorname>vendorname</param>
/// <param name=vendororderno>vendororderno</param>
/// <param name=formdate>formdate</param>
/// <param name=out emsg>return error message</param>
///<returns>details of all vendororderlist</returns>
public BindingCollection <modVendorOrderList> GetIList(string idlist, out string emsg)
{
try
{
BindingCollection <modVendorOrderList> modellist = new BindingCollection <modVendorOrderList>();
//Execute a query to read the categories
string sql = "select id,vendor_name,vendor_order_no,form_date,require_date,pay_method,purchase_man,product_id,product_name,specify,size,unit_no,qty,price,remark,currency,update_user,update_time "
+ "from vendor_order_list where id in ('" + idlist.Replace(",", "','") + "')order by id desc";
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
modVendorOrderList model = new modVendorOrderList();
model.Id = dalUtility.ConvertToInt(rdr["id"]);
model.VendorName = dalUtility.ConvertToString(rdr["vendor_name"]);
model.VendorOrderNo = dalUtility.ConvertToString(rdr["vendor_order_no"]);
model.FormDate = dalUtility.ConvertToDateTime(rdr["form_date"]);
model.RequireDate = dalUtility.ConvertToDateTime(rdr["require_date"]);
model.PayMethod = dalUtility.ConvertToString(rdr["pay_method"]);
model.PurchaseMan = dalUtility.ConvertToString(rdr["purchase_man"]);
model.ProductId = dalUtility.ConvertToString(rdr["product_id"]);
model.ProductName = dalUtility.ConvertToString(rdr["product_name"]);
model.Specify = dalUtility.ConvertToString(rdr["specify"]);
model.Size = dalUtility.ConvertToDecimal(rdr["size"]);
model.UnitNo = dalUtility.ConvertToString(rdr["unit_no"]);
model.Qty = dalUtility.ConvertToDecimal(rdr["qty"]);
model.Price = dalUtility.ConvertToDecimal(rdr["price"]);
model.SumMny = model.Qty * model.Price;
model.ReceivedQty = GetReceivedQty(model.VendorName, model.VendorOrderNo, model.ProductId);
model.Differ = model.Qty - model.ReceivedQty;
model.Remark = dalUtility.ConvertToString(rdr["remark"]);
model.Currency = dalUtility.ConvertToString(rdr["currency"]);
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>
/// update a vendororderlist
/// <summary>
/// <param name=id>id</param>
/// <param name=mod>model object of vendororderlist</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Update(int id, modVendorOrderList mod, out string emsg)
{
try
{
string sql = string.Format("update vendor_order_list set vendor_name='{0}',vendor_order_no='{1}',form_date='{2}',require_date='{3}',pay_method='{4}',purchase_man='{5}',product_id='{6}',product_name='{7}',specify='{8}',size={9},unit_no='{10}',qty={11},price={12},currency='{13}',remark='{14}',update_user='******',update_time=getdate() where id={16}", mod.VendorName, mod.VendorOrderNo, mod.FormDate, mod.RequireDate, mod.PayMethod, mod.PurchaseMan, mod.ProductId, mod.ProductName, mod.Specify, mod.Size, mod.UnitNo, mod.Qty, mod.Price, mod.Currency, mod.Remark, mod.UpdateUser, id);
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 vendororderlist
/// <summary>
/// <param name=mod>model object of vendororderlist</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Insert(modVendorOrderList mod, out string emsg)
{
try
{
string sql = string.Format("insert into vendor_order_list(vendor_name,vendor_order_no,form_date,require_date,pay_method,purchase_man,product_id,product_name,specify,size,unit_no,qty,price,currency,remark,update_user,update_time)values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}',{9},'{10}',{11},{12},'{13}','{14}','{15}',getdate())", mod.VendorName, mod.VendorOrderNo, mod.FormDate, mod.RequireDate, mod.PayMethod, mod.PurchaseMan, mod.ProductId, mod.ProductName, mod.Specify, mod.Size, mod.UnitNo, mod.Qty, mod.Price, mod.Currency, mod.Remark, mod.UpdateUser);
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);
}
}
public void EditItem(int id)
{
try
{
this.Cursor = Cursors.WaitCursor;
_action = "EDIT";
modVendorOrderList mod = _dal.GetItem(id, out Util.emsg);
if (mod != null)
{
txtId.Text = id.ToString();
dtpFormDate.Value = mod.FormDate;
dtpRequireDate.Value = mod.RequireDate;
txtVendorOrderNo.Text = mod.VendorOrderNo;
txtCurrency.Text = mod.Currency;
txtVendorName.Text = mod.VendorName;
txtPayMethod.Text = mod.PayMethod;
txtPurchaseMan.Text = mod.PurchaseMan;
txtUnitNo.Text = mod.UnitNo;
txtQty.Text = mod.Qty.ToString();
txtPrice.Text = mod.Price.ToString();
txtProductName.Tag = mod.ProductId;
txtProductName.Text = mod.ProductName;
txtSize.Text = mod.Size.ToString();
txtRemark.Text = mod.Remark;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void ShowColor()
{
if (DBGrid.RowCount == 0)
{
return;
}
for (int i = 0; i < DBGrid.RowCount; i++)
{
modVendorOrderList mod = (modVendorOrderList)DBGrid.Rows[i].DataBoundItem;
if (mod.Qty > 0)
{
decimal ratio = mod.ReceivedQty / mod.Qty;
decimal ratio_f = Convert.ToDecimal(clsLxms.GetParameterValue("ORDER_FINISHED_RATIO"));
decimal ratio_o = Convert.ToDecimal(clsLxms.GetParameterValue("ORDER_OVERFLOW_RATIO"));
if (ratio < ratio_f)
{
if (mod.RequireDate > DateTime.Today)
{
DBGrid.Rows[i].DefaultCellStyle.ForeColor = Color.Black;
}
else
{
DBGrid.Rows[i].DefaultCellStyle.ForeColor = Color.Blue;
}
}
else if (ratio <= ratio_o)
{
DBGrid.Rows[i].DefaultCellStyle.ForeColor = Color.DarkGray;
}
else
{
DBGrid.Rows[i].DefaultCellStyle.ForeColor = Color.Red;
}
}
}
}
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;
}
}
/// <summary>
/// get all vendororderlist
/// <summary>
/// <param name=incfinished>incfinished</param>
/// <param name=custid>custid</param>
/// <param name=vendorname>vendorname</param>
/// <param name=vendororderno>vendororderno</param>
/// <param name=formdate>formdate</param>
/// <param name=out emsg>return error message</param>
///<returns>details of all vendororderlist</returns>
public BindingCollection <modVendorOrderList> GetIList(bool incfinished, string vendorname, string vendororderno, string salesmanlist, string fromdate, string todate, out string emsg)
{
try
{
BindingCollection <modVendorOrderList> modellist = new BindingCollection <modVendorOrderList>();
//Execute a query to read the categories
string vendornamewhere = string.Empty;
if (vendorname != "ALL" && !string.IsNullOrEmpty(vendorname))
{
vendornamewhere = "and vendor_name like '%" + vendorname + "%' ";
}
string salesmanwhere = string.Empty;
if (!string.IsNullOrEmpty(salesmanlist) && salesmanlist.CompareTo("ALL") != 0)
{
salesmanwhere = "and purchase_man in ('" + salesmanlist.Replace(",", "','") + "') ";
}
string formdatewhere = string.Empty;
if (!string.IsNullOrEmpty(fromdate))
{
formdatewhere = "and form_date >= '" + Convert.ToDateTime(fromdate) + "' ";
}
if (!string.IsNullOrEmpty(todate))
{
formdatewhere += "and form_date <= '" + Convert.ToDateTime(todate) + "' ";
}
dalSysParameters dalpara = new dalSysParameters();
modSysParameters modpara = dalpara.GetItem("ORDER_FINISHED_RATIO", out emsg);
decimal ratio_f = Convert.ToDecimal(modpara.ParaValue);
string sql = "select id,vendor_name,vendor_order_no,form_date,require_date,pay_method,purchase_man,product_id,product_name,specify,size,unit_no,qty,price,remark,currency,update_user,update_time "
+ "from vendor_order_list where 1=1 " + vendornamewhere + salesmanwhere + formdatewhere + "order by id desc";
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
modVendorOrderList model = new modVendorOrderList();
model.Id = dalUtility.ConvertToInt(rdr["id"]);
model.VendorName = dalUtility.ConvertToString(rdr["vendor_name"]);
model.VendorOrderNo = dalUtility.ConvertToString(rdr["vendor_order_no"]);
model.FormDate = dalUtility.ConvertToDateTime(rdr["form_date"]);
model.RequireDate = dalUtility.ConvertToDateTime(rdr["require_date"]);
model.PayMethod = dalUtility.ConvertToString(rdr["pay_method"]);
model.PurchaseMan = dalUtility.ConvertToString(rdr["purchase_man"]);
model.ProductId = dalUtility.ConvertToString(rdr["product_id"]);
model.ProductName = dalUtility.ConvertToString(rdr["product_name"]);
model.Specify = dalUtility.ConvertToString(rdr["specify"]);
model.Size = dalUtility.ConvertToDecimal(rdr["size"]);
model.UnitNo = dalUtility.ConvertToString(rdr["unit_no"]);
model.Qty = dalUtility.ConvertToDecimal(rdr["qty"]);
model.Price = dalUtility.ConvertToDecimal(rdr["price"]);
model.SumMny = model.Qty * model.Price;
model.ReceivedQty = GetReceivedQty(model.VendorName, model.VendorOrderNo, model.ProductId);
model.Differ = model.Qty - model.ReceivedQty;
model.Remark = dalUtility.ConvertToString(rdr["remark"]);
model.Currency = dalUtility.ConvertToString(rdr["currency"]);
model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
if (incfinished || model.ReceivedQty < model.Qty * ratio_f)
{
modellist.Add(model);
}
}
}
emsg = null;
return(modellist);
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
private void toolSave_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (dtpFormDate.Value < Util.modperiod.StartDate)
{
MessageBox.Show("该日期的数据已锁定,不能更新数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
dtpFormDate.Focus();
return;
}
if (string.IsNullOrEmpty(txtSize.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("Size") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtSize.Focus();
return;
}
else if (!Util.IsNumeric(txtSize.Text))
{
MessageBox.Show(clsTranslate.TranslateString("Size") + clsTranslate.TranslateString(" must be a numeric!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtSize.Focus();
return;
}
else if (Convert.ToDecimal(txtSize.Text.Trim()) <= 0)
{
MessageBox.Show(clsTranslate.TranslateString("Size") + clsTranslate.TranslateString(" must > 0!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtSize.Focus();
return;
}
if (string.IsNullOrEmpty(txtQty.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("Qty") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtQty.Focus();
return;
}
else if (!Util.IsNumeric(txtQty.Text))
{
MessageBox.Show(clsTranslate.TranslateString("Qty") + clsTranslate.TranslateString(" must be a numeric!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtQty.Focus();
return;
}
if (string.IsNullOrEmpty(txtPrice.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("Price") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtPrice.Focus();
return;
}
else if (!Util.IsNumeric(txtPrice.Text))
{
MessageBox.Show(clsTranslate.TranslateString("Price") + clsTranslate.TranslateString(" must be a numeric!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtPrice.Focus();
return;
}
//if (string.IsNullOrEmpty(txtVendorOrderNo.Text))
//{
// MessageBox.Show(clsTranslate.TranslateString("Vendor Order No") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
// txtVendorOrderNo.Focus();
// return;
//}
if (string.IsNullOrEmpty(txtVendorName.Text))
{
MessageBox.Show(clsTranslate.TranslateString("Vendor Name") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtVendorName.Focus();
return;
}
if (string.IsNullOrEmpty(txtPurchaseMan.Text))
{
MessageBox.Show(clsTranslate.TranslateString("Purchase Man") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtPurchaseMan.Focus();
return;
}
if (string.IsNullOrEmpty(txtUnitNo.Text))
{
MessageBox.Show(clsTranslate.TranslateString("Unit No") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtUnitNo.Focus();
return;
}
if (txtProductName.Tag == null)
{
MessageBox.Show(clsTranslate.TranslateString("Product Name") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtProductName.Focus();
return;
}
modVendorOrderList mod = new modVendorOrderList();
mod.Id = Convert.ToInt32(txtId.Text);
mod.FormDate = dtpFormDate.Value;
mod.RequireDate = dtpRequireDate.Value;
mod.VendorOrderNo = txtVendorOrderNo.Text.Trim();
mod.VendorName = txtVendorName.Text.Trim();
mod.PayMethod = txtPayMethod.Text.Trim();
mod.PurchaseMan = txtPurchaseMan.Text.Trim();
mod.ProductId = txtProductName.Tag.ToString();
mod.ProductName = txtProductName.Text.Trim();
if (clsLxms.GetProductSizeFlag(mod.ProductId) == 0)
{
mod.Size = 1;
}
else
{
mod.Size = Convert.ToDecimal(txtSize.Text);
}
mod.Remark = txtRemark.Text.Trim();
mod.Currency = txtCurrency.Text.Trim();
mod.UnitNo = txtUnitNo.Text.Trim();
mod.Qty = Convert.ToDecimal(txtQty.Text);
mod.Price = Convert.ToDecimal(txtPrice.Text);
mod.UpdateUser = Util.UserId;
string detaillist = string.Empty;
bool ret = false;
if (_action == "ADD" || _action == "NEW")
{
ret = _dal.Insert(mod, out Util.emsg);
if (ret)
{
if (MessageBox.Show("保存成功，是否继续添加？", clsTranslate.TranslateString("Confirm"), MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
txtProductName.Tag = null;
txtProductName.Text = string.Empty;
txtSize.Text = string.Empty;
txtUnitNo.Text = string.Empty;
txtQty.Text = string.Empty;
txtPrice.Text = string.Empty;
txtRemark.Text = string.Empty;
}
else
{
this.DialogResult = DialogResult.OK;
this.Dispose();
}
}
else
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
ret = _dal.Update(mod.Id, mod, out Util.emsg);
if (ret)
{
this.DialogResult = DialogResult.OK;
this.Dispose();
}
else
{
MessageBox.Show(Util.emsg, 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 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;
}
}
private void toolExport_Click(object sender, EventArgs e)
{
if (DBGrid.CurrentRow == null)
{
return;
}
IList <modExcelRangeData> list = new List <modExcelRangeData>();
decimal summny = 0;
string vendorname = string.Empty;
string vendororderno = string.Empty;
dalProductList dalpdt = new dalProductList();
if (DBGrid.SelectedRows.Count == 0)
{
for (int i = 0; i < DBGrid.RowCount; i++)
{
if (DBGrid.Rows[i].Visible)
{
modVendorOrderList modd = (modVendorOrderList)DBGrid.Rows[i].DataBoundItem;
if (string.IsNullOrEmpty(vendorname))
{
dalVendorList dalvendor = new dalVendorList();
vendorname = modd.VendorName;
vendororderno = modd.VendorOrderNo;
list.Add(new modExcelRangeData(modd.VendorName, "B6", "E6"));
list.Add(new modExcelRangeData(modd.VendorOrderNo, "I6", "I6"));
list.Add(new modExcelRangeData(modd.FormDate.ToString("yyyy年MM月dd日"), "I7", "I7"));
}
else
{
if (vendorname != modd.VendorName)
{
MessageBox.Show("您所选的订单必须属于同一个供应商！", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (vendororderno != modd.VendorOrderNo)
{
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)
{
modVendorOrderList modd = (modVendorOrderList)DBGrid.SelectedRows[i].DataBoundItem;
if (string.IsNullOrEmpty(vendorname))
{
dalVendorList dalcust = new dalVendorList();
vendorname = modd.VendorName;
vendororderno = modd.VendorOrderNo;
list.Add(new modExcelRangeData(modd.VendorName, "B6", "E6"));
list.Add(new modExcelRangeData(modd.VendorOrderNo, "I6", "I6"));
list.Add(new modExcelRangeData(modd.FormDate.ToString("yyyy年MM月dd日"), "I7", "I7"));
}
else
{
if (vendorname != modd.VendorName)
{
MessageBox.Show("您所选的订单必须属于同一个供应商！", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (vendororderno != modd.VendorOrderNo)
{
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);
}
