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