コード例 #1
0
 public ProductDetail GetProductDetail(int pid)
 {
     ProductDetail detail = new ProductDetail();
     Type typeOfClass = detail.GetType();
     DataTable dt = dbHelper.ExecuteDataTable("select * from AliProductDetail where pid = " + pid, null);
     if (dt == null || dt.Rows.Count == 0) return null;
     foreach (DataRow row in dt.Rows)
     {
         foreach (DataColumn col in dt.Columns)
         {
             string propertyName = col.ColumnName;
             PropertyInfo pInfo = typeOfClass.GetProperty(propertyName);
             if (pInfo != null && pInfo.PropertyType.Name == "FormElement")
             {
                 string element = (string)row[propertyName];
                 FormElement el = JsonConvert.FromJson<FormElement>(element);
                 pInfo.SetValue(detail, el, null);
             }
         }
     }
     detail.pid = pid;
     detail.CustomAttr = GetCustomAttr(pid);
     detail.SysAttr = GetSystemAttr(pid, Constants.AttrType_SysAttr);
     detail.FixAttr = GetSystemAttr(pid, Constants.AttrType_FixAttr);
     return detail;
 }
コード例 #2
0
 public void Insert(ProductDetail detail)
 {
     Type typeOfClass = detail.GetType();
     PropertyInfo[] pInfo = typeOfClass.GetProperties();
     string sqlCondi = "INSERT INTO AliProductDetail(pid,gmtModified";
     string sqlValue = ")values(@pid, @gmtModified";
     string sqlEnd = ");";
     List<SQLiteParameter> parameter = new List<SQLiteParameter>();
     parameter.Add(new SQLiteParameter("@pid", detail.pid));
     parameter.Add(new SQLiteParameter("@gmtModified", detail.gmtModified));
     foreach (PropertyInfo info in pInfo)
     {
         if (info.PropertyType.Name == "FormElement")
         {
             sqlCondi = sqlCondi + ", " + info.Name;
             sqlValue = sqlValue + ", @" + info.Name;
             object val = info.GetValue(detail, null);
             string json = JsonConvert.ToJson(val);
             parameter.Add(new SQLiteParameter("@" + info.Name, json));
         }
     }
     string InsSql = sqlCondi + sqlValue + sqlEnd;
     dbHelper.ExecuteNonQuery(InsSql, parameter.ToArray());
 }
コード例 #3
0
 public void Update(ProductDetail detail)
 {
     Type typeOfClass = detail.GetType();
     PropertyInfo[] pInfo = typeOfClass.GetProperties();
     string sqlCondi = "Update AliProductDetail SET gmtModified=@gmtModified";
     string sqlEnd = " where pid = @pid";
     List<SQLiteParameter> parameter = new List<SQLiteParameter>();
     parameter.Add(new SQLiteParameter("@gmtModified", detail.gmtModified));
     foreach (PropertyInfo info in pInfo)
     {
         if (info.PropertyType.Name == "FormElement")
         {
             sqlCondi = sqlCondi + "," + info.Name + " = @" + info.Name;
             object val = info.GetValue(detail, null);
             string json = JsonConvert.ToJson(val);
             parameter.Add(new SQLiteParameter("@" + info.Name, json));
         }
     }
     parameter.Add(new SQLiteParameter("@pid", detail.pid));
     string UpdateSql = sqlCondi + sqlEnd;
     dbHelper.ExecuteNonQuery(UpdateSql, parameter.ToArray());
 }
