private void Load_Parameter(long RepID) { string strTmp; string[] arrTmp; List <string> ddlLink = new List <string>(); List <string> lstCriteria = new List <string>(); DataSet dsDic = new DataSet(); Paramters rep_par = new Paramters(); SqlDataAdapter daObject = new SqlDataAdapter(("SELECT ObjectTitle, UseAndOnly,ByBranch,CriteriaFields,CriteriaFieldsCaptions,SortFieldsList,Criteria" + "FieldsUnique,CriteriaFieldsTypes,CriteriaFieldsOperators,CriteriaFieldsSources FROM Objects WHERE ObjectID=" + RepID), DataTools.GetConnectionStr()); Session["ReportID"] = RepID; daObject.Fill(dtObject); Session["dtObject"] = dtObject; rep_par.RepTitle = dtObject.Rows[0]["ObjectTitle"].ToString(); strTmp = ((dtObject.Rows[0]["CriteriaFields"].ToString()) == null ? "" : dtObject.Rows[0]["CriteriaFields"].ToString()).Replace("\r\n", ""); arrTmp = strTmp.Split(';'); string[] arrtmp2 = (string[])arrTmp.Clone(); for (int i = 0; (i <= (arrtmp2.Length - 1)); i++) { if ((DataTools.GetStrPart(DataTools.ReadField(dtObject.Rows[0]["CriteriaFieldsCaptions"]), i) != "")) { arrtmp2[i] = DataTools.GetStrPart(DataTools.ReadField(dtObject.Rows[0]["CriteriaFieldsCaptions"]), i); } } strTmp = string.Join(";", arrtmp2); dsDic = DataTools.GetDic(strTmp); strTmp = ""; for (int i = 0; (i <= (arrTmp.Length - 1)); i++) { strTmp = ""; foreach (DataRow dr in dsDic.Tables[0].Rows) { if ((dr[0].ToString() == arrtmp2[i])) { strTmp = dr["LatinCap"].ToString(); break; } } ddlFields.Add(((strTmp == "") ? arrTmp[i] : strTmp)); } ddlLink.Add("AND"); if (!(bool)dtObject.Rows[0]["UseAndOnly"]) { ddlLink.Add("OR"); } DataTable dtCrit = new DataTable(); Session["Criteria"] = ""; Session["CriteriaCap"] = ""; dtCrit = DataTools.DLookUp(DataTools.GetConnectionStr(), "UsersRecent", "Criteria", ("UserName='******' AND ObjectID=" + RepID))), "", "", "AccessDate DESC", 1); if ((dtCrit.Rows.Count > 0)) { string CritFromTbl = dtCrit.Rows[0][0].ToString(); if (CritFromTbl != null && (CritFromTbl.Trim() != "")) { arrTmp = CritFromTbl.ToString().Split(';'); for (int i = 0; (i <= (arrTmp.Length - 1)); i++) { ValidateLine(DataTools.GetStrSerial(dtObject.Rows[0]["CriteriaFields"].ToString(), DataTools.GetStrPart(arrTmp[i], 0, "^^^")), DataTools.GetStrPart(arrTmp[i], 1, "^^^"), DataTools.GetStrPart(arrTmp[i], 2, "^^^"), DataTools.GetStrPart(arrTmp[i], 3, "^^^"), DataTools.GetStrPart(arrTmp[i], 4, "^^^"), ref strTmp); lstCriteria.Add(DataTools.GetStrPart(Session["CriteriaCap"].ToString(), i)); //Session["lstCriteria"] = (DataTools.GetStrPart(Session["Criteria"].ToString(), i)); //Session["criteria_val"] = (DataTools.GetStrPart(Session["CriteriaCap"].ToString(), i)); } } } }