//public static MUserQuery[] Get(Context ctx, int AD_Tab_ID, int AD_Table_ID) //{ // int AD_Client_ID = ctx.GetAD_Client_ID(); // string sqlQry = "SELECT * FROM AD_UserQuery WHERE" // + " AD_Client_ID=" + AD_Client_ID + " AND IsActive='Y'" // + " AND (AD_Tab_ID=" + AD_Tab_ID + " OR AD_Table_ID=" + AD_Table_ID + ")" // + " ORDER BY Name"; // List<MUserQuery> list = new List<MUserQuery>(); // try // { // DataSet ds = ExecuteQuery.ExecuteDataset(sqlQry); // int iTot = ds.Tables[0].Rows.Count; // for (int iRow = 0; iRow < iTot; iRow++) // { // list.Add(new MUserQuery(ctx, ds.Tables[0].Rows[iRow], null)); // } // } // catch (Exception e) // { // _log.Log(Level.SEVERE, sql, e); // } // MUserQuery[] retValue = new MUserQuery[list.Count]; // //list.ToArray(retValue); // retValue = list.ToArray(); // return retValue; //} //public static MUserQuery Get(Context ctx, int AD_Tab_ID, string name) //{ // int AD_Client_ID = ctx.GetAD_Client_ID(); // if (name == null) // name = "%"; // string sqlQry = "SELECT * FROM AD_UserQuery WHERE" // + " AD_Client_ID=" + AD_Client_ID + " AND AD_Tab_ID=" + AD_Tab_ID + " AND" // + " UPPER(Name) LIKE '" + name.ToUpper() + "' AND IsActive='Y'" // + " ORDER BY Name"; // MUserQuery retValue = null; // try // { // DataSet ds = ExecuteQuery.ExecuteDataset(sqlQry); // int iTot = ds.Tables[0].Rows.Count; // for (int iRow = 0; iRow < iTot; iRow++) // { // retValue = new MUserQuery(ctx, ds.Tables[0].Rows[iRow], null); // } // } // catch (Exception e) // { // _log.Log(Level.SEVERE, sql, e); // } // return retValue; //} //public static List<string> GetSavedQueryNames(int AD_Client_ID, int AD_Tab_ID) //{ // string sqlQry = "SELECT Name FROM AD_UserQuery WHERE" // + " AD_Client_ID=" + AD_Client_ID + " AND AD_Tab_ID=" + AD_Tab_ID + " AND IsActive='Y'" // + " ORDER BY Name"; // List<string> retValue = new List<string>(); // try // { // IDataReader dr = ExecuteQuery.ExecuteReader(sqlQry); // while (dr.Read()) // { // string name = dr[0].ToString(); // retValue.Add(name); // } // dr.Close(); // } // catch (Exception e) // { // _log.Log(Level.SEVERE, sql, e); // } // return retValue; //} //public static List<string> GetSavedQueryNamesForUser(int AD_User_ID, int AD_Tab_ID) //{ // string sqlQry = "SELECT Name FROM AD_UserQuery WHERE" // + " AD_User_ID=" + AD_User_ID + " AND AD_Tab_ID=" + AD_Tab_ID + " AND IsActive='Y'" // + " ORDER BY Name"; // List<string> retValue = new List<string>(); // try // { // IDataReader dr = ExecuteQuery.ExecuteReader(sqlQry); // while (dr.Read()) // { // string name = dr[0].ToString(); // retValue.Add(name); // } // dr.Close(); // } // catch (Exception e) // { // _log.Log(Level.SEVERE, sql, e); // } // return retValue; //} //public static MUserQuery GetForUser(Context ctx, int AD_Tab_ID, string name) //{ // int AD_User_ID = ctx.GetAD_User_ID(); // if (name == null) // name = "%"; // string sqlQry = "SELECT * FROM AD_UserQuery WHERE" // + " AD_User_ID=" + AD_User_ID + " AND AD_Tab_ID=" + AD_Tab_ID + " AND" // + " UPPER(Name) LIKE '" + name.ToUpper() + "' AND IsActive='Y'" // + " ORDER BY Name"; // MUserQuery retValue = null; // try // { // DataSet ds = ExecuteQuery.ExecuteDataset(sqlQry); // int iTot = ds.Tables[0].Rows.Count; // for (int iRow = 0; iRow < iTot; iRow++) // { // retValue = new MUserQuery(ctx, ds.Tables[0].Rows[iRow], null); // } // } // catch (Exception e) // { // _log.Log(Level.SEVERE, sql, e); // } // return retValue; //} //public MUserQueryLine[] GetLines(bool isReload) //{ // if (_lines != null && !isReload) // return _lines; // List<MUserQueryLine> list = new List<MUserQueryLine>(); // string sqlQry = "SELECT * FROM AD_UserQueryLine WHERE AD_UserQuery_ID=" + GetAD_UserQuery_ID() + " ORDER BY SeqNo"; // try // { // //pstmt = DataBase.prepareStatement(sqlQry, get_TrxName()); // //pstmt.setInt(1, getAD_UserQuery_ID()); // //ResultSet rs = pstmt.executeQuery(); // //while (rs.next()) // // list.add(new MUserQueryLine(getCtx(), rs, get_TrxName())); // //rs.close(); // //pstmt.close(); // //pstmt = null; // DataSet ds = ExecuteQuery.ExecuteDataset(sqlQry); // int iTot = ds.Tables[0].Rows.Count; // for (int iRow = 0; iRow < iTot; iRow++) // { // list.Add(new MUserQueryLine(GetCtx(), ds.Tables[0].Rows[iRow], Get_Trx())); // } // } // catch (Exception e) // { // log.Log(Level.SEVERE, sql, e); // } // // // _lines = new MUserQueryLine[list.Count]; // _lines = list.ToArray(); // return _lines; //} #endregion /// <summary> /// Get query lines of a query /// </summary> /// <returns>Dataset</returns> public DataSet GetQueryLines() { DataSet ds = null; string sql = "SELECT KEYNAME,KEYVALUE,OPERATOR AS OPERATORNAME,VALUE1NAME," + "VALUE1VALUE,VALUE2NAME,VALUE2VALUE,AD_USERQUERYLINE_ID FROM AD_UserQueryLine WHERE AD_UserQuery_ID=" + GetAD_UserQuery_ID() + " ORDER BY SeqNo"; try { ds = DataBase.DB.ExecuteDataset(sql, null, null); if (ds != null) { ds.Tables[0].Columns.Add("OPERATOR"); DataRow dr; string optrName = ""; string optr = ""; for (int iRow = 0; iRow < ds.Tables[0].Rows.Count; iRow++) { dr = ds.Tables[0].Rows[iRow]; optrName = ds.Tables[0].Rows[iRow]["OPERATORNAME"].ToString(); for (int i = 0; i < Query.OPERATORS.Length; i++) { VAdvantage.Model.ValueNamePair pp = Query.OPERATORS[i]; if (pp.GetValue().Equals(optrName)) { optr = pp.GetName(); break; } } dr[8] = optr; } } } catch (Exception ex) { if (ds != null) { ds = null; } _log.Log(Level.SEVERE, sql, ex); } return(ds); }
} // rollback // To get last log error while saving any MClass Suggested by Mukesh Sir and written by Manjot public virtual string GetRetrievedError(VAdvantage.Model.PO po, string defaultmsg) { VAdvantage.Model.ValueNamePair vp = VLogger.RetrieveError(); if (vp != null) { string tableName = string.Empty; string val = vp.GetName(); string connectionName = DataBase.VConnection.Get().Db_uid.ToUpper(); if (val.Contains(".")) { tableName = Util.GetValueOfString(DB.ExecuteScalar("SELECT Name FROM AD_Table WHERE AD_Table_ID =" + po.Get_Table_ID())); val = val.Replace(connectionName, string.Empty).Replace(po.Get_TableName().ToUpper(), string.Empty).Replace('"', ' ').Trim(); val = val.Substring(val.IndexOf(":") + 1).Replace(".", string.Empty).Replace(@")(", string.Empty); } log.SaveError(Msg.GetMsg(GetCtx(), "VIS_Erroron") + tableName + " :- ", val); return(Msg.GetMsg(GetCtx(), "VIS_Erroron") + tableName + " :-" + val); } log.SaveError(defaultmsg, ""); return(Msg.GetMsg(GetCtx(), defaultmsg)); }