コード例 #4
0
ファイル: ImpProductDetail.cs プロジェクト: rew170/soomecode
        public ProductDetail PrintElementsValue(HtmlNode htmlNode)
        {
            ProductDetail detail = new ProductDetail();
            Type typeOfClass = detail.GetType();
            IEnumerable<HtmlNode> nodeTags = htmlNode.SelectNodes(@".//input[@type='hidden'] | .//input[@type='text']");
            if (nodeTags != null)
            {
                foreach (HtmlNode node in nodeTags)
                {
                    string id = node.GetAttributeValue("id", "");
                    string type = node.GetAttributeValue("type", "");
                    string name = node.GetAttributeValue("name", "");
                    string value = node.GetAttributeValue("value", "");
                    if ("_fmp.pr._0.u" == name || "_fmp.pr._0.us" == name)
                    {
                        continue;
                    }
                    System.Diagnostics.Trace.WriteLine("Id:" + id + "  type:" + type + "  name:" + name + "  value:" + value);

                    FormElement el = new FormElement();
                    el.Id = id;
                    el.Type = type;
                    el.Name = name;
                    el.Value = value;

                    string propertyName = GetPropertyName(id, name);
                    PropertyInfo pInfo = typeOfClass.GetProperty(propertyName);
                    if (pInfo != null && pInfo.PropertyType.Name == "FormElement")
                    {
                        pInfo.SetValue(detail, el, null);
                    }
                }
            }
            detail.CustomAttr = new Dictionary<FormElement, FormElement>();
            HtmlNodeCollection customNameTags = htmlNode.SelectNodes(@".//tr[@class='custom-attr-item']/td/input[@name='_fmp.pr._0.u']");
            HtmlNodeCollection customValueTags = htmlNode.SelectNodes(@".//tr[@class='custom-attr-item']/td/input[@name='_fmp.pr._0.us']");
            if (customNameTags != null)
            {
                for (int i = 0; i < customNameTags.Count; i ++ )
                {
                    HtmlNode nameNode = customNameTags[i];
                    string id = nameNode.GetAttributeValue("id", "");
                    string type = nameNode.GetAttributeValue("type", "");
                    string name = nameNode.GetAttributeValue("name", "");
                    string value = nameNode.GetAttributeValue("value", "");
                    System.Diagnostics.Trace.WriteLine("Id:" + id + "  type:" + type + "  name:" + name + "  value:" + value);
                    FormElement nameEl = new FormElement();
                    nameEl.Id = id;
                    nameEl.Type = type;
                    nameEl.Name = name;
                    nameEl.Value = value;

                    HtmlNode valueNode = customValueTags[i];
                    string vid = valueNode.GetAttributeValue("id", "");
                    string vtype = valueNode.GetAttributeValue("type", "");
                    string vname = valueNode.GetAttributeValue("name", "");
                    string vvalue = valueNode.GetAttributeValue("value", "");
                    System.Diagnostics.Trace.WriteLine("Id:" + vid + "  type:" + vtype + "  name:" + vname + "  value:" + vvalue);
                    FormElement valueEl = new FormElement();
                    valueEl.Id = vid;
                    valueEl.Type = vtype;
                    valueEl.Name = vname;
                    valueEl.Value = vvalue;
                    detail.CustomAttr.Add(nameEl, valueEl);
                }
            }

            nodeTags = htmlNode.SelectNodes(@".//input[@type='radio']");
            System.Diagnostics.Trace.WriteLine("radiobox===========================");

            if (nodeTags != null)
            {
                foreach (HtmlNode node in nodeTags)
                {
                    string id = node.GetAttributeValue("id", "");
                    string type = node.GetAttributeValue("type", "");
                    string name = node.GetAttributeValue("name", "");
                    string value = node.GetAttributeValue("value", "");
                    bool chk = node.Attributes["checked"] != null;
                    FormElement el = new FormElement();
                    el.Id = id;
                    el.Type = type;
                    el.Name = name;
                    el.Value = value;
                    el.Checked = chk;
                    System.Diagnostics.Trace.WriteLine("Id:" + id + "  type:" + type + "  name:" + name + "  checked:" + chk + "  value:" + value);
                    string propertyName = GetRadioBoxPropertyName(id, name, value);
                    PropertyInfo pInfo = typeOfClass.GetProperty(propertyName);
                    if (pInfo != null && pInfo.PropertyType.Name == "FormElement")
                    {
                        pInfo.SetValue(detail, el, null);
                    }
                }
            }
            System.Diagnostics.Trace.WriteLine("radiobox===========================");

            nodeTags = htmlNode.SelectNodes(@".//input[@type='checkbox']");
            if (nodeTags != null)
            {
                foreach (HtmlNode node in nodeTags)
                {
                    string id = node.GetAttributeValue("id", "");
                    string type = node.GetAttributeValue("type", "");
                    string name = node.GetAttributeValue("name", "");
                    string value = node.GetAttributeValue("value", "");
                    bool chk = node.Attributes["checked"] != null;
                    System.Diagnostics.Trace.WriteLine("Id:" + id + "  type:" + type + "  name:" + name + "  checked:" + chk + "  value:" + value);
                    FormElement el = new FormElement();
                    el.Id = id;
                    el.Type = type;
                    el.Name = name;
                    el.Value = value;
                    el.Checked = chk;
                    string propertyName = GetPropertyName(id, name);
                    PropertyInfo pInfo = typeOfClass.GetProperty(propertyName);
                    if (pInfo != null && pInfo.PropertyType.Name == "FormElement")
                    {
                        pInfo.SetValue(detail, el, null);
                    }
                }
            }

            System.Diagnostics.Trace.WriteLine("select===========================");
            nodeTags = htmlNode.SelectNodes(@".//select");
            if (nodeTags != null)
            {
                foreach (HtmlNode node in nodeTags)
                {
                    string id = node.GetAttributeValue("id", "");
                    string type = "select";
                    string name = node.GetAttributeValue("name", "");
                    string value = GetSelectValue(node);
                    System.Diagnostics.Trace.WriteLine("Id:" + id + "  type:" + type + "  name:" + name + "  value:" + value);
                    FormElement el = new FormElement();
                    el.Id = id;
                    el.Type = type;
                    el.Name = name;
                    el.Value = value;
                    string propertyName = GetPropertyName(id, name);
                    PropertyInfo pInfo = typeOfClass.GetProperty(propertyName);
                    if (pInfo != null && pInfo.PropertyType.Name == "FormElement")
                    {
                        pInfo.SetValue(detail, el, null);
                    }

                }
            }
            System.Diagnostics.Trace.WriteLine("select===========================");

            nodeTags = htmlNode.SelectNodes(@".//textarea");
            if (nodeTags != null)
            {
                foreach (HtmlNode node in nodeTags)
                {
                    string id = node.GetAttributeValue("id", "");
                    string type = node.GetAttributeValue("type", "");
                    string name = node.GetAttributeValue("name", "");
                    string value = node.InnerHtml;
                    System.Diagnostics.Trace.WriteLine("Id:" + id + "  type:" + type + "  name:" + name + "  value:" + value);
                    FormElement el = new FormElement();
                    el.Id = id;
                    el.Type = "textarea";
                    el.Name = name;
                    el.Value = value;
                    string propertyName = GetPropertyName(id, name);
                    PropertyInfo pInfo = typeOfClass.GetProperty(propertyName);
                    if (pInfo != null && pInfo.PropertyType.Name == "FormElement")
                    {
                        pInfo.SetValue(detail, el, null);
                    }
                }
            }
            return detail;
        }