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()); }