/* /// <summary> /// Формирует описание структуры JSON-ответа для клиентского JsonStore из XML-описания. /// </summary> /// <param name="pCursorDef">XML-описание курсора.</param> /// <param name="jw">Объект LisJson.JsonWriter, в который запишутся метаданные.</param> public static JsonStoreMetadata ConstructMetadata(XPathNavigator cursorDef) { JsonStoreMetadata vResult = new JsonStoreMetadata(); vResult.fields = new List<JsonStoreMetadataFieldDef>(); XPathNodeIterator xmlFields = cursorDef.Select("fields/field[not(@generate) or (@generate='true')]"); if (xmlFields == null || xmlFields.Count <= 0) return vResult; if (cursorDef.SelectSingleNode("fields/field/@pk") != null) { vResult.fields.Add(new JsonStoreMetadataFieldDef() { name = csPKFieldName, type = CJsonStoreMetadataFieldType.ftString, hidden = true }); } while (xmlFields.MoveNext()){ XPathNavigator curNode = xmlFields.Current; JsonStoreMetadataFieldDef fldDef = new JsonStoreMetadataFieldDef(); fldDef.name = Xml.getAttribute(curNode, "name"); if (String.IsNullOrEmpty(fldDef.name)) continue; fldDef.hidden = String.Equals(Xml.getAttribute(curNode, "hidden"), "true"); fldDef.header = Xml.getAttribute(curNode, "header"); fldDef.type = detectFieldType(Xml.getAttribute(curNode, "type")); String v_group_str = Xml.getAttribute(curNode, "group"); fldDef.group = Int32.Parse(!String.IsNullOrEmpty(v_group_str) ? v_group_str : "-1"); fldDef.group_aggr = curNode.GetAttribute("group_aggr", null); int pkIndx = Int32.Parse(Xml.hasAttribute(curNode, "pk") ? Xml.getAttribute(curNode, "pk") : "0"); String boolVals = Xml.getAttribute(curNode, "boolVals"); String defaultVal = Xml.getAttribute(curNode, "defaultVal"); //if (fldDef.type == "currency") fldDef.Type = "float"; if (pkIndx > 0) fldDef.pk = pkIndx; if (fldDef.type == CJsonStoreMetadataFieldType.ftDate) fldDef.dateFormat = "Y-m-d\\TH:i:s"; else if (fldDef.type == CJsonStoreMetadataFieldType.ftBoolean && !String.IsNullOrEmpty(boolVals)) fldDef.boolVals = boolVals; if (!String.IsNullOrEmpty(defaultVal) && fldDef.type != CJsonStoreMetadataFieldType.ftDate) if (fldDef.type == CJsonStoreMetadataFieldType.ftBoolean) fldDef.defaultVal = Utl.Convert2Type<Boolean>(defaultVal); else if (fldDef.type == CJsonStoreMetadataFieldType.ftString) fldDef.defaultVal = defaultVal; else fldDef.defaultVal = Utl.Convert2Type<Double>(defaultVal); vResult.fields.Add(fldDef); } return vResult; } */ #endif #if !SILVERLIGHT /// <summary> /// Формирует описание структуры JSON-ответа для клиентского JsonStore из объекта System.Data.DataTable. /// </summary> /// <param name="table">Объект System.Data.DataTable, из которого нужно взять структуру.</param> public static JsonStoreMetadata ConstructMetadata(DataTable table) { JsonStoreMetadata vResult = new JsonStoreMetadata(); vResult.Fields = new List<JsonStoreMetadataFieldDef>(); if (table == null || table.Columns.Count <= 0) return vResult; foreach (DataColumn col in table.Columns) { //if (col.ColumnName == CExParams.C_RowNumberFieldName) // continue; JsonStoreMetadataFieldDef fldDef = new JsonStoreMetadataFieldDef(); fldDef.Name = col.ColumnName.ToUpper(); fldDef.Type = jsonUtl.detectFieldType(ftypeHelper.ConvertTypeToStr(col.DataType).ToLower()); var boolVals = (col.ExtendedProperties.ContainsKey("boolVals")) ? (String)col.ExtendedProperties["boolVals"] : null; if (fldDef.Type == JSFieldType.Date) fldDef.Format = "Y-m-d\\TH:i:s"; else if (fldDef.Type == JSFieldType.Boolean && !String.IsNullOrEmpty(fldDef.BoolVals)) fldDef.BoolVals = boolVals; if (col.DefaultValue != DBNull.Value && fldDef.Type != JSFieldType.Date) fldDef.DefaultVal = col.DefaultValue; vResult.Fields.Add(fldDef); } return vResult; }
public void CopyFrom(JsonStoreMetadata mdata) { this.ID = mdata.ID; if (this.Fields == null) this.Fields = new List<JsonStoreMetadataFieldDef>(); this.Fields.Clear(); foreach (JsonStoreMetadataFieldDef fd in mdata.Fields) { var newFld = new JsonStoreMetadataFieldDef() { Name = fd.Name, Type = fd.Type, PK = fd.PK, DefaultVal = fd.DefaultVal, Format = fd.Format, Align = fd.Align, BoolVals = fd.BoolVals, Hidden = fd.Hidden, Header = fd.Header, Group = fd.Group, GroupAggr = fd.GroupAggr, ReadOnly = fd.ReadOnly, Width = fd.Width }; this.Fields.Add(newFld); } }
/// <summary> /// Формирует описание структуры JSON-ответа для клиентского JsonStore из XML-описания. /// </summary> /// <param name="bioCode"/> /// <param name="cursorDef">XML-описание курсора.</param> public static JsonStoreMetadata ConstructMetadata(String bioCode, XmlNode cursorDef) { JsonStoreMetadata vResult = new JsonStoreMetadata(); vResult.Fields = new List<JsonStoreMetadataFieldDef>(); vResult.ReadOnly = Xml.getAttribute<Boolean>(cursorDef as XmlElement, "readOnly", true); vResult.Multiselection = Xml.getAttribute<Boolean>(cursorDef as XmlElement, "multiselection", false); XmlNodeList xmlFields = cursorDef.SelectNodes("fields/field[not(@generate) or (@generate='true')]"); if (xmlFields == null || xmlFields.Count <= 0) return vResult; foreach (XmlElement xmlEl in xmlFields) { String v_field_name = xmlEl.GetAttribute("name"); if (vResult.IndexOf(v_field_name) >= 0) throw new EBioException(String.Format("В описании объекта {0} поле {1} определено более 1 раза.", bioCode, v_field_name)); JsonStoreMetadataFieldDef fldDef = new JsonStoreMetadataFieldDef(); if (xmlEl.HasAttribute("generate") && xmlEl.GetAttribute("generate") != "true") continue; fldDef.Name = v_field_name; if (String.IsNullOrEmpty(fldDef.Name)) continue; fldDef.Header = xmlEl.GetAttribute("header"); if (!String.IsNullOrEmpty(fldDef.Header)) fldDef.Header = fldDef.Header.Replace("\\n", "\n"); fldDef.Hidden = Xml.getAttribute<Boolean>(xmlEl, "hidden", false); fldDef.ReadOnly = Xml.getAttribute<Boolean>(xmlEl, "readOnly", vResult.ReadOnly); fldDef.Type = jsonUtl.detectFieldType(xmlEl.GetAttribute("type")); fldDef.Width = Xml.getAttribute<Int32>(xmlEl, "width", 0); fldDef.Format = Xml.getAttribute<String>(xmlEl, "format", null); if (String.IsNullOrEmpty(fldDef.Format)) { if ((fldDef.Type == JSFieldType.Date) || (fldDef.Type == JSFieldType.DateUTC)) fldDef.Format = "dd.MM.yyyy HH:mm:ss"; if (fldDef.Type == JSFieldType.Int) fldDef.Format = "0"; if (fldDef.Type == JSFieldType.Currency) fldDef.Format = "#,##0.00 р"; } fldDef.Align = jsonUtl.detectAlignment(fldDef.Type, xmlEl.GetAttribute("align")); fldDef.Group = Xml.getAttribute<Int32>(xmlEl, "group", -1); fldDef.GroupAggr = xmlEl.GetAttribute("group_aggr"); Int32 pkIndx = Xml.getAttribute<Int32>(xmlEl, "pk", 0); String boolVals = xmlEl.GetAttribute("boolVals"); String defaultVal = xmlEl.GetAttribute("defaultVal"); //if (fldDef.type == "currency") fldDef.Type = "float"; if (pkIndx > 0) fldDef.PK = pkIndx; //if (fldDef.type == CJsonStoreMetadataFieldType.ftDate) // fldDef.dateFormat = "Y-m-d\\TH:i:s"; else if (fldDef.Type == JSFieldType.Boolean && !String.IsNullOrEmpty(boolVals)) fldDef.BoolVals = boolVals; if (!String.IsNullOrEmpty(defaultVal) && fldDef.Type != JSFieldType.Date) if (fldDef.Type == JSFieldType.Boolean) fldDef.DefaultVal = Utl.Convert2Type<Boolean>(defaultVal); else if (fldDef.Type == JSFieldType.String) fldDef.DefaultVal = defaultVal; else fldDef.DefaultVal = Utl.Convert2Type<Double>(defaultVal); vResult.Fields.Add(fldDef); } if (vResult.Multiselection) { var v_pks = vResult.GetPKFields(); if ((v_pks == null) || (v_pks.Length != 1)) throw new Exception(String.Format("Для режима multiselection, необходимо чтобы для ио [{0}] был определен первичный ключь(не составной).", bioCode)); } return vResult; }