private void DBGrid_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (DBGrid.CurrentRow == null)
{
return;
}
modSalesDesignForm mod = (modSalesDesignForm)DBGrid.CurrentRow.DataBoundItem;
switch (DBGrid.Columns[e.ColumnIndex].Name)
{
case "ReceiveStatus":
case "ReceiveDate":
case "AccountNo":
_dal.UpdateReceiveStatus(mod.Id, mod.ReceiveStatus, mod.ReceiveDate, mod.AccountNo, Util.UserId, out Util.emsg);
if (DBGrid.Columns[e.ColumnIndex].Name == "ReceiveStatus" && mod.ReceiveStatus == 1)
{
DBGrid.CurrentRow.Cells["ReceiveDate"].Value = DateTime.Today.ToString("yyyy-MM-dd");
}
break;
case "InvoiceStatus":
case "InvoiceNo":
case "InvoiceMny":
_dal.UpdateInvoiceStatus(mod.Id, 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 btnUpdate_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (cboAccountNo.SelectedValue == null)
{
MessageBox.Show(clsTranslate.TranslateString("Account No") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
cboAccountNo.Focus();
return;
}
if (cboReceiveStatus.SelectedIndex == 1)
{
if (cboAccountNo.SelectedIndex <= 0)
{
MessageBox.Show(clsTranslate.TranslateString("Account No") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
cboAccountNo.Focus();
return;
}
}
if (string.IsNullOrEmpty(txtInvoiceMny.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("Invoice Mny") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtInvoiceMny.Focus();
return;
}
else if (!Util.IsNumeric(txtInvoiceMny.Text))
{
MessageBox.Show(clsTranslate.TranslateString("Invoice Mny") + clsTranslate.TranslateString(" must be a numeric!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtInvoiceMny.Focus();
return;
}
if (cboInvoiceStatus.SelectedIndex == 2)
{
if (Convert.ToDecimal(txtInvoiceMny.Text) == 0)
{
MessageBox.Show(clsTranslate.TranslateString("Invoice Mny") + clsTranslate.TranslateString(" must >0 !"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtInvoiceMny.Focus();
return;
}
if (string.IsNullOrEmpty(txtInvoiceNo.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("Invoice No") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtInvoiceNo.Focus();
return;
}
}
bool ret = _dal.UpdateReceiveStatus(true, true, txtId.Text.Trim(), cboReceiveStatus.SelectedIndex, cboAccountNo.SelectedValue.ToString(), txtReceiveDate.Text.Trim(), cboInvoiceStatus.SelectedIndex, Convert.ToDecimal(txtInvoiceMny.Text), txtInvoiceNo.Text.Trim(), Util.UserId, 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;
}
}
