public static UserInfo SelectUserInfo(string userId) { var row = ShareImageDAL.GetUserInfo(ProcessConnection.OpenGungnirReadOnly, userId); if (row == null) { return(new UserInfo()); } string uName = !string.IsNullOrEmpty(row["u_Pref5"].ToString()) ? row["u_Pref5"].ToString() : row["u_last_name"].ToString(); if (string.IsNullOrEmpty(uName)) { string phone = row["u_mobile_number"].ToString(); uName = phone.Replace(phone.Substring(3, 4), "****"); } string defaultHead = "http://resource.tuhu.cn/Image/Product/zhilaohu.png"; string userHead = !string.IsNullOrEmpty(row["u_Imagefile"].ToString()) ?ConfigurationManager.AppSettings["DoMain_image"] + row["u_Imagefile"].ToString():defaultHead; string userPhone = row["u_mobile_number"].ToString(); return(new UserInfo { UserID = userId, NickName = uName, UserHead = userHead, UserPhone = userPhone }); }
public static bool UpdateStatus(int PKID, bool isActive) { try { return(ShareImageDAL.UpdateStatus(ProcessConnection.OpenMarketing, PKID, isActive)); } catch (Exception ex) { throw ex; } }
public static bool UpdateShareImages(ShareImage model) { try { return(ShareImageDAL.UpdateShareImages(ProcessConnection.OpenMarketing, model)); } catch (Exception ex) { throw ex; } }
//public static IEnumerable<ShareImage> SelectList(string strWhere) //{ // try // { // return ShareImageDAL.SelectList(ProcessConnection.OpenMarketing, strWhere); // } // catch (Exception ex) // { // throw ex; // } //} public static string ExecuteSqlForUpdate(string sql) { try { return(ShareImageDAL.ExecuteSqlForUpdate(ProcessConnection.OpenMarketing, sql).ToString()); } catch (Exception ex) { return("异常:" + ex.Message + "-------堆栈信息:" + ex.StackTrace); } }
public static List <ShareImage> SelectShareList(PagerModel pager, string strWhere) { try { DataTable dt = ShareImageDAL.SelectShareList(ProcessConnection.OpenMarketing, pager, strWhere); if (dt.Rows.Count > 0) { return(DTConvertShareImage(dt)); } else { return(new List <ShareImage>()); } } catch (Exception ex) { throw ex; } }
public static List <ShareImage> DTConvertShareImage(DataTable dt) { List <ShareImage> modelList = new List <ShareImage>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { for (int i = 0; i < rowsCount; i++) { #region MyRegion DataRow row = dt.Rows[i]; int pkid = row.Field <int>("PKID"); string userId = row.Field <Guid>("userId").ToString(); string content = row.Field <string>("content"); bool isActive = row.Field <bool>("isActive"); bool isDelete = row.Field <bool>("isDelete"); DateTime createTime = row.Field <DateTime>("createTime"); DateTime updateTime = row.Field <DateTime>("lastUpdateTime"); int likeCount = row.Field <int>("likesCount"); int commentCount = row.Field <int>("commentCount"); int shareCount = row.Field <int>("shareCount"); List <ImagesDetail> imageDetails = DTConvertImagesDetail(ShareImageDAL.SelectShareImages(ProcessConnection.OpenMarketing, pkid)); modelList.Add(new ShareImage() { PKID = pkid, userId = userId, content = content, isActive = isActive, isDelete = isDelete, createTime = createTime, lastUpdateTime = updateTime, likesCount = likeCount, commentCount = commentCount, shareCount = shareCount, images = imageDetails, User = SelectUserInfo(userId) }); #endregion } } return(modelList); }
public static ShareImage SelectShareDetailByPKID(int PKID) { var row = ShareImageDAL.SelectShareDetailByPKID(ProcessConnection.OpenMarketing, PKID); if (row == null) { return(new ShareImage()); } int pkid = row.Field <int>("PKID"); List <ImagesDetail> imageDetails = DTConvertImagesDetail(ShareImageDAL.SelectShareImages(ProcessConnection.OpenMarketing, pkid)); string userId = row.Field <Guid>("userId").ToString(); string content = row.Field <string>("content"); bool isActive = row.Field <bool>("isActive"); bool isDelete = row.Field <bool>("isDelete"); DateTime createTime = row.Field <DateTime>("createTime"); DateTime updateTime = row.Field <DateTime>("lastUpdateTime"); int likeCount = row.Field <int>("likesCount"); int commentCount = row.Field <int>("commentCount"); int shareCount = row.Field <int>("shareCount"); return(new ShareImage { PKID = pkid, userId = userId, content = content, isActive = isActive, isDelete = isDelete, createTime = createTime, lastUpdateTime = updateTime, likesCount = likeCount, commentCount = commentCount, shareCount = shareCount, images = imageDetails, User = SelectUserInfo(userId) }); }