private void toolEdit_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (DBGrid.CurrentRow == null)
{
return;
}
modPurchaseList mod = (modPurchaseList)DBGrid.CurrentRow.DataBoundItem;
EditPurchaseList frm = new EditPurchaseList();
frm.EditItem(mod.PurchaseId);
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;
}
}
private void DBGrid_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (DBGrid.CurrentRow == null)
{
return;
}
modPurchaseList mod = (modPurchaseList)DBGrid.CurrentRow.DataBoundItem;
switch (DBGrid.Columns[e.ColumnIndex].Name)
{
case "PayStatus":
case "PayDate":
case "AccountNo":
_dal.UpdatePayStatus(mod.PurchaseId, mod.PayStatus, mod.PayDate, mod.AccountNo, Util.UserId, out Util.emsg);
if (DBGrid.Columns[e.ColumnIndex].Name == "PayStatus" && mod.PayStatus == 1)
{
DBGrid.CurrentRow.Cells["PayDate"].Value = DateTime.Today.ToString("yyyy-MM-dd");
}
break;
case "InvoiceStatus":
case "InvoiceNo":
case "InvoiceMny":
_dal.UpdateInvoiceStatus(mod.PurchaseId, mod.InvoiceStatus, mod.InvoiceMny, mod.InvoiceNo, Util.UserId, out Util.emsg);
break;
}
}
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;
}
modPurchaseList mod = _dal.GetItem(DBGrid.CurrentRow.Cells[0].Value.ToString(), out Util.emsg);
if (mod.Status == 1)
{
MessageBox.Show("该单据已审核，您不能删除！", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
bool ret = _dal.Save("DEL", mod, null, 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 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 toolReset_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (DBGrid.RowCount == 0)
{
return;
}
if (DBGrid.SelectedRows.Count == 0 && DBGrid.CurrentRow == null)
{
return;
}
if (MessageBox.Show(clsTranslate.TranslateString("Do you really want to reset it?"), clsTranslate.TranslateString("Confirm"), MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
if (DBGrid.SelectedRows.Count == 0)
{
modPurchaseList mod = _dal.GetItem(DBGrid.CurrentRow.Cells[0].Value.ToString(), out Util.emsg);
if (mod.AccSeq > 0)
{
MessageBox.Show("该单据已做凭证，不可重置！", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (_dal.Reset(mod.PurchaseId, Util.UserId, out Util.emsg))
{
MessageBox.Show(clsTranslate.TranslateString("Reset Success!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadData();
}
else
{
MessageBox.Show(clsTranslate.TranslateString(Util.emsg), mod.PurchaseId, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
else
{
for (int i = DBGrid.SelectedRows.Count - 1; i >= 0; i--)
{
modPurchaseList mod = _dal.GetItem(DBGrid.SelectedRows[i].Cells[0].Value.ToString(), out Util.emsg);
if (mod.AccSeq > 0)
{
MessageBox.Show("该单据已做凭证，不可重置！", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (_dal.Reset(mod.PurchaseId, Util.UserId, out Util.emsg))
{
DBGrid.SelectedRows[i].Cells["status"].Value = 0;
DBGrid.SelectedRows[i].DefaultCellStyle.ForeColor = Color.Black;
DBGrid.SelectedRows[i].Selected = false;
}
else
{
MessageBox.Show(clsTranslate.TranslateString(Util.emsg), mod.PurchaseId, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
LoadData();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
