/// <summary>
/// Adds data in specified column at row number and table all into PartDataSet given
/// </summary>
/// <param name="Part"></param>
/// <param name="tableName"></param>
/// <param name="rowNum"></param>
/// <param name="colName"></param>
/// <param name="Input"></param>
/// <returns></returns>
public static PartDataSet AddDatum(PartDataSet Part, string tableName, int rowNum, string colName, string Input)
{
DataTable PartDT = Part.Tables[tableName];
DataRow[] WorkRow = PartDT.Select(null, null, DataViewRowState.Added);
WorkRow[0] = PartDT.Rows[rowNum];
try
{
WorkRow[0][colName] = Input;
}
catch (System.Exception ex)
{
try
{
WorkRow[0][colName] = double.Parse(Input);
}
catch //(System.Exception ex1)
{
try
{
WorkRow[0][colName] = (int)(double.Parse(Input));
}
catch //(System.Exception ex2)
{
System.Windows.Forms.MessageBox.Show(ex.Message, "Error!", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Exclamation);
}
}
}
return Part;
}
/// <summary>
/// Adds data in specified column at row number and table all into PartDataSet given
/// </summary>
/// <param name="Part"></param>
/// <param name="tableName"></param>
/// <param name="rowNum"></param>
/// <param name="colName"></param>
/// <param name="Input"></param>
/// <returns></returns>
public static PartDataSet AddDatum(PartDataSet Part, string tableName, int rowNum, string colName, string Input)
{
DataTable PartDT = Part.Tables[tableName];
DataRow[] WorkRow = PartDT.Select(null, null, DataViewRowState.Added);
WorkRow[0] = PartDT.Rows[rowNum];
try
{
WorkRow[0][colName] = Input;
}
catch (System.Exception ex)
{
try
{
WorkRow[0][colName] = double.Parse(Input);
}
catch //(System.Exception ex1)
{
try
{
WorkRow[0][colName] = (int)(double.Parse(Input));
}
catch //(System.Exception ex2)
{
System.Windows.Forms.MessageBox.Show(ex.Message, "Error!", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Exclamation);
}
}
}
return(Part);
}
private void Initialize()
{
bomSet = new BomDataSet(AppRes.DB.Connect, null, null);
productSet = new ProductDataSet(AppRes.DB.Connect, null, null);
partSet = new PartDataSet(AppRes.DB.Connect, null, null);
phyMainSet = new PhysicalMainDataSet(AppRes.DB.Connect, null, null);
cheMainSet = new ChemicalMainDataSet(AppRes.DB.Connect, null, null);
phyQuery = new PhysicalQuery(true);
cheQuery = new ChemicalQuery(true);
bomRec = new BomColumns();
bookmark = new GridBookmark(bomGridView);
AppHelper.SetGridEvenRow(bomGridView);
AppHelper.SetGridEvenRow(productGridView);
AppHelper.SetGridEvenRow(partGridView);
bomAreaColumn.DisplayFormat.FormatType = FormatType.Custom;
bomAreaColumn.DisplayFormat.Format = new ReportAreaFormat();
bomRegTimeColumn.DisplayFormat.FormatType = FormatType.Custom;
bomRegTimeColumn.DisplayFormat.Format = new ReportDateTimeFormat();
bomAreaCombo.DataSource = EnumHelper.GetNameValues <EReportArea>();
bomAreaCombo.DisplayMember = "Name";
bomAreaCombo.ValueMember = "Value";
}
public static bool CreatePartRevision(string PartNumber, string CurrentRev, string NewRev, string RevDesc)
{
bool _results;
try
{
Part Part = new Part(DataList.EpicConn);
PartDataSet PartData = new PartDataSet();
PartData = Part.GetByID(PartNumber);
Part.GetNewPartRev(PartData, PartNumber, CurrentRev);
int Y = PartData.Tables["PartRev"].Rows.Count - 1;
DataList.UpdateDatum(PartData, "PartRev", Y, "RevShortDesc", RevDesc);
DataList.UpdateDatum(PartData, "PartRev", Y, "RevisionNum", NewRev);
DataList.UpdateDatum(PartData, "PartRev", Y, "AltMethod", "");
Part.Update(PartData);
_results = true;
}
catch { _results = false; }
finally
{
EpicClose();
}
return(_results);
}
private void useselected_btn_Click(object sender, EventArgs e)
{
if (template_cbo.Text == "Other")
{
try
{
//Use text box part number
Part Part = new Part(DataList.EpicConn);
PartDataSet PData = new PartDataSet();
PData = Part.DuplicatePart(partnumber_txt.Text, _PartNumber, desc_txt.Text);
Part.Update(PData);
this.DialogResult = DialogResult.Ignore;
}
catch { }
}
else
{
//Use Listed Template
DataRow dr = eNGDataDataSet.Tables[0].Rows[template_cbo.SelectedIndex];
_Pdata.Description = dr["Desc"].ToString();
_Pdata.PMT = dr["Type"].ToString();
_Pdata.UOM_Class = dr["UOMClass"].ToString();
decimal fail = 0;
decimal.TryParse(dr["NetWeight"].ToString(), out fail);
_Pdata.Net_Weight = fail;
_Pdata.Net_Weight_UM = dr["UOMWeight"].ToString();
decimal.TryParse(dr["NetVol"].ToString(), out fail);
_Pdata.Net_Vol = fail;
_Pdata.Net_Vol_UM = dr["UOMVol"].ToString();
_Pdata.Primary_UOM = dr["UOM"].ToString();
_Pdata.PartGroup = dr["Group"].ToString();
_Pdata.PartClass = dr["Class"].ToString();
_Pdata.PartPlant = dr["Plant"].ToString();
_Pdata.PlantWhse = dr["Whse"].ToString();
}
this.Close();
}
/// <summary>
/// Search Function for retrieving Part lists
/// </summary>
/// <param name="WhereStatement">Equivalent to the SQL WHERE function; Leave blank for all possiblities</param>
/// <returns>Dataset of parts meeting the WhereStatement criteria</returns>
public PartDataSet PartSearchDataSet(string WhereStatement)
{
Part Part = new Part(EpicConn);
bool More;
DataSet dss = ((DataSet)Part.GetList(WhereStatement, 0, 0, out More));
PartDataSet ds = (PartDataSet)dss;
EpicClose();
return(ds);
}
public static PartDataSet UpdateDatum(PartDataSet Part, string tableName, int rowNum, string colName, string Input)
{
try
{
Part.Tables[tableName].Rows[rowNum][colName] = Input;
return(Part);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message, "Error!", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return(Part);
}
}
public static DataTable PartUOM(string PartNumber)
{
try
{
Part Part = new Part(EpicConn);
PartDataSet PartData = new PartDataSet();
PartData = Part.GetByID(PartNumber);
EpicClose();
return(PartData.Tables["PartUOM"]);
}
catch { return(null); }
}
public static string GetCurrentRev(string PartNumber)
{
try
{
Part Part = new Part(DataList.EpicConn);
PartDataSet PartData = new PartDataSet();
PartData = Part.GetByID(PartNumber);
int LastRowIndex = PartData.Tables["PartRev"].Rows.Count - 1;
string PartRev = PartData.Tables["PartRev"].Rows[LastRowIndex]["RevisionNum"].ToString();
EpicClose();
return(PartRev);
}
catch { return(""); }
}
public static string GetCurrentDesc(string PartNumber)
{
try
{
Part Part = new Part(EpicConn);
PartDataSet PartData = new PartDataSet();
PartData = Part.GetByID(PartNumber);
int LastRowIndex = PartData.Tables["Part"].Rows.Count - 1;
string PartDesc = PartData.Tables["Part"].Rows[LastRowIndex]["PartDescription"].ToString();
EpicClose();
return(PartDesc);
}
catch { return(null); }
}
public ChemicalQuery(bool local = false)
{
this.local = local;
if (local == true)
{
MainSet = new ChemicalMainDataSet(AppRes.DB.Connect, null, null);
ImageSet = new ChemicalImageDataSet(AppRes.DB.Connect, null, null);
JoinSet = new ChemicalItemJoinDataSet(AppRes.DB.Connect, null, null);
P2Set = new ChemicalP2DataSet(AppRes.DB.Connect, null, null);
P2ExtendSet = new ChemicalP2ExtendDataSet(AppRes.DB.Connect, null, null);
ProfJobSet = new ProfJobDataSet(AppRes.DB.Connect, null, null);
ProfJobSchemeSet = new ProfJobSchemeDataSet(AppRes.DB.Connect, null, null);
CtrlUs = null;
CtrlEu = null;
}
productSet = new ProductDataSet(AppRes.DB.Connect, null, null);
partSet = new PartDataSet(AppRes.DB.Connect, null, null);
staffSet = new StaffDataSet(AppRes.DB.Connect, null, null);
}
void pnum_txt_Leave(object sender, EventArgs e)
{
try
{
PartDataSet Pdata = new PartDataSet();
if (DataList.PartExists(pnum_txt.Text))
Pdata = DataList.GetPart(pnum_txt.Text);
RevGrid.DataSource = Pdata.Tables["PartRev"];
desc_txt.Text = Pdata.Tables["Part"].Rows[0]["PartDescription"].ToString();
}
catch
{
//nodata
}
}
/// <summary>
/// Sequence to determine if a part is a coil or a sheet based on Type
/// </summary>
/// <param name="PartNumber"></param>
/// <returns>True if part is not a coil/sheet; False if part is coil/sheet</returns>
public bool KeepRaw(string PartNumber)
{
Part Part = new Part(DataList.EpicConn);
PartDataSet Pdata = new PartDataSet();
Pdata = Part.GetByID(PartNumber);
string Type = Pdata.Tables ["Part"].Rows[0]["ClassDescription"].ToString();
if (Type == "INV COIL" || Type == "INV SHEET")
return false;
else
return true;
}
void TS_Click(object sender, EventArgs e)
{
ToolStripMenuItem TS = (ToolStripMenuItem)sender;
//retrieve template data
DataTable DT = new DataTable();
DT = Templates.GetFullTemplate(TS.Name, "BOM");
addraw.Enabled = true;
try
{
//line for each row
foreach (DataRow Dr in DT.Rows)
{
EngWB.GetNewECOMtl(EngWBDS, gid_txt.Text, parent_txt.Text, parentrev_txt.Text, "");
int row = EngWBDS.Tables["ECOMtl"].Rows.Count - 1;
EngWBDS.Tables["ECOMtl"].Rows[row]["MtlPartNum"] = Dr["PropertyValue"].ToString();
EngWBDS.Tables["ECOMtl"].Rows[row]["RelatedOperation"] = Dr["PropertyType"].ToString();
EngWBDS.Tables["ECOMtl"].Rows[row]["MtlPartNumPartDescription"] = DataList.GetCurrentDesc(Dr["PropertyValue"].ToString());
EngWBDS.Tables["ECOMtl"].Rows[row]["UOMCode"] = Dr["PropertyUOM"].ToString();
EngWBDS.Tables["ECOMtl"].Rows[row]["QtyPer"] = Dr["PropertyQty"].ToString();
EngWBDS.Tables["ECOMtl"].Rows[row]["ViewAsAsm"] = Dr["PropertyOptions"].ToString();
EngWBDS.Tables["ECOMtl"].Rows[row]["PullAsAsm"] = Dr["PropertyOptions1"].ToString();
if (Dr["PropertyOptions5"].ToString() != null || Dr["PropertyOptions5"].ToString() != "")
{
if (Dr["PropertyOptions5"].ToString() == "AREA")
EngWBDS.Tables["ECOMtl"].Rows[row]["QtyPer"] = area.Value;
if (Dr["PropertyOptions5"].ToString() == "WEIGHT")
{
try
{
Part Part = new Part(DataList.EpicConn);
PartDataSet Pdata = new PartDataSet();
Pdata = Part.GetByID(parent_txt.Text);
string Length = RailLength(Pdata.Tables["Part"].Rows[0]["PartDescription"].ToString());
string partnumber = Dr["PropertyValue"].ToString();
double density = double.Parse(sheetCoil_UsageTableAdapter.GetDensity(partnumber,"%","%","%","%").ToString());
double width = double.Parse(sheetCoil_UsageTableAdapter.GetWidth(partnumber, "%", "%", "%","%","%").ToString());
double thickness = double.Parse(sheetCoil_UsageTableAdapter.GetLength(partnumber, "%", "%", "%", "%", "%").ToString());
weight.Value = (decimal)(double.Parse(Length) * density * width * thickness) / 2;
}
finally
{
EngWBDS.Tables["ECOMtl"].Rows[row]["QtyPer"] = weight.Value;
}
}
}
EngWB.Update(EngWBDS);
}
EnableItemDetails();
}
catch (Exception ex) { MessageBox.Show(ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); }
}
private void savebtn_Click(object sender, EventArgs e)
{
try
{
//Commit Part Changes
Part Part = new Part(DataList.EpicConn);
PartDataSet Pdata = new PartDataSet();
//Pdata = (PartDataSet)DL.PartSearchDataSet("");
string serialWarning;
string questionString;
bool multipleMatch;
string PartNumber = Partnumber_txt.Text;
Part.GetPartXRefInfo(ref PartNumber, "", "", out serialWarning, out questionString, out multipleMatch);
if (!multipleMatch)
{
Part.GetNewPart(Pdata);
Part.ChangePartNum(PartNumber, Pdata);
DataList.AddDatum(Pdata, "Part", 0, "PartDescription", Description_txt.Text);
//SearchWord has 8 character limit
if (Description_txt.Text.Length > 8)
{
DataList.AddDatum(Pdata, "Part", 0, "SearchWord", Description_txt.Text.Substring(0, 8));
}
else
{
DataList.AddDatum(Pdata, "Part", 0, "SearchWord", Description_txt.Text);
}
DataList.AddDatum(Pdata, "Part", 0, "NetWeight", NetWeight.Text);
DataList.AddDatum(Pdata, "Part", 0, "NetWeightUOM", uomweight_cbo.SelectedValue.ToString());
//DataList.AddDatum(Pdata, "Part", 0, "NetVolume", NetVolume.Text);
//DataList.AddDatum(Pdata, "Part", 0, "NetVolumeUOM", uomvol_cbo.SelectedValue.ToString());
DataList.AddDatum(Pdata, "Part", 0, "IUM", uom_cbo.SelectedValue.ToString());
DataList.AddDatum(Pdata, "Part", 0, "ClassID", class_cbo.SelectedValue.ToString());
string Type_Code = type_cbo.SelectedItem.ToString();
Part.ChangePartTypeCode(Type_Code, Pdata);
Part.ChangePartProdCode(group_cbo.SelectedValue.ToString(), Pdata);
//Add data to allow BO to create plant tables
Part.Update(Pdata);
//retrieve the new copy of the data
Pdata = Part.GetByID(PartNumber);
DataList.UpdateDatum(Pdata, "PartPlant", 0, "PrimWhse", whse_cbo.SelectedValue.ToString());
DataList.UpdateDatum(Pdata, "PartPlant", 0, "PrimWhseDescription", whse_cbo.Text);
DataList.UpdateDatum(Pdata, "PartPlant", 0, "DBRowIdent", null);
//Update with warehouse information
Part.Update(Pdata);
DataList.EpicClose();
}
else
{
MessageBox.Show("Part already exists in database! Use revision to make changes.");
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
finally
{
this.Close();
}
}
public static bool PartExists(string partnumber)
{
Part Part = new Part(EpicConn);
PartDataSet Pdata = new PartDataSet();
try
{
Pdata = Part.GetByID(partnumber);
}
catch
{
EpicClose();
return false;
}
EpicClose();
return true;
}
public static string GetCurrentDesc(string PartNumber)
{
try
{
Part Part = new Part(EpicConn);
PartDataSet PartData = new PartDataSet();
PartData = Part.GetByID(PartNumber);
int LastRowIndex = PartData.Tables["Part"].Rows.Count - 1;
string PartDesc = PartData.Tables["Part"].Rows[LastRowIndex]["PartDescription"].ToString();
EpicClose();
return PartDesc;
}
catch { return null; }
}
private void savebtn_Click(object sender, EventArgs e)
{
if (trackserial.Checked && (SerialPrefix == "" || SerialPrefix == null))
MessageBox.Show("Cannot use null serial prefix. Set the prefix or uncheck 'Track Serial Number'", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
else
{
try
{
//Commit Part Changes
Part Part = new Part(DataList.EpicConn);
PartDataSet Pdata = new PartDataSet();
//Pdata = (PartDataSet)DL.PartSearchDataSet("");
string serialWarning;
string questionString;
bool multipleMatch;
string PartNumber = Partnumber_txt.Text;
DataViewRowState DRState;
if (!DataList.PartExists(PartNumber))
{
Part.GetPartXRefInfo(ref PartNumber, "", "", out serialWarning, out questionString, out multipleMatch);
Part.GetNewPart(Pdata);
Part.ChangePartNum(PartNumber, Pdata);
DRState = DataViewRowState.Added;
}
else
{
Pdata = Part.GetByID(PartNumber);
DRState = DataViewRowState.Unchanged;
#region Clear Bflush/SN Settings
try
{
DataList.UpdateDatum(Pdata, "Part", 0, "TrackSerialNum", false.ToString());
DataList.UpdateDatum(Pdata, "Part", 0, "UseMaskSeq", false.ToString());
DataList.UpdateDatum(Pdata, "PartPlant", 0, "PartTrackSerialNum", false.ToString());
DataList.UpdateDatum(Pdata, "PartPlant", 0, "BackFlush", false.ToString());
Part.Update(Pdata);
Pdata = Part.GetByID(PartNumber);
}
catch (Exception ex) { System.Diagnostics.Debug.Print(ex.Message); }
#endregion
}
Pdata = UpdateDataSet(Pdata, DRState);
//Add data to allow BO to create plant tables
try
{
Part.Update(Pdata);
if (bflush_chk.Checked)
{
//try to eliminate backflush if necessary
DataList.UpdateDatum(Pdata, "PartPlant", 0, "BackFlush", bflush_chk.Checked.ToString());
}
Part.Update(Pdata);
}
catch (Exception ex) { System.Diagnostics.Debug.Print(ex.Message); }
if (trackserial.Checked)
{
Pdata = Part.GetByID(PartNumber);
try
{
Part.ChangePartTrackSerialNum(trackserial.Checked, Pdata);
}
catch
{
//If the neat process fails, do it the hard way.
DataList.UpdateDatum(Pdata, "Part", 0, "TrackSerialNum", true.ToString());
DataList.UpdateDatum(Pdata, "Part", 0, "UseMaskSeq", true.ToString());
DataList.UpdateDatum(Pdata, "Part", 0, "SNLastUsedSeq", "");
Part.Update(Pdata);
Pdata = Part.GetByID(PartNumber);
DataList.UpdateDatum(Pdata, "PartPlant", 0, "EnableSerialNum", true.ToString());
DataList.UpdateDatum(Pdata, "PartPlant", 0, "PartTrackSerialNum", true.ToString());
try
{
DataList.UpdateDatum(Pdata, "PartPlant", 0, "PhantomBOM", false.ToString());
}
catch { }
Part.Update(Pdata);
Pdata = Part.GetByID(PartNumber);
}
DataList.UpdateDatum(Pdata, "Part", 0, "UseMaskSeq", true.ToString());
}
//retrieve the new copy of the data
Pdata = Part.GetByID(PartNumber);
if (whse_cbo.Items.Count > 0)
{
Part.Update(Pdata);
for (int i = 0; i < whse_cbo.Items.Count; i++)
{
whse_cbo.SelectedIndex = i;
DataList.UpdateDatum(Pdata, "PartPlant", 0, "PrimWhse", whse_cbo.SelectedValue.ToString());
DataList.UpdateDatum(Pdata, "PartPlant", 0, "PrimWhseDescription", whse_cbo.Text);
DataList.UpdateDatum(Pdata, "PartPlant", 0, "DBRowIdent", null);
//if (trackserial.Checked)
DataList.UpdateDatum(Pdata, "PartPlant", 0, "PartTrackSerialNum", trackserial.Checked.ToString());
}
if (trackserial.Checked)
{
Part.ChangePartSNBaseDataType("MASK", Pdata);
Part.ChangeSNMask(SerialMask, Pdata);
}
Part.Update(Pdata);
DataList.UpdateDatum(Pdata, "PartPlant", 0, "BackFlush", bflush_chk.Checked.ToString());
if (planner_cbo.Enabled)
{
DataList.UpdateDatum(Pdata, "PartPlant", 0, "PersonID", planner_cbo.Text);
DataList.UpdateDatum(Pdata, "PartPlant", 0, "PersonName", planner_cbo.Text);
}
//Update with warehouse information
Part.Update(Pdata);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
finally
{
DataList.EpicClose();
this.Close();
}
}
}
public static PartDataSet UpdateDatum(PartDataSet Part, string tableName, int rowNum, string colName, string Input)
{
try
{
Part.Tables[tableName].Rows[rowNum][colName] = Input;
return Part;
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message, "Error!", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return Part;
}
}
private void LoadData(PartDataSet pdata)
{
if (pdata.Tables[0].Rows[0]["Description"].ToString() != "")
Description_txt.Text = pdata.Tables[0].Rows[0]["Description"].ToString();
if (pdata.Tables[0].Rows[0]["PMT"].ToString() != "")
type_cbo.SelectedText = pdata.Tables[0].Rows[0]["PMT"].ToString();
if (pdata.Tables[0].Rows[0]["IUM"].ToString() != "")
uomclass_cbo.SelectedText = pdata.Tables[0].Rows[0]["IUM"].ToString();
if (decimal.Parse(pdata.Tables[0].Rows[0]["NetWeight"].ToString()) != 0)
NetWeight.Value = decimal.Parse(pdata.Tables[0].Rows[0]["NetWeight"].ToString());
if (pdata.Tables[0].Rows[0]["NetWeightUOM"].ToString() != "")
uomweight_cbo.SelectedText = pdata.Tables[0].Rows[0]["NetWeightUOM"].ToString();
trackserial.Checked = bool.Parse(pdata.Tables[0].Rows[0]["TrackSerialNum"].ToString());
qtybearing.Checked = bool.Parse(pdata.Tables[0].Rows[0]["QtyBearing"].ToString());
phantom_chk.Checked = bool.Parse(pdata.Tables[0].Rows[0]["PhantomBOM"].ToString());
userevision.Checked = bool.Parse(pdata.Tables[0].Rows[0]["UsePartRev"].ToString());
//Cannot change UOM after initial save, will cause all sorts of problems
uom_cbo.Enabled = false;
planner_cbo.Enabled = false;
}
public bool NewPart(SessionInfo _session, ProductsMasterModel model, out bool IsSucces, out string msgError)
{
//int iRunning = RunningPart();
//string PartNum = GetSerialByFormat(iRunning);
try
{
///TODO: Fix Epicor AppServer to workaround.
Session currSession = new Session(_session.UserID, _session.UserPassword, _session.AppServer, Session.LicenseType.Default);
Part myPart = new Part(currSession.ConnectionPool);
PartDataSet dsPart = new PartDataSet();
myPart.GetNewPart(dsPart);
DataRow drPart = dsPart.Tables[0].Rows[0];
drPart.BeginEdit();
drPart["PartNum"] = model.NorNum;
drPart["PartDescription"] = model.NorNum;
drPart["UOMClassID"] = "UCC";
drPart["IUM"] = (model.SizeLength > 0) ? "PCS" : "KG"; //Our UOM
drPart["PUM"] = (model.SizeLength > 0) ? "PCS" : "KG"; ; //Purchasing UOM
drPart["TypeCode"] = "M";
drPart["SalesUM"] = (model.SizeLength > 0) ? "PCS" : "KG"; ; //Sale UOM
drPart["ShortChar05"] = "M";
drPart["Number01"] = model.SizeThick;
drPart["Number02"] = model.SizeWidth;
drPart["Number03"] = model.SizeLength;
drPart["Number11"] = 1;
drPart["Number12"] = 1;
drPart["Character10"] = "N";
drPart["NetWeight"] = model.CoilWeigthMin;
drPart.EndEdit();
myPart.Update(dsPart);
currSession.Dispose();
IsSucces = true;
msgError = "";
}
catch (Exception ex)
{
IsSucces = false;
msgError = ex.Message;
return false;
}
return true;
}
public bool GetNewPart(MCSS model, Models.SessionInfo epiSession, out bool IsSucces, out string msgError)
{
try
{
Session currSession = new Session(epiSession.UserID, epiSession.UserPassword, epiSession.AppServer, Session.LicenseType.Default);
Part myPart = new Part(currSession.ConnectionPool);
bool partExst = false;
string whereClausePart = string.Format(@"Part.PartNum='{0}'", model.McssNum);
//whereClausePart.Replace("=\"","");
PartDataSet dsPart = new PartDataSet();
if (myPart.PartExists(model.McssNum))
{
dsPart = myPart.GetRows(whereClausePart, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", 0, 1, out partExst);
}
else
{
myPart.GetNewPart(dsPart);
}
DataRow drPart = dsPart.Tables[0].Rows[0];
drPart.BeginEdit();
drPart["PartNum"] = model.McssNum;
drPart["PartDescription"] = model.McssNum;
drPart["UOMClassID"] = "UCC";
drPart["TypeCode"] = "P";
drPart["IUM"] = (model.Length > 0) ? "PCS" : "KG"; //Our UOM
drPart["PUM"] = (model.Length > 0) ? "PCS" : "KG"; ; //Purchasing UOM
drPart["TypeCode"] = "M";
drPart["SalesUM"] = (model.Length > 0) ? "PCS" : "KG"; ; //Sale UOM
drPart["Character02"] = ""; //NCR No.
drPart["Character08"] = string.IsNullOrEmpty(model.CustID) ? "" : model.CustID;
drPart["Character10"] = ""; //Pack No.
drPart["ShortChar01"] = string.IsNullOrEmpty(model.CommodityCode) ? "" : model.CommodityCode;
drPart["ShortChar02"] = string.IsNullOrEmpty(model.MatSpec1) ? "" : model.MatSpec1;
drPart["ShortChar07"] = ""; //Old Stock No.
drPart["ShortChar09"] = string.IsNullOrEmpty(model.Coating1) ? "" : model.Coating1;
drPart["ShortChar10"] = "6"; //PartStatus = MCSS
drPart["Number01"] = model.Thick;
drPart["Number02"] = model.Width;
drPart["Number03"] = model.Length;
drPart["TrackLots"] = 1;
drPart["Number11"] = 1;
drPart["Number12"] = model.Pocession.GetInt();
drPart["Character10"] = "N";
drPart["NetWeight"] = model.WeightPerCoilMin.GetDecimal();
drPart.EndEdit();
myPart.Update(dsPart);
currSession.Dispose();
IsSucces = true;
msgError = "";
}
catch (Exception ex)
{
IsSucces = false;
msgError = ex.Message;
}
return IsSucces;
}
public static DataTable PartUOM(string PartNumber)
{
try
{
Part Part = new Part(EpicConn);
PartDataSet PartData = new PartDataSet();
PartData = Part.GetByID(PartNumber);
EpicClose();
return PartData.Tables["PartUOM"];
}
catch { return null; }
}
private void useselected_btn_Click(object sender, EventArgs e)
{
if (template_cbo.Text == "Other")
{
try
{
//Use text box part number
Part Part = new Part(DataList.EpicConn);
PartDataSet PData = new PartDataSet();
PData = Part.DuplicatePart(partnumber_txt.Text, _PartNumber, desc_txt.Text);
Part.Update(PData);
this.DialogResult = DialogResult.Ignore;
}
catch { }
}
else
{
//Use Listed Template
DataRow dr = eNGDataDataSet.Tables[0].Rows[template_cbo.SelectedIndex];
_Pdata.Description = dr["Desc"].ToString();
_Pdata.PMT = dr["Type"].ToString();
_Pdata.UOM_Class = dr["UOMClass"].ToString();
decimal fail = 0;
decimal.TryParse(dr["NetWeight"].ToString(), out fail);
_Pdata.Net_Weight = fail;
_Pdata.Net_Weight_UM = dr["UOMWeight"].ToString();
decimal.TryParse(dr["NetVol"].ToString(),out fail);
_Pdata.Net_Vol = fail;
_Pdata.Net_Vol_UM = dr["UOMVol"].ToString();
_Pdata.Primary_UOM = dr["UOM"].ToString();
_Pdata.PartGroup = dr["Group"].ToString();
_Pdata.PartClass = dr["Class"].ToString();
_Pdata.PartPlant = dr["Plant"].ToString();
_Pdata.PlantWhse = dr["Whse"].ToString();
}
this.Close();
}
public static string GetCurrentRev(string PartNumber)
{
try
{
Part Part = new Part(DataList.EpicConn);
PartDataSet PartData = new PartDataSet();
PartData = Part.GetByID(PartNumber);
int LastRowIndex = PartData.Tables["PartRev"].Rows.Count - 1;
string PartRev = PartData.Tables["PartRev"].Rows[LastRowIndex]["RevisionNum"].ToString();
EpicClose();
return PartRev;
}
catch { return ""; }
}
public bool NewPartCollection(NewPartModel model, Session epiSession, out bool IsSucces, out string msgError)
{
try
{
Part myPart = new Part(epiSession.ConnectionPool);
PartDataSet dsPart = new PartDataSet();
myPart.GetNewPart(dsPart);
DataRow drPart = dsPart.Tables[0].Rows[0];
drPart.BeginEdit();
drPart["PartNum"] = model.SerialNo;
drPart["PartDescription"] = model.SerialNo; ;
drPart["UOMClassID"] = "COUNT";
drPart["IUM"] = "KG";
drPart["PUM"] = "KG";
drPart["TypeCode"] = "M";
drPart["SalesUM"] = "KG";
drPart["UserChar4"] = string.IsNullOrEmpty(model.SupplierCode) ? "" : model.SupplierCode;
drPart["UnitPrice"] = model.Amount;
drPart["Character01"] = string.IsNullOrEmpty(model.SaleContract) ? "" : model.SaleContract;
drPart["Character03"] = string.IsNullOrEmpty(model.NGRemark) ? "-" : model.NGRemark;
drPart["Character07"] = model.ArticleNo;
drPart["Character07"] = model.CustID;
drPart["Number10"] = model.Quantity;
drPart["Date01"] = DateTime.Now;
drPart["ShortChar01"] = string.IsNullOrEmpty(model.CommodityCode) ? "" : model.CommodityCode;
drPart["ShortChar02"] = string.IsNullOrEmpty(model.SpecCode) ? "" : model.SpecCode;
drPart["ShortChar04"] = string.IsNullOrEmpty(model.BussinessType) ? "" : model.BussinessType;
drPart["ShortChar05"] = string.IsNullOrEmpty(model.MakerCode) ? "" : model.MakerCode;
drPart["ShortChar06"] = string.IsNullOrEmpty(model.MillCode) ? "" : model.MillCode;
drPart["Character07"] = string.IsNullOrEmpty(model.ArticleNo) ? "" : model.ArticleNo;
drPart["Number18"] = model.iRunning;
drPart["ShortChar09"] = string.IsNullOrEmpty(model.CoatingCode) ? "" : model.CoatingCode;
drPart["Number01"] = model.Thick;
drPart["Number02"] = model.Width;
drPart["Number03"] = model.Length;
drPart["Number11"] = 1;
drPart["Number12"] = 1;
if (model.NGStatus == 1)
{
drPart["Character10"] = "N";
}
else
{
drPart["Character10"] = "B";
}
drPart["NetWeight"] = model.Weight;
drPart.EndEdit();
myPart.Update(dsPart);
IsSucces = true;
msgError = "";
}
catch (Exception ex)
{
IsSucces = false;
msgError = ex.Message;
}
return IsSucces;
}
public static bool CreatePartRevision(string PartNumber, string CurrentRev, string NewRev, string RevDesc)
{
bool _results;
try
{
Part Part = new Part(DataList.EpicConn);
PartDataSet PartData = new PartDataSet();
PartData = Part.GetByID(PartNumber);
Part.GetNewPartRev(PartData, PartNumber, CurrentRev);
int Y = PartData.Tables["PartRev"].Rows.Count - 1;
DataList.UpdateDatum(PartData, "PartRev", Y, "RevShortDesc", RevDesc);
DataList.UpdateDatum(PartData, "PartRev", Y, "RevisionNum", NewRev);
DataList.UpdateDatum(PartData, "PartRev", Y, "AltMethod", "");
Part.Update(PartData);
_results = true;
}
catch { _results = false; }
finally
{
EpicClose();
}
return _results;
}
public string NewPart(NewPartModel model, SessionInfo epiSession, int StoreInNo, out bool IsSucces, out string msgError)
{
int iRunning = RunningPart();
string PartNum = GetSerialByFormat(iRunning);
try
{
Session currSession = new Session(epiSession.UserID, epiSession.UserPassword, epiSession.AppServer, Session.LicenseType.Default);
Part myPart = new Part(currSession.ConnectionPool);
PartDataSet dsPart = new PartDataSet();
myPart.GetNewPart(dsPart);
DataRow drPart = dsPart.Tables[0].Rows[0];
drPart.BeginEdit();
drPart["PartNum"] = PartNum;
drPart["PartDescription"] = PartNum;
drPart["UOMClassID"] = "COUNT";
drPart["IUM"] = "KG";
drPart["PUM"] = "KG";
drPart["TypeCode"] = "M";
drPart["SalesUM"] = "KG";
drPart["UserChar4"] = model.SupplierCode;
drPart["UnitPrice"] = model.Amount;
drPart["Character01"] = model.SaleContract;
drPart["Character03"] = model.NGRemark;
drPart["Character07"] = model.ArticleNo;
drPart["Character07"] = model.CustID;
drPart["Number10"] = model.Quantity;
drPart["Date01"] = DateTime.Now;
drPart["ShortChar01"] = string.IsNullOrEmpty(model.CommodityCode) ? "" : model.CommodityCode;
drPart["ShortChar02"] = string.IsNullOrEmpty(model.SpecCode) ? "" : model.SpecCode;
drPart["ShortChar04"] = model.BussinessType;
drPart["ShortChar05"] = model.MakerCode;
drPart["ShortChar06"] = model.MillCode;
drPart["Character07"] = model.ArticleNo;
drPart["ShortChar08"] = iRunning;
drPart["ShortChar09"] = model.CoatingCode;
drPart["Number01"] = model.Thick;
drPart["Number02"] = model.Width;
drPart["Number03"] = model.Length;
drPart["Number11"] = 1;
drPart["Number12"] = 1;
if (model.NGStatus == 1)
{
drPart["Character10"] = "N";
}
else
{
drPart["Character10"] = "B";
}
drPart["NetWeight"] = model.Weight;
drPart.EndEdit();
myPart.Update(dsPart);
currSession.Dispose();
UpdateStock(PartNum, model.Quantity);
IsSucces = true;
msgError = "";
}
catch (Exception ex)
{
IsSucces = false;
msgError = ex.Message;
}
return PartNum;
}
private PartDataSet UpdateDataSet(PartDataSet Pdata, DataViewRowState RowState)
{
Part Part = new Part(DataList.EpicConn);
DataList.AddDatum(Pdata, "Part", 0, "PartDescription", Description_txt.Text,RowState);
if (RowState == DataViewRowState.Unchanged)
RowState = DataViewRowState.ModifiedCurrent;
//SearchWord has 8 character limit
if (Description_txt.Text.Length > 8)
DataList.AddDatum(Pdata, "Part", 0, "SearchWord", Description_txt.Text.Substring(0, 8), RowState);
else
DataList.AddDatum(Pdata, "Part", 0, "SearchWord", Description_txt.Text, RowState);
DataList.AddDatum(Pdata, "Part", 0, "NetWeight", NetWeight.Text, RowState);
DataList.AddDatum(Pdata, "Part", 0, "NetWeightUOM", uomweight_cbo.SelectedValue.ToString(), RowState);
DataList.AddDatum(Pdata, "Part", 0, "IUM", uom_cbo.SelectedValue.ToString(), RowState);
DataList.AddDatum(Pdata, "Part", 0, "ClassID", class_cbo.SelectedValue.ToString(), RowState);
DataList.AddDatum(Pdata, "Part", 0, "QtyBearing", qtybearing.Checked.ToString(), RowState);
DataList.AddDatum(Pdata, "Part", 0, "UsePartRev", userevision.Checked.ToString(), RowState);
DataList.AddDatum(Pdata, "Part", 0, "PhantomBOM", phantom_chk.Checked.ToString(), RowState);
string Type_Code = type_cbo.SelectedItem.ToString();
Part.ChangePartTypeCode(Type_Code, Pdata);
Part.ChangePartProdCode(group_cbo.SelectedValue.ToString(), Pdata);
//add trackserial number if necessary
if (trackserial.Checked && (SerialPrefix != "" || SerialPrefix != null))
{
if (SerialPrefix == "" || SerialPrefix == null)
MessageBox.Show("Cannot use null serial prefix. Set the prefix or uncheck 'Track Serial Number'", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
else
{
DataList.AddDatum(Pdata, "Part", 0, "EnableSerialNum", trackserial.Checked.ToString(), RowState);
DataList.AddDatum(Pdata, "Part", 0, "TrackSerialNum", trackserial.Checked.ToString(), RowState);
Part.ChangePartSNBaseDataType("MASK", Pdata);
Part.ChangeSNMask(SerialMask, Pdata);
Part.ChangePartSNMaskPrefixSuffix(SerialPrefix, "", Pdata);
}
}
return Pdata;
}
public void IssueMtl(int AssembleySeq, int MtlSeq, string PartNum, decimal QtyPer)
{
string JobNum = this.Jobnumber;
JobMtlSearchDataSet jobmtlDS = new JobMtlSearchDataSet();
JobMtlSearch jobmtlsearch = new JobMtlSearch(Program.SConnPool.ConnectionPool);
try
{
jobmtlDS = jobmtlsearch.GetByID(
JobNum,
AssembleySeq,
MtlSeq);
}
catch (Exception e)
{
MessageBox.Show("[Job.IssueMtl]" + e.Message + "\n" +
e.InnerException.Message + "\n----\n" + JobNum.ToString() +
" / " + AssembleySeq.ToString() + " / " + MtlSeq.ToString());
return;
}
IssueReturn ir = new IssueReturn(Program.SConnPool.ConnectionPool);
IssueReturnDataSet irds = new IssueReturnDataSet();
string pcmsg = "";
ir.GetNewIssueReturnToJob(JobNum, AssembleySeq, "STK-MTL", "SwiftScan", out pcmsg, irds);
irds.IssueReturn[0]["PartNum"] = PartNum;
ir.OnChangePartNum(irds, "SwiftScan");
irds.IssueReturn[0]["TranQty"] = QtyPer;
Part partx = new Part(Program.SConnPool.ConnectionPool);
PartDataSet partDS = new PartDataSet();
bool reqinp;
string msg = "";
string allmsg = "";
partDS = partx.GetByID(PartNum);
irds.IssueReturn[0]["TranDate"] = DateTime.Now;
irds.IssueReturn[0]["DimCode"] = partDS.Part.Rows[0]["IUM"].ToString();
irds.IssueReturn[0]["FromWareHouseCode"] = "STORES"; //TODO: Ask Chris about this tooooo
irds.IssueReturn[0]["FromBinNum"] = "001";
irds.IssueReturn[0]["QtyRequired"] =
Convert.ToDecimal(QtyPer);
irds.IssueReturn[0]["ToJobSeq"] = MtlSeq;
irds.IssueReturn[0]["ToWarehouseCode"] = "STORES";
irds.IssueReturn[0]["ToBinNum"] = "001";
irds.IssueReturn[0]["ToJobSeqPartNum"] = PartNum;
irds.IssueReturn[0]["IssuedComplete"] = "true";
irds.IssueReturn[0]["DimConvFactor"] = 1;
irds.IssueReturn[0]["FromJobPlant"] = "MfgSys";
irds.IssueReturn[0]["ToJobPlant"] = "MfgSys";
irds.IssueReturn[0]["ProcessID"] = "SwiftScan";
irds.IssueReturn[0]["OnHandUM"] = partDS.Part.Rows[0]["IUM"].ToString();
irds.IssueReturn[0]["TranReference"] = "Assigned from SwiftScan";
irds.IssueReturn[0]["UM"] = partDS.Part.Rows[0]["IUM"].ToString();
irds.IssueReturn[0]["PartIUM"] = partDS.Part.Rows[0]["IUM"].ToString();
irds.IssueReturn[0]["RequirementUOM"] = partDS.Part.Rows[0]["IUM"].ToString();
irds.IssueReturn[0]["ToJobNum"] = JobNum;
irds.IssueReturn[0]["ToJobPartNum"] = JobNum;
ir.OnChangeTranQty(Convert.ToDecimal(QtyPer), irds);
ir.PrePerformMaterialMovement(irds, out reqinp);
if (reqinp == true)
{
MessageBox.Show("Requires Input");
}
string neg1, neg2;
ir.NegativeInventoryTest(
PartNum,
"STORES",
"001",
"",
"",
0,
QtyPer,
out neg1,
out neg2);
try
{
ir.PerformMaterialMovement(true, irds, out msg, out allmsg);
}
catch (Exception em)
{
MessageBox.Show(em.Message + "\n" + em.InnerException.Message);
throw;
}
allmsg += msg;
}
private void UpdateFormSet(string Pnum)
{
trackserial.CheckedChanged -= trackserial_CheckedChanged;
Part Part = new Part(DataList.EpicConn);
PartDataSet Pdata = new PartDataSet();
Pdata = Part.GetByID(Pnum);
Description_txt.Text = Pdata.Tables["Part"].Rows[0]["PartDescription"].ToString();
NetWeight.Value = decimal.Parse(Pdata.Tables["Part"].Rows[0]["NetWeight"].ToString());
uomweight_cbo.SelectedValue = Pdata.Tables["Part"].Rows[0]["NetWeightUOM"].ToString();
uom_cbo.SelectedValue = Pdata.Tables["Part"].Rows[0]["IUM"].ToString();
class_cbo.SelectedValue = Pdata.Tables["Part"].Rows[0]["ClassID"].ToString();
type_cbo.SelectedValue = Pdata.Tables["Part"].Rows[0]["TypeCode"].ToString();
group_cbo.SelectedValue = Pdata.Tables["Part"].Rows[0]["ProdCode"].ToString();
//Should set backflush flag correctly on load now.
bflush_chk.Checked = bool.Parse(Pdata.Tables["PartPlant"].Rows[0]["Backflush"].ToString());
trackserial.Checked = bool.Parse(Pdata.Tables[0].Rows[0]["TrackSerialNum"].ToString());
qtybearing.Checked = bool.Parse(Pdata.Tables[0].Rows[0]["QtyBearing"].ToString());
phantom_chk.Checked = bool.Parse(Pdata.Tables[0].Rows[0]["PhantomBOM"].ToString());
userevision.Checked = bool.Parse(Pdata.Tables[0].Rows[0]["UsePartRev"].ToString());
whse_cbo.DataSource = Pdata.Tables["PartWhse"];
whse_cbo.DisplayMember = "WarehouseDescription";
whse_cbo.ValueMember = "WarehouseCode";
for (int i = 0; i < Pdata.Tables["PartPlant"].Rows.Count; i++)
{
if (Pdata.Tables["PartPlant"].Rows[i]["Plant"].ToString() == "MfgSys")
planner_cbo.Text = Pdata.Tables["PartPlant"].Rows[i]["PersonID"].ToString();
}
SerialPrefix = Pdata.Tables[0].Rows[0]["SNMaskPrefix"].ToString();
SerialMask = Pdata.Tables[0].Rows[0]["SNMask"].ToString();
trackserial.CheckedChanged += trackserial_CheckedChanged;
}
private void savebtn_Click(object sender, EventArgs e)
{
try
{
//Commit Part Changes
Part Part = new Part(DataList.EpicConn);
PartDataSet Pdata = new PartDataSet();
//Pdata = (PartDataSet)DL.PartSearchDataSet("");
string serialWarning;
string questionString;
bool multipleMatch;
string PartNumber = Partnumber_txt.Text;
Part.GetPartXRefInfo(ref PartNumber, "", "", out serialWarning, out questionString, out multipleMatch);
if (!multipleMatch)
{
Part.GetNewPart(Pdata);
Part.ChangePartNum(PartNumber, Pdata);
DataList.AddDatum(Pdata, "Part", 0, "PartDescription", Description_txt.Text);
//SearchWord has 8 character limit
if (Description_txt.Text.Length > 8)
DataList.AddDatum(Pdata, "Part", 0, "SearchWord", Description_txt.Text.Substring(0, 8));
else
DataList.AddDatum(Pdata, "Part", 0, "SearchWord", Description_txt.Text);
DataList.AddDatum(Pdata, "Part", 0, "NetWeight", NetWeight.Text);
DataList.AddDatum(Pdata, "Part", 0, "NetWeightUOM", uomweight_cbo.SelectedValue.ToString());
//DataList.AddDatum(Pdata, "Part", 0, "NetVolume", NetVolume.Text);
//DataList.AddDatum(Pdata, "Part", 0, "NetVolumeUOM", uomvol_cbo.SelectedValue.ToString());
DataList.AddDatum(Pdata, "Part", 0, "IUM", uom_cbo.SelectedValue.ToString());
DataList.AddDatum(Pdata, "Part", 0, "ClassID", class_cbo.SelectedValue.ToString());
string Type_Code = type_cbo.SelectedItem.ToString();
Part.ChangePartTypeCode(Type_Code, Pdata);
Part.ChangePartProdCode(group_cbo.SelectedValue.ToString(), Pdata);
//Add data to allow BO to create plant tables
Part.Update(Pdata);
//retrieve the new copy of the data
Pdata = Part.GetByID(PartNumber);
DataList.UpdateDatum(Pdata, "PartPlant", 0, "PrimWhse", whse_cbo.SelectedValue.ToString());
DataList.UpdateDatum(Pdata, "PartPlant", 0, "PrimWhseDescription", whse_cbo.Text);
DataList.UpdateDatum(Pdata, "PartPlant", 0, "DBRowIdent", null);
//Update with warehouse information
Part.Update(Pdata);
DataList.EpicClose();
}
else
{
MessageBox.Show("Part already exists in database! Use revision to make changes.");
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
finally
{
this.Close();
}
}
