private void toolNew_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
frmSingleSelect frmsingle = new frmSingleSelect();
frmsingle.InitData("请选择记帐凭证类别", "一般凭证,销售凭证,设计加工凭证,采购凭证,仓库进出,费用登记,收款凭证,付款凭证,其它应收凭证,其它应付凭证,生产凭证,支票承兑,固定资产增加,固定资产处理,固定资产评估,资产折旧,零库清理,价格调整,利润分配", ComboBoxStyle.DropDownList);
if (frmsingle.ShowDialog() == DialogResult.OK)
{
frmSelectGrid frmsel = new frmSelectGrid();
EditAccCredenceList frm = new EditAccCredenceList();
switch (Util.retValue1)
{
case "销售凭证":
dalSalesShipment dalss = new dalSalesShipment();
BindingCollection <modSalesShipment> listss = dalss.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg);
if (listss != null && listss.Count > 0)
{
frmsel.InitViewList(Util.retValue1, listss);
if (frmsel.ShowDialog() == DialogResult.OK)
{
if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist))
{
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
}
else
{
if (!string.IsNullOrEmpty(Util.emsg))
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
break;
case "设计加工凭证":
dalSalesDesignForm dalsd = new dalSalesDesignForm();
BindingCollection <modSalesDesignForm> listsd = dalsd.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg);
if (listsd != null && listsd.Count > 0)
{
frmsel.InitViewList(Util.retValue1, listsd);
if (frmsel.ShowDialog() == DialogResult.OK)
{
if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist))
{
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
}
else
{
if (!string.IsNullOrEmpty(Util.emsg))
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
break;
case "采购凭证":
dalPurchaseList dalpc = new dalPurchaseList();
BindingCollection <modPurchaseList> listpc = dalpc.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg);
if (listpc != null && listpc.Count > 0)
{
frmsel.InitViewList(Util.retValue1, listpc);
if (frmsel.ShowDialog() == DialogResult.OK)
{
if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist))
{
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
}
else
{
if (!string.IsNullOrEmpty(Util.emsg))
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
break;
case "费用登记":
dalAccExpenseForm dalexp = new dalAccExpenseForm();
BindingCollection <modAccExpenseForm> listexp = dalexp.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg);
if (listexp != null && listexp.Count > 0)
{
frmsel.InitViewList(Util.retValue1, listexp);
if (frmsel.ShowDialog() == DialogResult.OK)
{
if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist))
{
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
}
else
{
if (!string.IsNullOrEmpty(Util.emsg))
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
break;
case "收款凭证":
dalAccReceivableForm dalrec = new dalAccReceivableForm();
BindingCollection <modAccReceivableForm> listrec = dalrec.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg);
if (listrec != null && listrec.Count > 0)
{
frmsel.InitViewList(Util.retValue1, listrec);
if (frmsel.ShowDialog() == DialogResult.OK)
{
if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist))
{
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
}
else
{
if (!string.IsNullOrEmpty(Util.emsg))
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
break;
case "付款凭证":
dalAccPayableForm dalpay = new dalAccPayableForm();
BindingCollection <modAccPayableForm> listpay = dalpay.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg);
if (listpay != null && listpay.Count > 0)
{
frmsel.InitViewList(Util.retValue1, listpay);
if (frmsel.ShowDialog() == DialogResult.OK)
{
if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist))
{
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
}
else
{
if (!string.IsNullOrEmpty(Util.emsg))
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
break;
case "其它应收凭证":
dalAccOtherReceivableForm dalorec = new dalAccOtherReceivableForm();
BindingCollection <modAccOtherReceivableForm> listorec = dalorec.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg);
if (listorec != null && listorec.Count > 0)
{
frmsel.InitViewList(Util.retValue1, listorec);
if (frmsel.ShowDialog() == DialogResult.OK)
{
if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist))
{
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
}
else
{
if (!string.IsNullOrEmpty(Util.emsg))
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
break;
case "其它应付凭证":
dalAccOtherPayableForm dalopay = new dalAccOtherPayableForm();
BindingCollection <modAccOtherPayableForm> listopay = dalopay.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg);
if (listopay != null && listopay.Count > 0)
{
frmsel.InitViewList(Util.retValue1, listopay);
if (frmsel.ShowDialog() == DialogResult.OK)
{
if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist))
{
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
}
else
{
if (!string.IsNullOrEmpty(Util.emsg))
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
break;
case "仓库进出":
dalWarehouseInoutForm dalio = new dalWarehouseInoutForm();
BindingCollection <modWarehouseInoutForm> listio = dalio.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg);
if (listio != null && listio.Count > 0)
{
frmsel.InitViewList(Util.retValue1, listio);
if (frmsel.ShowDialog() == DialogResult.OK)
{
if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist))
{
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
}
else
{
if (!string.IsNullOrEmpty(Util.emsg))
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
break;
case "生产凭证":
dalProductionForm dalpdt = new dalProductionForm();
BindingCollection <modProductionForm> listpdt = dalpdt.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg);
if (listpdt != null && listpdt.Count > 0)
{
frmsel.InitViewList(Util.retValue1, listpdt);
if (frmsel.ShowDialog() == DialogResult.OK)
{
if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist))
{
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
}
else
{
if (!string.IsNullOrEmpty(Util.emsg))
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
break;
case "支票承兑":
dalAccCheckForm dalcheck = new dalAccCheckForm();
BindingCollection <modAccCheckForm> listcheck = dalcheck.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg);
if (listcheck != null && listcheck.Count > 0)
{
frmsel.InitViewList(Util.retValue1, listcheck);
if (frmsel.ShowDialog() == DialogResult.OK)
{
if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist))
{
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
}
else
{
if (!string.IsNullOrEmpty(Util.emsg))
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
break;
case "固定资产增加":
dalAssetAdd dalassetadd = new dalAssetAdd();
BindingCollection <modAssetAdd> listassetadd = dalassetadd.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg);
if (listassetadd != null && listassetadd.Count > 0)
{
frmsel.InitViewList(Util.retValue1, listassetadd);
if (frmsel.ShowDialog() == DialogResult.OK)
{
if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist))
{
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
}
else
{
if (!string.IsNullOrEmpty(Util.emsg))
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
break;
case "固定资产处理":
dalAssetSale dalassetsale = new dalAssetSale();
BindingCollection <modAssetSale> listassetsale = dalassetsale.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg);
if (listassetsale != null && listassetsale.Count > 0)
{
frmsel.InitViewList(Util.retValue1, listassetsale);
if (frmsel.ShowDialog() == DialogResult.OK)
{
if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist))
{
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
}
else
{
if (!string.IsNullOrEmpty(Util.emsg))
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
break;
case "固定资产评估":
dalAssetEvaluate dalassetevaluate = new dalAssetEvaluate();
BindingCollection <modAssetEvaluate> listassetevaluate = dalassetevaluate.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg);
if (listassetevaluate != null && listassetevaluate.Count > 0)
{
frmsel.InitViewList(Util.retValue1, listassetevaluate);
if (frmsel.ShowDialog() == DialogResult.OK)
{
if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist))
{
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
}
else
{
if (!string.IsNullOrEmpty(Util.emsg))
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
break;
case "价格调整":
dalPriceAdjustForm dalpaf = new dalPriceAdjustForm();
BindingCollection <modPriceAdjustForm> listpaf = dalpaf.GetWaitCredenceList(Util.modperiod.StartDate.ToString(), Util.modperiod.EndDate.ToString(), out Util.emsg);
if (listpaf != null && listpaf.Count > 0)
{
frmsel.InitViewList(Util.retValue1, listpaf);
if (frmsel.ShowDialog() == DialogResult.OK)
{
if (frm.AddItem(Util.retValue1, frmSelectGrid.selectionlist))
{
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
}
else
{
if (!string.IsNullOrEmpty(Util.emsg))
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("没有找到相应的数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
break;
case "零库清理":
if (frm.AddItem(Util.retValue1, string.Empty))
{
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
break;
case "利润分配":
frm.AddItem(Util.retValue1, string.Empty);
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
break;
default:
frm.AddItem(Util.retValue1, string.Empty);
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
break;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void LoadData()
{
if (cboAccName.ComboBox.SelectedValue == null || cboExpenseType.ComboBox.SelectedValue == null)
{
return;
}
DBGrid.Columns.Clear();
DataGridViewTextBoxColumn col0 = new DataGridViewTextBoxColumn();
col0.HeaderText = "月";
col0.DataPropertyName = "Month";
col0.Name = "Month";
col0.Width = 50;
DBGrid.Columns.Add(col0);
DataGridViewTextBoxColumn col1 = new DataGridViewTextBoxColumn();
col1.HeaderText = "日";
col1.DataPropertyName = "Day";
col1.Name = "Day";
col1.Width = 50;
DBGrid.Columns.Add(col1);
DataGridViewTextBoxColumn col2 = new DataGridViewTextBoxColumn();
col2.HeaderText = "凭证号";
col2.DataPropertyName = "AccSeq";
col2.Name = "AccSeq";
col2.Width = 50;
DBGrid.Columns.Add(col2);
DataGridViewTextBoxColumn col3 = new DataGridViewTextBoxColumn();
col3.HeaderText = "摘要";
col3.DataPropertyName = "Digest";
col3.Name = "Digest";
col3.Width = 220;
DBGrid.Columns.Add(col3);
DataGridViewTextBoxColumn col4 = new DataGridViewTextBoxColumn();
col4.HeaderText = "小计";
col4.DataPropertyName = "RowSum";
col4.Name = "RowSum";
col4.Width = 120;
col4.DefaultCellStyle.BackColor = frmOptions.ALTERNATING_BACKCOLOR;
//col4.DefaultCellStyle.ForeColor = Color.Red;
col4.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
DBGrid.Columns.Add(col4);
dalAccExpenseForm dal = new dalAccExpenseForm();
BindingCollection <modAccExpenseColumn> list = dal.GetExpenseColumn(cboAccName.ComboBox.SelectedValue.ToString(), cboExpenseType.ComboBox.SelectedValue.ToString(), out Util.emsg);
if (list != null && list.Count > 0)
{
var p = list.Select(c => c.ExpenseName).Distinct();
foreach (string expenseName in p)
{
DataGridViewTextBoxColumn col = new DataGridViewTextBoxColumn();
col.HeaderText = expenseName;
col.DataPropertyName = expenseName;
col.Name = expenseName;
col.Width = 100;
col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
DBGrid.Columns.Add(col);
col.Dispose();
}
var q = list.Select(c => new { Month = c.FormDate.Month, Day = c.FormDate.Day, AccSeq = c.AccSeq, Digest = c.Digest }).OrderBy(a => a.Month).OrderBy(a => a.Day).OrderBy(a => a.AccSeq).Distinct().ToList();
q.ForEach(item =>
{
DataGridViewRow row = new DataGridViewRow();
row.CreateCells(DBGrid);
row.Height = 36;
row.Cells[0].Value = item.Month;
row.Cells[1].Value = item.Day;
row.Cells[2].Value = item.AccSeq;
row.Cells[3].Value = item.Digest;
decimal rowSum = 0;
for (int i = 5; i < DBGrid.ColumnCount; i++)
{
var t = list.Where(a => a.FormDate.Day == item.Day && a.AccSeq == item.AccSeq && a.Digest == item.Digest && a.ExpenseName == DBGrid.Columns[i].Name).Select(c => c.ExpenseMny).FirstOrDefault();
if (t != 0)
{
row.Cells[i].Value = t;
rowSum += t;
}
}
row.Cells[4].Value = rowSum;
DBGrid.Rows.Add(row);
row.Dispose();
});
DataGridViewRow rowTotal = new DataGridViewRow();
rowTotal.CreateCells(DBGrid);
rowTotal.Height = 36;
rowTotal.Cells[2].Value = "合 计";
for (int i = 4; i < DBGrid.ColumnCount; i++)
{
decimal colSum = 0;
for (int j = 0; j < DBGrid.RowCount; j++)
{
colSum += DBGrid.Rows[j].Cells[i].Value == null ? 0 : decimal.Parse(DBGrid.Rows[j].Cells[i].Value.ToString());
}
rowTotal.Cells[i].Value = colSum;
}
rowTotal.DefaultCellStyle.BackColor = frmOptions.ALTERNATING_BACKCOLOR;
DBGrid.Rows.Add(rowTotal);
}
else
{
if (!string.IsNullOrEmpty(Util.emsg))
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
