private void toolEdit_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; if (DBGrid.CurrentRow == null) { return; } modAccExpenseForm mod = (modAccExpenseForm)DBGrid.CurrentRow.DataBoundItem; EditAccExpenseForm frm = new EditAccExpenseForm(); frm.EditItem(mod.Id); 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 accexpenseform</returns> public modAccExpenseForm GetItem(int id, out string emsg) { try { //Execute a query to read the categories string sql = string.Format("select a.id,a.status,a.form_date,a.no,a.expense_id,a.expense_name,a.expense_man,a.currency,a.exchange_rate,a.expense_mny,a.subject_id,b.subject_name,a.detail_id,a.detail_name,a.check_no,a.check_type,a.bank_name,a.promise_date,a.remark,a.update_user,a.update_time,a.audit_man,a.audit_time,a.acc_name,a.acc_seq " + "from acc_expense_form a inner join acc_subject_list b on a.subject_id=b.subject_id where a.id = {0} order by a.id", id); using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql)) { if (rdr.Read()) { modAccExpenseForm model = new modAccExpenseForm(); model.Id = dalUtility.ConvertToInt(rdr["id"]); model.Status = dalUtility.ConvertToInt(rdr["status"]); model.FormDate = dalUtility.ConvertToDateTime(rdr["form_date"]); model.No = dalUtility.ConvertToString(rdr["no"]); model.ExpenseType = GetExpenseType(rdr["expense_id"].ToString()); model.ExpenseId = dalUtility.ConvertToString(rdr["expense_id"]); model.ExpenseName = dalUtility.ConvertToString(rdr["expense_name"]); model.ExpenseMan = dalUtility.ConvertToString(rdr["expense_man"]); model.Currency = dalUtility.ConvertToString(rdr["currency"]); model.ExchangeRate = dalUtility.ConvertToDecimal(rdr["exchange_rate"]); model.ExpenseMny = dalUtility.ConvertToDecimal(rdr["expense_mny"]); model.SubjectId = dalUtility.ConvertToString(rdr["subject_id"]); model.SubjectName = dalUtility.ConvertToString(rdr["subject_name"]); model.DetailId = dalUtility.ConvertToString(rdr["detail_id"]); model.DetailName = dalUtility.ConvertToString(rdr["detail_name"]); model.CheckNo = dalUtility.ConvertToString(rdr["check_no"]); model.CheckType = dalUtility.ConvertToString(rdr["check_type"]); model.BankName = dalUtility.ConvertToString(rdr["bank_name"]); model.PromiseDate = dalUtility.ConvertToDateTime(rdr["promise_date"]); model.Remark = dalUtility.ConvertToString(rdr["remark"]); model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]); model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]); model.AuditMan = dalUtility.ConvertToString(rdr["audit_man"]); model.AuditTime = dalUtility.ConvertToDateTime(rdr["audit_time"]); model.AccName = dalUtility.ConvertToString(rdr["acc_name"]); model.AccSeq = dalUtility.ConvertToInt(rdr["acc_seq"]); 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 accexpenseform /// <summary> /// <param name=accname>accname</param> /// <param name=accseq>accseq</param> /// <param name=out emsg>return error message</param> ///<returns>details of all accexpenseform</returns> public BindingCollection <modAccExpenseForm> GetIList(string accname, string expenseid, out string emsg) { try { BindingCollection <modAccExpenseForm> modellist = new BindingCollection <modAccExpenseForm>(); //Execute a query to read the categories //string sql = string.Format("select id,status,form_date,no,expense_id,expense_name,currency,exchange_rate,expense_mny,subject_id,detail_id,detail_name,check_no,check_type,bank_name,promise_date,remark,update_user,update_time,audit_man,audit_time,acc_name,acc_seq from acc_expense_form where acc_name='{0}' and acc_seq={1} order by id",accname,accseq); string sql = string.Format("select a.id,a.status,a.form_date,a.no,a.expense_id,a.expense_name,a.expense_man,a.currency,a.exchange_rate,a.expense_mny,a.subject_id,b.subject_name,a.detail_id,a.detail_name,a.check_no,a.check_type,a.bank_name,a.promise_date,a.remark,a.update_user,a.update_time,a.audit_man,a.audit_time,a.acc_name,a.acc_seq " + "from acc_expense_form a inner join acc_subject_list b on a.subject_id=b.subject_id where a.acc_name='{0}' and a.acc_seq={1} order by a.id", accname, expenseid); using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql)) { while (rdr.Read()) { modAccExpenseForm model = new modAccExpenseForm(); model.Id = dalUtility.ConvertToInt(rdr["id"]); model.Status = dalUtility.ConvertToInt(rdr["status"]); model.FormDate = dalUtility.ConvertToDateTime(rdr["form_date"]); model.No = dalUtility.ConvertToString(rdr["no"]); model.ExpenseType = GetExpenseType(rdr["expense_id"].ToString()); model.ExpenseId = dalUtility.ConvertToString(rdr["expense_id"]); model.ExpenseName = dalUtility.ConvertToString(rdr["expense_name"]); model.ExpenseMan = dalUtility.ConvertToString(rdr["expense_man"]); model.Currency = dalUtility.ConvertToString(rdr["currency"]); model.ExchangeRate = dalUtility.ConvertToDecimal(rdr["exchange_rate"]); model.ExpenseMny = dalUtility.ConvertToDecimal(rdr["expense_mny"]); model.SubjectId = dalUtility.ConvertToString(rdr["subject_id"]); model.SubjectName = dalUtility.ConvertToString(rdr["subject_name"]); model.DetailId = dalUtility.ConvertToString(rdr["detail_id"]); model.DetailName = dalUtility.ConvertToString(rdr["detail_name"]); model.CheckNo = dalUtility.ConvertToString(rdr["check_no"]); model.CheckType = dalUtility.ConvertToString(rdr["check_type"]); model.BankName = dalUtility.ConvertToString(rdr["bank_name"]); model.PromiseDate = dalUtility.ConvertToDateTime(rdr["promise_date"]); model.Remark = dalUtility.ConvertToString(rdr["remark"]); model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]); model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]); model.AuditMan = dalUtility.ConvertToString(rdr["audit_man"]); model.AuditTime = dalUtility.ConvertToDateTime(rdr["audit_time"]); model.AccName = dalUtility.ConvertToString(rdr["acc_name"]); model.AccSeq = dalUtility.ConvertToInt(rdr["acc_seq"]); modellist.Add(model); } } emsg = null; return(modellist); } catch (Exception ex) { emsg = dalUtility.ErrorMessage(ex.Message); return(null); } }
private void DBGrid_SelectionChanged(object sender, EventArgs e) { if (DBGrid.CurrentRow == null) { return; } modAccExpenseForm mod = (modAccExpenseForm)DBGrid.CurrentRow.DataBoundItem; if (mod.Status == 0) { toolDel.Enabled = true; toolAudit.Enabled = true; toolReset.Enabled = false; } else { toolDel.Enabled = false; toolAudit.Enabled = false; toolReset.Enabled = true; } }
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; } modAccExpenseForm mod = _dal.GetItem(Convert.ToInt32(DBGrid.CurrentRow.Cells[0].Value), out Util.emsg); if (mod.Status == 1) { MessageBox.Show("该单据已审核,您不能删除!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } 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; } }
/// <summary> /// update a accexpenseform /// <summary> /// <param name=id>id</param> /// <param name=mod>model object of accexpenseform</param> /// <param name=out emsg>return error message</param> /// <returns>true/false</returns> public bool Update(int?id, modAccExpenseForm mod, out string emsg) { try { string sql = string.Format("update acc_expense_form set status={0},form_date='{1}',no='{2}',expense_id='{3}',expense_name='{4}',currency='{5}',exchange_rate={6},expense_mny={7},subject_id='{8}',detail_id='{9}',detail_name='{10}',check_no='{11}',check_type='{12}',bank_name='{13}',promise_date='{14}',remark='{15}',expense_man='{16}' where id={17}", mod.Status, mod.FormDate, mod.No, mod.ExpenseId, mod.ExpenseName, mod.Currency, mod.ExchangeRate, mod.ExpenseMny, mod.SubjectId, mod.DetailId, mod.DetailName, mod.CheckNo, mod.CheckType, mod.BankName, mod.PromiseDate, mod.Remark, mod.ExpenseMan, 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 accexpenseform /// <summary> /// <param name=mod>model object of accexpenseform</param> /// <param name=out emsg>return error message</param> /// <returns>true/false</returns> public bool Insert(modAccExpenseForm mod, out string emsg) { try { string sql = string.Format("insert into acc_expense_form(status,form_date,no,expense_id,expense_name,currency,exchange_rate,expense_mny,subject_id,detail_id,detail_name,check_no,check_type,bank_name,promise_date,remark,expense_man,update_user,update_time)values({0},'{1}','{2}','{3}','{4}','{5}',{6},{7},'{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}',getdate())", mod.Status, mod.FormDate, mod.No, mod.ExpenseId, mod.ExpenseName, mod.Currency, mod.ExchangeRate, mod.ExpenseMny, mod.SubjectId, mod.DetailId, mod.DetailName, mod.CheckNo, mod.CheckType, mod.BankName, mod.PromiseDate, mod.Remark, mod.ExpenseMan, 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); } }
/// <summary> /// get all accexpenseform /// <summary> /// <param name=validonly>status is valid</param> /// <param name=out emsg>return error message</param> ///<returns>details of all accexpenseform</returns> public BindingCollection <modAccExpenseForm> GetIList(string statuslist, string idlist, string expenseidlist, string expensemanlist, string fromdate, string todate, out string emsg) { try { BindingCollection <modAccExpenseForm> modellist = new BindingCollection <modAccExpenseForm>(); //Execute a query to read the categories string statuswhere = string.Empty; if (!string.IsNullOrEmpty(statuslist) && statuslist.CompareTo("ALL") != 0) { statuswhere = "and a.status in ('" + statuslist.Replace(",", "','") + "') "; } string idwhere = string.Empty; if (!string.IsNullOrEmpty(idlist) && idlist.CompareTo("ALL") != 0) { idwhere = "and a.id in ('" + idlist.Replace(",", "','") + "') "; } string expenseidwhere = string.Empty; if (!string.IsNullOrEmpty(expenseidlist) && expenseidlist.CompareTo("ALL") != 0) { expenseidwhere = "and a.expense_id in ('" + expenseidlist.Replace(",", "','") + "') "; } string expensemanwhere = string.Empty; if (!string.IsNullOrEmpty(expensemanlist) && expensemanlist.CompareTo("ALL") != 0) { expensemanwhere = "and a.expense_man in ('" + expensemanlist.Replace(",", "','") + "') "; } string formdatewhere = string.Empty; if (!string.IsNullOrEmpty(fromdate)) { formdatewhere = "and a.form_date >= '" + Convert.ToDateTime(fromdate) + "' "; } if (!string.IsNullOrEmpty(todate)) { formdatewhere += "and a.form_date <= '" + Convert.ToDateTime(todate) + "' "; } string sql = "select a.id,a.status,a.form_date,a.no,a.expense_id,a.expense_name,a.expense_man,a.currency,a.exchange_rate,a.expense_mny,a.subject_id,b.subject_name,a.detail_id,a.detail_name,a.check_no,a.check_type,a.bank_name,a.promise_date,a.remark,a.update_user,a.update_time,a.audit_man,a.audit_time,a.acc_name,a.acc_seq " + "from acc_expense_form a inner join acc_subject_list b on a.subject_id=b.subject_id where 1=1 " + statuswhere + idwhere + expenseidwhere + expensemanwhere + formdatewhere + " order by id"; using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql)) { while (rdr.Read()) { modAccExpenseForm model = new modAccExpenseForm(); model.Id = dalUtility.ConvertToInt(rdr["id"]); model.Status = dalUtility.ConvertToInt(rdr["status"]); model.FormDate = dalUtility.ConvertToDateTime(rdr["form_date"]); model.No = dalUtility.ConvertToString(rdr["no"]); model.ExpenseType = GetExpenseType(rdr["expense_id"].ToString()); model.ExpenseId = dalUtility.ConvertToString(rdr["expense_id"]); model.ExpenseName = dalUtility.ConvertToString(rdr["expense_name"]); model.ExpenseMan = dalUtility.ConvertToString(rdr["expense_man"]); model.Currency = dalUtility.ConvertToString(rdr["currency"]); model.ExchangeRate = dalUtility.ConvertToDecimal(rdr["exchange_rate"]); model.ExpenseMny = dalUtility.ConvertToDecimal(rdr["expense_mny"]); model.SubjectId = dalUtility.ConvertToString(rdr["subject_id"]); model.SubjectName = dalUtility.ConvertToString(rdr["subject_name"]); model.DetailId = dalUtility.ConvertToString(rdr["detail_id"]); model.DetailName = dalUtility.ConvertToString(rdr["detail_name"]); model.CheckNo = dalUtility.ConvertToString(rdr["check_no"]); model.CheckType = dalUtility.ConvertToString(rdr["check_type"]); model.BankName = dalUtility.ConvertToString(rdr["bank_name"]); model.PromiseDate = dalUtility.ConvertToDateTime(rdr["promise_date"]); model.Remark = dalUtility.ConvertToString(rdr["remark"]); model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]); model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]); model.AuditMan = dalUtility.ConvertToString(rdr["audit_man"]); model.AuditTime = dalUtility.ConvertToDateTime(rdr["audit_time"]); model.AccName = dalUtility.ConvertToString(rdr["acc_name"]); model.AccSeq = dalUtility.ConvertToInt(rdr["acc_seq"]); modellist.Add(model); } } emsg = null; return(modellist); } catch (Exception ex) { emsg = dalUtility.ErrorMessage(ex.Message); return(null); } }
public void EditItem(int id) { try { this.Cursor = Cursors.WaitCursor; _action = "EDIT"; modAccExpenseForm mod = _dal.GetItem(id, out Util.emsg); if (mod != null) { txtId.Text = id.ToString(); dtpFormDate.Value = mod.FormDate; txtNo.Text = mod.No; txtExpenseId.Text = mod.ExpenseId; txtExpenseName.Text = mod.ExpenseName; txtExpenseMny.Text = mod.ExpenseMny.ToString(); txtExpenseMan.Text = mod.ExpenseMan; txtSubjectId.Text = mod.SubjectId; txtSubjectName.Text = mod.SubjectName; txtDetailId.Text = mod.DetailId; txtDetailName.Text = mod.DetailName; txtCurrency.Text = mod.Currency; txtExchangeRate.Text = mod.ExchangeRate.ToString(); txtCheckNo.Text = mod.CheckNo; cboCheckType.Text = mod.CheckType; cboBankName.Text = mod.BankName; dtpPromiseDate.Value = mod.PromiseDate; txtRemark.Text = mod.Remark; if (mod.Status == 1) { status4.Image = Properties.Resources.audited; Util.ChangeStatus(this, true); toolSave.Enabled = false; } else { status4.Image = null; toolSave.Visible = true; Util.ChangeStatus(this, false); txtId.ReadOnly = true; toolSave.Enabled = true; if (mod.SubjectId == "1075" || mod.SubjectId == "5125") //应收票据 应付票据 { txtCheckNo.ReadOnly = false; cboCheckType.Enabled = true; cboBankName.Enabled = true; dtpPromiseDate.Enabled = true; } else { txtCheckNo.ReadOnly = true; cboCheckType.Enabled = false; cboBankName.Enabled = false; dtpPromiseDate.Enabled = false; } } txtExpenseId.ReadOnly = true; txtExpenseName.ReadOnly = true; txtSubjectId.ReadOnly = true; txtSubjectName.ReadOnly = true; txtCurrency.ReadOnly = true; txtExpenseMan.ReadOnly = true; } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } finally { this.Cursor = Cursors.Default; } }
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(txtExpenseMny.Text.Trim())) { MessageBox.Show(clsTranslate.TranslateString("Expense mny") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtExpenseMny.Focus(); return; } else if (!Util.IsNumeric(txtExpenseMny.Text)) { MessageBox.Show(clsTranslate.TranslateString("Expense mny") + clsTranslate.TranslateString(" must be a numeric!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtExpenseMny.Focus(); return; } if (string.IsNullOrEmpty(txtExpenseId.Text)) { MessageBox.Show(clsTranslate.TranslateString("Expense Id") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtExpenseId.Focus(); return; } if (string.IsNullOrEmpty(txtExpenseMan.Text)) { MessageBox.Show(clsTranslate.TranslateString("Expense Man") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtExpenseMan.Focus(); return; } if (string.IsNullOrEmpty(txtSubjectId.Text)) { MessageBox.Show(clsTranslate.TranslateString("Subject Id") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtSubjectId.Focus(); return; } if (string.IsNullOrEmpty(txtCurrency.Text)) { MessageBox.Show(clsTranslate.TranslateString("Currency") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtCurrency.Focus(); return; } if (string.IsNullOrEmpty(txtExchangeRate.Text)) { MessageBox.Show(clsTranslate.TranslateString("Exchange rate") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtExchangeRate.Focus(); return; } else if (!Util.IsNumeric(txtExchangeRate.Text)) { MessageBox.Show(clsTranslate.TranslateString("Exchange rate") + clsTranslate.TranslateString(" must be a numeric!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtExchangeRate.Focus(); return; } if (txtSubjectId.Text.Trim() == "1030" || txtSubjectId.Text.Trim() == "1055" || txtSubjectId.Text.Trim() == "1060" || txtSubjectId.Text.Trim() == "5145" || txtSubjectId.Text.Trim() == "5155") //现金银行 应收 其它应收 应付 其它应付 { if (string.IsNullOrEmpty(txtDetailId.Text)) { MessageBox.Show(clsTranslate.TranslateString("Detail id") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtDetailId.Focus(); return; } } if (txtSubjectId.Text.Trim() == "1075" || txtSubjectId.Text.Trim() == "5125") //应收票据 应付票据 { if (string.IsNullOrEmpty(txtCheckNo.Text)) { MessageBox.Show(clsTranslate.TranslateString("Check no") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtCheckNo.Focus(); return; } if (string.IsNullOrEmpty(cboCheckType.Text)) { MessageBox.Show(clsTranslate.TranslateString("Check type") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboCheckType.Focus(); return; } if (string.IsNullOrEmpty(cboBankName.Text)) { MessageBox.Show(clsTranslate.TranslateString("Bank name") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboBankName.Focus(); return; } } if (clsLxms.GetParameterValue("NEED_RECEIVABLE_NO").CompareTo("T") == 0 && string.IsNullOrEmpty(txtNo.Text)) { MessageBox.Show(clsTranslate.TranslateString("No") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtNo.Focus(); return; } modAccExpenseForm mod = new modAccExpenseForm(); mod.Id = Convert.ToInt32(txtId.Text); mod.FormDate = dtpFormDate.Value; mod.No = txtNo.Text.Trim(); mod.ExpenseId = txtExpenseId.Text.Trim(); mod.ExpenseName = txtExpenseName.Text.Trim(); mod.ExpenseMny = Convert.ToDecimal(txtExpenseMny.Text); mod.ExpenseMan = txtExpenseMan.Text.Trim(); mod.SubjectId = txtSubjectId.Text.Trim(); mod.SubjectName = txtSubjectName.Text.Trim(); mod.DetailId = txtDetailId.Text.Trim(); mod.DetailName = txtDetailName.Text.Trim(); mod.Currency = txtCurrency.Text.Trim(); mod.ExchangeRate = Convert.ToDecimal(txtExchangeRate.Text); if (mod.SubjectId == "1075" || mod.SubjectId == "5125") { mod.CheckNo = txtCheckNo.Text.Trim(); mod.CheckType = cboCheckType.Text.Trim(); mod.BankName = cboBankName.Text.Trim(); ShowHideCheckControl(true); } else { ShowHideCheckControl(false); } mod.PromiseDate = dtpPromiseDate.Value; mod.Remark = txtRemark.Text.Trim(); mod.UpdateUser = Util.UserId; mod.Status = 0; bool ret; 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) { txtExpenseId.Text = string.Empty; txtExpenseName.Text = string.Empty; txtExpenseMny.Text = string.Empty; txtExpenseMan.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 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) { modAccExpenseForm mod = _dal.GetItem(Convert.ToInt32(DBGrid.CurrentRow.Cells[0].Value), out Util.emsg); if (mod.AccSeq > 0) { MessageBox.Show("该单据已做凭证,不可重置!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (_dal.Reset(mod.Id, 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.Id.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } } else { for (int i = DBGrid.SelectedRows.Count - 1; i >= 0; i--) { modAccExpenseForm mod = _dal.GetItem(Convert.ToInt32(DBGrid.SelectedRows[i].Cells[0].Value), out Util.emsg); if (mod.AccSeq > 0) { MessageBox.Show("该单据已做凭证,不可重置!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (_dal.Reset(mod.Id, Util.UserId, out Util.emsg)) { // } else { MessageBox.Show(clsTranslate.TranslateString(Util.emsg), mod.Id.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } } LoadData(); } toolDel.Enabled = true; toolAudit.Enabled = true; toolReset.Enabled = false; } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } finally { this.Cursor = Cursors.Default; } }