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]);
}
