public JsonResult GetUserInfos(string page, string pageSize, bool includeAll = false)
{
int total = 0;
string message = string.Empty;
bool success = false;
List <UserInfoModel> models = new List <UserInfoModel>();
try
{
var userInfos = GetEntities <UserApplicationInfo>(page, pageSize, out total, GetQueryCondition());
foreach (var info in userInfos)
{
UserApplicationInfo userInfo = info as UserApplicationInfo;
if (!includeAll)
{
if (BuiltIns.ExcludeUserIds.Contains(userInfo.User_Id))
{
total--;
continue;
}
}
models.Add(new UserInfoModel(userInfo));
}
success = true;
}
catch (DatabaseException exception)
{
message = exception.Message;
}
return(Json(new { Success = success, Rows = models.ToArray(), Total = total, Message = message }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetCurrentUserInfo(string page, string pageSize, int appId)
{
string token;
int userId;
UserInfoModel result = null;
string message = string.Empty;
bool success = false;
if (GetToken(out userId, out token))
{
int total = 0;
try
{
var userInfos = GetEntities <UserApplicationInfo>(page, pageSize, out total, GetQueryCondition());
foreach (var info in userInfos)
{
UserApplicationInfo userInfo = info as UserApplicationInfo;
if (userInfo.User_Id == userId && userInfo.Application_Id == appId)
{
result = new UserInfoModel(userInfo);
break;
}
}
success = true;
}
catch (DatabaseException exception)
{
message = exception.Message;
}
}
return(Json(new { Success = success, Model = result, Message = message }, JsonRequestBehavior.AllowGet));
}
public override void Initialize()
{
User usr = GetConcretEntity <User>();
UserInfo = ApplicationVM.Cache.UserInfos.FirstOrDefault(i => i.User_Id == usr.Id &&
(i.Application_Id == ApplicationVM.ApplicationId || i.Application_Id == BuiltIns.AllApplication.Id));
if (UserInfo != null)
{
if (UserInfo.Money.HasValue)
{
Money = UserInfo.Money.Value;
}
if (UserInfo.Score.HasValue)
{
Score = UserInfo.Score.Value;
}
RoleVM = ApplicationVM.LocalCache.AllRoleVMs.FirstOrDefault(r => r.Id == UserInfo.Role_Id);
}
var rrs = ApplicationVM.LocalCache.AllRoomRoleVMs.Where(rr => rr.UserId == Id);
if (rrs != null)
{
RoomRoleVMs = new System.Collections.ObjectModel.ObservableCollection <RoomRoleViewModel>(rrs);
}
base.Initialize();
}
public string Add()
{
AddUserApplicationParams actionParam = JavaScriptConvert.DeserializeObject <AddUserApplicationParams>(UnicodeToString(JsonParams));//当传递过来的参数值可能存在unicode编码的字符串时需要使用UnicodeToString方法
UserApplicationInfo userAppInfo = new UserApplicationInfo();
userAppInfo.AppId = actionParam.AppId;
userAppInfo.AppName = actionParam.AppName;
userAppInfo.Uid = actionParam.Uid;
userAppInfo.AllowFeed = actionParam.AllowFeed == null || (bool)actionParam.AllowFeed ? 1 : 0;//可不传递型属性处理实例
userAppInfo.AllowProfileLink = actionParam.AllowProfileLink == null || (bool)actionParam.AllowProfileLink ? 1 : 0;
userAppInfo.AllowSideNav = actionParam.AllowSideNav == null || (bool)actionParam.AllowSideNav ? 1 : 0;
userAppInfo.DisplayOrder = actionParam.DisplayOrder == null ? 0 : (int)actionParam.DisplayOrder;
userAppInfo.Privacy = Utils.GetEnum <PrivacyEnum>(actionParam.Privacy, PrivacyEnum.Public);
//不确定代码
userAppInfo.ProfileLink = actionParam.DefaultProfileLink;
userAppInfo.MYML = actionParam.DefaultMYML;
//当用户添加应用的时候，会在全局应用表中也增加或者更新原有记录，保证数据同步
ManyouApplicationInfo appInfo = new ManyouApplicationInfo();
appInfo.AppId = actionParam.AppId;
appInfo.AppName = actionParam.AppName;
appInfo.DisplayMethod = Utils.GetEnum <DisplayMethod>(actionParam.DisplayMethod, DisplayMethod.IFrame);
appInfo.DisplayOrder = actionParam.DisplayOrder ?? 0;
appInfo.Version = TypeConverter.StrToInt(actionParam.Version);
ManyouApplications.UpdateApplicationInfo(appInfo);
return(GetResult(ManyouApplications.AddUserApplication(userAppInfo) > -1));
}
public ClientUserModel(User user, UserApplicationInfo userInfo)
: base(user)
{
if (userInfo != null)
{
Application_Id = userInfo.Application_Id;
User_Id = userInfo.User_Id;
if (userInfo.AgentMoney.HasValue)
{
AgentMoney = userInfo.AgentMoney;
}
else
{
AgentMoney = 0;
}
if (userInfo.Money.HasValue)
{
Money = userInfo.Money;
}
else
{
Money = 0;
}
if (userInfo.Score.HasValue)
{
Score = userInfo.Score;
}
else
{
Score = 0;
}
Role_Id = userInfo.Role_Id;
}
}
/// <summary>
/// 更新用户应用信息
/// </summary>
/// <param name="userAppInfo"></param>
/// <returns></returns>
public static int UpdateUserApplication(UserApplicationInfo userAppInfo)
{
if (userAppInfo == null || userAppInfo.Uid < 1 || userAppInfo.AppId < 1)
{
return(-1);
}
return(Data.ManyouApplications.UpdateUserApplication(userAppInfo));
}
private string UpdateUserAppFieldsInfo()
{
SetUserAppFieldsInfoParams actionParams = JavaScriptConvert.DeserializeObject <SetUserAppFieldsInfoParams>(UnicodeToString(JsonParams));
UserApplicationInfo userAppInfo = ManyouApplications.GetUserApplicationInfo(actionParams.UId, actionParams.AppId.ToString())[0];
userAppInfo.MYML = actionParams.Markup != "" ? actionParams.Markup : userAppInfo.MYML;
userAppInfo.ProfileLink = actionParams.ActionMarkup != "" ? actionParams.ActionMarkup : userAppInfo.ProfileLink;
return(GetResult(ManyouApplications.UpdateUserApplication(userAppInfo)));
}
private static UserApplicationInfo LoadShortUserApplicationInfo(IDataReader reader)
{
UserApplicationInfo userAppInfo = new UserApplicationInfo();
userAppInfo.AppId = TypeConverter.ObjectToInt(reader["appid"]);
userAppInfo.AppName = reader["appname"].ToString();
userAppInfo.Uid = TypeConverter.ObjectToInt(reader["uid"]);
userAppInfo.DisplayOrder = TypeConverter.ObjectToInt(reader["displayorder"]);
userAppInfo.MenuOrder = TypeConverter.ObjectToInt(reader["menuorder"]);
return(userAppInfo);
}
private UserApplicationMessage LoadSingleUserApplicationMessage(UserApplicationInfo userAppInfo)
{
UserApplicationMessage appMsg = new UserApplicationMessage();
appMsg.AllowFeed = userAppInfo.AllowFeed == 1;
appMsg.AllowProfileLink = userAppInfo.AllowProfileLink == 1;
appMsg.AllowSideNav = userAppInfo.AllowSideNav == 1;
appMsg.AppId = userAppInfo.AppId;
appMsg.DisplayOrder = userAppInfo.DisplayOrder;
appMsg.Privacy = GetPrivacyString(userAppInfo.Privacy);
return(appMsg);
}
public UserInfoModel(UserApplicationInfo info) : base(info)
{
if (info != null)
{
Application_Id = info.Application_Id;
User_Id = info.User_Id;
AgentMoney = info.AgentMoney;
Money = info.Money;
Score = info.Score;
Role_Id = info.Role_Id;
}
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <param name="user"></param>
/// <returns></returns>
public static UserApplicationDataModel ToModel(this UserApplicationInfo model, DAL.Entities.UserInfo.User user)
{
return(new UserApplicationDataModel()
{
UserName = user.Id,
Create = model.Create,
Email = model.Email,
InvitedBy = model.InvitedBy,
AccountStatus = user.AccountStatus,
StatusBeginDate = user.StatusBeginDate,
StatusEndDate = user.StatusEndDate,
});
}
public static AccountType InvalidAccount(this UserApplicationInfo app)
{
if (app == null)
{
return(AccountType.NotBeenAuth);
}
var inviteBy = app.InvitedBy;
if (inviteBy == null)
{
return(AccountType.NotBeenAuth);
}
if (inviteBy == InviteByInvalidValue)
{
return(AccountType.Deny);
}
return(AccountType.BeenAuth);
}
private static UserApplicationInfo LoadUserApplicationInfo(IDataReader reader)
{
UserApplicationInfo userAppInfo = new UserApplicationInfo();
userAppInfo.AppId = TypeConverter.ObjectToInt(reader["appid"]);
userAppInfo.AppName = reader["appname"].ToString();
userAppInfo.Uid = TypeConverter.ObjectToInt(reader["uid"]);
userAppInfo.AllowSideNav = TypeConverter.ObjectToInt(reader["allowsidenav"]);
userAppInfo.AllowFeed = TypeConverter.ObjectToInt(reader["allowfeed"]);
userAppInfo.AllowProfileLink = TypeConverter.ObjectToInt(reader["allowprofilelink"]);
userAppInfo.Narrow = TypeConverter.ObjectToInt(reader["narrow"]);
userAppInfo.DisplayOrder = TypeConverter.ObjectToInt(reader["displayorder"]);
userAppInfo.MenuOrder = TypeConverter.ObjectToInt(reader["menuorder"]);
userAppInfo.ProfileLink = reader["profilelink"].ToString();
userAppInfo.MYML = reader["myml"].ToString();
return(userAppInfo);
}
public int UpdateUserApplication(UserApplicationInfo userAppInfo)
{
DbParameter[] parms =
{
DbHelper.MakeInParam("@appid", (DbType)SqlDbType.Int, 4, userAppInfo.AppId),
DbHelper.MakeInParam("@uid", (DbType)SqlDbType.Int, 4, userAppInfo.Uid),
DbHelper.MakeInParam("@appname", (DbType)SqlDbType.NChar, 30, userAppInfo.AppName),
DbHelper.MakeInParam("@privacy", (DbType)SqlDbType.TinyInt, 2, (int)userAppInfo.Privacy),
DbHelper.MakeInParam("@allowsidenav", (DbType)SqlDbType.TinyInt, 2, userAppInfo.AllowSideNav),
DbHelper.MakeInParam("@allowfeed", (DbType)SqlDbType.TinyInt, 2, userAppInfo.AllowFeed),
DbHelper.MakeInParam("@allowprofilelink", (DbType)SqlDbType.TinyInt, 2, userAppInfo.AllowProfileLink),
DbHelper.MakeInParam("@narrow", (DbType)SqlDbType.TinyInt, 2, userAppInfo.Narrow),
DbHelper.MakeInParam("@displayorder", (DbType)SqlDbType.TinyInt, 2, userAppInfo.DisplayOrder),
DbHelper.MakeInParam("@menuorder", (DbType)SqlDbType.TinyInt, 2, userAppInfo.MenuOrder),
DbHelper.MakeInParam("@profilelink", (DbType)SqlDbType.Text, 2000, userAppInfo.ProfileLink),
DbHelper.MakeInParam("@myml", (DbType)SqlDbType.Text, 2000, userAppInfo.MYML)
};
return(DbHelper.ExecuteNonQuery(CommandType.StoredProcedure, string.Format("{0}updateuserapp", BaseConfigs.GetTablePrefix), parms));
}
public string Update()
{
UpdateUserApplicationParams actionParam = JavaScriptConvert.DeserializeObject <UpdateUserApplicationParams>(UnicodeToString(JsonParams));
UserApplicationInfo userAppInfo = new UserApplicationInfo();
userAppInfo.AppId = actionParam.AppIds[0];
userAppInfo.AppName = actionParam.AppName;
userAppInfo.Uid = actionParam.Uid;
userAppInfo.AllowFeed = actionParam.AllowFeed == null || (bool)actionParam.AllowFeed ? 1 : 0;//可不传递型属性处理实例
userAppInfo.AllowProfileLink = actionParam.AllowProfileLink == null || (bool)actionParam.AllowProfileLink ? 1 : 0;
userAppInfo.AllowSideNav = actionParam.AllowSideNav == null || (bool)actionParam.AllowSideNav ? 1 : 0;
userAppInfo.DisplayOrder = actionParam.DisplayOrder == null ? 0 : (int)actionParam.DisplayOrder;
userAppInfo.Privacy = Utils.GetEnum <PrivacyEnum>(actionParam.Privacy, PrivacyEnum.Public);
//不确定代码
userAppInfo.ProfileLink = actionParam.DefaultProfileLink;
userAppInfo.MYML = actionParam.DefaultMYML;
return(GetResult(ManyouApplications.UpdateUserApplication(userAppInfo) > -1));
}
/// <summary>
/// 用户增加新应用
/// </summary>
/// <param name="userAppInfo"></param>
/// <returns></returns>
public static int AddUserApplication(UserApplicationInfo userAppInfo)
{
if (userAppInfo == null || userAppInfo.Uid < 1 || userAppInfo.AppId < 1)
{
return(-1);
}
int result = Data.ManyouApplications.AddUserApplication(userAppInfo);
DeleteApplicationInviteByAppId(userAppInfo.Uid, userAppInfo.AppId);
int olId = OnlineUsers.GetOlidByUid(userAppInfo.Uid);
if (olId > 0) //更新在线表信息
{
OnlineUsers.UpdateNewApplicationRequest(olId, ManyouApplications.GetApplicationInviteCount(userAppInfo.Uid));
}
return(result);
}
public JsonResult GetAgents(string page, string pageSize)
{
List <UserModel> users = new List <UserModel>();
int total = 0;
string message = string.Empty;
bool success = false;
try
{
var userAppInfos = GetEntities <UserApplicationInfo>(page, pageSize, out total, "[Role_Id] = " + BuiltIns.AgentRole.Id + "AND [Application_Id] = " + BuiltIns._9258ChatApplication.Id);
foreach (var userAppInfo in userAppInfos)
{
UserApplicationInfo user = userAppInfo as UserApplicationInfo;
users.Add(new UserModel(GetEntity <User>(new int[] { user.User_Id })));
}
success = true;
}
catch (DatabaseException exception)
{
message = exception.Message;
}
return(Json(new { Success = success, Rows = users.ToArray(), Total = total, Message = message }, JsonRequestBehavior.AllowGet));
}
public T GetEntity <T>(int[] ids) where T : ModelEntity
{
DSClient client = new DSClient(Models.Const.ApplicationId);
int userId;
string token;
if (GetToken(out userId, out token))
{
var t = typeof(T);
if (t == typeof(Application))
{
Application app = client.GetApplication(userId, token, ids[0]);
return(app as T);
}
else if (t == typeof(Role))
{
Role role = client.GetRole(userId, token, ids[0]);
return(role as T);
}
else if (t == typeof(Image))
{
Image image = client.GetImage(userId, token, ids[0]);
return(image as T);
}
else if (t == typeof(Command))
{
Command cmd = client.GetCommand(userId, token, ids[0]);
return(cmd as T);
}
else if (t == typeof(RoleCommand))
{
RoleCommand rc = client.GetRoleCommand(userId, token, ids[0]);
return(rc as T);
}
else if (t == typeof(RoleCommandView))
{
RoleCommandView rc = client.GetRoleCommandView(userId, token, ids[0]);
return(rc as T);
}
else if (t == typeof(User))
{
User user = client.GetUser(userId, token, ids[0]);
return(user as T);
}
else if (t == typeof(UserApplicationInfo))
{
UserApplicationInfo info = client.GetUserInfo(userId, token, ids[0], ids[1]);
return(info as T);
}
else if (t == typeof(RoomGroup))
{
RoomGroup roomGroup = client.GetRoomGroup(userId, token, ids[0]);
return(roomGroup as T);
}
else if (t == typeof(Room))
{
Room room = client.GetRoom(userId, token, ids[0]);
return(room as T);
}
else if (t == typeof(RoomRole))
{
RoomRole rRole = client.GetRoomRole(userId, token, ids[0], ids[1], ids[2]);
return(rRole as T);
}
else if (t == typeof(GiftGroup))
{
GiftGroup giftGroup = client.GetGiftGroup(userId, token, ids[0]);
return(giftGroup as T);
}
else if (t == typeof(Gift))
{
Gift gift = client.GetGift(userId, token, ids[0]);
return(gift as T);
}
else if (t == typeof(BlockType))
{
BlockType b = client.GetBlockType(userId, token, ids[0]);
return(b as T);
}
else if (t == typeof(BlockList))
{
BlockList b = client.GetBlockList(userId, token, ids[0]);
return(b as T);
}
else if (t == typeof(RoomRole))
{
RoomRole rr = client.GetRoomRole(userId, token, ids[0], ids[1], ids[2]);
return(rr as T);
}
else if (t == typeof(RoomConfig))
{
RoomConfig c = client.GetRoomConfig(userId, token, ids[0]);
return(c as T);
}
}
return(null);
}
/// <summary>
/// 更新用户应用信息
/// </summary>
/// <param name="userAppInfo"></param>
/// <returns></returns>
public static int UpdateUserApplication(UserApplicationInfo userAppInfo)
{
return(DatabaseProvider.GetInstance().UpdateUserApplication(userAppInfo));
}
