public Operations_Master(string PartNumber, string GroupID, string Rev)
{
InitializeComponent();
OPDataGrid.AutoGenerateColumns = false;
partnumber_txt.Text = PartNumber;
rev_txt.Text = Rev;
gid_txt.Text = GroupID;
bool morePages;
OpMaster OpMaster = new Epicor.Mfg.BO.OpMaster(DataList.EpicConn);
DataSet ds = (DataSet)OpMaster.GetRows("", "", "", "", "", "", 100, 0, out morePages);
opmast_cbo.DataSource = ds.Tables["OPMaster"];
opmast_cbo.ValueMember = ds.Tables["OPMaster"].Columns["OPCode"].ToString();
opmast_cbo.DisplayMember = ds.Tables["OPMaster"].Columns["OPDesc"].ToString();
EngWBDS = EngWB.GetDatasetForTree(gid_txt.Text, partnumber_txt.Text, rev_txt.Text, "", DateTime.Today, false, false);
OPDataGrid.DataSource = EngWBDS.Tables["ECOOpr"];
DataList.EpicClose();
}
public Operations_Master(string PartNumber, string GroupID, string Rev)
{
InitializeComponent();
OPDataGrid.AutoGenerateColumns = false;
partnumber_txt.Text = PartNumber;
rev_txt.Text = Rev;
gid_txt.Text = GroupID;
bool morePages;
OpMaster OpMaster = new Epicor.Mfg.BO.OpMaster(DataList.EpicConn);
DataSet ds = (DataSet)OpMaster.GetRows("", "", "", "", "", "", 100, 0, out morePages);
opmast_cbo.DataSource = ds.Tables["OPMaster"];
opmast_cbo.ValueMember = ds.Tables["OPMaster"].Columns["OPCode"].ToString();
opmast_cbo.DisplayMember = ds.Tables["OPMaster"].Columns["OPDesc"].ToString();
EngWBDS = EngWB.GetDatasetForTree(gid_txt.Text, partnumber_txt.Text, rev_txt.Text, "", DateTime.Today, false, false);
OPDataGrid.DataSource = EngWBDS.Tables["ECOOpr"];
DataList.EpicClose();
}
public Operations_Master(string PartNumber, string Rev)
{
InitializeComponent();
_PartNumber = PartNumber;
_Rev = Rev;
supplierid_txt.Leave += supplierid_txt_Leave;
OPDataGrid.AutoGenerateColumns = false;
partnumber_txt.Text = PartNumber;
rev_txt.Text = Rev;
desc_txt.Text = UpdateParentDesc();
try
{
bool morePages;
OpMaster OpMaster = new Epicor.Mfg.BO.OpMaster(DataList.EpicConn);
DataSet ds = (DataSet)OpMaster.GetRows("", "", "", "", "", "", 100, 0, out morePages);
opmast_cbo.DataSource = ds.Tables["OPMaster"];
subcon_opsmast_cbo.DataSource = ds.Tables["OPMaster"];
opmast_cbo.ValueMember = "OPCode";
opmast_cbo.DisplayMember = "OPDesc";
subcon_opsmast_cbo.ValueMember = "OPCode";
subcon_opsmast_cbo.DisplayMember = "OPDesc";
uom_cbo.DataSource = DataList.PartUOM(_PartNumber);
uom_cbo.DisplayMember = "UOMCode";
uom_cbo.ValueMember = "UOMCode";
BW.RunWorkerAsync();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Data Inconsistency!", MessageBoxButtons.OK, MessageBoxIcon.Stop);
this.Close();
}
}
public Operations_Master()
{
InitializeComponent();
OPDataGrid.AutoGenerateColumns = false;
bool morePages;
OpMaster OpMaster = new Epicor.Mfg.BO.OpMaster(DataList.EpicConn);
DataSet ds = (DataSet)OpMaster.GetRows("", "", "", "", "", "", 100, 0, out morePages);
opmast_cbo.DataSource = ds.Tables["OPMaster"];
opmast_cbo.ValueMember = ds.Tables["OPMaster"].Columns["OPCode"].ToString();
opmast_cbo.DisplayMember = ds.Tables["OPMaster"].Columns["OPDesc"].ToString();
DataList.EpicClose();
}
public Operations_Master()
{
InitializeComponent();
OPDataGrid.AutoGenerateColumns = false;
bool morePages;
OpMaster OpMaster = new Epicor.Mfg.BO.OpMaster(DataList.EpicConn);
DataSet ds = (DataSet)OpMaster.GetRows("", "", "", "", "", "", 100, 0, out morePages);
opmast_cbo.DataSource = ds.Tables["OPMaster"];
opmast_cbo.ValueMember = ds.Tables["OPMaster"].Columns["OPCode"].ToString();
opmast_cbo.DisplayMember = ds.Tables["OPMaster"].Columns["OPDesc"].ToString();
DataList.EpicClose();
}
private void add_op_btn_Click(object sender, EventArgs e)
{
RefreshTransaction();
Template_Title TT = new Template_Title();
DialogResult Dr = TT.ShowDialog();
if (TT.DialogResult == DialogResult.OK)
{
string TemplateName = TT.RetVal;
TT.Dispose();
TemplateAdapter.InsertNewLine(TemplateName, "OOM");
TemplateAdapter.FillByType((ENGDataDataSet.TemplatesDataTable)OpsTemplateList.DataSource, "OOM");
OpsTemplateList.CurrentCell = OpsTemplateList[0, OpsTemplateList.Rows.Count - 1];
OPDataGrid.DataSource = GetFullTemplate(OpsTemplateList.CurrentCell.Value.ToString(), "OOM");
oomtemplatename_txt.Text = OpsTemplateList.CurrentCell.Value.ToString();
seq_txt.Text = "";
opmast_cbo.SelectedIndex = -1;
prodhrs_num.Value = 0;
prodstd_cbo.SelectedValue = -1;
SNRequiredOpr_chk.Checked = false;
AutoRecieve_chk.Checked = false;
laborentry_cbo.SelectedIndex = -1;
subcon_opsmast_cbo.SelectedIndex = -1;
refneeded_chk.Checked = false;
qtyper_num.Value = 0;
supplierid_txt.Text = "";
quotesreq_num.Value = 0;
unitcost_num.Value = 0;
daysout_num.Value = 0;
subconuom_cbo.SelectedIndex = -1;
//OPDataGrid_CellClick(OPDataGrid, new DataGridViewCellEventArgs(0, 0));
bool morePages;
OpMaster OpMaster = new Epicor.Mfg.BO.OpMaster(DataList.EpicConn);
DataSet ds = (DataSet)OpMaster.GetRows("", "", "", "", "", "", 100, 0, out morePages);
opmast_cbo.DataSource = ds.Tables["OPMaster"];
opmast_cbo.ValueMember = "OPCode";
opmast_cbo.DisplayMember = "OPDesc";
}
}
public Template_Master()
{
InitializeComponent();
AddItemHandles();
#region Fill DataLists
DataTable dt = DataList.ProdGrupDataSet().Tables[0];
DataRow dr = dt.NewRow();
dr["Description"] = "";
dt.Rows.InsertAt(dr, 0);
group_cbo.DataSource = dt;
group_cbo.DisplayMember = "Description";
group_cbo.ValueMember = "ProdCode";
dt = DataList.PartClassDataSet().Tables[0];
dr = dt.NewRow();
dr["Description"] = "";
dt.Rows.InsertAt(dr, 0);
class_cbo.DataSource = dt;
class_cbo.DisplayMember = DataList.PartClassDataSet().Tables[0].Columns["Description"].ToString();
class_cbo.ValueMember = DataList.PartClassDataSet().Tables[0].Columns["ClassID"].ToString();
dt = DataList.UOMClassDataSet().Tables[0];
dr = dt.NewRow();
dr["Description"] = "";
dt.Rows.InsertAt(dr, 0);
uomclass_cbo.DataSource = dt;
uomclass_cbo.DisplayMember = DataList.UOMClassDataSet().Tables[0].Columns["Description"].ToString();
dt = DataList.PlantDataSet().Tables[0];
dr = dt.NewRow();
dr["NAME"] = "";
dt.Rows.InsertAt(dr, 0);
plant_cbo.DataSource = dt;
plant_cbo.DisplayMember = DataList.PlantDataSet().Tables[0].Columns["NAME"].ToString();
plant_cbo.ValueMember = "Plant";
dt = DataList.WarehseDataSet().Tables[0];
dr = dt.NewRow();
dr["Description"] = "";
dt.Rows.InsertAt(dr, 0);
/*
whse_cbo.DataSource = dt;
whse_cbo.DisplayMember = DataList.WarehseDataSet().Tables[0].Columns["Description"].ToString();
whse_cbo.ValueMember = "WarehouseCode";
*/
DataSet DS = DataList.UOMSearchDataSet();
DS.Tables[0].Columns.Add("FullCode", typeof(string), "UOMCode + ' - ' + UOMDesc");
dr = DS.Tables[0].NewRow();
dr["FullCode"] = "";
DS.Tables[0].Rows.InsertAt(dr, 0);
uom_cbo.DataSource = DS.Tables[0];
uom_cbo.DisplayMember = DS.Tables[0].Columns["FullCode"].ToString();
uom_cbo.ValueMember = "UOMCode";
uomclass_cbo.SelectedIndex = 2;
//type_cbo.SelectedIndex = 0;
dt = DataList.UOMVolumeDataSet().Tables[0];
dr = dt.NewRow();
dr["UOMCode"] = "";
dt.Rows.InsertAt(dr, 0);
uomvol_cbo.DataSource = dt;
uomvol_cbo.DisplayMember = DataList.UOMVolumeDataSet().Tables[0].Columns["UOMCode"].ToString();
uomvol_cbo.ValueMember = "UOMCode";
dt = DataList.UOMWeightDataSet().Tables[0];
dr = dt.NewRow();
dr["UOMCode"] = "";
dt.Rows.InsertAt(dr, 0);
uomweight_cbo.DataSource = dt;
uomweight_cbo.DisplayMember = DataList.UOMWeightDataSet().Tables[0].Columns["UOMCode"].ToString();
uomweight_cbo.ValueMember = "UOMCode";
bool morePages;
OpMaster OpMaster = new Epicor.Mfg.BO.OpMaster(DataList.EpicConn);
DataSet ds = (DataSet)OpMaster.GetRows("", "", "", "", "", "", 100, 0, out morePages);
opmast_cbo.DataSource = ds.Tables["OPMaster"];
opmast_cbo.ValueMember = "OPCode";
opmast_cbo.DisplayMember = "OPDesc";
FillProdStd();
#endregion
FillResourceList();
BillDataGrid.CellClick += BillDataGrid_CellClick;
OPDataGrid.CellClick += OPDataGrid_CellClick;
ResDataGrid.CellClick += ResDataGrid_CellClick;
this.FormClosing += Template_Master_FormClosing;
}
private void addbtn_Click(object sender, EventArgs e)
{
EngWB.GetNewECOOpr(EngWBDS, Properties.Settings.Default.ecogroup, partnumber_txt.Text, rev_txt.Text, "");
int RowIndex = OPDataGrid.Rows.Count - 1;
OPDataGrid.ClearSelection();
OPDataGrid.CurrentCell = OPDataGrid.Rows[RowIndex].Cells[0];
opmast_cbo.SelectedIndex = 0;
prodhrs_num.Value = 0;
OpMaster OpMaster = new Epicor.Mfg.BO.OpMaster(DataList.EpicConn);
bool morePages;
DataSet ds = (DataSet)OpMaster.GetRows("", "", "", "", "", "", 100, 0, out morePages);
DataList.EpicClose();
EngWBDS.Tables["ECOOpr"].Rows[RowIndex]["OpCode"] = ds.Tables["OpMaster"].Rows[opmast_cbo.SelectedIndex]["OpCode"].ToString();
EngWBDS.Tables["ECOOpr"].Rows[RowIndex]["OpDesc"] = opmast_cbo.Text;
EngWBDS.Tables["ECOOpr"].Rows[RowIndex]["ProdStandard"] = prodhrs_num.Value;
LaborEntryMethod_cbo.SelectedValue = "Q";
LaborEntryMethod_cbo_SelectedIndexChanged(LaborEntryMethod_cbo, null);
resource_show.Enabled = false;
EngWB.Update(EngWBDS);
EngWB.ResequenceOperations(Properties.Settings.Default.ecogroup, partnumber_txt.Text, rev_txt.Text, "", DateTime.Today, false, true, true, false);
resource_show.Enabled = true;
EngWBDS = EngWB.GetDatasetForTree(Properties.Settings.Default.ecogroup, partnumber_txt.Text, rev_txt.Text, "", DateTime.Today, false, false);
OPDataGrid.DataSource = EngWBDS.Tables["ECOOpr"];
removebtn.Enabled = true;
bool serialized = false;
for (int i = 0; i < OPDataGrid.Rows.Count; i++)
{
if (OPDataGrid["SNRequiredOpr", i].Value.ToString() == "true")
{
serialized = true;
break;
}
}
if (!serialized)
for (int i = 0; i < OPDataGrid.Rows.Count; i++)
{
EngWBDS.Tables["ECOOpr"].Rows[RowIndex]["AutoReceive"] = (i == OPDataGrid.Rows.Count - 1);
}
try
{
OPDataGrid.CurrentCell = OPDataGrid.Rows[OPDataGrid.Rows.Count - 1].Cells[0];
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
