public ActionResult EditDummy(string nickname, string money, string bettime, string bettype, string roomtype, string avatar, int vip, string st_h, string st_m, string et_h, string et_m, int dummyid = 0) { LoadRoom(); ViewData["referer"] = ShopUtils.GetAdminRefererCookie(); if (nickname != null && nickname != string.Empty) { MD_Dummy dum = new MD_Dummy { Dummyid = dummyid, Nickname = nickname, Money = money, Bettime = bettime, BetType = bettype, RoomName = roomtype, Avatar = avatar, Vip = vip, Start = (st_h.Length == 1 ? "0" + st_h : st_h) + ":" + (st_m.Length == 1 ? "0" + st_m : st_m), End = (et_h.Length == 1 ? "0" + et_h : et_h) + ":" + (et_m.Length == 1 ? "0" + et_m : et_m) }; DataTable result = NewUser.UpdateDummyUser(dum); if (result == null || result.Rows.Count == 0) { return(PromptView("保存失败")); } if (result.Rows[0]["state"].ToString().EndsWith("成功")) { string username = result.Rows[0]["username"].ToString(); return(PromptView("保存成功")); } else { return(PromptView(result.Rows[0]["state"].ToString() == "昵称已存在" ? "昵称已存在" : "保存失败")); } } else { return(PromptView("请输入有效的用户昵称")); } }
public ActionResult AddDummy(UserDummyModel model) { LoadRoom(); ViewData["referer"] = ShopUtils.GetAdminRefererCookie(); if (model.NickName != null && model.NickName != string.Empty) { MD_Dummy dum = new MD_Dummy { Nickname = model.NickName, Money = model.Money, Bettime = model.BetTime, BetType = model.BetType, RoomName = model.RoomType, Avatar = model.Avatar, Vip = int.Parse(model.Vip), Start = (model.ST_H.Length == 1?"0" + model.ST_H:model.ST_H) + ":" + (model.ST_M.Length == 1?"0" + model.ST_M:model.ST_M), End = (model.ET_H.Length == 1?"0" + model.ET_H:model.ET_H) + ":" + (model.ET_M.Length == 1?"0" + model.ET_M:model.ET_M) }; DataTable result = NewUser.UpdateDummyUser(dum); if (result == null || result.Rows.Count == 0) { return(PromptView("保存失败")); } if (result.Rows[0]["state"].ToString().EndsWith("成功")) { string username = result.Rows[0]["username"].ToString(); AddIM(username); return(PromptView("保存成功")); } else { return(PromptView(result.Rows[0]["state"].ToString() == "昵称已存在" ? "昵称已存在" : "保存失败")); } } else { return(PromptView("请输入有效的用户昵称")); } }
/// <summary> /// 添加/修改用户 /// </summary> /// <param name="info"></param> /// <returns></returns> public static DataTable UpdateDummyUser(MD_Dummy info) { return(OWZX.Data.NewUser.UpdateDummyUser(info)); }
/// <summary> /// 添加/修改用户 /// </summary> /// <param name="info"></param> /// <returns></returns> public static DataTable UpdateDummyUser(MD_Dummy info) { return(OWZX.Core.BSPData.RDBS.UpdateDummyUser(info)); }
/// <summary> /// 添加/修改用户 /// </summary> /// <param name="info"></param> /// <returns></returns> public DataTable UpdateDummyUser(MD_Dummy info) { DbParameter[] parms = { GenerateInParam("@dummyid", SqlDbType.Int, 4, info.Dummyid), GenerateInParam("@nickname", SqlDbType.VarChar, 30, info.Nickname), GenerateInParam("@money", SqlDbType.VarChar, 500, info.Money), GenerateInParam("@bettime", SqlDbType.VarChar, 500, info.Bettime), GenerateInParam("@bettype", SqlDbType.VarChar, 500, info.BetType), GenerateInParam("@roomname", SqlDbType.VarChar, 50, info.RoomName), GenerateInParam("@avatar", SqlDbType.VarChar, 50, info.Avatar), GenerateInParam("@vip", SqlDbType.Int, 4, info.Vip), GenerateInParam("@start", SqlDbType.VarChar, 5, info.Start), GenerateInParam("@end", SqlDbType.VarChar, 5, info.End) }; string sql = string.Format(@" begin try begin tran t1 if exists(select 1 from owzx_dummyinfo where dummyid=@dummyid) begin if not exists(select 1 from owzx_dummyinfo where dummyid !=@dummyid and nickname=@nickname) begin update a set a.nickname=@nickname,a.money=@money,a.bettime=@bettime, a.bettype=@bettype,a.roomname=@roomname,avatar=@avatar,vip=@vip, a.start=@start,a.[end]=@end from owzx_dummyinfo a where dummyid=@dummyid select '成功' state,'' username commit tran t1 end else begin select '昵称已存在' state commit tran t1 end end else begin if not exists(select 1 from owzx_dummyinfo where nickname=@nickname) begin INSERT INTO [owzx_dummyinfo]([username],[nickname],money,bettime,roomname,bettype,avatar,vip,start,[end]) VALUES('usn'+rtrim(cast((select count(1)+1 from owzx_dummyinfo) as varchar(10))),@nickname,@money,@bettime,@roomname,@bettype,@avatar,@vip,@start,@end) select '成功' state,'usn'+rtrim(cast((select count(1) from owzx_dummyinfo) as varchar(10))) username commit tran t1 end else begin select '昵称已存在' state commit tran t1 end end end try begin catch rollback tran t1 select error_message() state end catch ", info.Dummyid, info.Nickname); return(RDBSHelper.ExecuteTable(sql, parms)[0]); }