private void frmPlanProtCpature_Load(object sender, EventArgs e) { updateSecurity(); barCaptureOptions.EditValue = "1"; captureOption = "1"; barProdMonth.EditValue = TProductionGlobal.ProdMonthAsDate(TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).CurrentProductionMonth.ToString()); btnUnlockData.Enabled = true; CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = this.theSystemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; if (BMEBL.get_ReviseActivity() == true) { editActitivity.DataSource = BMEBL.ResultsDataTable; editActitivity.DisplayMember = "Desc"; editActitivity.ValueMember = "Code"; } LoadSections(); }
public void LoadMiningMethod() { CPMBusinessLayer.clsBusinessLayer bl = new CPMBusinessLayer.clsBusinessLayer(); bl.SetsystemDBTag = this.systemDBTag; bl.SetUserCurrentInfo = this.UserCurrentInfo; tblMiningMethods = bl.getMiningMethods(Activity); }
private void frmResavePlanningProtocol_Load(object sender, EventArgs e) { //string ThePath = System.Environment.GetFolderPath(System.Environment.SpecialFolder.LocalApplicationData); //string path = string.Format(@"{0}\{1}_{2}.txt", ThePath, r["Prodmonth"], r["WorkPlaceID"]); //MessageBox.Show(ThePath); mwProdmonthEdit1.EditValue = TProductionGlobal.ProdMonthAsDate(TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).CurrentProductionMonth.ToString()); CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = this.theSystemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; if (BMEBL.get_Activity() == true) { // this.tscbShaft.Items.Add("MINE"); editActivity.Properties.DataSource = BMEBL.ResultsDataTable; editActivity.Properties.DisplayMember = "Desc"; editActivity.Properties.ValueMember = "Code"; editActivity.ItemIndex = 0; } updateSections(TProductionGlobal.ProdMonthAsString(Convert.ToDateTime(mwProdmonthEdit1.EditValue)), editActivity.EditValue.ToString()); DataStructure(); }
private void ucGradeReport_Load(object sender, EventArgs e) { reportSettings.ReportDate = DateTime.Now; reportSettings.Paylimit = 1330; reportSettings.ShiftsNo = 2; reportSettings.CutOffGrade = 860; reportSettings.useShiftsDefault = true; reportSettings.useShifts = false; reportSettings.TopPanels = "Gold"; CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = this.theSystemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; DataTable dtActivityData = BMEBL.GetActivity(); rpActivity.DataSource = dtActivityData; rpActivity.DisplayMember = "Description"; rpActivity.ValueMember = "Activity"; setScreenSelection(); pgGradeReport.SelectedObject = reportSettings; }
public void StopWorkplace(String WorkplaceID, int ProdMonth, string SectionID, string SectionID_2) { txtWorkplaceID.Text = WorkplaceID; txtProdMonth.Text = Convert.ToString(ProdMonth); theSectionID = SectionID; theSectionID_2 = SectionID_2; _clChnageOfPlanData.SetProdMonth(Convert.ToInt32(ProdMonth)); _clChnageOfPlanData.SetWorkplaceID(WorkplaceID); _clChnageOfPlanData.SetSectionID(SectionID); _clChnageOfPlanData.SetSectionID_2(SectionID_2); _clChnageOfPlanData.SetRequestType((int)replanningType.rpStartWP); CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = this.theSystemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; DataTable theDates = new DataTable(); if (BMEBL.get_BeginEndDates(SectionID_2, ProdMonth.ToString()) == true) { theDates = BMEBL.ResultsDataTable; } DateTime theBeginDate = new DateTime(); DateTime theEndDate = new DateTime(); foreach (DataRow r in theDates.Rows) { theBeginDate = Convert.ToDateTime(r["StartDate"].ToString()); theEndDate = Convert.ToDateTime(r["EndDate"].ToString()); } dateStart.Properties.MaxValue = theEndDate; dateStart.Properties.MinValue = theBeginDate; MWDataManager.clsDataAccess _WPData = new MWDataManager.clsDataAccess(); _WPData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _WPData.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _WPData.queryReturnType = MWDataManager.ReturnType.DataTable; _WPData.SqlStatement = "SELECT * FROM WORKPLACE WHERE WORKPLACEID = '" + WorkplaceID + "'"; _WPData.ExecuteInstruction(); foreach (DataRow r in _WPData.ResultsDataTable.Rows) { txtWorkplaceName.Text = r["DESCRIPTION"].ToString(); } _WPData.SqlStatement = "SELECT DISTINCT Name_2 FROM dbo.SECTION_COMPLETE WHERE PRODMONTH = '" + Convert.ToString(ProdMonth) + "' AND SECTIONID_2 = '" + SectionID_2 + "'"; _WPData.ExecuteInstruction(); foreach (DataRow r in _WPData.ResultsDataTable.Rows) { txtSection.Text = r["Name_2"].ToString(); // _clChnageOfPlanData.SetSectionID(Convert.ToInt32(txtSection.EditValue)); } loadCurrentValues(WorkplaceID, ProdMonth, SectionID, SectionID_2, false); }
private void LoadSundryMiningDescription() { CPMBusinessLayer.clsBusinessLayer bl = new CPMBusinessLayer.clsBusinessLayer(); bl.SetsystemDBTag = this.theSystemDBTag; bl.SetUserCurrentInfo = this.UserCurrentInfo; SundryMining.DataSource = bl.getSundryMiningActivity(2); SundryMining.DisplayMember = "SMDescription"; SundryMining.ValueMember = "SMDescription"; }
private void LoadMiningMethod() { CPMBusinessLayer.clsBusinessLayer bl = new CPMBusinessLayer.clsBusinessLayer(); bl.SetsystemDBTag = this.theSystemDBTag; bl.SetUserCurrentInfo = this.UserCurrentInfo; reActivity.DataSource = bl.getMiningMethods(2); reActivity.DisplayMember = "Description"; reActivity.ValueMember = "TargetID"; }
private void ucPlannedVsBooked_Load(object sender, EventArgs e) { try { reportSettings.Type = "Tons"; reportSettings.ShowType = "Both"; reportSettings.CastType = "Both"; reportSettings.MSType = "All"; reportSettings.WhatMonth = "Production Month"; CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = this.theSystemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; DataTable dtActivityData = BMEBL.GetActivityReports(); rpActivity.DataSource = dtActivityData; rpActivity.DisplayMember = "Desc"; rpActivity.ValueMember = "Code"; reportSettings.UserCurrentInfo = this.UserCurrentInfo; reportSettings.systemDBTag = this.theSystemDBTag; reportSettings.pmonth = TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).CurrentProductionMonth.ToString(); int theYear = Convert.ToInt32(reportSettings.pmonth.Substring(0, 4)); int theMonth = Convert.ToInt32(reportSettings.pmonth.Substring(4, 2)); DateTime theDate = new DateTime(theYear, theMonth, 1); reportSettings.Prodmonth = theDate.Date; reportSettings.UpdateSumOnRequest += reportSettings_UpdateSumOnRequest; reportSettings.Showuntil = DateTime.Now; iShowuntil.Properties.Value = reportSettings.Showuntil; reportSettings.Desc = "0"; iProdmonth.Properties.Value = reportSettings.Prodmonth.ToString(); DataTable dtSectionData = new DataTable(); if (BMEBL.GetPlanSectionsAndNameADO(reportSettings.pmonth) == true) { dtSectionData = BMEBL.ResultsDataTable; rpSectionid.DataSource = BMEBL.ResultsDataTable; rpSectionid.DisplayMember = "NAME"; rpSectionid.ValueMember = "NAME"; } reportSettings.NAME = dtSectionData.Rows[0]["NAME"].ToString(); pgPlanVsBookSettings.SelectedObject = reportSettings; } catch (Exception) { throw; } }
private void ucRevisedPlanningAuditReport_Load(object sender, EventArgs e) { CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = this.theSystemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; reportSettings.FromProdmonth = TProductionGlobal.ProdMonthAsDate(TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).CurrentProductionMonth.ToString()); reportSettings.ToProdmonth = TProductionGlobal.ProdMonthAsDate(TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).CurrentProductionMonth.ToString()); DataTable section = new DataTable(); if (BMEBL.GetPlanSectionsAndNameADO(TProductionGlobal.ProdMonthAsString(reportSettings.FromProdmonth)) == true) { section = BMEBL.ResultsDataTable; rpSection.DataSource = BMEBL.ResultsDataTable; rpSection.DisplayMember = "NAME"; rpSection.ValueMember = "sectionid"; } reportSettings.sectionid = section.Rows[0]["sectionid"].ToString(); reportSettings.RevisedPlanningType = "All"; MWDataManager.clsDataAccess _RevisedOptions = new MWDataManager.clsDataAccess(); _RevisedOptions.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _RevisedOptions.SqlStatement = "SELECT 0 Code, 'All' [RevisedPlanningType] " + "UNION " + "SELECT 1 Code, 'Stop Workplace' [RevisedPlanningType] " + "union " + "select 2 Code, 'New Workplace' [RevisedPlanningType] " + "union " + "select 3 Code, 'Crew Miner Changes' [RevisedPlanningType] " + "union " + "select 4 Code, 'Call Changes' [RevisedPlanningType] " + "union " + "select 5 Code, 'Move Planning' [RevisedPlanningType] " + "union " + "select 6 Code, 'Start Workplace' [RevisedPlanningType] " + "union " + "select 7 Code, 'Mining Method Change' [RevisedPlanningType] " + "union " + "select 8 Code, 'Drill Rig Change' [RevisedPlanningType] " + "union " + "select 9 Code, 'Delete Planning' [RevisedPlanningType] "; _RevisedOptions.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _RevisedOptions.queryReturnType = MWDataManager.ReturnType.DataTable; _RevisedOptions.ExecuteInstruction(); rpRevisedPlanningType.DataSource = _RevisedOptions.ResultsDataTable; rpRevisedPlanningType.DisplayMember = "RevisedPlanningType"; rpRevisedPlanningType.ValueMember = "RevisedPlanningType"; pgRevisedPlanningAudit.SelectedObject = reportSettings; }
public void updateSections(string prodMonth, string activity) { CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = this.theSystemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; if (BMEBL.get_SectionsReportsNotSaved(prodMonth, activity) == true) { // this.tscbShaft.Items.Add("MINE"); lcSections.DataSource = BMEBL.ResultsDataTable; lcSections.DisplayMember = "NAME"; lcSections.ValueMember = "SECTIONID"; } }
private void setSections() { CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = this.theSystemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; if (BMEBL.get_Sections(Convert.ToString(prodmonth1.EditValue), TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).MOHierarchicalID.ToString()) == true) { editSection.DataSource = BMEBL.ResultsDataTable; editSection.DisplayMember = "Name"; editSection.ValueMember = "SectionID"; } }
public void updateSections(int prodMonth) { CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = this.theSystemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; if (BMEBL.get_Sections(Convert.ToString(prodMonth), TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).MOHierarchicalID.ToString()) == true) { editMineoverseer1.DataSource = BMEBL.ResultsDataTable; editMineoverseer1.DisplayMember = "Name"; editMineoverseer1.ValueMember = "Name"; } }
private void AddWorkplace(string WPDesc) { MWDataManager.clsDataAccess _NewWorkPlace = new MWDataManager.clsDataAccess(); _NewWorkPlace.ConnectionString = TConnections.GetConnectionString(systemDBTag, UserCurrentInfo.Connection); _NewWorkPlace.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure; _NewWorkPlace.queryReturnType = MWDataManager.ReturnType.DataTable; // _NewWorkPlace.SqlStatement = "spAddPrePlanningWorkPlace"; _NewWorkPlace.SqlStatement = "sp_PrePlanning_AddWorkplace"; SqlParameter[] _paramCollection = { _NewWorkPlace.CreateParameter("@Prodmonth", SqlDbType.Int, 0, Convert.ToInt32(PlanningSettings.ProdMonth)), _NewWorkPlace.CreateParameter("@Sectionid_2", SqlDbType.VarChar, 20, PlanningSettings.MOSectionID), _NewWorkPlace.CreateParameter("@WPDESCRIPTION", SqlDbType.VarChar, 100, WPDesc), _NewWorkPlace.CreateParameter("@ActivityCode", SqlDbType.Int, 0, PlanningSettings.ActivityID), }; _NewWorkPlace.ParamCollection = _paramCollection; clsDataResult exr = _NewWorkPlace.ExecuteInstruction(); if (exr.success == false) { MessageBox.Show(exr.Message); } if (_NewWorkPlace.ResultsDataTable.Rows.Count != 0) { CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = systemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; // DataTable theDates = new DataTable(); if (BMEBL.get_BeginEndDates(PlanningSettings.MOSectionID, PlanningSettings.ProdMonth) == true) { theDates = BMEBL.ResultsDataTable; } if (_NewWorkPlace.ResultsDataTable.Rows.Count > 0) { foreach (DataRow r in _NewWorkPlace.ResultsDataTable.Rows) { tblPlanningData.ImportRow(r); } } } }
private void ucProblemAnalysisReport_Load(object sender, EventArgs e) { ActiveReport.UserCurrentInfo = this.UserCurrentInfo; reportSettings.FromProdmonth = TProductionGlobal.ProdMonthAsDate(TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).CurrentProductionMonth.ToString()); reportSettings.ToProdmonth = TProductionGlobal.ProdMonthAsDate(TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).CurrentProductionMonth.ToString()); reportSettings.FromDate = TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).Rundate; reportSettings.ToDate = TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).Rundate; reportSettings.Period = "Prodmonth"; reportSettings.Sections = "Single"; reportSettings.Activity = "Stoping"; reportSettings.Type = "ProbDesc"; reportSettings.GraphInfo = "Potential"; reportSettings.Available = GetAvailableList(); reportSettings.Details = false; reportSettings.DetailsGraph = false; reportSettings.TrendGraph = false; reportSettings.PerShaft = false; reportSettings.LostBlasts = false; iFromProdmonth.Visible = true; iToProdmonth.Visible = true; iToDate.Visible = false; iFromDate.Visible = false; iSectionSelect.Enabled = false; GetAvailableData(); CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = this.theSystemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; _pmonth = TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).CurrentProductionMonth.ToString(); DataTable section = new DataTable(); if (BMEBL.GetPlanSectionsAndNameADO(_pmonth) == true) { section = BMEBL.ResultsDataTable; riSectionSingle.DataSource = BMEBL.ResultsDataTable; riSectionSingle.DisplayMember = "NAME"; riSectionSingle.ValueMember = "NAME"; } reportSettings.NAME = section.Rows[0]["NAME"].ToString(); pgProblemAnalysis.SelectedObject = reportSettings; }
public void DeleteWorkplace(string WorkplaceID, int ProdMonth, string SectionID, string SectionID_2, int activity) { theActivity = activity; txtWorkplaceID.Text = WorkplaceID; txtProdMonth.Text = Convert.ToString(ProdMonth); theSectionID = SectionID; theSectionID_2 = SectionID_2; _clChnageOfPlanData.SetSectionID(SectionID); _clChnageOfPlanData.SetSectionID_2(SectionID_2); _clChnageOfPlanData.SetProdMonth(Convert.ToInt32(txtProdMonth.Text)); _clChnageOfPlanData.SetWorkplaceID(txtWorkplaceID.Text); _clChnageOfPlanData.SetRequestType((int)replanningType.rpDeleteWorkplace); CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; DataTable theDates = new DataTable(); BMEBL.SetsystemDBTag = theSystemDBTag; BMEBL.SetUserCurrentInfo = UserCurrentInfo; MWDataManager.clsDataAccess _WPData = new MWDataManager.clsDataAccess(); _WPData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _WPData.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _WPData.queryReturnType = MWDataManager.ReturnType.DataTable; _WPData.SqlStatement = "SELECT * FROM WORKPLACE WHERE WORKPLACEID = '" + WorkplaceID + "'"; _WPData.ExecuteInstruction(); foreach (DataRow r in _WPData.ResultsDataTable.Rows) { txtWorkplaceName.Text = r["DESCRIPTION"].ToString(); } _WPData.SqlStatement = "SELECT DISTINCT Name_2 FROM dbo.SECTION_COMPLETE WHERE PRODMONTH = '" + Convert.ToString(ProdMonth) + "' AND SECTIONID_2 = '" + SectionID_2 + "'"; _WPData.ExecuteInstruction(); foreach (DataRow r in _WPData.ResultsDataTable.Rows) { txtSection.Text = r["Name_2"].ToString(); } CPMBusinessLayer.clsBusinessLayer BMEBL1 = new CPMBusinessLayer.clsBusinessLayer(); BMEBL1._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL1.SetsystemDBTag = this.theSystemDBTag; BMEBL1.SetUserCurrentInfo = this.UserCurrentInfo; loadCurrentValues(WorkplaceID, ProdMonth, SectionID, SectionID_2, false); }
private void editRovingCrew_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = this.theSystemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; if (BMEBL.get_reOrgDaySelection(theProdmonth, theSectionID_2) == true) { editRovingCrew.Properties.DataSource = BMEBL.ResultsDataTable; editRovingCrew.Properties.DisplayMember = "Crew_Org"; editRovingCrew.Properties.ValueMember = "Crew_Org"; } editRovingCrew.Text = editRovingCrew.SelectedText; }
public void LoadSections() { CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = this.theSystemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; DataTable dtSectionData = new DataTable(); if (BMEBL.GetPlanSectionsAndNameADO(TProductionGlobal.ProdMonthAsString(reportSettings.Prodmonth)) == true) { dtSectionData = BMEBL.ResultsDataTable; riSection.DataSource = BMEBL.ResultsDataTable; riSection.DisplayMember = "NAME"; riSection.ValueMember = "sectionid"; } reportSettings.NAME = dtSectionData.Rows[0]["sectionid"].ToString(); }
/// <summary> /// Updates the sections list for the selected production month /// </summary> public void updateSections() { CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = systemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; List <string> Thelist = TProductionGlobal.getUserInfo(UserCurrentInfo.Connection).PlanBookSections; DataTable _SectionResult = new DataTable(); GetSectionsAndName theData = new GetSectionsAndName(); theData.theSystemDBTag = systemDBTag; theData.UserCurrentInfo = UserCurrentInfo; List <string> sections = TProductionGlobal.getUserInfo(UserCurrentInfo.Connection).PlanBookSections; foreach (string item in sections) { MWDataManager.clsDataAccess temp = theData.theSectionsAndName(_prodMonth, item, TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).MOHierarchicalID); temp.ExecuteInstruction(); if (temp.ResultsDataTable.Rows.Count != 0) { if (_SectionResult.Columns.Count == 0) { _SectionResult = temp.ResultsDataTable.Clone(); } _SectionResult.Merge(temp.ResultsDataTable); } } tblSections = _SectionResult; //} //if (BMEBL.get_Sections(Convert.ToString(_prodMonth), TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).MOHierarchicalID.ToString()) == true) //{ // tblSections = BMEBL.ResultsDataTable.Clone(); // tblSections = BMEBL.ResultsDataTable.Copy(); //} }
/// <summary> /// Gest the current sections calendar dates start and end /// </summary> public clsResults ValidateSectionCalender() { clsResults theResults = new clsResults(); tblSectionStartEndDates = new DataTable(); CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = systemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; if (BMEBL.get_MinerSectionStartEndDates(PlanningSettings.ProdMonth, PlanningSettings.MOSectionID) == true) { tblSectionStartEndDates = BMEBL.ResultsDataTable; } if (tblSectionStartEndDates != null && tblSectionStartEndDates.Rows.Count > 0) { foreach (DataRow r in tblSectionStartEndDates.Rows) { if (r["StartDate"].ToString() != "") // test if dates are valid { theBeginDate = Convert.ToDateTime(r["StartDate"].ToString()); theEndDate = Convert.ToDateTime(r["EndDate"].ToString()); theResults.Successfull = true; } else { theResults.Successfull = false; theResults.Message.AppendLine("The calendars for the selected section is invalid"); } } } else { theResults.Successfull = false; theResults.Message.AppendLine("The calendars for the selected section is invalid"); } return(theResults); }
private void MOEdit_EditValueChanged(object sender, EventArgs e) { if (theNewSectionID_2 != MOEdit.EditValue.ToString()) { theNewSectionID_2 = MOEdit.EditValue.ToString(); DataTable dt = getMinerList(); editMiner1.Properties.DataSource = dt; editMiner1.Properties.ValueMember = "SECTIONID"; editMiner1.Properties.DisplayMember = "Name"; CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = this.theSystemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; if (BMEBL.get_reOrgDaySelection(theProdmonth, theNewSectionID_2) == true) { // editDay1.Properties.DataSource = BMEBL.ResultsDataTable; dtaftercrew = BMEBL.ResultsDataTable; editAfternoon1.Properties.DataSource = dtaftercrew; editAfternoon1.Properties.DisplayMember = "Crew_Org"; editAfternoon1.Properties.ValueMember = "Crew_Org"; dtnightcrew = BMEBL.ResultsDataTable; editNight1.Properties.DataSource = dtnightcrew; editNight1.Properties.DisplayMember = "Crew_Org"; editNight1.Properties.ValueMember = "Crew_Org"; dtrovingcrew = BMEBL.ResultsDataTable; editRoming1.Properties.DataSource = dtrovingcrew; editRoming1.Properties.DisplayMember = "Crew_Org"; editRoming1.Properties.ValueMember = "Crew_Org"; } CPMBusinessLayer.clsBusinessLayer BMEBL1 = new CPMBusinessLayer.clsBusinessLayer(); BMEBL1._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL1.SetsystemDBTag = this.theSystemDBTag; BMEBL1.SetUserCurrentInfo = this.UserCurrentInfo; if (BMEBL1.get_reOrgDaySelection(theProdmonth, theNewSectionID_2) == true) { DataRow[] rows = BMEBL1.ResultsDataTable.Select("Crew_Org=''"); BMEBL1.ResultsDataTable.Rows.Remove(rows[0]); //DataRow[] rows1 = BMEBL.ResultsDataTable.Select("Crew_Org='Contractor'"); //BMEBL.ResultsDataTable.Rows.Remove(rows1[0]); dtdaycrew = BMEBL1.ResultsDataTable; editDay1.Properties.DataSource = dtdaycrew; editDay1.Properties.DisplayMember = "Crew_Org"; editDay1.Properties.ValueMember = "Crew_Org"; } editDay1.Text = editDay1.SelectedText; editNight1.Text = editNight1.SelectedText; editAfternoon1.Text = editAfternoon1.SelectedText; editRoming1.Text = editRoming1.SelectedText; editMiner1.EditValue = dt.Rows[0][0].ToString(); editDay1.EditValue = null; editAfternoon1.EditValue = null; editNight1.EditValue = null; editRoming1.EditValue = null; } }
public void addWorkplace(String WorkplaceID, int ProdMonth, string SectionID, string SectionID_2, int Activity) { MWDataManager.clsDataAccess _WPData = new MWDataManager.clsDataAccess(); _WPData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _WPData.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _WPData.queryReturnType = MWDataManager.ReturnType.DataTable; theActivity = Activity; theProdmonth = ProdMonth; theSectionID_2 = SectionID_2; theWorkPlaceID = WorkplaceID; theSectionID = SectionID; _clChnageOfPlanData.SetSectionID(SectionID ); _clChnageOfPlanData.SetProdMonth(Convert.ToInt32 (ProdMonth )); _clChnageOfPlanData.SetSectionID_2(SectionID_2); _clChnageOfPlanData.SetWorkplaceID(WorkplaceID); _clChnageOfPlanData.SetRequestType((int)replanningType.rpNewWP); CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = this.theSystemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; DataTable theDates = new DataTable(); if (BMEBL.get_BeginEndDates(SectionID_2, ProdMonth.ToString()) == true) { theDates = BMEBL.ResultsDataTable; } DateTime theBeginDate = new DateTime(); DateTime theEndDate = new DateTime(); foreach (DataRow r in theDates.Rows) { theBeginDate = Convert.ToDateTime(r["StartDate"].ToString()); theEndDate = Convert.ToDateTime(r["EndDate"].ToString()); } editStartDate.Properties.MaxValue = theEndDate; editStartDate.Properties.MinValue = theBeginDate; CPMBusinessLayer.clsBusinessLayer BMEBL1 = new CPMBusinessLayer.clsBusinessLayer(); BMEBL1._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL1.SetsystemDBTag = this.theSystemDBTag; BMEBL1.SetUserCurrentInfo = this.UserCurrentInfo; editMiningMethod.Properties.DataSource = BMEBL1.getMiningMethods(theActivity); editMiningMethod.Properties.ValueMember = "TargetID";//TargetID editMiningMethod.Properties.DisplayMember = "Description"; // theSectionIDMO = SectionIDMO; editWorkplace.Properties.DataSource = getWorkplaceList(); editWorkplace.Properties.ValueMember = "WORKPLACEID"; //editWorkplace.Properties.ValueMember = "Workplaceid"; editWorkplace.Properties.DisplayMember = "DESCRIPTION"; editMiner.Properties.DataSource = getMinerList(); editMiner.Properties.ValueMember = "SECTIONID"; editMiner.Properties.DisplayMember = "Name"; string prodmonth = Convert.ToString(theProdmonth); editPeodMonth.Text = prodmonth; _WPData.SqlStatement = "SELECT DISTINCT Name_2 FROM dbo.SECTION_COMPLETE WHERE PRODMONTH = '" + Convert.ToString(ProdMonth) + "' AND SECTIONID_2 = '" + SectionID_2 + "'"; _WPData.ExecuteInstruction(); foreach (DataRow r in _WPData.ResultsDataTable.Rows) { editSection.Text = r["Name_2"].ToString(); } _WPData.SqlStatement = "SELECT * FROM WORKPLACE WHERE WORKPLACEID = '" + editWorkplace .EditValue + "'"; _WPData.ExecuteInstruction(); foreach (DataRow r in _WPData.ResultsDataTable.Rows) { editFaceLength.Text = r["FL"].ToString(); } _clChnageOfPlanData.SetActivity(Activity); loadCurrentValues(ProdMonth, SectionID, SectionID_2, WorkplaceID, Activity, false); }
public void changecrew(String WorkplaceID, int ProdMonth, string SectionID, string SectionID_2, int activity) { txtProdMonth.Text = Convert.ToString(ProdMonth); theSectionID = SectionID; theWorkplaceID = WorkplaceID; theProdmonth = ProdMonth; theSectionID_2 = SectionID_2; theNewSectionID_2 = SectionID_2; MOEdit.Properties.DataSource = getMOList(); MOEdit.Properties.ValueMember = "SectionID"; MOEdit.Properties.DisplayMember = "MO"; MOEdit.EditValue = theSectionID_2; editMiner1.Properties.DataSource = getMinerList(); editMiner1.Properties.ValueMember = "SECTIONID"; editMiner1.Properties.DisplayMember = "Name"; CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = this.theSystemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; if (BMEBL.get_reOrgDaySelection(theProdmonth, theNewSectionID_2) == true) { // editDay1.Properties.DataSource = BMEBL.ResultsDataTable; dtaftercrew = BMEBL.ResultsDataTable; editAfternoon1.Properties.DataSource = dtaftercrew; editAfternoon1.Properties.DisplayMember = "Crew_Org"; editAfternoon1.Properties.ValueMember = "Crew_Org"; dtnightcrew = BMEBL.ResultsDataTable; editNight1.Properties.DataSource = dtnightcrew; editNight1.Properties.DisplayMember = "Crew_Org"; editNight1.Properties.ValueMember = "Crew_Org"; dtrovingcrew = BMEBL.ResultsDataTable; editRoming1.Properties.DataSource = dtrovingcrew; editRoming1.Properties.DisplayMember = "Crew_Org"; editRoming1.Properties.ValueMember = "Crew_Org"; } CPMBusinessLayer.clsBusinessLayer BMEBL1 = new CPMBusinessLayer.clsBusinessLayer(); BMEBL1._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL1.SetsystemDBTag = this.theSystemDBTag; BMEBL1.SetUserCurrentInfo = this.UserCurrentInfo; if (BMEBL1.get_reOrgDaySelection(theProdmonth, theNewSectionID_2) == true) { DataRow[] rows = BMEBL1.ResultsDataTable.Select("Crew_Org=''"); BMEBL1.ResultsDataTable.Rows.Remove(rows[0]); dtdaycrew = BMEBL1.ResultsDataTable; editDay1.Properties.DataSource = dtdaycrew; editDay1.Properties.DisplayMember = "Crew_Org"; editDay1.Properties.ValueMember = "Crew_Org"; } editDay1.Text = editDay1.SelectedText; editNight1.Text = editNight1.SelectedText; editAfternoon1.Text = editAfternoon1.SelectedText; editRoming1.Text = editRoming1.SelectedText; theActivity = activity; MWDataManager.clsDataAccess _WPData = new MWDataManager.clsDataAccess(); _WPData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _WPData.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _WPData.queryReturnType = MWDataManager.ReturnType.DataTable; _WPData.SqlStatement = "SELECT * FROM WORKPLACE WHERE WORKPLACEID = '" + WorkplaceID + "'"; _WPData.ExecuteInstruction(); _WPData.SqlStatement = "SELECT * FROM PLANMONTH WHERE Workplaceid = '" + WorkplaceID + "' and Prodmonth='" + ProdMonth + "'"; _WPData.ExecuteInstruction(); foreach (DataRow r in _WPData.ResultsDataTable.Rows) { txtDay.Text = r["OrgUnitDay"].ToString(); txtNight.Text = r["OrgUnitNight"].ToString(); txtAfternoon.Text = r["OrgUnitAfternoon"].ToString(); txtRoving.Text = r["RomingCrew"].ToString(); editDay1.Properties.NullText = ""; editDay1.EditValue = r["OrgUnitDay"].ToString(); _clChnageOfPlanData.SetDayCrew(r["OrgUnitDay"].ToString()); editNight1.Properties.NullText = ""; editNight1.EditValue = r["OrgUnitNight"].ToString(); _clChnageOfPlanData.SetNightCrew(r["OrgUnitNight"].ToString()); editAfternoon1.Properties.NullText = ""; editAfternoon1.EditValue = r["OrgUnitAfternoon"].ToString(); _clChnageOfPlanData.SetAfternoonCrew(r["OrgUnitAfternoon"].ToString()); editRoming1.Properties.NullText = ""; editRoming1.EditValue = r["RomingCrew"].ToString(); _clChnageOfPlanData.SetRovingCrew(r["RomingCrew"].ToString()); } loadCurrentValues(WorkplaceID, ProdMonth, SectionID, SectionID_2, false); }
public void MoveBooking(String WorkplaceID, int ProdMonth, string SectionID, string SectionID_2, int activity) { textEdit2.Text = Convert.ToString(ProdMonth); textEdit2.Properties.ReadOnly = true; theSectionID = SectionID; theWorkplaceID = WorkplaceID; theProdmonth = ProdMonth; theSectionID_2 = SectionID_2; theActivity = activity; CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = this.theSystemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; CPMBusinessLayer.clsBusinessLayer BMEBL1 = new CPMBusinessLayer.clsBusinessLayer(); BMEBL1._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL1.SetsystemDBTag = this.theSystemDBTag; BMEBL1.SetUserCurrentInfo = this.UserCurrentInfo; editMiningMethod.Properties.DataSource = BMEBL1.getMiningMethods(theActivity); editMiningMethod.Properties.ValueMember = "TargetID";//TargetID editMiningMethod.Properties.DisplayMember = "Description"; MWDataManager.clsDataAccess _WPData = new MWDataManager.clsDataAccess(); _WPData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _WPData.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _WPData.queryReturnType = MWDataManager.ReturnType.DataTable; _WPData.SqlStatement = "SELECT * FROM WORKPLACE WHERE WORKPLACEID = '" + WorkplaceID + "'"; _WPData.ExecuteInstruction(); editToWorkplace.Properties.DataSource = getWorkplaceList(); editToWorkplace.Properties.ValueMember = "WORKPLACEID"; editToWorkplace.Properties.DisplayMember = "DESCRIPTION"; foreach (DataRow r in _WPData.ResultsDataTable.Rows) { textEdit1.Text = r["DESCRIPTION"].ToString(); textEdit1.Properties.ReadOnly = true; } _WPData.SqlStatement = "SELECT * FROM PLANMONTH WHERE Workplaceid = '" + WorkplaceID + "' and Prodmonth='" + theProdmonth + "' and Sectionid= '" + theSectionID + "' AND PLANCODE='MP'"; _WPData.ExecuteInstruction(); foreach (DataRow r in _WPData.ResultsDataTable.Rows) { theActivity = Convert.ToInt32(r["Activity"].ToString()); switch (Convert.ToInt32(r["Activity"].ToString())) { case 0: layoutControlItem4.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; break; case 1: layoutControlItem4.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; break; } daycrew = r["OrgUnitDay"].ToString();; nightcrew = r["OrgUnitNight"].ToString(); afternooncrew = r["OrgUnitAfternoon"].ToString(); roamingcrew = r["RomingCrew"].ToString(); } loadCurrentValues(WorkplaceID, ProdMonth, SectionID, SectionID_2, false); }
public void DrillRig(string WorkplaceID, int ProdMonth, string SectionID, string SectionID_2, int activity) { theActivity = activity; txtWorkplaceID.Text = WorkplaceID; txtProdMonth.Text = Convert.ToString(ProdMonth); theSectionID = SectionID; theSectionID_2 = SectionID_2; _clChnageOfPlanData.SetSectionID(SectionID); _clChnageOfPlanData.SetSectionID_2(SectionID_2); _clChnageOfPlanData.SetProdMonth(Convert.ToInt32(txtProdMonth.Text)); _clChnageOfPlanData.SetWorkplaceID(txtWorkplaceID.Text); _clChnageOfPlanData.SetRequestType((int)replanningType.rpDrillRig); // _clChnageOfPlanData.SetRequestType((int)replanningType.rpStopWp); CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; DataTable theDates = new DataTable(); BMEBL.SetsystemDBTag = theSystemDBTag; BMEBL.SetUserCurrentInfo = UserCurrentInfo; MWDataManager.clsDataAccess _WPData = new MWDataManager.clsDataAccess(); _WPData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _WPData.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _WPData.queryReturnType = MWDataManager.ReturnType.DataTable; _WPData.SqlStatement = "SELECT * FROM WORKPLACE WHERE WORKPLACEID = '" + WorkplaceID + "'"; _WPData.ExecuteInstruction(); foreach (DataRow r in _WPData.ResultsDataTable.Rows) { txtWorkplaceName.Text = r["DESCRIPTION"].ToString(); } _WPData.SqlStatement = "SELECT DISTINCT Name_2 FROM dbo.SECTION_COMPLETE WHERE PRODMONTH = '" + Convert.ToString(ProdMonth) + "' AND SECTIONID_2 = '" + SectionID_2 + "'"; _WPData.ExecuteInstruction(); foreach (DataRow r in _WPData.ResultsDataTable.Rows) { txtSection.Text = r["Name_2"].ToString(); } CPMBusinessLayer.clsBusinessLayer BMEBL1 = new CPMBusinessLayer.clsBusinessLayer(); BMEBL1._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL1.SetsystemDBTag = this.theSystemDBTag; BMEBL1.SetUserCurrentInfo = this.UserCurrentInfo; // editMiningMethod.Properties.DataSource = BMEBL1.getMiningMethods(theActivity); MWDataManager.clsDataAccess _MinerData = new MWDataManager.clsDataAccess(); _MinerData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _MinerData.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _MinerData.queryReturnType = MWDataManager.ReturnType.DataTable; _MinerData.SqlStatement = "SELECT '' DRID union " + "select distinct DRID from DRILLRIG_PROJECT DRP " + "INNER JOIN vw_Workplace_WorkArea WPWA ON " + "DRP.Project = WPWA.Project"; _MinerData.ExecuteInstruction(); editDrillRigg.Properties.DataSource = _MinerData.ResultsDataTable; editDrillRigg.Properties.ValueMember = "DRID";;//TargetID editDrillRigg.Properties.DisplayMember = "DRID";; _WPData.SqlStatement = "SELECT PP.DrillRig from PLANMONTH PP " + " where PP.ProdMonth='" + ProdMonth + "' and PP.Workplaceid='" + WorkplaceID + "' and PP.Sectionid='" + SectionID + "' and PP.Sectionid_2='" + SectionID_2 + "'"; _WPData.ExecuteInstruction(); foreach (DataRow r in _WPData.ResultsDataTable.Rows) { editDrillRigg.Properties.NullText = r["DrillRig"].ToString(); editDrillRigg.EditValue = editDrillRigg.Properties.GetKeyValueByDisplayText(r["DrillRig"].ToString()); // CBD = r["TargetID"].ToString(); } loadCurrentValues(WorkplaceID, ProdMonth, SectionID, SectionID_2, false); }