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