public FormulaDialog() { InitializeComponent(); table.Columns.Add("PRODUCTCODE"); table.Columns.Add("ORIGINAL"); table.Columns.Add("GRADE"); table.Columns.Add("YEARS"); table.Columns.Add("STYLE"); table.Columns.Add("QUANTITY"); table.Columns.Add("FORMULACODE"); table.Columns.Add("FORDER"); table.Columns.Add("OTHERCODE"); table.Columns["STYLE"].DefaultValue = "Ƭ��"; table.Columns["QUANTITY"].DefaultValue = 0; FormulaDal formulaDal = new FormulaDal(); STYLE.DataSource = formulaDal.GetStyle(); STYLE.ValueMember = "PSTYLE"; STYLE.DisplayMember = "PSTYLE"; dgvDetail.DataSource = table; cbCigarette.ValueMember = "CIGARETTECODE"; cbCigarette.DisplayMember = "CIGARETTENAME"; cbCigarette.DataSource = new CigaretteDal().GetAll(); }
public FormulaDialog(string formulaCode, string formulaName, string formulaDate, string cigaretteName, string quantity, string formulaNo, DataTable detailTable, bool canSave) { InitializeComponent(); FormulaDal formulaDal = new FormulaDal(); STYLE.DataSource = formulaDal.GetStyle(); STYLE.ValueMember = "PSTYLE"; STYLE.DisplayMember = "PSTYLE"; txtFormulaCode.Text = formulaCode; txtFormulaName.Text = formulaName; dtpFormulaDate.Value = DateTime.Parse(formulaDate); txtQuantity.Text = quantity; txtNo.Text = formulaNo; cbCigarette.ValueMember = "CIGARETTECODE"; cbCigarette.DisplayMember = "CIGARETTENAME"; cbCigarette.DataSource = new CigaretteDal().GetAll(); cbCigarette.SelectedValue = cigaretteName; this.table = detailTable; table.Columns["QUANTITY"].DefaultValue = 0; dgvDetail.DataSource = table; lblStatus.Text = string.Format("�ϼ�:{0}", SumQuantity()); btnSave.Enabled = canSave; btnExcel.Enabled = canSave; dgvDetail.AllowUserToAddRows = canSave; dgvDetail.AllowUserToDeleteRows = canSave; dgvDetail.ReadOnly = !canSave; }
private void bsMain_PositionChanged(object sender, EventArgs e) { if (bsMain.Current != null) { try { DataRowView masterRow = (DataRowView)bsMain.Current; FormulaDal formulaDal = new FormulaDal(); detailTable = formulaDal.GetFormulaDetail(masterRow["FORMULACODE"].ToString()); bsDetail.DataSource = detailTable; THOKUtil.EnableFilter(dgvDetail); } catch (Exception exp) { THOKUtil.ShowInfo("�����䷽������ʧ�ܣ�ԭ��" + exp.Message); } } }
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); } } } }