private void CbListDataBinding(object sender, EventArgs e) { var chk = (CheckBoxList)sender; var container = (IDataItemContainer)chk.NamingContainer; try { chk.Visible = visibleStatus.DefaultIfEmpty(true).First(); var xmlNod = GenXmlFunctions.GetGenXmLnode(chk.ID, "checkboxlist", (string)DataBinder.Eval(container.DataItem, _databindColumn)); var xmlNodeList = xmlNod.SelectNodes("./chk"); if (xmlNodeList != null) { foreach (XmlNode xmlNoda in xmlNodeList) { if (xmlNoda.Attributes != null) { if (xmlNoda.Attributes.GetNamedItem("data") != null) { var datavalue = xmlNoda.Attributes["data"].Value; //use the data attribute if there if ((chk.Items.FindByValue(datavalue).Value != null)) { chk.Items.FindByValue(datavalue).Selected = Convert.ToBoolean(xmlNoda.Attributes["value"].Value); } } } } } } catch (Exception) { //do nothing } }
private String BuildCategorySearch(String search, NBrightInfo searchData, String selectoperator) { var objQual = DotNetNuke.Data.DataProvider.Instance().ObjectQualifier; var dbOwner = DotNetNuke.Data.DataProvider.Instance().DatabaseOwner; // get list of selected categories. var catlist = new List<string>(); var xmlNod = GenXmlFunctions.GetGenXmLnode(searchData.XMLData, search); if (xmlNod != null) { var xmlNodeList = xmlNod.SelectNodes("./chk"); if (xmlNodeList != null) { if (xmlNodeList.Count == 0) {//dropdown list catlist.Add(xmlNod.InnerText); } else {// checkbox list foreach (XmlNode xmlNoda in xmlNodeList) { if (xmlNoda.Attributes != null && xmlNoda.Attributes["value"] != null && xmlNoda.Attributes["data"] != null) { if (xmlNoda.Attributes["value"].Value.ToLower() == "true") { catlist.Add(xmlNoda.Attributes["data"].Value); } } } } } } //build SQL var strRtn = ""; if (catlist.Count > 0) { var categorylist = ""; for (int i = 0; i < catlist.Count; i++) { categorylist += catlist[i] + ","; } categorylist = categorylist.TrimEnd(','); if (selectoperator.ToLower() == "and") { strRtn += " (select count(parentitemid) from " + dbOwner + "[" + objQual + "NBrightBuy] where typecode = 'CATXREF' and parentitemid = NB1.[ItemId] and XrefItemId in (" + categorylist + ")) = " + catlist.Count + " "; } else { if (selectoperator.ToLower() == "cascade") { strRtn += "NB1.[ItemId] in (select parentitemid from " + dbOwner + "[" + objQual + "NBrightBuy] where (typecode = 'CATCASCADE' or typecode = 'CATXREF') and XrefItemId in (" + categorylist + ")) "; } else { strRtn += "NB1.[ItemId] in (select parentitemid from " + dbOwner + "[" + objQual + "NBrightBuy] where typecode = 'CATXREF' and XrefItemId in (" + categorylist + ")) "; } } } else { // no categories selected, so add sql to stop display strRtn += "NB1.[ItemId] = -1"; } return strRtn; }
public UserDataInfo(int portalId, int moduleId, DataCtrlInterface objCtrl, string ctrlTypeCode) { _objCtrl = objCtrl; PortalId = portalId; ModuleId = moduleId; SearchPortalId = portalId; SearchModuleId = 0; // don't auto link search moduledid to module. (This is done in the "EventBeforeBindListData" event) CtrlTypeCode = ctrlTypeCode; UserDataKey = Cookie.GetCookieValue(portalId, "UserDataInfo", "UserDataKey", moduleId.ToString("")); if (UserDataKey != "") { var strFilter = " and guidkey = '" + UserDataKey + "' "; var l = objCtrl.GetList(portalId, moduleId, "USERDATAINFO", strFilter, "", 1); if (l.Count >= 1) { _obj = l[0]; } if (_obj == null) { CreateNewUserDataInfoRecord(); } } else { CreateNewUserDataInfoRecord(); } if (_obj == null) { return; } ItemId = _obj.ItemID; GUIDKey = _obj.GUIDKey; var s = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/current/tabid"); if (Utils.IsNumeric(s)) { TabId = Convert.ToInt32(s); } else { TabId = -1; } SkinSrc = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/current/skinsrc"); EntityTypeCode = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/current/entitytypecode"); EntityTypeCodeLang = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/current/entitytypecodelang"); RtnSelUrl = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/current/rtnselurl"); RtnUrl = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/current/rtnurl"); FromItemId = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/current/fromitemid"); SelItemId = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/current/selitemid"); SelType = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/current/seltype"); SortItemId = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/current/sortitemid"); if (CtrlTypeCode != null) { SearchClearAfter = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/" + CtrlTypeCode.ToLower() + "/searchclearafter"); SearchExtra1 = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/" + CtrlTypeCode.ToLower() + "/searchextra1"); SearchExtra2 = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/" + CtrlTypeCode.ToLower() + "/searchextra2"); SearchFilters = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/" + CtrlTypeCode.ToLower() + "/searchfilters"); SearchOrderby = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/" + CtrlTypeCode.ToLower() + "/searchorderby"); SearchPageNumber = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/" + CtrlTypeCode.ToLower() + "/searchpagenumber"); SearchReturnLimit = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/" + CtrlTypeCode.ToLower() + "/searchreturnlimit"); SearchDate1 = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/" + CtrlTypeCode.ToLower() + "/searchsearchdate1"); SearchDate2 = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/" + CtrlTypeCode.ToLower() + "/searchsearchdate2"); var strSearchPortalId = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/" + CtrlTypeCode.ToLower() + "/searchportalid"); if (Utils.IsNumeric(strSearchPortalId) && (Convert.ToInt32(strSearchPortalId) > 0)) { SearchPortalId = Convert.ToInt32(strSearchPortalId); } var strSearchModuleId = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/" + CtrlTypeCode.ToLower() + "/searchmoduleid"); if (Utils.IsNumeric(strSearchModuleId) && (Convert.ToInt32(strSearchModuleId) > 0 | Convert.ToInt32(strSearchModuleId) == -1)) { SearchModuleId = Convert.ToInt32(strSearchModuleId); } var xmlNod = GenXmlFunctions.GetGenXmLnode(_obj.XMLData, "root/" + CtrlTypeCode.ToLower() + "/searchgenxml"); if (xmlNod != null) { SearchGenXml = xmlNod.InnerXml; } else { SearchGenXml = ""; } } var d = new XmlDocument(); s = GenXmlFunctions.GetGenXmlValue(_obj.XMLData, "root/extraxml"); if (s != "") { d.LoadXml(s); } ExtraXml = d; }