/// <summary>
/// * Create MTab VO
/// </summary>
/// <param name="wVO">Window VO Object</param>
/// <param name="TabNo">Tab Number</param>
/// <param name="dr">Datarow</param>
/// <param name="isRO">Is Read Only</param>
/// <param name="onlyCurrentDays">only current day</param>
/// <param name="AD_UserDef_Win_ID">window id</param>
/// <returns>this object</returns>
public static GridTabVO Create(GridWindowVO wVO, int TabNo, IDataReader dr,
bool isRO, int onlyCurrentDays, int AD_UserDef_Win_ID)
{
VLogger.Get().Config("#" + TabNo);
GridTabVO vo = new GridTabVO(wVO.GetCtx(), wVO.windowNo);
vo.AD_Window_ID = wVO.AD_Window_ID;
vo.tabNo = TabNo;
//
if (!LoadTabDetails(vo, dr))
{
return(null);
}
if (isRO)
{
VLogger.Get().Fine("Tab is ReadOnly");
vo.IsReadOnly = true;
}
vo.onlyCurrentDays = onlyCurrentDays;
// Create Fields
if (vo.IsSortTab)
{
vo.fields = new List <GridFieldVO>(); // dummy
}
else
{
CreateFields(vo, AD_UserDef_Win_ID);
if (vo.fields == null || vo.fields.Count == 0)
{
VLogger.Get().Log(Level.SEVERE, vo.Name + ": No Fields");
return(null);
}
if (vo.IsHeaderPanel)
{
CreateHeaderPanel(vo);
}
CreateTabPanels(vo);
if (vo.panels != null && vo.panels.Count > 0)
{
vo.HasPanels = true;
wVO.hasPanel = true;
}
}
return(vo);
} // create
} // setCtx
/**
* Clone
* @param windowNo no
* @return WindowVO
*/
public GridWindowVO Clone(int windowNo)
{
GridWindowVO clone = null;
try
{
clone = new GridWindowVO(ctx, windowNo);
clone.AD_Window_ID = AD_Window_ID;
clone.Name = Name;
clone.Description = Description;
clone.Help = Help;
clone.WindowType = WindowType;
clone.AD_Image_ID = AD_Image_ID;
clone.AD_Color_ID = AD_Color_ID;
clone.IsReadWrite = IsReadWrite;
clone.WinWidth = WinWidth;
clone.WinHeight = WinHeight;
clone.IsSOTrx = IsSOTrx;
ctx.SetContext(windowNo, "IsSOTrx", clone.IsSOTrx);
clone.AD_Table_ID = AD_Table_ID;
ctx.SetContext(windowNo, "BaseTable_ID", clone.AD_Table_ID);
//
clone.Tabs = new List <GridTabVO>();
for (int i = 0; i < Tabs.Count; i++)
{
GridTabVO tab = Tabs[i];
GridTabVO cloneTab = tab.Clone(clone.ctx, windowNo);
if (cloneTab == null)
{
return(null);
}
clone.Tabs.Add(cloneTab);
}
}
catch
{
clone = null;
}
return(clone);
} // clone
} // setCtx
/**
* Clone
* @param windowNo no
* @return WindowVO
*/
public GridWindowVO Clone(Ctx ctx, int windowNo)
{
GridWindowVO clone = null;
try
{
clone = new GridWindowVO(ctx, windowNo);
clone.AD_Window_ID = AD_Window_ID;
clone.Name = Name;
clone.Description = Description;
clone.Help = Help;
clone.WindowType = WindowType;
clone.AD_Image_ID = AD_Image_ID;
clone.AD_Color_ID = AD_Color_ID;
clone.IsReadWrite = IsReadWrite;
clone.WinWidth = WinWidth;
clone.WinHeight = WinHeight;
clone.IsSOTrx = IsSOTrx;
ctx.SetContext(windowNo, "IsSOTrx", clone.IsSOTrx);
clone.AD_Table_ID = AD_Table_ID;
ctx.SetContext(windowNo, "BaseTable_ID", clone.AD_Table_ID);
clone.IsAppointment = IsAppointment;
clone.IsTask = IsTask;
clone.IsEmail = IsEmail;
clone.IsLetter = IsLetter;
clone.IsSms = IsSms;
clone.IsFaxEmail = IsFaxEmail;
clone.DisplayName = DisplayName;
clone.IsChat = IsChat;
clone.IsAttachment = IsAttachment;
clone.IsHistory = IsHistory;
clone.IsCheckRequest = IsCheckRequest;
clone.IsCopyReocrd = IsCopyReocrd;
clone.IsSubscribedRecord = IsSubscribedRecord;
clone.IsZoomAcross = IsZoomAcross;
clone.IsCreatedDocument = IsCreatedDocument;
clone.IsUploadedDocument = IsUploadedDocument;
clone.IsViewDocument = IsViewDocument;
clone.IsAttachDocumentFrom = IsAttachDocumentFrom;
clone.IsImportMap = IsImportMap;
clone.IsMarkToExport = IsMarkToExport;
clone.IsArchive = IsArchive;
clone.IsAttachmail = IsAttachmail;
clone.IsRoleCenterView = IsRoleCenterView;
//
clone.hasPanel = hasPanel;
clone.Tabs = new List <GridTabVO>();
for (int i = 0; i < Tabs.Count; i++)
{
GridTabVO tab = Tabs[i];
GridTabVO cloneTab = tab.Clone(clone.ctx, windowNo);
if (cloneTab == null)
{
return(null);
}
clone.Tabs.Add(cloneTab);
}
}
catch
{
clone = null;
}
return(clone);
} // clone
/// <summary>
/// Create Window Tabs
/// </summary>
/// <param name="mWindowVO"></param>
/// <param name="AD_UserDef_Win_ID"></param>
/// <returns></returns>
private static bool CreateTabs(GridWindowVO mWindowVO, int AD_UserDef_Win_ID)
{
mWindowVO.Tabs = new List <GridTabVO>();
String sql = GridTabVO.GetSQL(mWindowVO.ctx, AD_UserDef_Win_ID);
int TabNo = 0;
IDataReader dr = null;
try
{
// create statement
System.Data.SqlClient.SqlParameter[] param = new System.Data.SqlClient.SqlParameter[1];
param[0] = new System.Data.SqlClient.SqlParameter("@windowID", mWindowVO.AD_Window_ID);
dr = DataBase.DB.ExecuteReader(sql, param);
bool firstTab = true;
while (dr.Read())
{
if (mWindowVO.AD_Table_ID == 0)
{
mWindowVO.AD_Table_ID = Utility.Util.GetValueOfInt(dr["AD_Table_ID"]);
}
// Create TabVO
int onlyCurrentDays = 0;
if (mWindowVO.WindowType.Equals(WINDOWTYPE_TRX))
{
onlyCurrentDays = 1;
}
GridTabVO mTabVO = GridTabVO.Create(mWindowVO, TabNo, dr,
mWindowVO.WindowType.Equals(WINDOWTYPE_QUERY), // isRO
onlyCurrentDays, AD_UserDef_Win_ID);
if (mTabVO == null && firstTab)
{
break; // don't continue if first tab is null
}
if (mTabVO != null)
{
if (!mTabVO.IsReadOnly && "N".Equals(mWindowVO.IsReadWrite))
{
mTabVO.IsReadOnly = true;
}
mWindowVO.Tabs.Add(mTabVO);
TabNo++; // must be same as mWindow.getTab(x)
firstTab = false;
}
}
dr.Close();
dr = null;
param = null;
}
catch (System.Data.Common.DbException e)
{
if (dr != null)
{
dr.Close();
dr = null;
}
VLogger.Get().Log(Level.SEVERE, "createTabs", e);
return(false);
}
// No Tabs
if (TabNo == 0 || mWindowVO.Tabs.Count == 0)
{
VLogger.Get().Log(Level.SEVERE, "No Tabs - AD_Window_ID="
+ mWindowVO.AD_Window_ID + " - " + sql);
return(false);
}
// Put base table of window in ctx (for VDocAction)
mWindowVO.ctx.SetContext(mWindowVO.windowNo, "BaseTable_ID", mWindowVO.AD_Table_ID);
return(true);
}
/// <summary>
/// Create Window Tabs
/// </summary>
/// <param name="mWindowVO"></param>
/// <param name="AD_UserDef_Win_ID"></param>
/// <returns></returns>
private static bool CreateEditorTabs(GridWindowVO mWindowVO, int AD_UserDef_Win_ID)
{
mWindowVO.Tabs = new List <GridTabVO>();
bool isBase = false;
if (Utility.Env.IsBaseLanguage(mWindowVO.ctx, "AD_Tab"))
{
isBase = true;
}
StringBuilder sql = new StringBuilder(" SELECT ")
.Append(" t.AD_Tab_ID AS AD_Tab_ID , ")
.Append(" t.AD_Window_ID AS AD_Window_ID , ")
.Append(" t.AD_Table_ID AS AD_Table_ID , ")
.Append(" t.AD_CtxArea_ID AS AD_CtxArea_ID , ")
.Append(" uw.AD_Role_ID AS UserDef_Role_ID , ")
.Append(" uw.AD_User_ID AS AD_User_ID , ")
.Append(" uw.AD_UserDef_Win_ID AS AD_UserDef_Win_ID , ")
.Append(" uw.CustomizationName AS CustomizationName , ")
.Append(" u.AD_UserDef_Tab_ID AS AD_UserDef_Tab_ID , ");
if (isBase)
{
sql.Append(" COALESCE(u.Name,t.Name) AS Name , ")
.Append(" COALESCE(u.Description,t.Description) AS Description , ")
.Append(" COALESCE(u.Help,t.Help) AS Help , ");
}
else
{
sql.Append(" COALESCE(u.Name,trl.Name) AS Name , ")
.Append(" COALESCE(u.Description,trl.Description) AS Description , ")
.Append(" COALESCE(u.Help,trl.Help) AS Help , ");
}
sql.Append(" COALESCE(u.SeqNo,t.SeqNo) AS SeqNo , ")
.Append(" COALESCE(u.IsSingleRow,t.IsSingleRow) AS IsSingleRow , ")
.Append(" t.HasTree AS HasTree , ")
.Append(" t.IsInfoTab AS IsInfoTab , ")
.Append(" t.Referenced_Tab_ID AS Referenced_Tab_ID , ")
.Append(" tbl.ReplicationType AS ReplicationType , ")
.Append(" tbl.TableName AS TableName , ")
.Append(" tbl.AccessLevel AS AccessLevel , ")
.Append(" tbl.IsSecurityEnabled AS IsSecurityEnabled , ")
.Append(" tbl.IsDeleteable AS IsDeleteable , ")
.Append(" tbl.IsHighVolume AS IsHighVolume , ")
.Append(" tbl.IsView AS IsView , ")
.Append(" t.IsTranslationTab AS IsTranslationTab , ")
.Append(" COALESCE(u.IsReadOnly,t.IsReadOnly) AS IsReadOnly , ")
.Append(" t.AD_Image_ID AS AD_Image_ID , ")
.Append(" t.TabLevel AS TabLevel , ")
.Append(" t.WhereClause AS WhereClause , ")
.Append(" t.OrderByClause AS OrderByClause , ")
.Append(" t.CommitWarning AS CommitWarning , ")
.Append(" COALESCE(u.ReadOnlyLogic,t.ReadOnlyLogic) AS ReadOnlyLogic , ")
.Append(" COALESCE(u.IsDisplayed,t.IsDisplayed) AS IsDisplayed , ")
.Append(" COALESCE(u.DisplayLogic,t.DisplayLogic) AS DisplayLogic , ")
.Append(" t.AD_Column_ID AS AD_Column_ID , ")
.Append(" c.ColumnName AS LinkColumnName , ")
.Append(" t.AD_Process_ID AS AD_Process_ID , ")
.Append(" t.IsSortTab AS IsSortTab , ")
.Append(" t.IsAdvancedTab AS IsAdvancedTab , ")
.Append(" COALESCE(u.IsInsertRecord,t.IsInsertRecord) AS IsInsertRecord , ")
.Append(" t.AD_ColumnSortOrder_ID AS AD_ColumnSortOrder_ID, ")
.Append(" t.AD_ColumnSortYesNo_ID AS AD_ColumnSortYesNo_ID, ")
.Append(" t.Included_Tab_ID AS Included_Tab_ID, ")
.Append(" t.ShowSummaryLevelNodes As ShowSummaryLevelNodes ");
if (isBase)
{
sql.Append(" FROM AD_Tab t ");
}
else
{
sql.Append(" FROM AD_Tab t ")
.Append(" INNER JOIN AD_Tab_Trl trl ON t.AD_Tab_ID = trl.AD_Tab_ID ");
isBase = true;
}
sql.Append(" INNER JOIN AD_Table tbl ON (t.AD_Table_ID = tbl.AD_Table_ID) ")
.Append(" LEFT OUTER JOIN AD_Column c ON (t.AD_Column_ID=c.AD_Column_ID) ")
.Append(" LEFT OUTER JOIN AD_UserDef_Tab u ON (u.AD_Tab_ID=t.AD_Tab_ID) ")
.Append(" LEFT OUTER JOIN AD_UserDef_Win uw ON (uw.AD_UserDef_Win_ID=u.AD_UserDef_Win_ID) ")
.Append(" WHERE t.AD_Window_ID = @windowID ");
if (!isBase)
{
sql.Append(" AND trl.AD_Language='" + Env.GetAD_Language(mWindowVO.ctx) + "'");
}
if (AD_UserDef_Win_ID != 0)
{
sql.Append(" AND u.AD_UserDef_Win_ID=" + AD_UserDef_Win_ID);
}
sql.Append(" ORDER BY SeqNo");
int TabNo = 0;
IDataReader dr = null;
try
{
// create statement
System.Data.SqlClient.SqlParameter[] param = new System.Data.SqlClient.SqlParameter[1];
param[0] = new System.Data.SqlClient.SqlParameter("@windowID", mWindowVO.AD_Window_ID);
dr = DataBase.DB.ExecuteReader(sql.ToString(), param);
bool firstTab = true;
while (dr.Read())
{
if (mWindowVO.AD_Table_ID == 0)
{
mWindowVO.AD_Table_ID = Utility.Util.GetValueOfInt(dr["AD_Table_ID"]);
}
// Create TabVO
int onlyCurrentDays = 0;
if (mWindowVO.WindowType.Equals(WINDOWTYPE_TRX))
{
onlyCurrentDays = 1;
}
GridTabVO mTabVO = GridTabVO.CreateEditorTabs(mWindowVO, TabNo, dr,
mWindowVO.WindowType.Equals(WINDOWTYPE_QUERY), // isRO
onlyCurrentDays, AD_UserDef_Win_ID);
if (mTabVO == null && firstTab)
{
break; // don't continue if first tab is null
}
if (mTabVO != null)
{
if (!mTabVO.IsReadOnly && "N".Equals(mWindowVO.IsReadWrite))
{
mTabVO.IsReadOnly = true;
}
mWindowVO.Tabs.Add(mTabVO);
TabNo++; // must be same as mWindow.getTab(x)
firstTab = false;
}
}
dr.Close();
dr = null;
param = null;
}
catch (System.Data.Common.DbException e)
{
if (dr != null)
{
dr.Close();
dr = null;
}
VLogger.Get().Log(Level.SEVERE, "createTabs", e);
return(false);
}
// No Tabs
if (TabNo == 0 || mWindowVO.Tabs.Count == 0)
{
VLogger.Get().Log(Level.SEVERE, "No Tabs - AD_Window_ID="
+ mWindowVO.AD_Window_ID + " - " + sql);
return(false);
}
// Put base table of window in ctx (for VDocAction)
mWindowVO.ctx.SetContext(mWindowVO.windowNo, "BaseTable_ID", mWindowVO.AD_Table_ID);
return(true);
}
} // create
/// <summary>
///Create Window Value Object
/// </summary>
/// <param name="ctx"></param>
/// <param name="WindowNo"></param>
/// <param name="AD_Window_ID"></param>
/// <param name="AD_Menu_ID"></param>
/// <returns></returns>
public static GridWindowVO Create(Ctx ctx, int windowNo, int AD_Window_ID)
{
VLogger.Get().Config("#" + windowNo
+ " - AD_Window_ID=" + AD_Window_ID);
GridWindowVO vo = new GridWindowVO(ctx, windowNo);
vo.AD_Window_ID = AD_Window_ID;
IDataReader dr = null;
// -- Get Window
//int AD_Role_ID = vo.ctx.GetAD_Role_ID();
bool isBase = false;
if (Utility.Env.IsBaseLanguage(vo.ctx, "AD_Window"))
{
isBase = true;
}
StringBuilder sql = new StringBuilder("SELECT ");
//w.ad_window_id, u.ad_client_id, u.ad_role_id AS userdef_role_id, u.ad_user_id,u.ad_userdef_win_id, u.customizationname, COALESCE(u.name, w.name) AS name,")
// .Append("COALESCE(u.description, w.description) AS description, COALESCE(u.help, w.help) AS help, w.windowtype, w.ad_color_id, w.ad_image_id, COALESCE(u.winheight, w.winheight) AS winheight,")
// .Append("COALESCE(u.winwidth, w.winwidth) AS winwidth, w.ad_ctxarea_id,'Y' AS IsSOTrx,'Y' AS IsReadWrite, w.isdefault ");
sql.Append(" w.AD_Window_ID AS AD_Window_ID , ")
.Append(" u.AD_Client_ID AS AD_Client_ID , ")
.Append(" u.AD_Role_ID AS userdef_role_id , ")
.Append(" u.AD_user_ID AS AD_User_ID , ")
.Append(" u.AD_UserDef_Win_ID AS AD_UserDef_Win_ID , ")
.Append(" u.CustomizationName AS CustomizationName , ");
if (isBase)
{
sql.Append(" COALESCE(u.name, w.name) AS Name , ")
.Append(" COALESCE(u.description, w.description) AS Description , ")
.Append(" COALESCE(u.help, w.help) AS Help , ");
}
else
{
sql.Append(" COALESCE(u.Name,trl.Name) AS Name , ")
.Append(" COALESCE(u.Description,trl.Description) AS Description , ")
.Append(" COALESCE(u.Help,trl.Help) AS Help , ");
}
sql.Append(" w.WindowType AS WindowType , ")
.Append(" w.AD_Color_ID AS AD_Color_ID , ")
.Append(" w.AD_Image_ID AS AD_Image_ID , ")
.Append(" COALESCE(u.WinHeight,w.WinHeight) AS WinHeight , ")
.Append(" COALESCE(u.WinWidth,w.WinWidth) AS WinWidth , ")
.Append(" w.AD_CtxArea_ID AS AD_CtxArea_ID , ")
.Append(" COALESCE((SELECT IsSOTrx FROM AD_CtxArea ctx WHERE w.AD_CtxArea_ID=ctx.AD_CtxArea_ID ),'Y') AS IsSOTrx , ")
.Append(" a.AD_Role_ID AS AD_Role_ID , ")
.Append(" a.IsReadWrite AS IsReadWrite , ")
.Append(" w.IsDefault AS IsDefault ");
if (isBase)
{
sql.Append(" FROM AD_Window w ");
}
else
{
sql.Append(" FROM AD_Window w ")
.Append(" INNER JOIN AD_Window_Trl trl ON w.AD_Window_id = trl.AD_Window_ID ");
}
sql.Append(" INNER JOIN AD_Window_Access a ON w.AD_Window_ID = a.AD_Window_ID ")
.Append(" LEFT OUTER JOIN AD_userdef_win u ON w.AD_Window_ID = u.AD_Window_ID ")
.Append(" WHERE w.AD_Window_ID=" + vo.AD_Window_ID);
if (!isBase)
{
sql.Append(" AND trl.AD_Language='")
.Append(Utility.Env.GetAD_Language(vo.ctx)).Append("'");
}
//int AD_Client_ID = vo.ctx.getAD_Client_ID();
int AD_UserDef_Win_ID = 0;
//IDataReader dr = null;
try
{
// create statement
dr = DataBase.DB.ExecuteReader(sql.ToString(), null);
// get data
if (dr.Read())
{
vo.Name = dr["Name"].ToString();
vo.Description = dr["Description"].ToString();
if (vo.Description == null)
{
vo.Description = "";
}
vo.Help = dr["Help"].ToString();
if (vo.Help == null)
{
vo.Help = "";
}
vo.WindowType = dr["WindowType"].ToString();
//
vo.AD_Color_ID = Utility.Util.GetValueOfInt(dr["AD_Color_ID"]);
vo.AD_Image_ID = Utility.Util.GetValueOfInt(dr["Ad_Image_ID"]);
vo.IsReadWrite = dr["IsReadWrite"].ToString();
//
vo.WinHeight = Utility.Util.GetValueOfInt(dr["WinHeight"]);
vo.WinWidth = Utility.Util.GetValueOfInt(dr["WinWidth"]);
//
vo.IsSOTrx = "Y".Equals(dr["IsSOTrx"].ToString());
AD_UserDef_Win_ID = Utility.Util.GetValueOfInt(dr["AD_UserDef_Win_ID"]);
}
else
{
vo = null;
}
dr.Close();
dr = null;
}
catch (System.Exception ex)
{
if (dr != null)
{
dr.Close();
dr = null;
}
VLogger.Get().Log(Level.SEVERE, sql.ToString(), ex);
return(null);
}
if (dr != null)
{
dr.Close();
dr = null;
}
// Not found
if (vo == null)
{
VLogger.Get().Log(Level.SEVERE, "No Window - AD_Window_ID=" + AD_Window_ID + " - " + sql);
VLogger.Get().SaveError("AccessTableNoView", "(Not found)");
return(null);
}
// Read Write
if (vo.IsReadWrite == null)
{
VLogger.Get().SaveError("AccessTableNoView", "(found)");
return(null);
}
// Create Tabs
CreateEditorTabs(vo, AD_UserDef_Win_ID);
if (vo.Tabs == null || vo.Tabs.Count == 0)
{
return(null);
}
return(vo);
}
/// <summary>
///Create Window Value Object
/// </summary>
/// <param name="ctx"></param>
/// <param name="WindowNo"></param>
/// <param name="AD_Window_ID"></param>
/// <param name="AD_Menu_ID"></param>
/// <returns></returns>
public static GridWindowVO Create(Ctx ctx, int windowNo, int AD_Window_ID, int AD_Menu_ID)
{
VLogger.Get().Config("#" + windowNo
+ " - AD_Window_ID=" + AD_Window_ID + "; AD_Menu_ID=" + AD_Menu_ID);
GridWindowVO vo = new GridWindowVO(ctx, windowNo);
vo.AD_Window_ID = AD_Window_ID;
IDataReader dr = null;
// Get Window_ID if required - (used by HTML UI)
if (vo.AD_Window_ID == 0 && AD_Menu_ID != 0)
{
String sql0 = "SELECT AD_Window_ID, IsSOTrx, IsReadOnly FROM AD_Menu "
+ "WHERE AD_Menu_ID=" + AD_Menu_ID.ToString() + " AND Action='W'";
try
{
dr = DataBase.DB.ExecuteReader(sql0, null);
if (dr.Read())
{
vo.AD_Window_ID = Utility.Util.GetValueOfInt(dr[0]);
String IsSOTrx = dr[1].ToString();
ctx.SetContext(windowNo, "IsSOTrx", (IsSOTrx != "" && IsSOTrx.Equals("Y")));
//
String IsReadOnly = dr[2].ToString();
if (IsReadOnly != "" && IsReadOnly.Equals("Y"))
{
vo.IsReadWrite = "Y";
}
else
{
vo.IsReadWrite = "N";
}
}
dr.Close();
dr = null;
}
catch (System.Exception e)
{
if (dr != null)
{
dr.Close();
dr = null;
}
VLogger.Get().Log(Level.SEVERE, "Menu", e);
return(null);
}
VLogger.Get().Config("AD_Window_ID=" + vo.AD_Window_ID);
}
// -- Get Window
int AD_Role_ID = vo.ctx.GetAD_Role_ID();
StringBuilder sql01 = new StringBuilder("SELECT Name,Description,Help,WindowType, "
+ "AD_Color_ID,AD_Image_ID, IsReadWrite, WinHeight,WinWidth, "
+ "IsSOTrx, AD_UserDef_Win_ID,IsAppointment,IsTask,IsEmail,IsLetter,IsSms,IsFaxEmail,Name2, "
+ "ISCHAT, ISATTACHMENT,ISHISTORY,ISCHECKREQUEST,ISCOPYRECORD,ISSUBSCRIBERECORD,ISZOOMACROSS,ISCREATEDOCUMENT,ISUPLOADDOCUMENT,ISVIEWDOCUMENT,IsAttachDocumentFrom, "
+ " ISIMPORTMAP,ISMARKTOEXPORT,ISARCHIVE,ISATTACHEMAIL,ISROLECENTERVIEW ");
if (Utility.Env.IsBaseLanguage(vo.ctx, "AD_Window"))
{
sql01.Append("FROM AD_Window_v WHERE AD_Window_ID=" + vo.AD_Window_ID.ToString());
sql01.Append(" AND AD_Role_ID=" + AD_Role_ID);
}
else
{
sql01.Append("FROM AD_Window_vt w WHERE AD_Window_ID=" + vo.AD_Window_ID.ToString());
sql01.Append(" AND AD_Role_ID=" + AD_Role_ID);
sql01.Append(" AND AD_Language='")
.Append(Utility.Env.GetAD_Language(vo.ctx)).Append("'");
}
// Commented BY Karan 21 Dec 2018.. To imrove performance
//StringBuilder sql = new StringBuilder("SELECT Name,Description,Help,WindowType, "
// + "AD_Color_ID,AD_Image_ID, IsReadWrite, WinHeight,WinWidth, "
// + "IsSOTrx, AD_UserDef_Win_ID,IsAppointment,IsTask,IsEmail,IsLetter,IsSms,IsFaxEmail,Name2 ");
//if (Utility.Env.IsBaseLanguage(vo.ctx, "AD_Window"))
//{
// sql.Append("FROM AD_Window_v WHERE AD_Window_ID=" + vo.AD_Window_ID.ToString());
// sql.Append(" AND AD_Role_ID=" + AD_Role_ID);
//}
//else
//{
// sql.Append("FROM AD_Window_vt w WHERE AD_Window_ID=" + vo.AD_Window_ID.ToString());
// sql.Append(" AND AD_Role_ID=" + AD_Role_ID);
// sql.Append(" AND AD_Language='")
// .Append(Utility.Env.GetAD_Language(vo.ctx)).Append("'");
//}
////Without Name2 Field
//StringBuilder sql2 = new StringBuilder("SELECT Name,Description,Help,WindowType, "
// + "AD_Color_ID,AD_Image_ID, IsReadWrite, WinHeight,WinWidth, "
// + "IsSOTrx, AD_UserDef_Win_ID, IsAppointment,IsTask,IsEmail,IsLetter,IsSms ");
//if (Utility.Env.IsBaseLanguage(vo.ctx, "AD_Window"))
//{
// sql2.Append("FROM AD_Window_v WHERE AD_Window_ID=" + vo.AD_Window_ID.ToString());
// sql2.Append(" AND AD_Role_ID=" + AD_Role_ID);
//}
//else
//{
// sql2.Append("FROM AD_Window_vt w WHERE AD_Window_ID=" + vo.AD_Window_ID.ToString());
// sql2.Append(" AND AD_Role_ID=" + AD_Role_ID);
// sql2.Append(" AND AD_Language='")
// .Append(Utility.Env.GetAD_Language(vo.ctx)).Append("'");
//}
////Default Query [ Window + Web]
//StringBuilder sql3 = new StringBuilder("SELECT Name,Description,Help,WindowType, "
// + "AD_Color_ID,AD_Image_ID, IsReadWrite, WinHeight,WinWidth, "
// + "IsSOTrx, AD_UserDef_Win_ID ");
//if (Utility.Env.IsBaseLanguage(vo.ctx, "AD_Window"))
//{
// sql3.Append("FROM AD_Window_v WHERE AD_Window_ID=" + vo.AD_Window_ID.ToString());
// sql3.Append(" AND AD_Role_ID=" + AD_Role_ID);
//}
//else
//{
// sql3.Append("FROM AD_Window_vt w WHERE AD_Window_ID=" + vo.AD_Window_ID.ToString());
// sql3.Append(" AND AD_Role_ID=" + AD_Role_ID);
// sql3.Append(" AND AD_Language='")
// .Append(Utility.Env.GetAD_Language(vo.ctx)).Append("'");
//}
//int AD_Client_ID = vo.ctx.getAD_Client_ID();
int AD_UserDef_Win_ID = 0;
//IDataReader dr = null;
try
{
// create statement
//try
//{
dr = DataBase.DB.ExecuteReader(sql01.ToString(), null);
//}
//catch
//{
// try
// {
// dr = DataBase.DB.ExecuteReader(sql.ToString(), null);
// }
// catch
// {
// try
// {
// dr = DataBase.DB.ExecuteReader(sql2.ToString(), null);
// }
// catch
// {
// dr = DataBase.DB.ExecuteReader(sql3.ToString(), null);
// }
// }
//}
// get data
if (dr.Read())
{
vo.Name = dr[0].ToString();
vo.Description = dr[1].ToString();
if (vo.Description == null)
{
vo.Description = "";
}
vo.Help = dr[2].ToString();
if (vo.Help == null)
{
vo.Help = "";
}
vo.WindowType = dr[3].ToString();
//
vo.AD_Color_ID = Utility.Util.GetValueOfInt(dr[4]);
vo.AD_Image_ID = Utility.Util.GetValueOfInt(dr[5]);
vo.IsReadWrite = dr[6].ToString();
//
vo.WinHeight = Utility.Util.GetValueOfInt(dr[7]);
vo.WinWidth = Utility.Util.GetValueOfInt(dr[8]);
//
vo.IsSOTrx = "Y".Equals(dr[9].ToString());
AD_UserDef_Win_ID = Utility.Util.GetValueOfInt(dr[10]);
if (dr.FieldCount > 11)
{
vo.IsAppointment = "Y".Equals(dr[11].ToString());
vo.IsTask = "Y".Equals(dr[12].ToString());
vo.IsEmail = "Y".Equals(dr[13].ToString());
vo.IsLetter = "Y".Equals(dr[14].ToString());
vo.IsSms = "Y".Equals(dr[15].ToString());
if (dr.FieldCount > 16)
{
vo.IsFaxEmail = "Y".Equals(dr[16].ToString());
vo.DisplayName = dr[17].ToString();
}
if (dr.FieldCount > 18)
{
vo.IsChat = !("N".Equals(dr[18].ToString()));
vo.IsAttachment = !("N".Equals(dr[19].ToString()));
vo.IsHistory = !("N".Equals(dr[20].ToString()));
vo.IsCheckRequest = !("N".Equals(dr[21].ToString()));
vo.IsCopyReocrd = !("N".Equals(dr[22].ToString()));
vo.IsSubscribedRecord = !("N".Equals(dr[23].ToString()));
vo.IsZoomAcross = !("N".Equals(dr[24].ToString()));
vo.IsCreatedDocument = !("N".Equals(dr[25].ToString()));
vo.IsUploadedDocument = !("N".Equals(dr[26].ToString()));
vo.IsViewDocument = !("N".Equals(dr[27].ToString()));
vo.IsAttachDocumentFrom = !("N".Equals(dr[28].ToString()));
vo.IsImportMap = !("N".Equals(dr[29].ToString()));
vo.IsMarkToExport = !("N".Equals(dr[30].ToString()));
vo.IsArchive = !("N".Equals(dr[31].ToString()));
vo.IsAttachmail = !("N".Equals(dr[32].ToString()));
vo.IsRoleCenterView = !("N".Equals(dr[33].ToString()));
}
}
}
else
{
vo = null;
}
dr.Close();
dr = null;
}
catch (System.Exception ex)
{
if (dr != null)
{
dr.Close();
dr = null;
}
VLogger.Get().Log(Level.SEVERE, sql01.ToString(), ex);
return(null);
}
if (dr != null)
{
dr.Close();
dr = null;
}
// Not found
if (vo == null)
{
VLogger.Get().Log(Level.SEVERE, "No Window - AD_Window_ID=" + AD_Window_ID
+ ", AD_Role_ID=" + AD_Role_ID + " - " + sql01);
VLogger.Get().SaveError("AccessTableNoView", "(Not found)");
return(null);
}
// Read Write
if (vo.IsReadWrite == null)
{
VLogger.Get().SaveError("AccessTableNoView", "(found)");
return(null);
}
// Create Tabs
CreateTabs(vo, AD_UserDef_Win_ID);
if (vo.Tabs == null || vo.Tabs.Count == 0)
{
return(null);
}
return(vo);
} // create