/// <summary> /// Gets all the fields from the SYSSET table /// </summary> /// <param name="theSystemDBTag"></param> /// <param name="UserCurrentInfo"></param> public static void GetSysSettings(string theSystemDBTag, TUserCurrentInfo UserCurrentInfo) { MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);// ConfigurationSettings.AppSettings["SQLConnectionStr"]; _dbMan.SqlStatement = "SELECT * FROM [dbo].[tbl_SysSet]"; _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); DataTable SubB = _dbMan.ResultsDataTable; ProdMonth = Convert.ToInt32(SubB.Rows[0]["currentproductionmonth"].ToString()); MillMonth = Convert.ToInt32(SubB.Rows[0]["currentmillmonth"].ToString()); Banner = SubB.Rows[0]["Banner"].ToString(); StdAdv = Convert.ToDecimal(SubB.Rows[0]["stpadv"].ToString()); CheckMeas = SubB.Rows[0]["CheckMeas"].ToString(); PlanType = SubB.Rows[0]["PlanType"].ToString(); CleanShift = SubB.Rows[0]["CleanShift"].ToString(); AdjBook = SubB.Rows[0]["AdjBook"].ToString(); BlastQual = Convert.ToInt32(Math.Round(Convert.ToDecimal(SubB.Rows[0]["percblastqualification"].ToString()), 0)); DSOrg = SubB.Rows[0]["dsorg"].ToString(); CHkMeasLevel = SubB.Rows[0]["checkmeaslvl"].ToString(); PlanNotes = SubB.Rows[0]["PlanNotes"].ToString(); CylePlan = "Y"; RepDir = SubB.Rows[0]["RepDir"].ToString(); HGrade = Convert.ToDecimal(SubB.Rows[0]["stopingpaylimit"].ToString()); ServDir = SubB.Rows[0]["ServerPath"].ToString(); Vampsqm = Convert.ToInt32(Math.Round(Convert.ToDecimal(SubB.Rows[0]["vampsqm"].ToString()), 0)); FatFreeShift = Convert.ToInt32(Math.Round(Convert.ToDecimal(SubB.Rows[0]["FatFreeShift"].ToString()), 0)); RepDirImage = SubB.Rows[0]["RepDir"].ToString(); }
public ucBaseUserControl getUserSettingsScreen(ScreenStatus _theScreenStatus, string _userID, TUserCurrentInfo userInfo, string theConnection) { return(null); }
public ucBaseUserControl getUserSettingsScreen(ScreenStatus _theScreenStatus, string _userID, TUserCurrentInfo userInfo, string theConnection) { Controls.Users.UserProductionSettingsUserControl theResult = new Controls.Users.UserProductionSettingsUserControl() { theScreenStatus = _theScreenStatus, UserID = _userID, theSystemDBTag = MinewasteResource.systemDBTag, theSystemTag = MinewasteResource.systemTag, UserCurrentInfo = userInfo }; theResult.currentConnection = theConnection; return(theResult); }
public ucBaseUserControl getUserSettingsScreen(ScreenStatus _theScreenStatus, string _userID, TUserCurrentInfo userInfo, string theConnection) { SysAdminScreens.Users.ucUserProductionSettings theResult = new SysAdminScreens.Users.ucUserProductionSettings() { theScreenStatus = _theScreenStatus, UserID = _userID, theSystemDBTag = resWPAS.systemDBTag, theSystemTag = resWPAS.systemTag, UserCurrentInfo = userInfo }; theResult.currentConnection = theConnection; return(theResult); }
public void stopdata(TUserCurrentInfo userinfo, string section, string PRODMONTH) { UserCurrentInfo = userinfo; SectionID = section; prodmonth = PRODMONTH; }