public static DbSearchEntity ItemSelect(DbSearchEntity dbSearchEntity)
{
DbSearchDBEntity dbParm = (dbSearchEntity.DbSearchDBEntity.Count > 0) ? dbSearchEntity.DbSearchDBEntity[0] : new DbSearchDBEntity();
if (String.IsNullOrEmpty(dbParm.SqlContent))
{
return dbSearchEntity;
}
dbSearchEntity.QueryResult = HotelVp.Common.DBUtility.DbHelperOra.Query(dbParm.SqlContent,true);
return dbSearchEntity;
}
public static DbSearchEntity ItemSqlSelect(DbSearchEntity dbSearchEntity)
{
DbSearchDBEntity dbParm = (dbSearchEntity.DbSearchDBEntity.Count > 0) ? dbSearchEntity.DbSearchDBEntity[0] : new DbSearchDBEntity();
if (String.IsNullOrEmpty(dbParm.SqlContent))
{
return dbSearchEntity;
}
DataCommand cmd = DataCommandManager.CreateCustomDataCommand("CMS", CommandType.Text, dbParm.SqlContent);
dbSearchEntity.QueryResult = cmd.ExecuteDataSet();
return dbSearchEntity;
}
public static DbSearchEntity ItemSqlSelect(DbSearchEntity dbsearchEntity)
{
dbsearchEntity.LogMessages.MsgType = MessageType.INFO;
dbsearchEntity.LogMessages.Content = _nameSpaceClass + "ItemSqlSelect";
LoggerHelper.LogWriter(dbsearchEntity.LogMessages);
try
{
return DbSearchDA.ItemSqlSelect(dbsearchEntity);
}
catch (Exception ex)
{
dbsearchEntity.LogMessages.MsgType = MessageType.ERROR;
dbsearchEntity.LogMessages.Content = _nameSpaceClass + "ItemSqlSelect Error: " + ex.Message;
LoggerHelper.LogWriter(dbsearchEntity.LogMessages);
throw ex;
}
}
public static DbSearchEntity TableColumsSelect(DbSearchEntity dbSearchEntity)
{
OracleParameter[] parm ={
new OracleParameter("TABLENM",OracleType.VarChar)
};
DbSearchDBEntity dbParm = (dbSearchEntity.DbSearchDBEntity.Count > 0) ? dbSearchEntity.DbSearchDBEntity[0] : new DbSearchDBEntity();
if (String.IsNullOrEmpty(dbParm.TableID))
{
return dbSearchEntity;
}
else
{
parm[0].Value = dbParm.TableID;
}
//string strSQL = HotelVp.Common.DBUtility.XmlSqlAnalyze.GotSqlTextFromXml("DbSearch", "t_lm_b_dbsearch_tablecolums");
//strSQL = String.Format(strSQL, dbParm.TableID);
//dbSearchEntity.QueryResult = HotelVp.Common.DBUtility.DbHelperOra.Query(strSQL);
dbSearchEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("DbSearch", "t_lm_b_dbsearch_tablecolums",true, parm);
return dbSearchEntity;
}
public static DbSearchEntity SqlMenuSelectFromCMS(DbSearchEntity dbSearchEntity)
{
DataCommand cmd = DataCommandManager.GetDataCommand("SelectSqlMenuSelectFromCMS");
dbSearchEntity.QueryResult = cmd.ExecuteDataSet();
return dbSearchEntity;
}
public static DbSearchEntity MenuSelect(DbSearchEntity dbSearchEntity)
{
dbSearchEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("DbSearch", "t_lm_b_dbsearch_table", true);
return dbSearchEntity;
}