private void button1_Click(object sender, EventArgs e)
{
ArrayList fields = new ArrayList();
for (int i = 0; i < dgvShow.Columns.Count; i++)
{
if (!dgvShow.Columns[i].HeaderText.Trim().Equals("id"))
{
fields.Add(dgvShow.Columns[i].HeaderText);
}
}
FrmTreeField treeFieldForm = new FrmTreeField();
treeFieldForm.FieldNames = fields;
treeFieldForm.ShowDialog();
if (treeFieldForm.DialogResult == DialogResult.Yes)
{
treefields = fields;
viewStatus();
if (fields.Count > 0)
{
CostEditLogic logic = new CostEditLogic();
treeView1.Nodes.Clear();
logic.DistillAlterBitumenExpenditureTree(ref treeView1, fields);
}
}
}
private void bottonSearch()
{
CostEditLogic logic = new CostEditLogic();
DataTable dt = new DataTable();
selectAlterBitumenWaitDetachExpenditure conds = new selectAlterBitumenWaitDetachExpenditure();
conds.prName = cmbProductName.Text.Trim().Equals("") ? null : cmbProductName.Text;
conds.prModel = cmbProductmodel.Text.Trim().Equals("") ? null : cmbProductmodel.Text;
conds.eqName = cmbEquipmentName.Text.Trim().Equals("") ? null : cmbEquipmentName.Text;
conds.eqModel = cmbEquipmentModel.Text.Trim().Equals("") ? null : cmbEquipmentModel.Text;
conds.flag = CBFlag.Text;
if (checkBox1.Checked)
{
conds.beginDateTime = dtpStart.Value.ToString();
}
if (checkBox2.Checked)
{
conds.endDateTime = dtpEnd.Value.ToString();
}
dt = logic.SelectAllData(conds);
dgvShow.DataSource = dt;
caleRecordAndMoney(dt);
dgvShow.Columns["id"].Visible = false;
}
private void FormInit()
{
CostEditLogic logic = new CostEditLogic();
logic.SetExpenditureKind(ref cmbKind);
cmbYear.Text = DateTime.Now.Year.ToString();
cmbMonth.Text = DateTime.Now.Month.ToString();
//logic.CreateExpenditureTree(treeView1);
}
private void FormInit()
{
bottonSearch();
treefields.Clear();
treefields.Add("费用类别");
CostEditLogic logic = new CostEditLogic();
treeView1.Nodes.Clear();
logic.DistillAlterBitumenExpenditureTree(ref treeView1, treefields);
viewStatus();
}
//窗体初始化
private void FormInit()
{
logic.CreateExpenditureTree(treev1);
treev1.ExpandAll();
cmbYear.Text = DateTime.Now.Year.ToString();
cmbMonth.Text = DateTime.Now.Month.ToString();
CostEditLogic costEditLogic = new CostEditLogic();
costEditLogic.SetExpenditureKind(ref cmbExpenditureSort);
costEditLogic.SetExpenditureName(ref cmbExpenditureName);
costEditLogic.SetExpenditureDetail(ref cmbExpenditureDetail);
costEditLogic.SetEquipmentName(ref cmbEquipmentName);
costEditLogic.SetProductName(ref cmbProductName);
tempDataTable.Columns.Add("id");
tempDataTable.Columns.Add("ekId");
tempDataTable.Columns.Add("enId");
tempDataTable.Columns.Add("ecId");
tempDataTable.Columns.Add("expenditureDepict");
tempDataTable.Columns.Add("year");
tempDataTable.Columns.Add("month");
tempDataTable.Columns.Add("eiId");
tempDataTable.Columns.Add("pId");
tempDataTable.Columns.Add("number");
tempDataTable.Columns.Add("unitPrice");
tempDataTable.Columns.Add("money");
tempDataTable.Columns.Add("inputDate");
tempDataTable.Columns.Add("inputMan");
tempDataTable.Columns.Add("convert");
tempDataTable.Columns.Add("remark");
tempDataTable.Columns.Add("费用类别");
tempDataTable.Columns.Add("费用名称");
tempDataTable.Columns.Add("费用明细");
tempDataTable.Columns.Add("设备名称");
tempDataTable.Columns.Add("产品名称");
dateTimePicker1.Value = DateTime.Now;
dataGridView1.DataSource = tempDataTable;
}
// 删除表中的记录之后重新绑定数据源取表的过程
private DataTable distillCostTable()
{
CostEditLogic logic = new CostEditLogic();
DataTable dt = new DataTable();
selectAlterBitumenWaitDetachExpenditure conds = new selectAlterBitumenWaitDetachExpenditure();
conds.prName = cmbProductName.Text.Trim().Equals("") ? null : cmbProductName.Text;
conds.prModel = cmbProductmodel.Text.Trim().Equals("") ? null : cmbProductmodel.Text;
conds.eqName = cmbEquipmentName.Text.Trim().Equals("") ? null : cmbEquipmentName.Text;
conds.eqModel = cmbEquipmentModel.Text.Trim().Equals("") ? null : cmbEquipmentModel.Text;
if (checkBox1.Checked)
{
conds.beginDateTime = dtpStart.Value.ToString();
}
if (checkBox2.Checked)
{
conds.endDateTime = dtpEnd.Value.ToString();
}
dt = logic.SelectAllData(conds);
return(dt);
}
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
if (treeView1.SelectedNode != null)
{
selectAlterBitumenWaitDetachExpenditure conds = new selectAlterBitumenWaitDetachExpenditure();
TreeNode nodes = new TreeNode();
nodes = treeView1.SelectedNode;
for (int i = treeView1.SelectedNode.Level; i >= 0; i--)
{
switch (treefields[i].ToString().Trim())
{
case "费用类别":
conds.exSort = nodes.Text;
break;
case "费用名称":
conds.exName = nodes.Text;
break;
case "费用明细":
conds.exDetail = nodes.Text;
break;
case "费用描述":
conds.exDepict = nodes.Text;
break;
case "年份":
conds.exYear = nodes.Text;
break;
case "月份":
conds.exMonth = nodes.Text;
break;
case "设备名称":
conds.eqName = nodes.Text;
break;
case "设备型号":
conds.eqModel = nodes.Text;
break;
case "产品名称":
conds.prName = nodes.Text;
break;
case "产品型号":
conds.prModel = nodes.Text;
break;
case "单价":
conds.exUnitPrice = nodes.Text;
break;
case "数量":
conds.exNumber = nodes.Text;
break;
case "金额":
conds.exMoney = nodes.Text;
break;
case "录入时间":
conds.exInputDate = nodes.Text;
break;
case "录入人":
conds.exInputMan = nodes.Text;
break;
case "折算系数":
conds.exConvert = nodes.Text;
break;
case "备注":
conds.exRemark = nodes.Text;
break;
}
nodes = nodes.Parent;
}
CostEditLogic logic = new CostEditLogic();
DataTable dt = new DataTable();
dt = logic.SelectAllData(conds);
dgvShow.DataSource = dt;
caleRecordAndMoney(dt);
dgvShow.Columns["id"].Visible = false;
}
}
