示例#1
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public Maticsoft.Model.Logo DataRowToModel(DataRow row)
 {
     Maticsoft.Model.Logo model=new Maticsoft.Model.Logo();
     if (row != null)
     {
         if(row["LogoID"]!=null && row["LogoID"].ToString()!="")
         {
             model.LogoID=int.Parse(row["LogoID"].ToString());
         }
         if(row["Url"]!=null)
         {
             model.Url=row["Url"].ToString();
         }
         if(row["CompanyName"]!=null)
         {
             model.CompanyName=row["CompanyName"].ToString();
         }
         if(row["AddTime"]!=null && row["AddTime"].ToString()!="")
         {
             model.AddTime=DateTime.Parse(row["AddTime"].ToString());
         }
         if(row["AddUser"]!=null)
         {
             model.AddUser=row["AddUser"].ToString();
         }
     }
     return model;
 }
示例#2
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Maticsoft.Model.Logo GetModel(int LogoID)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("select  top 1 LogoID,Url,CompanyName,AddTime,AddUser from Logo ");
            strSql.Append(" where LogoID=@LogoID");
            SqlParameter[] parameters = {
                    new SqlParameter("@LogoID", SqlDbType.Int,4)
            };
            parameters[0].Value = LogoID;

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