Пример #1
0
 public void GetKeyColumn(XmlNode xnP ,PdmKey mKey)
 {
     XmlElement xe = (XmlElement)xnP;
     XmlNodeList nodeList = xe.ChildNodes;
     foreach (XmlNode node in nodeList)
     {
         ColumnInfo ci = new ColumnInfo();
         ci.ColumnId = ((XmlElement)node).GetAttribute("Ref");
         mKey.AddColumn(ci);
     }
 }
Пример #2
0
 public void AddColumn(ColumnInfo mColumn)
 {
     if (columns == null)
         columns = new List<ColumnInfo>();
     columns.Add(mColumn);
 }
Пример #3
0
 private ColumnInfo GetColumn(XmlNode xnColumn)
 {
     ColumnInfo mColumn = new ColumnInfo();
     XmlElement xe = (XmlElement)xnColumn;
     mColumn.ColumnId = xe.GetAttribute("Id");
     XmlNodeList xnCProperty = xe.ChildNodes;
     foreach (XmlNode xnP in xnCProperty)
     {
         switch (xnP.Name)
         {
             case "a:ObjectID": mColumn.ObjectID = xnP.InnerText;
                 break;
             case "a:Name": mColumn.Name = xnP.InnerText;
                 break;
             case "a:Code": mColumn.Code = xnP.InnerText;
                 break;
             case "a:CreationDate": mColumn.CreationDate = Convert.ToInt32(xnP.InnerText);
                 break;
             case "a:Creator": mColumn.Creator = xnP.InnerText;
                 break;
             case "a:ModificationDate": mColumn.ModificationDate = Convert.ToInt32(xnP.InnerText);
                 break;
             case "a:Modifier": mColumn.Modifier = xnP.InnerText;
                 break;
             case "a:Comment": mColumn.Comment = xnP.InnerText;
                 break;
             case "a:DataType": mColumn.DataType = xnP.InnerText;
                 break;
             case "a:Length": mColumn.Length = xnP.InnerText;
                 break;
             case "a:Identity": mColumn.Identity = xnP.InnerText.Equals("Yes") ? true : false;
                 break;
             case "a:Mandatory": mColumn.Mandatory = xnP.InnerText.Equals("1") ? true : false;
                 break;
             case "a:PhysicalOptions": mColumn.PhysicalOptions = xnP.InnerText;
                 break;
             case "a:ExtendedAttributesText": mColumn.ExtendedAttributesText = xnP.InnerText;
                 break;
         }
     }
     return mColumn;
 }
Пример #4
0
        private string GenerateColumnScripts(XElement root)
        {
            StringBuilder sb = new StringBuilder();

            ColumnInfo sd = new ColumnInfo();

            foreach (XElement element in root.Elements())
            {
                if (element.Name.LocalName == "Name")
                {
                    sd.Name = element.Value;
                }
                if (element.Name.LocalName == "Code")
                {
                    sd.Code = element.Value;
                }
                if (element.Name.LocalName == "DataType")
                {
                    sd.DataType = element.Value;
                }
                if (element.Name.LocalName == "Mandatory")
                {
                    sd.Mandatory = element.Value == "1" ? true:false;
                }
                if (element.Name.LocalName == "Comment")
                {
                    sd.Comment = element.Value;
                }

            }

            return sd.Code + " " + sd.DataType + " " + (sd.Mandatory ? " NOT NULL " : " ") + " , --" + sd.Name + (string.IsNullOrWhiteSpace(sd.Comment) ?"": " ; "+sd.Comment);
        }