Exemple #1
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public MxWeiXinPF.Model.wx_wsite_setting DataRowToModel(DataRow row)
 {
     MxWeiXinPF.Model.wx_wsite_setting model=new MxWeiXinPF.Model.wx_wsite_setting();
     if (row != null)
     {
         if(row["id"]!=null && row["id"].ToString()!="")
         {
             model.id=int.Parse(row["id"].ToString());
         }
         if(row["wId"]!=null && row["wId"].ToString()!="")
         {
             model.wId=int.Parse(row["wId"].ToString());
         }
         if(row["wName"]!=null)
         {
             model.wName=row["wName"].ToString();
         }
         if(row["companyName"]!=null)
         {
             model.companyName=row["companyName"].ToString();
         }
         if(row["bgMusic"]!=null)
         {
             model.bgMusic=row["bgMusic"].ToString();
         }
         if(row["bgPic"]!=null)
         {
             model.bgPic=row["bgPic"].ToString();
         }
         if(row["bgDongHuaId"]!=null && row["bgDongHuaId"].ToString()!="")
         {
             model.bgDongHuaId=int.Parse(row["bgDongHuaId"].ToString());
         }
         if(row["wCopyright"]!=null)
         {
             model.wCopyright=row["wCopyright"].ToString();
         }
         if(row["wBrief"]!=null)
         {
             model.wBrief=row["wBrief"].ToString();
         }
         if(row["remark"]!=null)
         {
             model.remark=row["remark"].ToString();
         }
         if(row["phone"]!=null)
         {
             model.phone=row["phone"].ToString();
         }
         if(row["addr"]!=null)
         {
             model.addr=row["addr"].ToString();
         }
         if(row["addrUrl"]!=null)
         {
             model.addrUrl=row["addrUrl"].ToString();
         }
         if(row["email"]!=null)
         {
             model.email=row["email"].ToString();
         }
         if(row["seo_title"]!=null)
         {
             model.seo_title=row["seo_title"].ToString();
         }
         if(row["seo_keywords"]!=null)
         {
             model.seo_keywords=row["seo_keywords"].ToString();
         }
         if(row["seo_desc"]!=null)
         {
             model.seo_desc=row["seo_desc"].ToString();
         }
         if(row["createDate"]!=null && row["createDate"].ToString()!="")
         {
             model.createDate=DateTime.Parse(row["createDate"].ToString());
         }
         if(row["extInt"]!=null && row["extInt"].ToString()!="")
         {
             model.extInt=int.Parse(row["extInt"].ToString());
         }
         if(row["extStr"]!=null)
         {
             model.extStr=row["extStr"].ToString();
         }
         if(row["extStr2"]!=null)
         {
             model.extStr2=row["extStr2"].ToString();
         }
     }
     return model;
 }
Exemple #2
0
        /// <summary>
        /// 通过wid获得该微帐号的站点信息
        /// </summary>
        public MxWeiXinPF.Model.wx_wsite_setting GetModelByWid(int wid)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1 id,wId,wName,companyName,bgMusic,bgPic,bgDongHuaId,wCopyright,wBrief,remark,phone,addr,addrUrl,email,seo_title,seo_keywords,seo_desc,createDate,extInt,extStr,extStr2 from wx_wsite_setting ");
            strSql.Append(" where wId=@wId");
            SqlParameter[] parameters = {
                    new SqlParameter("@wId", SqlDbType.Int,4)
            };
            parameters[0].Value = wid;

            MxWeiXinPF.Model.wx_wsite_setting model = new MxWeiXinPF.Model.wx_wsite_setting();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }