/*
/// <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;
}
