Example #1
0
 public bool UpdatePhotoDetail(D_PhotoDetail photoDetail)
 {
     string sql = @"
     update Photos
     set
     relateId=@relateId,
     picOrder=@picOrder,
     picType=@photoType,
     title=@title,
     title_cn=@title_cn,
     description=@description,
     description_cn=@description_cn,
     status=@status
     where picId=@picId
     ";
     SqlParameter[] para = {
         new SqlParameter("@picId", photoDetail.picId),
         new SqlParameter("@relateId", photoDetail.relateId),
         new SqlParameter("@picOrder", photoDetail.picOrder),
         new SqlParameter("@photoType", photoDetail.photoType),
         new SqlParameter("@title", photoDetail.title),
         new SqlParameter("@title_cn", photoDetail.title_cn),
         new SqlParameter("@description", photoDetail.description),
         new SqlParameter("@description_cn", photoDetail.description_cn),
         new SqlParameter("@status", photoDetail.status)
     };
     m_dao.ExecuteNoQuery(sql, para);
     return true;
 }
Example #2
0
        public D_PhotoDetail GetPhotoDetail(int photoId)
        {
            D_PhotoDetail pd = new D_PhotoDetail();
            if (photoId <= 0)
                return pd;

            string sql = "select * from Photos where picId=@picId";
            SqlParameter[] para = {
                new SqlParameter("@picId", photoId)
            };
            IDataReader dr = m_dao.ExecuteReader(sql, para);
            if (dr.Read())
            {
                pd.picId = (int)dr["picId"];
                pd.relateId = (int)dr["relateId"];
                pd.title = (string)dr["title"];
                pd.title_cn = (string)dr["title_cn"];
                pd.description = (string)dr["description"];
                pd.description_cn = (string)dr["description_cn"];
                pd.picOrder = (int)dr["picOrder"];
                pd.photoType = (byte)dr["picType"];
                pd.status = (byte)dr["status"];
            }
            return pd;
        }