public void setProdMonth()
{
int ProdMonth;
MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess();
_dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
//StringBuilder sb = new StringBuilder();
//sb.AppendLine("SELECT DISTINCT TOP 1 [Prodmonth] ProdMonth FROM [SECCAL] WHERE BeginDate <= CAST(GETDATE() AS DATE) and EndDate >= CAST(GETDATE() AS DATE)");
_dbMan.SqlStatement = "select case when pm1 is null then prodmonth else pm1 end as prodmonth from (select 'a' lbl, (year(getdate())*100) + month(getdate()) prodmonth ) a \r\n" +
"left outer join \r\n" +
"(SELECT DISTINCT TOP 1[Prodmonth] pm1, 'a' lbl \r\n" +
"FROM[SECCAL] WHERE BeginDate <= CAST(GETDATE() AS DATE) and EndDate >= CAST(GETDATE() AS DATE)) b \r\n" +
"on a.lbl = b.lbl ";
_dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbMan.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbMan.ExecuteInstruction();
DataTable SubB = _dbMan.ResultsDataTable;
ProdMonth = Convert.ToInt32(SubB.Rows[0]["ProdMonth"].ToString());
editProdmonth.EditValue = TProductionGlobal.ProdMonthAsDate(ProdMonth.ToString());
}
public void setProdMonth()
{
int ProdMonth;
MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess();
_dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
StringBuilder sb = new StringBuilder();
sb.AppendLine("SELECT [CurrentProductionMonth] ProdMonth FROM [SYSSET]");
_dbMan.SqlStatement = sb.ToString();
_dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbMan.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbMan.ExecuteInstruction();
DataTable SubB = _dbMan.ResultsDataTable;
ProdMonth = Convert.ToInt32(SubB.Rows[0]["ProdMonth"].ToString());
editProdmonth.EditValue = TProductionGlobal.ProdMonthAsDate(ProdMonth.ToString());
}
