public FilterParamList(MEDMDefClass dc, XmlNode xrequest) { foreach (XmlNode xparam in xrequest.SelectNodes("descendant::param")) { string[] nn = XFunc.GetAttr(xparam, "name", "").Split('.'); string n = nn[0]; string m = ""; if (nn.Length > 1) { if (nn[0].ToLower() == "filter") { n = nn[nn.Length - 1]; if (nn.Length == 3) { m = nn[1].ToLower(); } } if (nn[0].ToLower() == "paginator") { n = nn[nn.Length - 1]; if (n.ToLower() == "top") { Top = MFunc.StringToInt(XFunc.GetText(xparam, ""), 0); continue; } } } MEDMDefProperty dp = dc.Properties[n]; if (dp != null) { object v = dp.ConvertToPropertyType(XFunc.GetText(xparam, "")); Add(new FilterParam(n, m, v)); } } }
private int GetLen(MEDMDefProperty dp) { return(dp.Length); /* * if (dp.Length > 0) return dp.Length; * switch (dp.GetDataTypeFor740()) * { * case "num": * return 10; * case "date": * return 10; * } * return dp.Header.Length + 1; */ }
protected override void RunRefreshSelect(List <MObj> list, MEDMDefClass dc, string name, MEDMSql model, XmlNode xrequest, XmlNode xresponse) { FilterParamList l = new FilterParamList(dc, xrequest); object[] parms = new object[l.Count * 2 + 2]; string t = l.Top > 0 ? "top " + l.Top.ToString():""; string sql = $"select {t} * from [{dc.Name}] (nolock) where id!=@p0"; parms[0] = "p0"; parms[1] = dc.GetIdPropery().GetDefaultValue(); for (int i = 0; i < l.Count; i++) { switch (l[i].Mode) { case "": case "eq": sql += $" and ( [{l[i].Name}]=@p{i + 1})"; break; case "ne": sql += $" and ( [{l[i].Name}]!=@p{i + 1})"; break; case "eqornone": sql += $" and ( [{l[i].Name}]=@p{i + 1} or [{l[i].Name}]=@p0)"; break; } parms[(i + 1) * 2] = $"p{i + 1}"; parms[(i + 1) * 2 + 1] = l[i].Value; } { MEDMDefProperty dp = dc.Properties.Find(p => p.Name.ToLower() == "name"); if (dp == null) { dp = dc.Properties.Find(p => p.Name.ToLower().EndsWith("name")); } if (dp == null) { dp = dc.Properties.Find(p => p.Name.ToLower().Contains("name")); } if (dp != null) { sql += $" order by [{dp.Name}]"; } } model.Select(list, dc.GetClassType(), sql, parms); }
protected override void RunJoin(string name, MEDMSql model, XmlNode xrequest, XmlNode xresponse) { MEDMDefClass dc = MEDMDefModel.MainDef.Find(name); if (dc == null) { throw new Exception($"Нет описателя класса соответстующго имени {name}"); } MEDMDefProperty dp = dc.GetIdPropery(); List <Guid> l = MarkId <Guid>(Session.GetString(MarkKey(xrequest)), name.ToLower()); if (l.Count > 0) { object id = M740.GetParam(dp.GetPropertyType(), xrequest, "id", ""); if (id != dp.GetDefaultValue()) { string sql = ""; foreach (MEDMDefClass dc1 in MEDMDefModel.MainDef.AllClasses) { foreach (MEDMDefProperty dp1 in dc1.Properties) { if (dp1.RefClass == dc) { sql += $"update [{dc1.Name}] set [{dp1.Name}]=@p0 where CountryPresentingDemandId=@p1\r\n"; } } } sql += $"delete [{name}] where Id=@p1\r\n"; foreach (object joinid in l) { if (joinid != dp.GetDefaultValue() && joinid != id) { model.Exec(sql, "p0", id, "p1", joinid); } } RunMarkClear(name, model, xrequest, xresponse); XFunc.SetAttr(xresponse, "exec", "refresh"); } } else { throw new Exception($"Нет омеченных элементов"); } }