Exemplo n.º 1
0
        /// <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();
        }
Exemplo n.º 2
0
 public ucBaseUserControl getUserSettingsScreen(ScreenStatus _theScreenStatus, string _userID, TUserCurrentInfo userInfo, string theConnection)
 {
     return(null);
 }
Exemplo n.º 3
0
 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;
 }