private void mnuDesignForm_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (DBGrid.CurrentRow == null)
{
return;
}
modCustomerOrderList mod = (modCustomerOrderList)DBGrid.CurrentRow.DataBoundItem;
dalSalesDesignForm dal = new dalSalesDesignForm();
BindingCollection <modSalesDesignForm> list = dal.GetIList(string.Empty, string.Empty, mod.CustId, string.Empty, mod.CustOrderNo, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, out Util.emsg);
if (list != null && list.Count > 0)
{
frmViewList frm = new frmViewList();
frm.InitViewList(clsTranslate.TranslateString("Sales Design Form"), 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;
}
}
private void LoadData()
{
try
{
this.Cursor = Cursors.WaitCursor;
string custlist = string.Empty;
if (cboCustomer.Visible)
{
custlist = cboCustomer.SelectedValue.ToString();
}
else
{
custlist = string.Empty;
}
DBGrid.toolCancelFrozen_Click(null, null);
BindingCollection <modSalesDesignForm> list = _dal.GetIList(rbStatus0.Checked ? "0" : "1", string.Empty, custlist, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, rbStatus0.Checked ? string.Empty : dtpFrom.Text, rbStatus0.Checked ? string.Empty : 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.Exclamation);
}
else
{
AddComboBoxColumns();
DBGrid.ReadOnly = false;
for (int i = 0; i < DBGrid.ColumnCount; i++)
{
DBGrid.Columns[i].ReadOnly = true;
}
DBGrid.Columns["ReceiveStatus"].ReadOnly = false;
DBGrid.Columns["ReceiveDate"].ReadOnly = false;
DBGrid.Columns["AccountNo"].ReadOnly = false;
DBGrid.Columns["InvoiceStatus"].ReadOnly = false;
DBGrid.Columns["InvoiceNo"].ReadOnly = false;
DBGrid.Columns["InvoiceMny"].ReadOnly = false;
ShowColor();
string[] showcell = { "AccountNo" };
DBGrid.SetParam(showcell);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
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 custlist = string.Empty;
if (lstCustomer.SelectedItems.Count > 0 && lstCustomer.SelectedItems.Count < lstCustomer.Items.Count)
{
for (int i = 0; i < lstCustomer.SelectedItems.Count; i++)
{
modCustomerList mod = (modCustomerList)lstCustomer.SelectedItems[i];
if (i == 0)
{
custlist = mod.CustId;
}
else
{
custlist += "," + mod.CustId;
}
}
}
BindingCollection <modSalesDesignForm> list = new BindingCollection <modSalesDesignForm>();
if (DBGrid.CurrentRow.Index == DBGrid.RowCount - 1)
{
list = _dal.GetIList(statuslist, cboFormType.SelectedValue.ToString(), custlist, string.Empty, string.Empty, string.Empty, string.Empty, paystatuslist, invoicestatuslist, dtpFrom.Text, dtpTo.Text, out Util.emsg);
}
else
{
modSalesDesignSummary moditem = (modSalesDesignSummary)DBGrid.CurrentRow.DataBoundItem;
list = _dal.GetIList(string.Empty, moditem.FormType, moditem.CustId, string.Empty, string.Empty, string.Empty, string.Empty, paystatuslist, invoicestatuslist, dtpFrom.Text, dtpTo.Text, out Util.emsg);
}
if (list != null && list.Count > 0)
{
frmViewList frm = new frmViewList();
frm.InitViewList(clsTranslate.TranslateString("Sales Shipment Detail"), list);
frm.ShowDialog();
}
}
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 custlist = string.Empty;
if (lstCustomer.SelectedItems.Count > 0 && lstCustomer.SelectedItems.Count < lstCustomer.Items.Count)
{
for (int i = 0; i < lstCustomer.SelectedItems.Count; i++)
{
modCustomerList mod = (modCustomerList)lstCustomer.SelectedItems[i];
if (i == 0)
{
custlist = mod.CustId;
}
else
{
custlist += "," + mod.CustId;
}
}
}
BindingCollection <modSalesDesignForm> list = _dal.GetIList(statuslist, cboFormType.SelectedValue.ToString(), custlist, txtInvNo.Text.Trim(), txtCustOrderNo.Text.Trim(), cboSalesMan.SelectedValue.ToString(), txtProductName.Text.Trim(), paystatuslist, invoicestatuslist, dtpFrom.Text, dtpTo.Text, out Util.emsg);
DBGrid.DataSource = list;
decimal sum = 0;
if (list != null && list.Count > 0)
{
foreach (modSalesDesignForm mod in list)
{
sum += mod.Mny * Convert.ToDecimal(mod.AdFlag);
}
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;
}
}
