/// <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;
}
