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; } }