public static string SaveFileInfo(string information, string viewName, string reference) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); return(iWrapFunctions.SaveFileInfo(information, viewName, reference)); }
public static string GetInfoForThisFile(string viewName, string fileName) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); return(iWrapFunctions.GetInfoForThisFile(viewName, fileName)); }
public static string GetListQueryByListName(string sqlFrom, string whereClause, string rep_code, string listName) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); string[] listQueryAndDescription = GetListQueryAndDescriptionByName(listName, rep_code).Split(new string[] { "@@@@" }, StringSplitOptions.None); string listQuery = listQueryAndDescription[0]; string[] fields = HIT.OB.STD.CommonUtil.ExtractFieldNameFromQuery(listQuery).Split(','); List <string> columnField = new List <string>(); DataTable dtData = iWrapFunctions.GetDataTable("SELECT * FROM " + sqlFrom); listQuery = RemoveFieldsFromWhereClauseWhichValuesAreNotAvailable(listQuery, fields, columnField, dtData); string sqlQuery = "select " + string.Join(",", columnField.ToArray()) + " FROM " + sqlFrom + " WHERE " + whereClause; dtData = iWrapFunctions.GetDataTable(sqlQuery); foreach (string field in columnField) { listQuery = listQuery.Replace("%" + field + "%", "'" + dtData.Rows[0][field].ToString().Trim() + "'"); } return(listQuery); }
public static string ValidateDeepLink(ref string deepLinkReport, string whereClause) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); return(iWrapFunctions.ValidateDeepLink(ref deepLinkReport, whereClause)); }
public static string GetItemInfoByItemNo(string sqlFrom, string whereClause, string selectedFields) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); //string strSql = "Select " + string.Join(",", selectedFields.Split(';')) + " from " + sqlFrom + " where " + whereClause; string strSql = "Select distinct " + selectedFields + " from " + sqlFrom + " where " + whereClause; DataTable dtPartlistInfo = iWrapFunctions.GetDataTable(strSql); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("ItemInfo:["); //int rowNum = 1; for (int i = 0; i < dtPartlistInfo.Rows.Count; i++) { DataRow currentRow = dtPartlistInfo.Rows[i]; // stringBuilder.Append("[\"" + (i + 1).ToString() + "\","); stringBuilder.Append("["); foreach (DataColumn column in dtPartlistInfo.Columns) { stringBuilder.AppendFormat("\"{0}\",", GetJSONFormat(currentRow[column.ColumnName].ToString())); } stringBuilder = stringBuilder.Remove(stringBuilder.ToString().LastIndexOf(','), 1); stringBuilder.Append("]"); if (i < dtPartlistInfo.Rows.Count - 1) { stringBuilder.Append(","); } } stringBuilder.Append("]"); return("{" + stringBuilder + "}"); }
public static string UpdateBusket(string sqlFrom) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); DataTable dtPartlistInfo = iWrapFunctions.GetDataTable(sqlFrom); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("ItemInfo:["); //int rowNum = 1; for (int i = 0; i < dtPartlistInfo.Rows.Count; i++) { DataRow currentRow = dtPartlistInfo.Rows[i]; // stringBuilder.Append("[\"" + (i + 1).ToString() + "\","); stringBuilder.Append("["); foreach (DataColumn column in dtPartlistInfo.Columns) { stringBuilder.AppendFormat("\"{0}\",", GetJSONFormat(currentRow[column.ColumnName].ToString())); } stringBuilder = stringBuilder.Remove(stringBuilder.ToString().LastIndexOf(','), 1); stringBuilder.Append("]"); if (i < dtPartlistInfo.Rows.Count - 1) { stringBuilder.Append(","); } } stringBuilder.Append("]"); return("{" + stringBuilder + "}"); }
public static string GetReportList(string roleName) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); DataTable dtReportInfo = iWrapFunctions.GetReportList(roleName); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("reportList:["); for (int r = 0; r < dtReportInfo.Rows.Count; r++) { DataRow reportInfoRow = dtReportInfo.Rows[r]; stringBuilder.Append("{"); stringBuilder.AppendFormat("report_code: '{0}'", reportInfoRow["report_code"].ToString()); stringBuilder.AppendFormat(",report_name: '{0}'", reportInfoRow["report_name"].ToString()); stringBuilder.Append("}"); if (r < dtReportInfo.Rows.Count - 1) { stringBuilder.Append(","); } } dtReportInfo.Dispose(); stringBuilder.Append("]"); return("{" + stringBuilder + "}"); }
public static DataTable GetReportCodeList() { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); return(iWrapFunctions.GetReportList()); }
public static string UpdateFileInfo(string information, string viewName, string relfilename) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); return(iWrapFunctions.UpdateFileInfo(information, viewName, relfilename)); }
public static bool InsertGroupColor(string REPORT_CODE, string GROUP_BY, string GROUP_CODE, string COLOR_CODE) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iOBFunctions = dbManagerFactory.GetDBManager(); bool result = iOBFunctions.InsertGroupColor(REPORT_CODE, GROUP_BY, GROUP_CODE, COLOR_CODE); return(result); }
internal static bool CreateNewReportWithSettings(string REPORT_CODE, string REPORT_NAME, string SQL_WHERE, string GROUP_BY, string ORDER_BY, string ORDER_BY_DIR, string field_caps, string report_settings, string sid, string reports, string obs) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iOBFunctions = dbManagerFactory.GetDBManager(); iOBFunctions.CreateNewReportWithSettings(REPORT_CODE, REPORT_NAME, SQL_WHERE, GROUP_BY, ORDER_BY, ORDER_BY_DIR, field_caps, report_settings, sid, reports, obs); return(true); }
public static bool DeleteReport(string rep_code) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); string result = iWrapFunctions.DeleteReport(rep_code); return(result == "success" ? true : false); }
internal static bool UpdateUserDefinedReportSettings(string REPORT_CODE, string SQL_WHERE, string GROUP_BY, string ORDER_BY, string ORDER_BY_DIR, string report_settings) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iOBFunctions = dbManagerFactory.GetDBManager(); iOBFunctions.UpdateUserDefinedReportSettings(REPORT_CODE, SQL_WHERE, GROUP_BY, ORDER_BY, ORDER_BY_DIR, report_settings); return(true); }
public static string GetReportConfigInfo(string rep_code) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); DataRow drRepportConfigInfo = iWrapFunctions.GetReportConfigInfo(rep_code); return(drRepportConfigInfo["SQL_FROM"].ToString()); }
public static string GetListQueryAndDescriptionByName(string listName, string rep_code) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); DataTable listInfoTable = iWrapFunctions.GetReportExtensionInfo(rep_code); return(listInfoTable.Rows[0]["list_" + listName + "sql"].ToString() + "@@@@" + listInfoTable.Rows[0]["description_list_" + listName + "sql"].ToString()); }
public static string GetPartlistQueryAndKeys(string sqlFrom, string whereClause, string rep_code) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); string artCodeRevisonAndQuery = iWrapFunctions.GetArticleCodeAndRevisionAndPartlistDataQuery(sqlFrom, whereClause.Replace("|", "'"), rep_code); string[] partlistInfoArray = artCodeRevisonAndQuery.Split(new string[] { "@@@@" }, StringSplitOptions.None); string artRevInfo = "Keys:['" + partlistInfoArray[0] + "','" + partlistInfoArray[1] + "'],"; return("{" + artRevInfo + "Query:[\"" + partlistInfoArray[2] + "\"]}"); }
public static string GetAvailableListQueryPair(string sqlFrom, string whereClause, string rep_code) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); DataTable listInfoTable = iWrapFunctions.GetReportExtensionInfo(rep_code); List <string> columnsNamelist = new List <string>(); foreach (DataColumn column in listInfoTable.Columns) { if (column.ColumnName.StartsWith("list")) { columnsNamelist.Add(column.ColumnName); } } StringBuilder listNameQueryPair = new StringBuilder(); listNameQueryPair.Append("{listNameQueryPair:["); if (listInfoTable.Rows.Count > 0) { int i = 0; string queryValue = string.Empty; foreach (string column in columnsNamelist) { if (!listInfoTable.Rows[0][column].ToString().Equals(string.Empty)) { //queryDescription.AppendFormat("['{0}','{1}']", listInfoTable.Rows[0][column], listInfoTable.Rows[0]["description_" + column]); queryValue = listInfoTable.Rows[0][column].ToString(); if (queryValue.Contains("AS")) { queryValue.Replace("\"", ";double;Quote;"); } listNameQueryPair.AppendFormat("['{0}','{1}']", column.Replace("sql", string.Empty).Replace("list_", string.Empty).ToUpperFirstChar(), queryValue); if (i < columnsNamelist.Count - 1) { listNameQueryPair.Append(","); } } i++; } } listNameQueryPair.Append("]}"); return(listNameQueryPair.ToString()); }
public static bool CheckForReportCodeAvailability(string rep_code) { bool isAvailable = true; DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); DataTable dt = iWrapFunctions.GetDataTable("select * from dfn_repdetail where upper(report_code) = '" + rep_code.ToUpper() + "'"); if (dt.Rows.Count > 0) { isAvailable = false; } return(isAvailable); }
public static string GetPartlistInfo(string sqlFrom, string whereClause, string rep_code) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); string artCodeRevisonAndQuery = iWrapFunctions.GetArticleCodeAndRevisionAndPartlistDataQuery(sqlFrom, whereClause.Replace("|", "'"), rep_code); string[] partlistInfoArray = artCodeRevisonAndQuery.Split(new string[] { "@@@@" }, StringSplitOptions.None); DataTable dtPartlistInfo = iWrapFunctions.GetPartlistInfo(partlistInfoArray[2]); StringBuilder stringBuilder = new StringBuilder(); stringBuilder = GetColumnInfoGridInfoFromDataTable(dtPartlistInfo, stringBuilder); string artRevInfo = "Keys:['" + partlistInfoArray[0] + "','" + partlistInfoArray[1] + "'],"; return("{" + artRevInfo + stringBuilder + "}"); }
public static string GetBaseMaterialDetail(string keyNameValues, string rep_code) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); DataTable dtBaseMaterial = iWrapFunctions.GetBaseMaterialDetail(keyNameValues, rep_code); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("\"columnInfo\":["); string columns = string.Empty; foreach (DataColumn column in dtBaseMaterial.Columns) { columns += "\"" + column.ColumnName + "\","; } stringBuilder.Append(columns); stringBuilder = stringBuilder.Remove(stringBuilder.ToString().LastIndexOf(','), 1); stringBuilder.Append("],"); stringBuilder.Append("gridInfo:["); //int rowNum = 1; for (int i = 0; i < dtBaseMaterial.Rows.Count; i++) { DataRow currentRow = dtBaseMaterial.Rows[i]; //stringBuilder.Append("[\"" + rowNum + "\","); stringBuilder.Append("["); foreach (DataColumn column in dtBaseMaterial.Columns) { stringBuilder.AppendFormat("\"{0}\",", GetJSONFormat(currentRow[column.ColumnName].ToString())); } stringBuilder = stringBuilder.Remove(stringBuilder.ToString().LastIndexOf(','), 1); stringBuilder.Append("]"); if (i < dtBaseMaterial.Rows.Count - 1) { stringBuilder.Append(","); } } stringBuilder.Append("]"); return("{" + stringBuilder + "}"); }
public static string GetReportArguments(string reportCode) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); DataTable dtReportInfo = iWrapFunctions.GetReportArguments(reportCode); StringBuilder settingsBuilder = new StringBuilder(); string sqlSelect = string.Empty; string FieldList = ""; StringBuilder sqlkeyfields = new StringBuilder(); StringBuilder detailSqlFields = new StringBuilder(); string fieldTypesJson = ""; string keyfields = string.Empty; string detailSqlFieldSets = string.Empty; if (dtReportInfo.Rows.Count > 0) { DataRow reportInfoRow = dtReportInfo.Rows[0]; string sqlFrom = reportInfoRow["sql_from"].ToString(); string reportSettings = reportInfoRow["report_settings"].ToString(); string orderBy = reportInfoRow["sql_orderby"].ToString(); string groupBy = reportInfoRow["sql_groupby"].ToString(); if (string.IsNullOrEmpty(groupBy)) { groupBy = "NONE"; } string fieldNameAndType = GetFieldAndTypeList(reportInfoRow["sql_from"].ToString(), reportCode); string sqlWhere = reportInfoRow["sql_where"].ToString(); if (!string.IsNullOrEmpty(sqlWhere)) { string isWhereValid = HIT.OB.STD.Core.BLL.OBController.ValidateWhereClause(reportCode, sqlFrom, sqlWhere); if (isWhereValid != "true") { sqlWhere = "INVALID_WHERE"; } } string fieldCaps = reportInfoRow["field_caps"].ToString().Replace(',', ';').Trim(new char[] { ';' }); FieldList = fieldNameAndType.Split(new string[] { "$$$$" }, StringSplitOptions.None)[0]; fieldTypesJson = fieldNameAndType.Split(new string[] { "$$$$" }, StringSplitOptions.None)[1]; settingsBuilder.AppendFormat("report_code: \"{0}\"", GetJSONFormat(reportCode)); settingsBuilder.AppendFormat(",report_name: \"{0}\"", GetJSONFormat(reportInfoRow["report_name"].ToString())); settingsBuilder.AppendFormat(",field_caps: \"{0}\"", GetJSONFormat(fieldCaps)); string selectedFields = FieldList.Replace("'", "").Replace(',', ';').Trim(';'); settingsBuilder.AppendFormat(",sql_select: \"{0}\"", GetJSONFormat(selectedFields)); settingsBuilder.AppendFormat(",sql_from: \"{0}\"", GetJSONFormat(sqlFrom)); settingsBuilder.AppendFormat(",sql_where: \"{0}\"", GetJSONFormat(sqlWhere)); settingsBuilder.AppendFormat(",sql_groupby: \"{0}\"", GetJSONFormat(groupBy)); settingsBuilder.AppendFormat(",gis_theme_layer: \"{0}\"", reportInfoRow["gis_theme_layer"].ToString().ToLower()); settingsBuilder.AppendFormat(",sql_orderby: \"{0}\"", GetJSONFormat(orderBy)); settingsBuilder.AppendFormat(",sql_orderdir: \"{0}\"", GetJSONFormat(reportInfoRow["sql_orderdir"].ToString())); settingsBuilder.AppendFormat(",report_settings: \"{0}\"", GetJSONFormat(reportSettings)); string multiSelect = reportInfoRow["multiselect"].ToString().ToLower(); settingsBuilder.AppendFormat(",multiselect: \"{0}\"", multiSelect); // sqlSelect = reportInfoRow["sql_select"].ToString(); detailSqlFieldSets = reportInfoRow["detail_fieldsets"].ToString().Replace(",", ";").Trim(';'); detailSqlFields.AppendFormat("detailsqlfields: \"{0}\"", GetJSONFormat(detailSqlFieldSets)); keyfields = reportInfoRow["sql_keyfields"].ToString().Replace(',', ';').Trim(';'); sqlkeyfields.AppendFormat("sqlkeyfields: {0}", GetJSONFormat(SQLKeyFieldsJSON(keyfields))); } dtReportInfo.Dispose(); //***Report function processing DataTable dtFunctionReportInfo = iWrapFunctions.GetReportFunctionsList(reportCode); StringBuilder functionList = new StringBuilder(); StringBuilder sqlMandatory = new StringBuilder(); string parameters = string.Empty; string sqlFunList = string.Empty; string imageUrls = string.Empty; string orderPos = string.Empty; string temp = string.Empty; string commonParams = string.Empty; string iscustom = string.Empty; if (dtFunctionReportInfo.Rows.Count > 0) { foreach (DataRow dr in dtFunctionReportInfo.Rows) { sqlFunList = dr["function_name"].ToString(); orderPos = dr["order_position"].ToString(); parameters = dr["parameters"].ToString().Replace(',', ';').Trim(new char[] { ';' }); iscustom = dr["iscustom"].ToString().ToLower(); // getting sqlparameters as semicolon separated. parameters = parameters.Trim(';'); StringBuilder param = new StringBuilder(); param.Append("'").Append(parameters.Replace(";", "','")).Append("'"); // checking common parameters. commonParams = CommonParameters(parameters, commonParams); functionList.AppendFormat("['{0}','{1}','{2}',[{3}]]", sqlFunList.ToUpper(), orderPos, iscustom, param.ToString()); functionList.Append(","); } // END of foreach commonParams = CompareSqlManSqlKey(commonParams, keyfields); functionList.Remove(functionList.ToString().LastIndexOf(','), 1); sqlMandatory.Append("'").Append(commonParams).Append("'"); } else { sqlMandatory.Append(""); functionList.Append(""); } dtFunctionReportInfo.Dispose(); return("{settings:{" + settingsBuilder.ToString() + "},fieldTypes:{" + fieldTypesJson + "},fieldList:[" + FieldList + "]" + ",sqlmandatory:[" + sqlMandatory.ToString() + "],functionlist:[" + functionList.ToString() + "]," + sqlkeyfields.ToString() + "," + detailSqlFields.ToString() + "}"); }
public static string GetListItemInfo(string sqlFrom, string whereClause, string rep_code, string listName, string selectedFields) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); string[] listQueryAndDescription = GetListQueryAndDescriptionByName(listName, rep_code).Split(new string[] { "@@@@" }, StringSplitOptions.None); string listQuery = listQueryAndDescription[0]; string[] fields = HIT.OB.STD.CommonUtil.ExtractFieldNameFromQuery(listQuery).Split(','); List <string> columnField = new List <string>(); DataTable dtData = iWrapFunctions.GetDataTable("SELECT * FROM " + sqlFrom); listQuery = RemoveFieldsFromWhereClauseWhichValuesAreNotAvailable(listQuery, fields, columnField, dtData); string[] requiredField = selectedFields.Split(';'); string currentRevision = string.Empty; string sqlQuery = "select " + string.Join(",", columnField.ToArray()) + (selectedFields.Length > 0 ? ("," + selectedFields.Replace(';', ',')) : "") + " FROM " + sqlFrom + " WHERE " + whereClause.Substring(0, whereClause.IndexOf("AND")); dtData = iWrapFunctions.GetDataTable(sqlQuery); foreach (string field in columnField) { if (field.Contains("revision")) { listQuery = listQuery.Replace("%revision%", whereClause.Split('=')[2].ToString().Trim()); } else { listQuery = listQuery.Replace("%" + field + "%", "'" + dtData.Rows[0][field].ToString().Trim() + "'"); } if (field.Contains("rev")) { //currentRevision = dtData.Rows[0]["revision"].ToString(); currentRevision = whereClause.Split('=')[2].ToString().Replace("'", "").Trim(); } } DataTable dtPartlistInfo = iWrapFunctions.GetPartlistInfo(listQuery); DataTable dtMainPartList = dtPartlistInfo.Clone(); foreach (DataRow row in dtPartlistInfo.Rows) { DataRow newMainRow = dtMainPartList.NewRow(); newMainRow[0] = row[0]; newMainRow[1] = row[1]; newMainRow[2] = row[2]; newMainRow[3] = row[3]; newMainRow[4] = row[4]; newMainRow[5] = row[5]; newMainRow[6] = row[6]; newMainRow[7] = row[7]; newMainRow[8] = row[8]; newMainRow[9] = row[9]; dtMainPartList.Rows.Add(newMainRow); string childComp_itemNo = row["comp_item"].ToString(); string childItemNo = row["item"].ToString(); string childRevNo = row["revision"].ToString(); //childQuery = "SELECT * FROM rc_bom WHERE item='" + childItemNo + "' AND revision='" + childRevNo + "' ORDER BY pos_nr"; if (!childComp_itemNo.Equals(childItemNo)) { string childQuery = listQueryAndDescription[0]; childQuery = childQuery.Replace("%item%", "'" + childComp_itemNo + "'"); childQuery = childQuery.Replace("%revision%", "'" + childRevNo + "'"); DataTable dtChildPartList = iWrapFunctions.GetPartlistInfo(childQuery); foreach (DataRow childRow in dtChildPartList.Rows) { //dtMainPartList.ImportRow(childRow); DataRow newrow = dtMainPartList.NewRow(); newrow[0] = childRow[0]; newrow[1] = childRow[1]; newrow[2] = childRow[2]; newrow[3] = childRow[3]; newrow[4] = childRow[4]; newrow[5] = childRow[5]; newrow[6] = childRow[6]; newrow[7] = childRow[7]; newrow[8] = childRow[8]; newrow[9] = childRow[9]; //newrow = childRow; //newrow[ = childRow; dtMainPartList.Rows.Add(newrow); } } } StringBuilder stringBuilder = new StringBuilder(); //stringBuilder = GetColumnInfoGridInfoFromDataTable(dtPartlistInfo, stringBuilder); stringBuilder = GetColumnInfoGridInfoFromDataTable(dtMainPartList, stringBuilder); string firstLabel = columnField[0].ToUpperFirstChar() + " : " + dtData.Rows[0][0].ToString(); string secondLabel = string.Empty; if (dtData.Rows[0][requiredField[0]].ToString() != string.Empty && (!columnField.Contains(requiredField[0]))) { secondLabel = requiredField[0].ToUpperFirstChar() + " : " + dtData.Rows[0][requiredField[0]].ToString(); } string thirdLabel = string.Empty; if (dtData.Rows[0][requiredField[1]].ToString() != string.Empty && (!columnField.Contains(requiredField[1]))) { thirdLabel = requiredField[1].ToUpperFirstChar() + " : " + dtData.Rows[0][requiredField[1]].ToString(); } string artRevInfo = "Keys:['" + firstLabel + "','" + secondLabel + "','" + thirdLabel + "','" + listQueryAndDescription[1] + "','" + currentRevision + "'],"; string revision = GetRevision(whereClause, sqlFrom, iWrapFunctions); return("{" + artRevInfo + revision + stringBuilder + "}"); }