private void btnDelete_Click(object sender, EventArgs e) { if (dgvMain.SelectedRows.Count != 0) { DataGridViewRow row = dgvMain.SelectedRows[0]; try { UnitDal unitDal = new UnitDal(); unitDal.DeleteUnitClass(row.Cells[0].Value.ToString()); bsMain.DataSource = unitDal.GetUnitClass(); } catch (Exception exp) { THOKUtil.ShowInfo(exp.Message); } } }
private void btnAdd_Click(object sender, EventArgs e) { UnitClassDialog classDialog = new UnitClassDialog(); if (classDialog.ShowDialog() == DialogResult.OK) { try { UnitDal unitDal = new UnitDal(); unitDal.AddUnitClass(classDialog.ClassCode, classDialog.ClassName, classDialog.Memo); bsMain.DataSource = unitDal.GetUnitClass(); } catch (Exception exp) { THOKUtil.ShowInfo(exp.Message); } } }
private void InitializeUnit() { UnitDal unitDal = new UnitDal(); DataTable classTable = unitDal.GetUnitClass(); DataTable unitTable = unitDal.GetUnit(); foreach (DataRow classRow in classTable.Rows) { TreeNode classNode = new TreeNode(); classNode.Name = classRow["UNITCLASSCODE"].ToString(); classNode.Text = string.Format("{0}[{1}]", classRow["UNITCLASSNAME"], classRow["UNITCLASSCODE"]); classNode.Tag = classRow["UNITCLASSNAME"]; DataRow[] unitRows = unitTable.Select(string.Format("UNITCLASS='{0}'", classRow["UNITCLASSCODE"])); foreach (DataRow unitRow in unitRows) { TreeNode unitNode = new TreeNode(); unitNode.Name = unitRow["UNITCODE"].ToString(); unitNode.Text = string.Format("{0}[{1}]", unitRow["UNITNAME"], unitRow["UNITCODE"].ToString().Trim()); unitNode.Tag = unitRow["UNITNAME"]; classNode.Nodes.Add(unitNode); } tvUnit.Nodes.Add(classNode); } }
private void pnlMain_ParentChanged(object sender, EventArgs e) { if (!hasInitialize) { UnitDal unitDal = new UnitDal(); DataTable classTable = unitDal.GetUnitClass(); unitTable = unitDal.GetUnit(); foreach (DataRow classRow in classTable.Rows) { TreeNode classNode = new TreeNode(); classNode.Name = classRow["UNITCLASSCODE"].ToString(); classNode.Text = string.Format("{0}[{1}]", classRow["UNITCLASSNAME"], classRow["UNITCLASSCODE"]); classNode.Tag = classRow["UNITCLASSNAME"]; DataRow[] unitRows = unitTable.Select(string.Format("UNITCLASS='{0}'", classRow["UNITCLASSCODE"])); foreach (DataRow unitRow in unitRows) { TreeNode unitNode = new TreeNode(); unitNode.Name = unitRow["UNITCODE"].ToString(); unitNode.Text = string.Format("{0}[{1}]", unitRow["UNITNAME"], unitRow["UNITCODE"].ToString().Trim()); unitNode.Tag = unitRow; classNode.Nodes.Add(unitNode); } tvLeft.Nodes.Add(classNode); } hasInitialize = true; tvLeft.ExpandAll(); tvLeft.Focus(); } }
private void pnlMain_ParentChanged(object sender, EventArgs e) { UnitDal unitDal = new UnitDal(); bsMain.DataSource = unitDal.GetUnitClass(); }
private void btnModify_Click(object sender, EventArgs e) { if (dgvMain.SelectedRows.Count != 0) { DataRowView row = (DataRowView)dgvMain.SelectedRows[0].DataBoundItem; UnitClassDialog classDialog = new UnitClassDialog(row["UNITCLASSCODE"].ToString(), row["UNITCLASSNAME"].ToString(), row["MEMO"].ToString()); if (classDialog.ShowDialog() == DialogResult.OK) { try { UnitDal unitDal = new UnitDal(); unitDal.SaveUnitClass(classDialog.ClassCode, classDialog.ClassName, classDialog.Memo); bsMain.DataSource = unitDal.GetUnitClass(); } catch (Exception exp) { THOKUtil.ShowInfo(exp.Message); } } } }