public ViewYogisModels Add_Model(ViewYogisModels entity)
{
YogisModels user = Repository.Add(ViewYogisModels.ToEntity(entity));
Repository.Save();
return(ViewYogisModels.ToViewModel(user));
}
public static ViewYogisModels ToViewModel(YogisModels model)
{
if (model == null)
{
return(null);
}
ViewYogisModels item = new ViewYogisModels();
item.YID = model.YID;
item.UID = model.UID;
item.RealName = model.RealName;
item.Gender = model.Gender;
item.Headid = model.Headid;
item.CenterID = model.CenterID;
item.YogaTypeid = model.YogaTypeid;
item.TeachYogis = model.TeachYogis;
item.EachClassCost = model.EachClassCost;
item.IdType = model.IdType;
item.IdCardNum = model.IdCardNum;
item.StartTeachYear = model.StartTeachYear;
item.Nationality = model.Nationality;
item.Street = model.Street;
item.LocationID = model.LocationID;
item.DistrictID = model.DistrictID;
item.CityID = model.CityID;
item.ProvinceID = model.ProvinceID;
item.CountryID = model.CountryID;
item.YogisLevel = model.YogisLevel;
item.YogiStatus = model.YogiStatus;
item.BecomeYogisTime = model.BecomeYogisTime;
item.YogisScore = model.YogisScore;
item.DisplayImg = model.DisplayImg;
item.IsPayRecord = model.IsPayRecord;
item.Profileid = model.Profileid;
item.CreateDate = model.CreateDate;
item.UpgradeDate = model.UpgradeDate;
item.IsAcceptAgreement = model.IsAcceptAgreement;
item.YogisDepict = model.YogisDepict;
item.GudWords = model.GudWords;
item.iRate = model.iRate;
item.CoverImg = model.CoverImg;
item.delState = model.delState;
item.Leveldetails = model.Leveldetails;
item.iZan = model.iZan;
return(item);
}
/// <summary>
/// 获取头像列表
/// </summary>
/// <param name="uids"></param>
/// <param name="classId"></param>
/// <param name="page"></param>
/// <param name="size"></param>
/// <returns></returns>
public List <YogisModels> GetAvatars(string uids, int classId, int page, int size)
{
List <YogisModels> users = new List <YogisModels>();
string sqlStr = @"SELECT * FROM (
SELECT ROW_NUMBER() OVER(ORDER BY I.CreateTime DESC) AS ROWID, U.UID,CASE WHEN Y.REALNAME IS NULL THEN U.RealName_cn ELSE Y.RealName END AS NAME, CASE WHEN Y.DisplayImg IS NULL THEN U.DisplayImg ELSE Y.DisplayImg END AS AVATAR
FROM YogaUserDetail U LEFT JOIN YogisModels Y ON U.UID = Y.UID JOIN InterestedClass I ON I.UserId=U.UID
WHERE '," + uids + ",' LIKE '%,'+CAST(U.UID AS VARCHAR(50))+',%' AND I.ClassId=" + classId + @"
) T WHERE T.ROWID BETWEEN " + ((page - 1) * size + 1) + " AND " + page * size;
SqlDataReader reader = SQLHelper.ExecuteDataReader(sqlStr, CommandType.Text, null);
while (reader.Read())
{
YogisModels user = new YogisModels()
{
UID = Convert.ToInt32(reader["uid"]), RealName = reader["name"].ToString(), DisplayImg = reader["avatar"].ToString()
};
users.Add(user);
}
return(users);
}
