private void btnAdd_Click(object sender, EventArgs e) { FormulaDialog formulaDialog = new FormulaDialog(); if (formulaDialog.ShowDialog() == DialogResult.OK) { try { FormulaDal formulaDal = new FormulaDal(); formulaDal.AddFormula(formulaDialog.FormulaCode, formulaDialog.FormulaName, formulaDialog.FormulaDate, formulaDialog.CigaretteName, formulaDialog.Quantity, UserID, formulaDialog.FormulaNo, formulaDialog.FormulaDetail); bsMain.DataSource = formulaDal.GetFormulaMaster(); } catch (Exception exp) { THOKUtil.ShowInfo("�����䷽������ʧ�ܣ�ԭ��" + exp.Message); } } }
private void btnFormula_Click(object sender, EventArgs e) { if (dgvMain.CurrentRow != null) { DataRow masterRow = ((DataRowView)dgvMain.CurrentRow.DataBoundItem).Row; if (masterRow["FORMULACODE"].ToString().Trim().Length != 0) { if (THOKUtil.ShowQuery("��ȷ��Ҫ����뵱ǰ�����ƻ����䷽������") == DialogResult.Yes) { try { ScheduleDal scheduleDal = new ScheduleDal(); scheduleDal.ClearFormula(masterRow["SCHEDULENO"].ToString(), masterRow["FORMULACODE"].ToString()); masterRow["FORMULACODE"] = ""; } catch (Exception exp) { THOKUtil.ShowInfo("�����䷽����ʧ�ܣ�ԭ��" + exp.Message); } } } else { FormulaDal formulaDal = new FormulaDal(); DataTable table = formulaDal.GetFormulaMaster(masterRow["CIGARETTECODE"].ToString()); SelectDialog selectDialog = new SelectDialog(table, fields, false); if (selectDialog.ShowDialog() == DialogResult.OK) { try { string minFormula = formulaDal.GetMinFormula(masterRow["CIGARETTENAME"].ToString(), selectDialog["FORMULACODE"]); if (minFormula.Trim().Length != 0 && THOKUtil.ShowQuery(string.Format("��ѡ����䷽����Ϊ'{0}',�䷽��'{1}'��ʹ�ô�����0,ȷ��Ҫʹ��ѡ����䷽����?", selectDialog["FORMULACODE"], minFormula)) == DialogResult.No) return; ScheduleDal scheduleDal = new ScheduleDal(); scheduleDal.SaveFormula(masterRow["SCHEDULENO"].ToString(), masterRow["CIGARETTENAME"].ToString(), selectDialog.SelectedValue["FORMULACODE"]); masterRow["FORMULACODE"] = selectDialog.SelectedValue["FORMULACODE"]; } catch (Exception exp) { THOKUtil.ShowInfo("�����䷽����ʧ�ܣ�ԭ��" + exp.Message); } } } } else THOKUtil.ShowInfo("��ѡ��Ҫ����������ƻ���"); }
private void btnCopy_Click(object sender, EventArgs e) { if (dgvMaster.SelectedRows.Count != 0) { DataRow masterRow = ((DataRowView)dgvMaster.CurrentRow.DataBoundItem).Row; FormulaDialog formulaDialog = new FormulaDialog(masterRow["FORMULACODE"].ToString(), masterRow["FORMULANAME"].ToString(), masterRow["FORMULADATE"].ToString(), masterRow["CIGARETTENAME"].ToString(), masterRow["USECOUNT"].ToString(), masterRow["FORMULANO"].ToString(), detailTable, true); if (formulaDialog.ShowDialog() == DialogResult.OK) { try { FormulaDal formulaDal = new FormulaDal(); formulaDal.AddFormula(formulaDialog.FormulaCode, formulaDialog.FormulaName, formulaDialog.FormulaDate, formulaDialog.CigaretteName, formulaDialog.Quantity, UserID, formulaDialog.FormulaNo, formulaDialog.FormulaDetail); bsMain.DataSource = formulaDal.GetFormulaMaster(); } catch (Exception exp) { detailTable.RejectChanges(); THOKUtil.ShowInfo("�����䷽������ʧ�ܣ�ԭ��" + exp.Message); } } } }
private void btnRefresh_Click(object sender, EventArgs e) { try { FormulaDal formulaDal = new FormulaDal(); DataTable table = formulaDal.GetFormulaMaster(); bsMain.DataSource = table; DataGridViewAutoFilter.DataGridViewAutoFilterTextBoxColumn.RemoveFilter(dgvMaster); } catch (Exception exp) { THOKUtil.ShowInfo("�����䷽������ʧ�ܣ�ԭ��" + exp.Message); } }
private void btnModify_Click(object sender, EventArgs e) { if (dgvMaster.CurrentRow != null) { DataRow masterRow = ((DataRowView)dgvMaster.CurrentRow.DataBoundItem).Row; bool canSave = new THOK.PFK.Dal.ScheduleDal().GetFormula(masterRow["FORMULACODE"].ToString()) == 0; FormulaDialog formulaDialog = new FormulaDialog(masterRow["FORMULACODE"].ToString(), masterRow["FORMULANAME"].ToString(), masterRow["FORMULADATE"].ToString(), masterRow["CIGARETTENAME"].ToString(), masterRow["USECOUNT"].ToString(), masterRow["FORMULANO"].ToString(), detailTable, canSave); formulaDialog.FormulaCode = masterRow[0].ToString(); if (formulaDialog.ShowDialog() == DialogResult.OK) { try { FormulaDal formulaDal = new FormulaDal(); formulaDal.SaveFormula(formulaDialog.FormulaCode, formulaDialog.FormulaName, formulaDialog.FormulaDate, formulaDialog.CigaretteName, formulaDialog.Quantity, UserID, formulaDialog.FormulaNo, formulaDialog.FormulaDetail); bsMain.DataSource = formulaDal.GetFormulaMaster(); } catch (Exception exp) { THOKUtil.ShowInfo("�����䷽������ʧ�ܣ�ԭ��" + exp.Message); } } } }
private void btnDelete_Click(object sender, EventArgs e) { if (dgvMaster.SelectedRows.Count != 0) { if (THOKUtil.ShowQuery("��ȷʵҪɾ����ǰ�䷽����") == DialogResult.Yes) { try { FormulaDal formulaDal = new FormulaDal(); formulaDal.DeleteFormula(dgvMaster.SelectedRows[0].Cells["FORMULACODE"].Value.ToString()); DataTable table = formulaDal.GetFormulaMaster(); bsMain.DataSource = table; if (table.Rows.Count == 0) bsDetail.DataSource = null; } catch (Exception exp) { THOKUtil.ShowInfo("ɾ���䷽������ʧ�ܣ�ԭ��" + exp.Message); } } } }