//游戏时长排行
public void BindGameTimeList()
{
DataTable dt = new BLL.Member().ListPlayTimeCount(10);
rptGameTime.DataSource = dt.DefaultView;
rptGameTime.DataBind();
}
protected void Login1_LoggedIn(object sender, EventArgs e)
{
bool signout = false;
MembershipUser user = Membership.GetUser(Login1.UserName);
Member member = new Member();
member.GetMemberByUserId(new Guid(user.ProviderUserKey.ToString()));
if (member.RowStatusID != (int)Helper.Enums.RowStatus.Enabled)
{
signout = true;
}
else
{
member.IsOnLine = true;
CheckBox cb = (CheckBox)Login1.FindControl("uiCheckBoxInvisible");
if (cb.Checked)
member.Status = (int)Helper.Enums.MemberStatus.Offline;
member.Save();
Session[SessionManager.loggedInMemberID] = member.s_MemberID;
Response.Redirect("home.aspx");
}
if (signout)
{
FormsAuthentication.SignOut();
ClientScript.RegisterStartupScript(this.GetType(), "notEnabled", "$(document).ready(function (){ $('#NotEnabled').modal('show'); });", true);
}
}
//奖券排行
public void BindLotteriesList()
{
DataTable dt = new BLL.Member().ListLotteries(10);
rptLotteries.DataSource = dt.DefaultView;
rptLotteries.DataBind();
}
//
//public void BindGameList()
//{
// Game game = new Game();
// rptGame1.DataSource = game.GetGameInfoList(0, 1);
// rptGame1.DataBind();
// rptGame2.DataSource = game.GetGameInfoList(0, 2);
// rptGame2.DataBind();
// rptGame3.DataSource = game.GetGameInfoList(0, 3);
// rptGame3.DataBind();
//}
//绑定热门游戏列表
//public void BindHotGame()
//{
// rpHotGameList.DataSource = new BLL.Game().List(5, 1).DefaultView;
// rpHotGameList.DataBind();
//}
//public void BindAllGame()
//{
// rpAllGameList.DataSource = new BLL.Game().List(16, 0).DefaultView;
// rpAllGameList.DataBind();
//}
/*
* /// <summary>
* /// 绑定玩家鲜花排行
* /// </summary>
* private void BindTopFollows()
* {
* DataTable dt = DbSession.Default.FromSql("select TOP 7 * from Web_vFaciSum order by fascisum desc").ToDataTable();
* if (dt.Rows.Count > 0)
* {
* rptFollowsTop.Visible = true;
* ltNonFollows.Visible = false;
* rptFollowsTop.DataSource = dt;
* rptFollowsTop.DataBind();
* }
* else
* {
* rptFollowsTop.Visible = false;
* ltNonFollows.Visible = true;
* }
* }
*
* /// <summary>
* /// 绑定新闻栏目列表
* /// </summary>
* private void BindNewsColumn()
* {
* //DataTable dt = ( new BLL.News() ).TypeList(4);
* //if( dt.Rows.Count > 0 )
* //{
* // ltNonNewsColumn.Visible = false;
* // rptNewsColumnList.Visible = true;
* // rptNewsColumnList.DataSource = dt;
* // rptNewsColumnList.DataBind();
* //}
* //else
* //{
* // ltNonNewsColumn.Visible = true;
* // rptNewsColumnList.Visible = false;
* //}
* }
*
*
*
* //兑奖名单
* public void BindDuiJiangLog()
* {
* //rpDuiJingLog.DataSource = new BLL.Member().ListDuiJiangLog(6);
* //rpDuiJingLog.DataBind();
* }
*
*
*
* //绑定奖品数据 杨大胜 2009-4-14
* public void BindJiangPin()
* {
*
* <asp:Repeater ID="rpJiangPin" runat="server" Visible="false">
* <ItemTemplate>
* <tr>
* <td>
* <a href="/DuiJiang.aspx?id=<%#Eval("Award_ID") %>">
* <img src="<%#Eval("Award_Pic") %>" alt="<%#Eval("Award_Name") %>" onerror="this.src='/Images/NoPicture/no_pic.gif'" height="100" width="265" /></a></td>
* </tr>
* </ItemTemplate>
* <SeparatorTemplate>
* <tr>
* <td>
* </td>
* </tr>
* </SeparatorTemplate>
* </asp:Repeater>
*
*
* //DataTable dt = new BLL.JiangPin().List(3);
* //rpJiangPin.DataSource = dt.DefaultView;
* //rpJiangPin.DataBind();
* }
*
* //绑定道具数据 杨大胜 2009-4-13
* public void BindDaoJu()
* {
* //DataTable dt = new BLL.DaoJu().List( 4 );
* //rpDaoJu.DataSource = dt.DefaultView;
* //rpDaoJu.DataBind();
* }
*
* //绑定友情链接 杨大胜 2009-4-23
* public void BindFriend()
* {
* //rpFriend.DataSource = new BLL.FriendLink().List(0);
* //rpFriend.DataBind();
* }
*/
//玩家财富排行
public void BindCaifu()
{
DataTable dt = new BLL.Member().ListCaifu(10);
rpCaifu.DataSource = dt.DefaultView;
rpCaifu.DataBind();
}
protected void uiButtonChangePass_Click(object sender, EventArgs e)
{
Member user = new Member();
if (Request.QueryString["rc"] != null)
{
string querystring = Helper.General.DecryptString(Request.QueryString["rc"].ToString());
string[] allkeys = querystring.Split('&');
if (!(allkeys.Length < 2))
{
int id = Convert.ToInt32(allkeys[0].Substring(4));
string mail = allkeys[1].Substring(6);
user.LoadByPrimaryKey(id);
if (user.Email == mail)
{
MembershipUser _user = Membership.GetUser(user.UserName);
if (_user.ChangePassword(_user.GetPassword(user.Answer), Password.Text))
ErrorMessage.Text = "تم تغيير كلمة السر بنجاح.";
else
ErrorMessage.Text = "حدث خطأ . من فضلك حاول مرة أخرى.";
ClearFields();
}
else
ErrorMessage.Text = "حدث خطأ . من فضلك حاول مرة أخرى.";
}
else
ErrorMessage.Text = "حدث خطأ . من فضلك حاول مرة أخرى.";
ErrorMessage.Visible = true;
}
else
Response.Redirect("default.aspx");
}
private void MatchApply()
{
string contestId = Common.FilterString(Common.GetStringOfUrl("id"));
try
{
string uid = Common.FilterString(Common.GetIntOfUrl("uid").ToString());
if (!UiCommon.UserLoginInfo.IsLogin)
{
//判断是否从平台跳转过来的
string token = Common.FilterString(Common.GetStringOfUrl("token2").ToString());
if (CommonManager.String.IsInteger(uid) && token.Trim().Length > 0)
{
string un = new BLL.Member().GetNameByUserID(uid, token);
if (!string.IsNullOrEmpty(un))
{
UserLoginInfo.SetInfo(uid, un);
}
else
{
Response.Write("抱歉，报名失败，可能是服务器繁忙，请稍后再试！");
return;
}
}
}
Dictionary <string, object> dic = new Dictionary <string, object>();
DbSession.Default.FromProc("Web_pApplyMatch").AddInputParameter("@UserID", DbType.Int32, UserLoginInfo.UserID)
.AddInputParameter("@ContestID", DbType.Int32, Request.QueryString["id"].ToString())
.AddReturnValueParameter("@ReturnValue", DbType.Int32)
.Execute(out dic);
if (dic.Count <= 0)
{
Response.Write("抱歉，报名失败，可能是服务器繁忙，请稍后再试！");
return;
}
if (dic["ReturnValue"].ToString() == "-1")
{
Response.Write("抱歉，报名失败，您银行的" + ConfigurationManager.AppSettings["moneyName"].ToString() + "不足！");
return;
}
if (dic["ReturnValue"].ToString() == "-2")
{
Response.Write("已成功报名！");
return;
}
Response.Write("报名成功！");
}
catch (Exception ex)
{
Response.Write("报名失败，服务器未知错误！");
}
}
public void addToRoom(int memberID, int roomid)
{
Groups.Add(Context.ConnectionId, roomid.ToString());
try
{
Member member = new Member();
member.LoadByPrimaryKey(memberID);
bool isHidden = member.Status == (int)Helper.Enums.MemberStatus.Offline &&
Roles.IsUserInRole(member.Name, Helper.Enums.MemberRoles.InvisibleInRoom.ToString());
RoomMember roomMember = new RoomMember();
if (!roomMember.LoadByPrimaryKey(memberID, roomid))
{
roomMember.AddNew();
roomMember.MemberID = memberID;
roomMember.RoomID = roomid;
}
roomMember.LastJoinDate = DateTime.Now;
roomMember.InRoom = !isHidden;
Room room = new Room();
room.LoadByPrimaryKey(roomid);
if (!room.IsColumnNull("CreatedBy"))
{
if (room.CreatedBy == roomMember.MemberID)
roomMember.RoomMemberLevelID = (int)Helper.Enums.RoomMemberLevel.Owner;
}
roomMember.Save();
Helper.ChatMember chatMember = roomMember.LoadWithSettings(roomid, roomMember.MemberID, roomMember.MemberID, null).FirstOrDefault();
if (!isHidden)
Clients.Group(roomid.ToString()).addNewMember(roomid.ToString(), chatMember);
if (roomMember.RoomMemberLevelID > (int)Helper.Enums.RoomMemberLevel.Visitor)
Groups.Add(Context.ConnectionId, GetRoomAdminGroupName(roomid));
BLL.MemberLog log = new BLL.MemberLog();
Helper.Enums.LogType lgType = Helper.Enums.LogType.EnterRoom;
if (isHidden)
lgType = Helper.Enums.LogType.EnterRoomHidden;
log.AddNew(memberID, new BLL.Log.EnterRoom() { Type = lgType, RoomID = roomid, RoomName = room.Name }, null, roomid);
RoomMember onlineroomMember = new RoomMember();
onlineroomMember.GetAllOnlineMembersByRoomID(roomid);
Clients.All.updateExistingCount(roomid, onlineroomMember.RowCount);
var item = ConnectedUsers.FirstOrDefault(m => m.MemberID == memberID);
if (item == null)
{
var newMember = new Helper.SignalRUser { ConnectionId = Context.ConnectionId, MemberName = member.Name, MemberID = member.MemberID, ProfilePic = member.ProfilePic, MemberTypeSpecID = member.MemberType.MemberTypeSpecDuration.MemberTypeSpecID };
ConnectedUsers.Add(newMember);
}
}
catch (Exception ex)
{
}
}
public void TuiguangBalance()
{
string tgUserId = Common.SqlEncode(Common.GetStringOfUrl("tguserid"));
string userId = Common.SqlEncode(Common.GetStringOfUrl("userid"));
//返回值：-1未达到有效推广 ， 0达到有效推广 ， 或其它值
int iRe = new BLL.Member().TuiguangBalance(tgUserId, userId);
Response.Write(iRe);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Member member = new Member();
member.GetMemberByUserId(new Guid(Membership.GetUser().ProviderUserKey.ToString()));
ctrlSendMail.MemberID = member.MemberID;
ctrlSendMail.MemberName = member.Name;
}
}
protected void Page_Load(object sender, EventArgs e)
{
string billno = Utility.Common.GetStringOfUrl("billno"); //订单编号
string amount = Utility.Common.GetStringOfUrl("amount"); //订单金额
string date = Utility.Common.GetStringOfUrl("date"); //订单日期
string succ = Utility.Common.GetStringOfUrl("succ"); //成功标志
string ipsbillno = Utility.Common.GetStringOfUrl("ipsbillno"); //IPS订单编号
string currency_Type = Utility.Common.GetStringOfUrl("Currency_type"); //币种
string signature = Utility.Common.GetStringOfUrl("signature").ToLower(); //MD5签名
string retencodetype = Utility.Common.GetStringOfUrl("retencodetype");//交易返回签名方式
if (string.IsNullOrEmpty(billno) || string.IsNullOrEmpty(amount) || string.IsNullOrEmpty(date) ||
string.IsNullOrEmpty(succ) || string.IsNullOrEmpty(ipsbillno) || string.IsNullOrEmpty(currency_Type) || string.IsNullOrEmpty(signature))
{
Server.Transfer("Default.aspx");
}
if (succ.Equals("Y"))
{
//交易成功
if (currency_Type == null || currency_Type == "")
{
currency_Type = "RMB";
}
string signatureVal = Utility.Common.md5("billno" + billno + "currencytype" + currency_Type + "amount" + amount + "date" + date + "succ" + succ + "ipsbillno" + ipsbillno + "retencodetype" + retencodetype + UiCommon.StringConfig.IPS_Letter).ToLower();
if (signature.Equals(signatureVal.ToLower()))
{
Member mem = new Member();
if (!mem.IsPaySuccess(billno))
{
mem.Update3PayOrder((int)(float.Parse(amount)), billno);
}
}
else
{
}
}
else
{
//交易失败
// lblMsg.Text = "充值失败，请稍后再试！";
}
}
protected void Page_Load(object sender, EventArgs e)
{
AdminPopedom.IsHoldModel("15");
StringBuilder where = new StringBuilder( );
string userName = string.Empty;
string un = CommonManager.Web.RequestUrlDecode("un", "");
if (!string.IsNullOrEmpty(un))
{
userName = un;
where.Append(" and UserName='******'");
}
where.Append(" and ID<>0");
DataSet ds = DbSession.Default.FromProc("Web_pGetDataPager")
.AddInputParameter("@PageSize", DbType.Int32, anpPageIndex.PageSize)
.AddInputParameter("@CurrentPage", DbType.Int32, PageIndex)
.AddInputParameter("@Columns", DbType.String, "*")
.AddInputParameter("@TableName", DbType.String, "Web_VFasciClearPropLog")
.AddInputParameter("@Wheres", DbType.String, where.ToString())
.AddInputParameter("@KeyName", DbType.String, "ID")
.AddInputParameter("@OrderBy", DbType.String, "InputDate desc,ID desc")
.ToDataSet();
if (ds.Tables.Count > 0)
{
anpPageIndex.RecordCount = (int)ds.Tables[0].Rows[0][0];
anpPageIndex.CurrentPageIndex = PageIndex;
if (ds.Tables[1].Rows.Count > 0)
{
rptDataList.Visible = true;
lbNonData.Visible = false;
rptDataList.DataSource = ds.Tables[1];
rptDataList.DataBind();
}
else
{
rptDataList.Visible = false;
lbNonData.Visible = true;
}
}
DataRow dr = new BLL.Member().GetPropFasciStatLog(userName);
if (dr != null)
{
GaoJiPropFasci = dr["GaoJi"].ToString();
ZhongJiPropFasci = dr["ZhongJi"].ToString();
DiJiPropFasci = dr["DiJi"].ToString();
}
}
protected void uiLinkButtonConfirm_Click(object sender, EventArgs e)
{
MembershipUser user = Membership.GetUser();
if (user.PasswordQuestion == uiDropDownListQuestion.SelectedValue && Member.CurrentMember.Answer == uiTextBoxAnswer.Text.Trim())
{
if (!string.IsNullOrEmpty(uiHiddenFieldFriendID.Value))
{
try
{
int points = Convert.ToInt32(uiHiddenFieldPoints.Value);
if (Member.CurrentMember.Credit_Point < points)
{
ClientScript.RegisterStartupScript(this.GetType(), "Error3", @"$(document).ready(function () { notify('error', 'حدث خطأ . رصيدك الحالى لا يسمح لإتمام الشحن.'); });", true);
return;
}
Member ToMember = new Member();
ToMember.LoadByPrimaryKey(Convert.ToInt32(uiHiddenFieldFriendID.Value));
ToMember.Credit_Point = ToMember.Credit_Point + points;
Member.CurrentMember.Credit_Point -= points;
ToMember.Save();
Member.CurrentMember.Save();
ClientScript.RegisterStartupScript(this.GetType(), "Success1", @"$(document).ready(function () { notify('success', 'تم تحويل النقاط بنجاح.'); });", true);
// logging
BLL.MemberLog log = new BLL.MemberLog();
log.AddNew(Member.CurrentMemberID, new BLL.Log.RechargePoints() { FromMemberName=BLL.Member.CurrentMember.Name,ToMemberName = ToMember.Name, Points = points }, ToMember.MemberID, null);
LoadBalance();
uiHiddenFieldPrice.Value = "";
uiHiddenFieldPoints.Value = "";
uiHiddenFieldFriendID.Value = "";
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Error11", @"$(document).ready(function () { notify('error', 'حدث خطأ . من فضلك أعد المحاولة.'); });", true);
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Error4", @"$(document).ready(function () { notify('error', 'حدث خطأ . من فضلك أعد المحاولة.'); });", true);
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Error5", @"$(document).ready(function () { notify('error', 'حدث خطأ . من فضلك تأكد من السؤال والإجابة السرى.'); });", true);
return;
}
}
//魅力值排行
public void BindMeiliList()
{
string where = " and meili>0";
if (ConfigurationManager.AppSettings["RobotRank"] != null && ConfigurationManager.AppSettings["RobotRank"] == "0")
{
where += " and userid in (select userid from tusers where isrobot=0)";
}
int counts;
DataTable dt = new BLL.Member().PagerListFascination(10, 1, out counts, where);
rpMeili.DataSource = dt.DefaultView;
rpMeili.DataBind();
}
protected void Page_Load( object sender, EventArgs e )
{
AdminPopedom.IsHoldModel( "15" );
StringBuilder where = new StringBuilder( );
string userName = string.Empty;
string un = CommonManager.Web.RequestUrlDecode( "un", "" );
if (!string.IsNullOrEmpty(un))
{
userName = un;
where.Append(" and UserName='******'");
}
where.Append(" and ID<>0");
DataSet ds = DbSession.Default.FromProc( "Web_pGetDataPager" )
.AddInputParameter( "@PageSize", DbType.Int32, anpPageIndex.PageSize )
.AddInputParameter( "@CurrentPage", DbType.Int32, PageIndex )
.AddInputParameter( "@Columns", DbType.String, "*" )
.AddInputParameter( "@TableName", DbType.String, "Web_VFasciClearPropLog" )
.AddInputParameter( "@Wheres", DbType.String, where.ToString() )
.AddInputParameter( "@KeyName", DbType.String, "ID" )
.AddInputParameter( "@OrderBy", DbType.String, "InputDate desc,ID desc" )
.ToDataSet();
if( ds.Tables.Count > 0 )
{
anpPageIndex.RecordCount = (int)ds.Tables[0].Rows[0][0];
anpPageIndex.CurrentPageIndex = PageIndex;
if( ds.Tables[1].Rows.Count > 0 )
{
rptDataList.Visible = true;
lbNonData.Visible = false;
rptDataList.DataSource = ds.Tables[1];
rptDataList.DataBind();
}
else
{
rptDataList.Visible = false;
lbNonData.Visible = true;
}
}
DataRow dr = new BLL.Member().GetPropFasciStatLog(userName);
if (dr != null)
{
GaoJiPropFasci = dr["GaoJi"].ToString();
ZhongJiPropFasci = dr["ZhongJi"].ToString();
DiJiPropFasci = dr["DiJi"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Member member=new Member();
member.GetMemberByUserId(new Guid(Membership.GetUser().ProviderUserKey.ToString()));
ctrlMail.MemberName = Membership.GetUser().UserName;
ctrlMail.MemberID = member.MemberID;
// logging
BLL.MemberLog log = new BLL.MemberLog();
log.AddNew(BLL.Member.CurrentMemberID, new BLL.Log.Log() { Type = Helper.Enums.LogType.ViewMailPage }, null, null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Member user = BLL.Member.CurrentMember;
Member online = new Member();
online.GetMemberFriendsByStatus(user.MemberID, true);
Member offline = new Member();
offline.GetMemberFriendsByStatus(user.MemberID, false);
uiRepeaterOnline.DataSource = online.DefaultView;
uiRepeaterOnline.DataBind();
uiRepeaterOffline.DataSource = offline.DefaultView;
uiRepeaterOffline.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string position = CommonManager.Web.Request("position", "");
if (!string.IsNullOrEmpty(position) && position == "index")
{
//校验验证码
string vali = CommonManager.Web.Request("vali", "");
if (string.IsNullOrEmpty(vali) || !CommonManager.String.IsInteger(vali))
{
Response.Write("ValiError");
return;
}
if (Session["CodeImageV"] == null || vali != Session["CodeImageV"].ToString())
{
Response.Write("ValidateExpair");
return;
}
Session["CodeImageV"] = "";
}
string sqlUserName = CommonManager.Web.RequestUrlDecode("username", "");
string sqlpassword = CommonManager.Web.RequestUrlDecode("password", "");
BLL.LoginResults lr = new BLL.Member().Login(sqlUserName, sqlpassword);
if (lr == BLL.LoginResults.MemberNameInvalid || lr == BLL.LoginResults.PasswordInvalid)
{
Response.Write("False");
}
else if (lr == BLL.LoginResults.Locked)
{
Response.Write("NoPass");
}
else if (lr == BLL.LoginResults.Succeed)
{
new BLL.Member().UpdateLastLogin(sqlUserName, Utility.Common.RequestIP);
Response.Write("True");
}
}
catch (Exception ex)
{
Response.Write("Error");
//Response.Write("Message:" + ex.Message + "Source:" + ex.Source + "StackTrace:" + ex.StackTrace);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string position = CommonManager.Web.Request("position", "");
if (!string.IsNullOrEmpty(position) && position == "index")
{
//校验验证码
string vali = CommonManager.Web.Request("vali", "");
if (string.IsNullOrEmpty(vali) || !CommonManager.String.IsInteger(vali))
{
Response.Write("ValiError");
return;
}
if (Session["CodeImageV"] == null || vali != Session["CodeImageV"].ToString())
{
Response.Write("ValidateExpair");
return;
}
Session["CodeImageV"] = "";
}
string sqlUserName = CommonManager.Web.RequestUrlDecode("username", "");
string sqlpassword = CommonManager.Web.RequestUrlDecode("password", "");
BLL.LoginResults lr = new BLL.Member().Login(sqlUserName, sqlpassword);
if (lr == BLL.LoginResults.MemberNameInvalid || lr == BLL.LoginResults.PasswordInvalid)
{
Response.Write("False");
}
else if (lr == BLL.LoginResults.Locked)
{
Response.Write("NoPass");
}
else if (lr == BLL.LoginResults.Succeed)
{
new BLL.Member().UpdateLastLogin(sqlUserName, Utility.Common.RequestIP);
Response.Write("True");
}
}
catch (Exception ex)
{
Response.Write("Error");
//Response.Write("Message:" + ex.Message + "Source:" + ex.Source + "StackTrace:" + ex.StackTrace);
}
}
protected void uiLinkButtonCreateTempRoom_Click(object sender, EventArgs e)
{
if (Request.IsAuthenticated)
{
if (uiCheckBoxListFriends.Items.Cast<ListItem>().Where(i => i.Selected).Count() > 0)
{
IHubContext _Ncontext = GlobalHost.ConnectionManager.GetHubContext<NotificationHub>();
Member member = new Member();
member.GetMemberByUserId(new Guid(Membership.GetUser().ProviderUserKey.ToString()));
Room room = new Room();
room.AddNew();
room.EnableCam = true;
room.EnableMic = true;
room.RowStatusID = 1;
room.CreatedDate = DateTime.Now;
room.Save();
room.Name = "غرفة مؤقتة - " + room.RoomID.ToString();
room.Save();
Session["TempRoomCreate"] = room.RoomID;
// notify friends with new temp room
for (int i = 0; i < uiCheckBoxListFriends.Items.Count; i++)
{
if (uiCheckBoxListFriends.Items[i].Selected)
{
Member temp = new Member();
temp.LoadByPrimaryKey(Convert.ToInt32(uiCheckBoxListFriends.Items[i].Value));
MembershipUser u = Membership.GetUser(temp.UserID);
_Ncontext.Clients.Group(u.UserName).inviteToTempRoom(room.RoomID, member.Name);
}
}
IHubContext _Rcontext = GlobalHost.ConnectionManager.GetHubContext<ChatRoomHub>();
_Rcontext.Clients.Group(member.UserName).openTempRoom(room.RoomID);
//ClientScript.RegisterStartupScript(this.GetType(), "initTempRoom", "self.parent.location='/home.aspx';", true);
//Response.Redirect("home.aspx");
}
else
{
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(ActivationCode))
{
Guid ac;
Guid.TryParse(ActivationCode, out ac);
if (ac != Guid.Empty)
{
Member currentmember = Member.CurrentMember;
Member account = new Member();
account.GetMemberByActivationCode(ac);
if (account.MemberID == currentmember.MemberID)
{
account.IsMailActivated = true;
account.Save();
uiPanelActivationForm.Visible = false;
uiPanelMailSent.Visible = false;
uiPanelActivated.Visible = true;
}
else
{
uiPanelActivationForm.Visible = true;
uiPanelMailSent.Visible = false;
uiPanelActivated.Visible = false;
}
}
else
{
uiPanelActivationForm.Visible = true;
uiPanelMailSent.Visible = false;
uiPanelActivated.Visible = false;
}
}
else
{
uiPanelActivationForm.Visible = true;
uiPanelMailSent.Visible = false;
uiPanelActivated.Visible = false;
}
}
}
protected void uiButtonRegister_Click(object sender, EventArgs e)
{
MembershipUser[] users = Membership.GetAllUsers().Cast<MembershipUser>().Where(m => m.Email == Email.Text).ToArray();
if (users.Length == 15)
{
ErrorMessage.Text = GetLocalResourceObject("maxMailAccount").ToString();
ErrorMessage.Visible = true;
return;
}
MembershipCreateStatus objstatus;
MembershipUser objUser = Membership.CreateUser(UserName.Text, Password.Text, Email.Text, Question.Text, Answer.Text, true, out objstatus);
bool success = true;
switch (objstatus)
{
case MembershipCreateStatus.DuplicateUserName:
ErrorMessage.Text = GetLocalResourceObject("duplicateUsername").ToString();
ErrorMessage.Visible = true;
success = false;
break;
case MembershipCreateStatus.InvalidPassword:
ErrorMessage.Text = GetLocalResourceObject("invalidPass").ToString();
ErrorMessage.Visible = true;
success = false;
break;
case MembershipCreateStatus.ProviderError:
case MembershipCreateStatus.UserRejected:
ErrorMessage.Text = GetLocalResourceObject("generalError").ToString();
ErrorMessage.Visible = true;
success = false;
break;
default:
break;
}
if (success)
{
Member member = new Member ();
member.AddNew();
member.UserID = new Guid(objUser.ProviderUserKey.ToString());
member.Name = objUser.UserName;
member.Save();
FormsAuthentication.SetAuthCookie(objUser.Email, false);
Response.Redirect("Account.aspx");
}
}
protected void uiLinkButtonAddPhoto_Click(object sender, EventArgs e)
{
/*string path = "~/" + ConfigurationManager.AppSettings["accountpics"].ToString();
DirectoryInfo dir = new DirectoryInfo(Server.MapPath(path + "/" + Membership.GetUser().ProviderUserKey.ToString()));
if (!dir.Exists)
dir.Create();
Member member = new Member();
member.GetMemberByUserId(new Guid(Membership.GetUser().ProviderUserKey.ToString()));
path += "/" + Membership.GetUser().ProviderUserKey.ToString();
if (uiFileUploadAddImage.HasFile)
{
path = path + "/" + DateTime.Now.ToString("ddMMyyyy_hhmmss_") + uiFileUploadAddImage.FileName;
uiFileUploadAddImage.SaveAs(Server.MapPath(path));
MemberPic pic = new MemberPic();
pic.AddNew();
pic.Description = uiTextBoxPhotoDesc.Text;
pic.PicPath = path.Substring(1);
pic.MemberID = member.MemberID;
pic.Save();
}*/
Member member = new Member();
member.GetMemberByUserId(new Guid(Membership.GetUser().ProviderUserKey.ToString()));
if (Session["CurrentUploadedFiles"] != null)
{
Hashtable Files;
Files = (Hashtable)Session["CurrentUploadedFiles"];
if (Files.Count > 0)
{
MemberPic pic = new MemberPic();
foreach (DictionaryEntry item in Files)
{
pic.AddNew();
pic.Description = "";
pic.PicPath = item.Value.ToString(); ;
pic.MemberID = member.MemberID;
}
pic.Save();
Session["CurrentUploadedFiles"] = null;
}
}
LoadPics();
ClientScript.RegisterStartupScript(this.GetType(), "donePic", "$(document).ready(function (){ notify('success','تم إضافة الصورة / الصور بنجاح.');}); ", true);
}
public void BindList()
{
string where = string.Empty;
int counts;
DataTable dt = new BLL.Member().PagerListPropTotal(WebPager1.PageSize, WebPager1.CurrentPageIndex, out counts);
WebPager1.RecordCount = counts;
Rowid = WebPager1.CurrentPageIndex * WebPager1.PageSize - WebPager1.PageSize;
if (dt.Rows.Count <= 0)
{
this.NoDataList.Visible = true;
}
else
{
rpList.DataSource = dt.DefaultView;
rpList.DataBind();
}
}
private void BindRoomInfo()
{
clearFields();
BLL.Room room = new BLL.Room();
room.LoadByPrimaryKey(RoomID);
if (!room.IsColumnNull("CreatedDate"))
uiLabelCreatedDate.Text = Helper.Date.ToString(room.CreatedDate);
BLL.Member creator = new BLL.Member ();
if(!room.IsColumnNull("CreatedBy"))
{
creator.LoadByPrimaryKey(room.CreatedBy);
uiLabelCreator.Text = creator.UserName;
uiLabelName.Text = room.Name;
loadAdminTable();
uiGridViewAdmins.DataSource = AdminsTable;
uiGridViewAdmins.DataBind();
}
}
private void LoadFriends()
{
Member member = new Member();
member.GetMemberByUserId(new Guid(Membership.GetUser().ProviderUserKey.ToString()));
MemberFriend friends = new MemberFriend();
friends.GetAllMemberOnlineFriends(member.MemberID);
if (friends.RowCount > 0)
{
uiCheckBoxListFriends.DataSource = friends.DefaultView;
uiCheckBoxListFriends.DataTextField = "UserName";
uiCheckBoxListFriends.DataValueField = "FriendID";
uiCheckBoxListFriends.DataBind();
}
else
{
uiPanelNoFriendsFound.Visible = true;
uiCheckBoxListFriends.Visible = false;
}
}
public void BindList()
{
string where = string.Empty;
int counts;
DataTable dt = new BLL.Member().PagerListPropTotal(WebPager1.PageSize, WebPager1.CurrentPageIndex, out counts);
WebPager1.RecordCount = counts;
Rowid = WebPager1.CurrentPageIndex * WebPager1.PageSize - WebPager1.PageSize;
if (dt.Rows.Count <= 0)
{
this.NoDataList.Visible = true;
}
else
{
rpList.DataSource = dt.DefaultView;
rpList.DataBind();
}
}
private void ExitMatch()
{
try
{
string contestId = Common.FilterString(Common.GetStringOfUrl("id"));
string hids = Common.FilterString(Common.GetStringOfUrl("hidTime"));
string uid = Common.FilterString(Common.GetIntOfUrl("uid").ToString());
if (!UiCommon.UserLoginInfo.IsLogin)
{
//判断是否从平台跳转过来的
string token = Common.FilterString(Common.GetStringOfUrl("token2").ToString());
if (CommonManager.String.IsInteger(uid) && token.Trim().Length > 0)
{
string un = new BLL.Member().GetNameByUserID(uid, token);
if (!string.IsNullOrEmpty(un))
{
UserLoginInfo.SetInfo(uid, un);
}
else
{
Response.Write("抱歉，退赛失败，可能是服务器繁忙，请稍后再试！");
return;
}
}
}
DateTime dt1 = Convert.ToDateTime(hids);
if (DateTime.Compare(dt1, DateTime.Now) < 0)
{
Response.Write("抱歉，比赛已开始，不能退赛！");
return;
}
DbSession.Default.FromProc("Web_pExitMatch")
.AddInputParameter("@UserID", DbType.Int32, UiCommon.UserLoginInfo.UserID)
.AddInputParameter("@ContestID", DbType.Int32, contestId)
.Execute();
Response.Write("退赛成功！");
}
catch (Exception ex)
{
Response.Write("退赛失败，服务器未知错误！");
}
}
protected void uiLinkButtonAdd_Click(object sender, EventArgs e)
{
string path = "~/" + ConfigurationManager.AppSettings["accountpics"].ToString();
DirectoryInfo dir = new DirectoryInfo(Server.MapPath(path + "/" + Membership.GetUser().ProviderUserKey.ToString()));
if (!dir.Exists)
dir.Create();
Member member = new Member();
member.GetMemberByUserId(new Guid(Membership.GetUser().ProviderUserKey.ToString()));
path += "/" + Membership.GetUser().ProviderUserKey.ToString();
if (uiFileUploadImage.HasFile)
{
path = path + "/" + DateTime.Now.ToString("ddMMyyyy_hhmmss_") + uiFileUploadImage.FileName;
uiFileUploadImage.SaveAs(Server.MapPath(path));
MemberPic pic = new MemberPic ();
pic.AddNew();
pic.Description = path.Substring(1);
pic.MemberID = member.MemberID;
pic.Save();
}
}
public void SendMailNotifications(int? memberID)
{
IHubContext context = GlobalHost.ConnectionManager.GetHubContext<NotificationHub>();
if (!memberID.HasValue)
{
memberID = 0;
BLL.Member member=new Member();
if (member.GetMemberByUserId(new Guid(Membership.GetUser().ProviderUserKey.ToString())))
{
memberID = member.MemberID;
}
}
SendMailNotication(memberID.Value, context);
if (Helper.Admin.IsAdmin() && Helper.Admin.HasRole(Helper.Enums.AdminRoles.Admin_SiteMails.ToString()))
{
foreach (var m in BLL.Member.SiteMembers)
{
SendMailNotication(m.MemberID, context);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Member member = new Member();
member.GetMemberByUserId(new Guid(Membership.GetUser().ProviderUserKey.ToString()));
MemberFriend friends = new MemberFriend();
friends.GetAllMemberOnlineFriends(member.MemberID);
if (friends.RowCount > 0)
{
uiCheckBoxListFriends.DataSource = friends.DefaultView;
uiCheckBoxListFriends.DataTextField = "UserName";
uiCheckBoxListFriends.DataValueField = "FriendID";
uiCheckBoxListFriends.DataBind();
}
else
{
uiPanelNoFriendsFound.Visible = true;
uiCheckBoxListFriends.Visible = false;
}
}
}
protected void CreateUserClick(object sender, EventArgs e)
{
string username = string.Empty, nickname = string.Empty, pwd = string.Empty, idcard = string.Empty, realname = string.Empty;
username = CommonManager.Web.RequestForm("u", "");
BLL.Member member = new BLL.Member();
if (member.ExistName(username))
{
this.ErrorLabel.Text = "该用户名已经存在！";
return;
}
nickname = Server.HtmlDecode(CommonManager.Web.RequestForm("n", "").Replace(",", "''"));
if (member.ExistNick(nickname))
{
this.ErrorLabel.Text = "该昵称已经存在！";
return;
}
pwd = CommonManager.Web.RequestForm("pwd", "");
idcard = CommonManager.Web.RequestForm("idcard", "");
realname = CommonManager.Web.RequestForm("realname", "");
int dbLogoId = member.SetLogoID(1, 1);
int userId = member.Add_UserInfo(username, nickname, string.Empty, 1, dbLogoId, pwd, pwd, idcard, string.Empty, string.Empty, Utility.Common.RequestIP, string.Empty, realname);
if (userId > 0)
{
this.ErrorLabel.ForeColor = System.Drawing.Color.Green;
this.ErrorLabel.Text = "用户创建成功！";
}
else
{
this.ErrorLabel.Text = "抱歉，创建失败，可能是服务器繁忙，请稍后再试！！";
}
}
public void DaoJuZS()
{
string userId = UiCommon.UserLoginInfo.UserID;
string userName = UiCommon.UserLoginInfo.UserName;
string propId = Common.SqlEncode(Common.GetStringOfUrl("id"));
string targetName = Common.GetStringOfUrl("targetname");
int count = Common.GetIntOfUrl("count");
BLL.Member member = new BLL.Member();
if (userName.Trim() == targetName.Trim())
{
//1.如果被赠送用户是自己，不允许赠送
Response.Write("myself");
}
else if (!member.ExistName(Common.SqlEncode(targetName)))
{
//2.被赠送的用户不存在
Response.Write("nouser");
}
else if (count > member.GetDaoJuCount(userId, propId))
{
//3.赠送人道具库中的道具数量不足或没有
Response.Write("nodaoju");
}
else
{
//4.赠送
int iRows = member.ZengsongDaoJu(userId, member.GetUserID(targetName), propId, count);
if (iRows > 0)
{
Response.Write("zsdjcg");
}
else
{
Response.Write("zsdjsb");
}
}
}
protected void CreateUserClick(object sender, EventArgs e)
{
string username = string.Empty, nickname = string.Empty, pwd = string.Empty,idcard=string.Empty,realname=string.Empty;
username = CommonManager.Web.RequestForm("u", "");
BLL.Member member = new BLL.Member();
if (member.ExistName(username))
{
this.ErrorLabel.Text = "该用户名已经存在！";
return;
}
nickname =Server.HtmlDecode(CommonManager.Web.RequestForm("n", "").Replace(",","''"));
if (member.ExistNick(nickname))
{
this.ErrorLabel.Text = "该昵称已经存在！";
return;
}
pwd = CommonManager.Web.RequestForm("pwd", "");
idcard = CommonManager.Web.RequestForm("idcard", "");
realname = CommonManager.Web.RequestForm("realname", "");
int dbLogoId = member.SetLogoID(1, 1);
int userId = member.Add_UserInfo(username, nickname, string.Empty, 1, dbLogoId, pwd, pwd, idcard, string.Empty, string.Empty, Utility.Common.RequestIP, string.Empty, realname);
if( userId > 0 )
{
this.ErrorLabel.ForeColor=System.Drawing.Color.Green;
this.ErrorLabel.Text = "用户创建成功！";
}
else
{
this.ErrorLabel.Text = "抱歉，创建失败，可能是服务器繁忙，请稍后再试！！";
}
}
public int Insert(Member member)
{
return(memberDal.Insert(member));
}
protected void uiLinkButtonAddFriend_Click(object sender, EventArgs e)
{
Member member = new Member();
member.GetMemberByUserId(new Guid(Membership.GetUser().ProviderUserKey.ToString()));
try
{
MemberFriend newfriend = new MemberFriend();
newfriend.AddNew();
newfriend.MemberID = member.MemberID;
newfriend.FriendID = Convert.ToInt32(uiHiddenFieldFriendID.Value);
newfriend.Save();
Member memberfriend = new Member();
memberfriend.LoadByPrimaryKey(newfriend.FriendID);
// logging
BLL.MemberLog log = new BLL.MemberLog();
log.AddNew(BLL.Member.CurrentMemberID, new BLL.Log.AddFriend() { FriendID = newfriend.FriendID, FriendName = memberfriend.Name }, newfriend.FriendID, null);
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "ErrorAddingFriend", "$(document).ready(function (){ notify('error','خطأ. حدث خطأ . من فضلك أعد المحاولة مرة أخرى أو تأكد من وجود الصديق فى قائمة الأصدقاء.');}); ", true);
}
}
private void BindRooms()
{
string[] myparams = null;
if (!string.IsNullOrEmpty(localParams))
{
myparams = localParams.Split('&');
}
if (myparams.Length > 0)
{
if (myparams[0] == "cat=1")
{
int cid = Convert.ToInt32(myparams[1].Substring(2));
Room rooms = new Room();
rooms.GetRoomsByCategoryID(cid);
uiRepeaterRooms.DataSource = rooms.DefaultView;
uiRepeaterRooms.DataBind();
}
else if (myparams[0] == "subcat=1")
{
int scid = Convert.ToInt32(myparams[1].Substring(2));
Room rooms = new Room();
rooms.GetRoomsBySubCategoryID(scid);
uiRepeaterRooms.DataSource = rooms.DefaultView;
uiRepeaterRooms.DataBind();
}
else if (myparams[0] == "vip=1")
{
Room rooms = new Room();
rooms.GetPremiumRooms();
uiRepeaterRooms.DataSource = rooms.DefaultView;
uiRepeaterRooms.DataBind();
}
else if (myparams[0] == "cb=1")
{
Member member = new Member();
member.GetMemberByUserId(new Guid(Membership.GetUser().ProviderUserKey.ToString()));
Room rooms = new Room();
rooms.GetRoomsByCreatorID(member.MemberID);
uiRepeaterRooms.DataSource = rooms.DefaultView;
uiRepeaterRooms.DataBind();
}
else if (myparams[0] == "fav=1")
{
Member member = new Member();
member.GetMemberByUserId(new Guid(Membership.GetUser().ProviderUserKey.ToString()));
Room rooms = new Room();
rooms.GetFavoriteByMemberID(member.MemberID);
uiRepeaterRooms.DataSource = rooms.DefaultView;
uiRepeaterRooms.DataBind();
}
}
}
protected void btnSubmit_ServerClick(object sender, EventArgs e)
{
string validcode = Common.GetStringOfForm("validcode");
if (ValidCode.CurrentCode != validcode)
{
/*Label1.Text = "温馨提示：验证码输入错误，请重新输入！";
* Label1.Visible = true;*/
CommonManager.Web.RegJs(this, "alert('温馨提示：验证码输入错误，请重新输入！');location.href=location.href;", true);
return;
}
string username = Common.FilterString(Common.GetStringOfForm("username"));
//昵称可以输入任何字符，所以要对它进行HTML编码，防止恶意木马脚本字符串；过滤"'"为"''"，避免SQL注入式攻击
string nickname = Server.HtmlEncode(Common.GetStringOfForm("nickname").Replace("'", "''"));
string sex = Common.FilterString(Common.GetStringOfForm("sex"));
string pwd = Common.FilterString(Common.GetStringOfForm("pwd")); //Common.FilterString(Common.GetStringOfForm("pwd"));
string ejpwd = Common.FilterString(Common.GetStringOfForm("ejpwd")); //Common.FilterString(Common.GetStringOfForm("ejpwd"));
string email = Common.FilterString(Common.GetStringOfForm("email"));
string mobile = Common.FilterString(Common.GetStringOfForm("mobile")); //电话保存到TUserInfo表的PhoneNum列
string promoter = Common.FilterString(Common.GetStringOfForm("promoter"));
string logoid = Common.FilterString(Common.GetStringOfForm("hidLogoID"));
string idcard = Common.FilterString(Common.GetStringOfForm("idcard"));
string qqNum = Common.FilterString(Common.GetStringOfForm("qqnum"));
string realname = Common.FilterString(Common.GetStringOfForm("realname"));
if (string.IsNullOrEmpty(sex) || !CommonManager.String.IsInteger(sex))
{
sex = "1";
}
if (string.IsNullOrEmpty(logoid) || !CommonManager.String.IsInteger(logoid))
{
logoid = "1";
}
//新增：注册时选择职业和地区
//string occu = CommonManager.Web.RequestForm( "txtOccuPation", "" );
//string prov = CommonManager.Web.RequestForm( "hidProvince", "" );
//string city = CommonManager.Web.RequestForm( "hidCity", "" );
//string address = Server.HtmlEncode( CommonManager.Web.RequestForm( "txtAddress", "" ) );
//如果银行密码为空，就把它设为登录密码
if (ejpwd.Trim().Length == 0)
{
ejpwd = pwd;
}
BLL.Member member = new BLL.Member();
int dbLogoId = member.SetLogoID(int.Parse(sex), int.Parse(logoid));
#region 增加判断是否在新手送礼包活动期间
/*
* bool isaction = false;
* if (RookiePresentConfig.Config.IsEnable)
* {
* if (RookiePresentConfig.Config.BeginDate <= DateTime.Now && RookiePresentConfig.Config.EndDate >= DateTime.Now)
* {
* isaction = true;
* //walletMoney += RookiePresentConfig.Config.Money;
* //赠送道具
* if (RookiePresentConfig.Config.PropPresent.Rows.Count > 0)
* {
* string select = "select Count(PropID) from TPropDefine where PropID=@PropID;";
* string sql = "insert into TUserProp (UserID,PropID,HoldCount) values ({0},{1},{2});";
* StringBuilder sqlCollection = new StringBuilder();
* foreach (DataRow row in RookiePresentConfig.Config.PropPresent.Rows)
* {
* int tmpcount = DbSession.Default.FromSql(select).AddInputParameter("@PropID", DbType.Int32, row["PropID"]).ToScalar<int>();
* if (tmpcount <= 0)
* continue;
* sqlCollection.AppendFormat(sql, userId, row["PropID"].ToString(), row["Amount"].ToString());
* }
* if (sqlCollection.ToString().Length > 0)
* {
* DbSession.Default.FromSql(sqlCollection.ToString()).Execute();
* }
* }
* }
* else
* {
* isaction = false;
* RookiePresentConfig.Config.IsEnable = false;
* RookiePresentConfig.Save(RookiePresentConfig.Config);
* }
* }*/
#endregion
//2012-12-16 根据域名来获取代理商ID，域名设置在代理商资料修改中
string agencyName = UiCommon.StringConfig.GetAgencyNameByTwoDname(); //获取域名获取代理商账号
int userId = Convert.ToInt32(member.Add_UserInfo(username, nickname, promoter, int.Parse(sex), dbLogoId, pwd, ejpwd, idcard, mobile, email, Common.RequestIP, qqNum, realname, agencyName)["UserID"]);
if (userId > 0)
{
//5.保存用户信息
UiCommon.UserLoginInfo.SetInfo(userId.ToString(), username);
//更新用户登陆信息
new BLL.Member().UpdateLastLogin(username, Utility.Common.RequestIP);
//6.记录当前客户机器上的注册时间到cookies
BCSTCache.Default.Save <CookiesCache>("RegDateTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
Response.Redirect("/Manage/Default.aspx");
}
//else if (userId == -3)
//{
// CommonManager.Web.RegJs(this, "alert('抱歉，注册失败，此IP今天注册人数已满！');location.href=location.href;", true);
//}
//else if (userId == -4)
//{
// CommonManager.Web.RegJs(this, "alert('抱歉，注册失败，此身份证号已达到注册次数限制！');location.href=location.href;", true);
//}
else
{
CommonManager.Web.RegJs(this, "alert('抱歉，注册失败，可能是服务器繁忙，请稍后再试！');location.href=location.href;", true);
}
}
protected void btnSubmit_ServerClick(object sender, EventArgs e)
{
string validcode = Common.GetStringOfForm("validcode");
if (ValidCode.CurrentCode != validcode)
{
/*Label1.Text = "��ܰ��ʾ����֤������������������룡";
Label1.Visible = true;*/
CommonManager.Web.RegJs(this, "alert('��ܰ��ʾ����֤������������������룡');location.href=location.href;", true);
return;
}
string username = Common.FilterString(Common.GetStringOfForm("username"));
//�dzƿ��������κ��ַ�������Ҫ��������HTML���룬��ֹ����ľ��ű��ַ���������"'"Ϊ"''"������SQLע��ʽ����
string nickname = Server.HtmlEncode(Common.GetStringOfForm("nickname").Replace("'", "''"));
string sex = Common.FilterString(Common.GetStringOfForm("sex"));
string pwd = Common.FilterString(Common.GetStringOfForm("pwd"));//Common.FilterString(Common.GetStringOfForm("pwd"));
string ejpwd = Common.FilterString(Common.GetStringOfForm("ejpwd"));//Common.FilterString(Common.GetStringOfForm("ejpwd"));
string email = Common.FilterString(Common.GetStringOfForm("email"));
string mobile = Common.FilterString(Common.GetStringOfForm("mobile"));//�绰���浽TUserInfo���PhoneNum��
string promoter = Common.FilterString(Common.GetStringOfForm("promoter"));
string logoid = Common.FilterString(Common.GetStringOfForm("hidLogoID"));
string idcard = Common.FilterString(Common.GetStringOfForm("idcard"));
string qqNum = Common.FilterString(Common.GetStringOfForm("qqnum"));
string realname = Common.FilterString(Common.GetStringOfForm("realname"));
if (string.IsNullOrEmpty(sex) || !CommonManager.String.IsInteger(sex))
{
sex = "1";
}
if (string.IsNullOrEmpty(logoid) || !CommonManager.String.IsInteger(logoid))
{
logoid = "1";
}
//������ע��ʱѡ��ְҵ�͵���
//string occu = CommonManager.Web.RequestForm( "txtOccuPation", "" );
//string prov = CommonManager.Web.RequestForm( "hidProvince", "" );
//string city = CommonManager.Web.RequestForm( "hidCity", "" );
//string address = Server.HtmlEncode( CommonManager.Web.RequestForm( "txtAddress", "" ) );
//�����������Ϊ�գ��Ͱ�����Ϊ��¼����
if (ejpwd.Trim().Length == 0)
{
ejpwd = pwd;
}
BLL.Member member = new BLL.Member();
int dbLogoId = member.SetLogoID(int.Parse(sex), int.Parse(logoid));
#region �����ж��Ƿ��������������ڼ�
/*
bool isaction = false;
if (RookiePresentConfig.Config.IsEnable)
{
if (RookiePresentConfig.Config.BeginDate <= DateTime.Now && RookiePresentConfig.Config.EndDate >= DateTime.Now)
{
isaction = true;
//walletMoney += RookiePresentConfig.Config.Money;
//���͵���
if (RookiePresentConfig.Config.PropPresent.Rows.Count > 0)
{
string select = "select Count(PropID) from TPropDefine where PropID=@PropID;";
string sql = "insert into TUserProp (UserID,PropID,HoldCount) values ({0},{1},{2});";
StringBuilder sqlCollection = new StringBuilder();
foreach (DataRow row in RookiePresentConfig.Config.PropPresent.Rows)
{
int tmpcount = DbSession.Default.FromSql(select).AddInputParameter("@PropID", DbType.Int32, row["PropID"]).ToScalar<int>();
if (tmpcount <= 0)
continue;
sqlCollection.AppendFormat(sql, userId, row["PropID"].ToString(), row["Amount"].ToString());
}
if (sqlCollection.ToString().Length > 0)
{
DbSession.Default.FromSql(sqlCollection.ToString()).Execute();
}
}
}
else
{
isaction = false;
RookiePresentConfig.Config.IsEnable = false;
RookiePresentConfig.Save(RookiePresentConfig.Config);
}
}*/
#endregion
//2012-12-16 ������������ȡ������ID�����������ڴ�������������
string agencyName = UiCommon.StringConfig.GetAgencyNameByTwoDname(); //��ȡ������ȡ�������˺�
int userId = Convert.ToInt32(member.Add_UserInfo(username, nickname, promoter, int.Parse(sex), dbLogoId, pwd, ejpwd, idcard, mobile, email, Common.RequestIP, qqNum, realname, agencyName)["UserID"]);
if (userId > 0)
{
//5.�����û���Ϣ
UiCommon.UserLoginInfo.SetInfo(userId.ToString(), username);
//�����û���½��Ϣ
new BLL.Member().UpdateLastLogin(username, Utility.Common.RequestIP);
//6.��¼��ǰ�ͻ������ϵ�ע��ʱ�䵽cookies
BCSTCache.Default.Save<CookiesCache>("RegDateTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
Response.Redirect("/Manage/Default.aspx");
}
//else if (userId == -3)
//{
// CommonManager.Web.RegJs(this, "alert('��Ǹ��ע��ʧ�ܣ���IP����ע������������');location.href=location.href;", true);
//}
//else if (userId == -4)
//{
// CommonManager.Web.RegJs(this, "alert('��Ǹ��ע��ʧ�ܣ������֤���Ѵﵽע��������ƣ�');location.href=location.href;", true);
//}
else
{
CommonManager.Web.RegJs(this, "alert('��Ǹ��ע��ʧ�ܣ������Ƿ�������æ�����Ժ����ԣ�');location.href=location.href;", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
AdminPopedom.IsHoldModel("04");
string isTrader = ConfigurationManager.AppSettings["IsOpenTrader"];
if (isTrader == "0")
{
trIsTrader.Visible = false;
}
if (UserID == 0)
{
CommonManager.Web.RegJs(this, "alert('参数错误。');", false);
return;
}
if (IsPostBack)
{
return;
}
string sql = @"select *,DATEADD([second],viptime,'1970-1-1 8:00:00') AS VipTimes,(select isnull(Convert(bigint,sum(ChangeTax)),0) as tax from TChangeRecordUser where UserID=@UserID) as AllTax from TUsers a inner join TUserInfo b on b.UserID=a.UserID inner join Web_Users c on c.UserID=a.UserID where a.UserID=@UserID";
DataTable dt = DbSession.Default.FromSql(sql).AddInputParameter("@UserID", DbType.Int32, UserID).ToDataTable();
if (dt.Rows.Count <= 0)
{
CommonManager.Web.RegJs(this, "alert('参数错误。');", false);
return;
}
DataRow row = dt.Rows[0];
#region 填充页面表单
if (row["LockMathine"].ToString() == "1")
{
lockLB.Visible = true;
LockLabel.Text = "已锁定";
}
else
{
LockLabel.Text = "未锁定";
}
txtBankMoney.Text = row["BankMoney"].ToString();
txtFascination.Text = row["Fascination"].ToString();
txtNickName.Text = row["NickName"].ToString();
//LiteralNickName.Text = row["NickName"].ToString();
txtPwd_anw.Text = row["Pwd_anw"].ToString();
ltPwd_ques.Text = row["Pwd_ques"].ToString();
//txtUserNames.Text = row["UserName"].ToString();
LiteralUserName.Text = row["UserName"].ToString();
if (UiCommon.StringConfig.BankVersion == "1")
{
txtWalletMoney.Text = row["WalletMoney"].ToString();
}
else
{
txtWalletMoney.Text = (new BLL.Member()).GetWalletMoney(UserID.ToString()).ToString();
txtWalletMoney.ReadOnly = true;
}
txtZJ_Number.Text = row["ZJ_Number"].ToString();
CommonManager.Web.SetListControlSelectedFromValue(ddlMaster, row["Master"].ToString());
CommonManager.Web.SetListControlSelectedFromValue(ddlMember, row["Member"].ToString());
CommonManager.Web.SetListControlSelectedFromValue(ddlUserType, row["UserType"].ToString());
CommonManager.Web.SetListControlSelectedFromValue(ddlZJ_Type, row["ZJ_type"].ToString());
CommonManager.Web.SetListControlSelectedFromValue(rdolDisabled, row["Disabled"].ToString());
CommonManager.Web.SetListControlSelectedFromValue(rdolSex, row["Sex"].ToString());
CommonManager.Web.SetListControlSelectedFromValue(rdoIsTrader, row["Trader"].ToString());
ltSignDesc.Text = row["SignDescr"].ToString();
ltAddress.Text = row["Address"].ToString();
ltTelNo.Text = row["TelNo"].ToString();
//ltAdrCity.Text = row["AdrCity"].ToString();
//ltAdrProvince.Text = row["AdrProvince"].ToString();
//ltAdrZone.Text = row["AdrZone"].ToString();
ltAllLoginTime.Text = row["AllLoginTime"].ToString();
ltCurrentVIPTime.Text = row["VipTimes"].ToString();
ltEmail.Text = row["Email"].ToString();
ltqqnum.Text = row["qqnum"].ToString();
//设置头像图片显示
int Sex = Convert.ToInt32(row["Sex"]);
int LogoID = (int)row["LogoID"];
LogoID = new BLL.Member().GetLogoID(Sex, LogoID);
string UserHeadImg = "";
if (LogoID >= BLL.Member.LogoId_Const1 && LogoID <= BLL.Member.LogoId_Const2)
{
if (row["Sex"].ToString() == "1")
{
UserHeadImg = "/Image/Users/b_" + LogoID + ".png";
}
else
{
UserHeadImg = "/Image/Users/g_" + LogoID + ".png";
}
}
else if (LogoID >= BLL.Member.LogoId_Const3 && LogoID <= BLL.Member.LogoId_Const4) //上传的自定义头像 256<=LogoID<=512
{
int childDirName = UserID / 1000;
UserHeadImg = "/Upload/" + UiCommon.StringConfig.UserCustHeadFolderName + "/" + childDirName + "/" + UserID + ".png";
}
else if (LogoID > BLL.Member.LogoId_Const4) //上传的自定义头像 LogoID>512 需审核或有过期时间的自定义头像
{
int childDirName = UserID / 1000;
UserHeadImg = "/Upload/" + UiCommon.StringConfig.UserCustHeadFolderName + "/" + childDirName + "/" + UserID + ".png";
}
ltHeadImg.Text = "<img src='" + UserHeadImg + "' onerror='this.src=\"/images/NoPicture/no_pic.gif\";this.onerror=\"\";' />";
ltLastLoginIP.Text = row["LastLoginIP"].ToString();
ltLastLoginTM.Text = ((DateTime)row["LastLoginTM"]).ToString("yyyy-MM-dd HH:mm:ss");
//ltOccuPation.Text = row["OccuPation"].ToString();
ltPhoneNum.Text = row["Phone"].ToString();
ltRegisterIP.Text = row["RegisterIP"].ToString();
ltRegisterTM.Text = ((DateTime)row["RegisterTM"]).ToString("yyyy-MM-dd HH:mm:ss");
ltUserName.Text = row["UserName"].ToString();
userName = row["UserName"].ToString();
//ltWebLoginTime.Text = row["WebLoginTime"].ToString();
ltSourcePwd.Text = row["Pass"].ToString();
ltSourceTwoPwd.Text = row["TwoPassword"].ToString();
ltAllTax.Text = row["AllTax"].ToString();
txtUserRealName.Text = row["RealName"].ToString();
txtLotteries.Text = row["Lotteries"].ToString();
if (row["Disabled"].ToString() == "1")
{
txtBankMoney.Enabled = false;
txtWalletMoney.Enabled = false;
rdolVip.Enabled = false;
txtCustomVIP.Enabled = false;
}
#endregion
}
public void BuyDaoJu()
{
string userId = UiCommon.UserLoginInfo.UserID;
string propId = Common.SqlEncode(Common.GetStringOfUrl("id"));
DataRow drDaoju = new BLL.DaoJu().GetInfo(propId);
if (drDaoju != null)
{
int count = Common.GetIntOfUrl("count");
int price = Convert.ToInt32(drDaoju["Price"]);// Common.GetIntOfUrl("price");
int vipPrice = Convert.ToInt32(drDaoju["VipPrice"]);
//1.读取当前登录用户的信息，UserID,BankMoney,VipTime
DataRow dr = new BLL.Member().GetInfoInTUserInfo(userId);
string vipTime = "1970-01-01 08:00:00";
Int64 bankMoney = 0;
if (dr != null)
{
//购买vip的公式：当前日期+购买天数*60*60*24
vipTime = dr["VipTime2"].ToString();
bankMoney = Convert.ToInt64(dr["BankMoney"]);
}
//2.判断是否有足够的金币购买该道具
int buyMoney = 0;
if (DateTime.Now < Convert.ToDateTime(vipTime))
{
buyMoney = vipPrice * count;
}
else
{
buyMoney = price * count;
}
if (buyMoney < 0)//数据溢出
{
Response.Write("buysb");
return;
}
if (bankMoney < buyMoney)
{
Response.Write("notmoney");
}
else
{
//3.金币足够，判断三种类型的道具：普通道具、1小时双倍积分卡、3小时双倍积分卡
int doublePointTime = 0;
if (propId.Trim() == "6")
{
//1小时双倍积分卡
doublePointTime = count * 60 * 60;
}
else if (propId.Trim() == "7")
{
//3小时双倍积分卡
doublePointTime = count * 60 * 60 * 3;
}
//4.提交数据
int iRows = new BLL.Member().BuyDaoJu(userId, propId, count, buyMoney, doublePointTime);
if (iRows > 0)
{
Response.Write("buycg");
}
else
{
Response.Write("buysb");
}
}
}
else
{
Response.Write("nodaoju");
}
}
protected void btnSubmit_ServerClick(object sender, EventArgs e)
{
string validcode = Common.GetStringOfForm("validcode");
if (ValidCode.CurrentCode != validcode)
{
Label1.Text = "温馨提示：验证码输入错误，请重新输入！";
Label1.Visible = true;
return;
}
string username = Common.FilterString(Common.GetStringOfForm("username"));
//昵称可以输入任何字符，所以要对它进行HTML编码，防止恶意木马脚本字符串；过滤"'"为"''"，避免SQL注入式攻击
string nickname = Server.HtmlEncode(Common.GetStringOfForm("nickname").Replace("'", "''"));
string sex = Common.FilterString(Common.GetStringOfForm("sex"));
string pwd = Common.FilterString(Common.GetStringOfForm("pwd")); //Common.FilterString( Common.GetStringOfForm( "hidPwd" ) );//
string ejpwd = ""; //Common.FilterString( Common.GetStringOfForm( "hidPwd2" ) );//
string email = "";
string mobile = Common.FilterString(Common.GetStringOfForm("mobile")); //电话保存到TUserInfo表的PhoneNum列
string promoter = Common.FilterString(Common.GetStringOfForm("promoter"));
string logoid = Common.FilterString(Common.GetStringOfForm("logoid"));
string idcard = Common.FilterString(Common.GetStringOfForm("idcard"));
string signDsc = Server.HtmlEncode(Common.GetStringOfForm("sign").Replace("'", "''"));
string qqnum = "";
string realname = "";
if (string.IsNullOrEmpty(sex) || !CommonManager.String.IsInteger(sex))
{
sex = "1";
}
if (string.IsNullOrEmpty(logoid) || !CommonManager.String.IsInteger(logoid))
{
logoid = "1";
}
//新增：注册时选择职业和地区
//string occu = CommonManager.Web.RequestForm( "txtOccuPation", "" );
//string prov = CommonManager.Web.RequestForm( "hidProvince", "" );
//string city = CommonManager.Web.RequestForm( "hidCity", "" );
//string address = Server.HtmlEncode( CommonManager.Web.RequestForm( "txtAddress", "" ) );
//如果银行密码为空，就把它设为登录密码
if (ejpwd.Trim().Length == 0)
{
ejpwd = pwd;
}
BLL.Member member = new BLL.Member();
int dbLogoId = member.SetLogoID(int.Parse(sex), int.Parse(logoid));
/*
* string userId = Utility.SqlHelper.GetMaxID("UserID", "TUsers").ToString();
*
* //1.插入TUsers表
*
* member.Add2TUsers( userId, username, nickname, pwd, ejpwd, int.Parse( sex ), dbLogoId );
*
* //2.插入TUserInfo表
* int walletMoney = BLL.Config.GoldCountOfReg();
* BLL.Promotion promo = new BLL.Promotion();
* bool isTg = false;
* if( promoter.Trim().Length > 0 )
* {
* if( member.ExistName( promoter ) && promo.ExistTGUser( promoter ) )
* {
* isTg = true;
* walletMoney += BLL.Config.GoldCountOfRegTG();
* }
* }*/
#region 增加判断是否在新手送礼包活动期间
/*
* bool isaction = false;
* if (RookiePresentConfig.Config.IsEnable)
* {
* if (RookiePresentConfig.Config.BeginDate <= DateTime.Now && RookiePresentConfig.Config.EndDate >= DateTime.Now)
* {
* isaction = true;
* //walletMoney += RookiePresentConfig.Config.Money;
* //赠送道具
* if (RookiePresentConfig.Config.PropPresent.Rows.Count > 0)
* {
* string select = "select Count(PropID) from TPropDefine where PropID=@PropID;";
* string sql = "insert into TUserProp (UserID,PropID,HoldCount) values ({0},{1},{2});";
* StringBuilder sqlCollection = new StringBuilder();
* foreach (DataRow row in RookiePresentConfig.Config.PropPresent.Rows)
* {
* int tmpcount = DbSession.Default.FromSql(select).AddInputParameter("@PropID", DbType.Int32, row["PropID"]).ToScalar<int>();
* if (tmpcount <= 0)
* continue;
* sqlCollection.AppendFormat(sql, userId, row["PropID"].ToString(), row["Amount"].ToString());
* }
* if (sqlCollection.ToString().Length > 0)
* {
* DbSession.Default.FromSql(sqlCollection.ToString()).Execute();
* }
* }
* }
* else
* {
* isaction = false;
* RookiePresentConfig.Config.IsEnable = false;
* RookiePresentConfig.Save(RookiePresentConfig.Config);
* }
* }*/
#endregion
/*member.Add2TUserInfo(userId, walletMoney, Common.RequestIP);
* //修改为如下方法：
* //member.Add2TUserInfo( userId, walletMoney, Common.RequestIP, occu, prov, city, address, mobile );
*
* //3.插入Web_Users表
* member.Add2Web_Users(userId, email, mobile, Common.RequestIP, idcard);
* //member.Add2Web_Users( userId, email, "", Common.RequestIP );
*
* //4.插入推广日志信息
* if( isTg )
* {
* promo.AddLog( promoter, userId );
* }
*/
string agencyName = UiCommon.StringConfig.GetAgencyNameByTwoDname(); //获取域名获取代理商账号
int userId = Convert.ToInt32(member.Add_UserInfo(username, nickname, promoter, int.Parse(sex), dbLogoId, pwd, ejpwd, idcard, mobile, email, Common.RequestIP, qqnum, realname, agencyName, signDsc)["UserID"]);
if (userId > 0)
{
//5.保存用户信息
UiCommon.UserLoginInfo.SetInfo(userId.ToString(), username);
//更新用户登陆信息
new BLL.Member().UpdateLastLogin(username, Utility.Common.RequestIP);
//6.记录当前客户机器上的注册时间到cookies
BCSTCache.Default.Save <CookiesCache>("RegDateTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
//Limit.outMsgBox("温馨提示：\\n\\n会员注册成功！", "bzwp://regsucceed?username="******"", true);
//Response.Write("<script language=javascript>window.alert('" + Message + "');" + str + "</script>");
string ieEvent = "bzwp://regsucceed?username="******"&userid=" + userId;
Response.Write("<script language=javascript>window.location.href='" + ieEvent + "';</script>");
}
else
{
Label1.Text = "抱歉，注册失败，可能是服务器繁忙，请稍后再试！";
return;
}
/*
* if (isaction)
* {
* Response.Write("<script language=javascript>alert('现在是活动期间，您获得系统赠送给您的道具！\\r\\n快到游戏的道具箱中去体验我们的道具吧！');window.location.href='" + ieEvent + "';</script>");
* }
* else
* {
* Response.Write("<script language=javascript>window.location.href='" + ieEvent + "';</script>");
* }
*/
}
protected void Page_Load(object sender, EventArgs e)
{
string UserId =Utility.Common.GetStringOfUrl( Request["P_UserId"]);
string OrderId = Utility.Common.GetStringOfUrl(Request["P_OrderId"]);
string CardId = Utility.Common.GetStringOfUrl(Request["P_CardId"]);
string CardPass = Utility.Common.GetStringOfUrl(Request["P_CardPass"]);
string FaceValue = Utility.Common.GetStringOfUrl(Request["P_FaceValue"]);
string ChannelId = Utility.Common.GetStringOfUrl(Request["P_ChannelId"]);
string subject = Utility.Common.GetStringOfUrl(Request["P_Subject"]);
string description = Utility.Common.GetStringOfUrl(Request["P_Description"]);
string price = Utility.Common.GetStringOfUrl(Request["P_Price"]);
string quantity = Utility.Common.GetStringOfUrl(Request["P_Quantity"]);
string notic = Utility.Common.GetStringOfUrl(Request["P_Notic"]);
string ErrCode = Utility.Common.GetStringOfUrl(Request["P_ErrCode"]);
string PostKey = Utility.Common.GetStringOfUrl(Request["P_PostKey"]);
string payMoney = Utility.Common.GetStringOfUrl(Request["P_PayMoney"]);
string SalfStr =UiCommon.StringConfig.KFPayKey;
string preEncodeStr = UserId + "|" + OrderId + "|" + CardId + "|" + CardPass + "|" + FaceValue + "|" + ChannelId + "|" + SalfStr;
string encodeStr = Utility.Common.md5(preEncodeStr);
// Response.Write(preEncodeStr + "<br>" + encodeStr+"<br>");//调试语句
Response.Write("errCode=0");
//string FilePath = Server.MapPath("/test/weather.txt");
//if (!File.Exists(FilePath))
//{
// FileStream fs = File.Create(FilePath);
// fs.Close();
//}
////写入文本
//StreamWriter sr = new StreamWriter(Server.MapPath("/test/weather.txt"), false, System.Text.Encoding.Default);
//try
//{
// string str = "P_UserId:" + UserId + "P_OrderId:" + OrderId + "P_CardId:"
// + CardId + "P_CardPass:"******"P_FaceValue:" + FaceValue
// + "P_ChannelId:" + ChannelId + "P_Subject:" + subject
// + "P_Description:" + description + "P_Price:" + price
// + "P_ErrCode:" + ErrCode + "P_PostKey:" + PostKey
// + "P_PayMoney:" + payMoney;
// sr.Write(str+"<br/>"+preEncodeStr + "<br/>" + encodeStr + "<br/>");
// sr.Close();
//}
//catch
//{
//}
if (PostKey.ToUpper().CompareTo(encodeStr.ToUpper()) == 0)//表示数据合法
{
if (int.Parse(ErrCode) == 0)//说明是充值成功了的
{
//这里进行订单更新
Member mem = new Member();
if (!mem.IsPaySuccess(OrderId))
{
mem.Update3PayOrder((int)(float.Parse(FaceValue)), OrderId);
}
}
else
{
// Response.Write("-Err");
}
}
else
{
// Response.Write("-数据不合法");
}
}
private void LoadRooms()
{
Member member = new Member();
member.GetMemberByUserId(new Guid(Membership.GetUser().ProviderUserKey.ToString()));
Room myrooms = new Room();
myrooms.GetRoomsByCreatorID(member.MemberID);
uiRepeaterMyRooms.DataSource = myrooms.DefaultView;
uiRepeaterMyRooms.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
String key = UiCommon.StringConfig.JFTpay_MemberKey; //配置文件密钥
//返回参数
String orderid = Request.QueryString["orderid"];//返回订单号
String opstate = Request.QueryString["opstate"];//返回处理结果
String ovalue = Request.QueryString["ovalue"];//返回充值金额
String sign = Request.QueryString["sign"];//返回加密标记
String Reply = Request.QueryString["Reply"];//同步发送：1代表同步发送，2代表异步发送
String kaorderID = Request.QueryString["ekaorderid"];
String time = Request.QueryString["ekatime"];//亿卡处理时间。
//组织参数
String param = String.Format("orderid={0}&opstate={1}&ovalue={2}{3}", orderid, opstate, ovalue, key);
//比对参数是否有效
if (sign.Equals(FormsAuthentication.HashPasswordForStoringInConfigFile(param, "MD5").ToLower()))
{
//执行操作方法
if (opstate.Equals("0"))
{
#region [add] jeffery
//if (Session["CouponInfo"] != null)
//{
// string strCouponInfo = Session["CouponInfo"].ToString();
// Session["CouponInfo"] = ""; // 用完后销毁
// if (strCouponInfo != "")
// {
// int pos = strCouponInfo.IndexOf("!@#");
// string username = strCouponInfo.Substring(0, pos);
// int couponNum = Convert.ToInt32(
// strCouponInfo.Substring(pos + 1)
// );
// string strsql =
// "select UserID from TUsers where UserName=@username";
// DataTable dt =
// SqlHelper.ExecuteDataset(CommandType.Text,
// strsql,
// new SqlParameter[]
// {
// new SqlParameter("@username",username)
// }
// ).Tables[0];
// if (dt.Rows.Count > 0)
// {
// int userid = Convert.ToInt32(dt.Rows[0]["UserID"]);
// strsql = "insert into TCoupon(UserID,CouponNum,RechargeType,CreateTime)values(@userid,@coupon,@rechargeType,@createTime)";
// int num =
// SqlHelper.ExecuteNonQuery(CommandType.Text,strsql,
// new SqlParameter[]
// {
// new SqlParameter("@userid",userid),
// new SqlParameter("@coupon",couponNum),
// new SqlParameter("@rechargeType",6),
// new SqlParameter("@createTime",DateTime.Now)
// });
// if (num != 1)
// {
// Response.Write("<script>alert('充值成功，但赠送奖劵失败！')</script>");
// }
// }
// }
//}
#endregion
Member mem = new Member();
if (Reply == "1")
{
Response.Write("opstate=0");
//操作流程成功的情况
//注：不能打印其他的字符，否则不会同步
if (!mem.IsPaySuccess(orderid)) //防止重复刷新页面而带来的问题
{
//更新订单信息为完成状态
if (orderid.ToLower().Contains("ka"))
mem.Update3PayOrder2((int)(float.Parse(ovalue)), orderid);
else
mem.Update3PayOrder((int)(float.Parse(ovalue)), orderid);
}
}
else if (Reply == "2")
{
//防止重复刷新页面而带来的问题
if (!mem.IsPaySuccess(orderid))
{
if (orderid.ToLower().Contains("ka"))
mem.Update3PayOrder2((int)(float.Parse(ovalue)), orderid);
else
mem.Update3PayOrder((int)(float.Parse(ovalue)), orderid);
}
//返回到成功页面
Response.Redirect("NotityReceive.aspx?orderid=" + orderid + "&opstate=" + opstate);
}
}
if (opstate.Equals("-1"))
{
//请求参数无效
Response.Write("请求参数无效");
}
if (opstate.Equals("-2"))
{
//交易签名无效
Response.Write("签名错误");
}
}
}
public int Update(Member member)
{
return(memberDal.Update(member));
}
protected void Page_Load(object sender, EventArgs e)
{
string billno = Utility.Common.GetStringOfUrl("billno"); //订单编号
string amount = Utility.Common.GetStringOfUrl("amount"); //订单金额
string date = Utility.Common.GetStringOfUrl("date"); //订单日期
string succ = Utility.Common.GetStringOfUrl("succ"); //成功标志
string ipsbillno = Utility.Common.GetStringOfUrl("ipsbillno"); //IPS订单编号
string currency_Type = Utility.Common.GetStringOfUrl("Currency_type"); //币种
string signature = Utility.Common.GetStringOfUrl("signature").ToLower(); //MD5签名
string retencodetype = Utility.Common.GetStringOfUrl("retencodetype");//交易返回签名方式
// [add] jeffery
//string strAttach = Utility.Common.GetStringOfUrl("attach");
// ---end
if (string.IsNullOrEmpty(billno) || string.IsNullOrEmpty(amount) || string.IsNullOrEmpty(date) ||
string.IsNullOrEmpty(succ) || string.IsNullOrEmpty(ipsbillno) || string.IsNullOrEmpty(currency_Type) || string.IsNullOrEmpty(signature))
{
Server.Transfer("Default.aspx");
}
PayOrderID = billno;
PayMoney = amount;
if (succ.Equals("Y"))
{
//交易成功
PayResult = "恭喜您，充值成功！";
if (currency_Type == null || currency_Type == "")
{
currency_Type = "RMB";
}
string signatureVal = Utility.Common.md5("billno" + billno + "currencytype" + currency_Type + "amount" + amount + "date" + date + "succ" + succ + "ipsbillno" + ipsbillno + "retencodetype" + retencodetype + UiCommon.StringConfig.IPS_Letter).ToLower();
if (signature.Equals(signatureVal.ToLower()))
{
Member mem = new Member();
if (!mem.IsPaySuccess(billno))
{
mem.Update3PayOrder((int)(float.Parse(PayMoney)), PayOrderID);
}
#region [add] jeffery
//int pos = strAttach.IndexOf("!@#");
//string username = strAttach.Substring(0, pos);
//int couponNum =
// Convert.ToInt32(
// strAttach.Substring(pos + 1)
// );
//string strsql =
// "select UserID from TUsers where UserName=@username";
//DataTable dt =
// SqlHelper.ExecuteDataset(CommandType.Text,
// strsql,
// new SqlParameter[]
// {
// new SqlParameter("@username",username)
// }
// ).Tables[0];
//int userid = Convert.ToInt32(dt.Rows[0]["UserID"]);
//strsql = "insert into TCoupon(UserID,CouponNum,RechargeType,CreateTime)values(@userid,@coupon,@rechargeType,@createTime)";
//int num =
// SqlHelper.ExecuteNonQuery
// (CommandType.Text,
// strsql,
// new SqlParameter[]
// {
// new SqlParameter("@userid",userid),
// new SqlParameter("@coupon",couponNum),
// new SqlParameter("@rechargeType",2),
// new SqlParameter("@createTime",DateTime.Now)
// });
//if (num != 1)
//{
// Response.Write("<script>alert('充值成功，但赠送奖劵失败！')</script>");
//}
#endregion
}
else
{
PayResult = "充值失败，请不要恶意删改数据";
}
}
else
{
//交易失败
PayResult = "充值失败，请稍后再试！";
}
}
protected void uiLinkButtonConfirm_Click(object sender, EventArgs e)
{
MembershipUser user = Membership.GetUser();
if (user.PasswordQuestion == uiDropDownListQuestion.SelectedValue && BLL.Member.CurrentMember.Answer == uiTextBoxAnswer.Text.Trim())
{
if (!String.IsNullOrEmpty(hdnMember.Value))
{
Member upgrademember = new Member();
upgrademember.LoadByPrimaryKey(Convert.ToInt32(hdnMember.Value));
try
{
int durationID = Convert.ToInt32(hdnDuration.Value);
int specID = Convert.ToInt32(hdnSpec.Value);
BLL.MemberTypeSpecDuration bllMemberTypeSpecDuration = new MemberTypeSpecDuration();
bllMemberTypeSpecDuration.Where.TypeDurationID.Value = durationID;
bllMemberTypeSpecDuration.Where.MemberTypeSpecID.Value = specID;
bllMemberTypeSpecDuration.Query.Load();
int points = bllMemberTypeSpecDuration.Points;
if (BLL.Member.CurrentMember.Credit_Point < points)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Error3", @"$(document).ready(function () { notify('error', 'حدث خطأ . رصيدك الحالى لا يسمح لإتمام العملية.'); });", true);
return;
}
BLL.Member.CurrentMember.Credit_Point -= points;
BLL.Member.CurrentMember.Save();
//delete old records
BLL.MemberType bllMemberType = new MemberType();
bllMemberType.DeleteMemberTypes(upgrademember.MemberID);
upgrademember.MemberType.MemberTypeSpecDurationID = bllMemberTypeSpecDuration.ID;
upgrademember.MemberType.CreateBy = BLL.Member.CurrentMember.MemberID;
upgrademember.MemberType.StartDate = DateTime.Now;
upgrademember.MemberType.EndDate = DateTime.Now.AddMonths(bllMemberTypeSpecDuration.TypeDuration.MonthesNumber);
upgrademember.MemberType.Save();
Page.ClientScript.RegisterStartupScript(this.GetType(), "Success1", @"$(document).ready(function () { notify('success', 'تم ترقية الإسم بنجاح.'); });", true);
BLL.MemberLog log = new BLL.MemberLog();
log.AddNew(BLL.Member.CurrentMemberID, new BLL.Log.ChangeMemberType() { MemberName = upgrademember.Name, NewTypeName = upgrademember.MemberType.MemberTypeSpecDuration.MemberTypeSpec.Name, NewTypeExpiryDate = upgrademember.MemberType.EndDate, Points = points }, upgrademember.MemberID, null);
lblPoints.Text = BLL.Member.CurrentMember.Credit_Point.ToString();
NotifyMember(upgrademember.MemberID, bllMemberTypeSpecDuration.MemberTypeSpecID);
LoadBalance();
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Error11", @"$(document).ready(function () { notify('error', 'حدث خطأ . من فضلك أعد المحاولة.'); });", true);
}
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Error4", @"$(document).ready(function () { notify('error', 'حدث خطأ . من فضلك أعد المحاولة.'); });", true);
}
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Error5", @"$(document).ready(function () { notify('error', 'حدث خطأ . من فضلك تأكد من السؤال والإجابة السرى.'); });", true);
return;
}
}
protected void btnSubmit_ServerClick(object sender, EventArgs e)
{
string validcode = Common.GetStringOfForm("validcode");
if (ValidCode.CurrentCode != validcode)
{
Label1.Text = "��ܰ��ʾ����֤������������������룡";
Label1.Visible = true;
return;
}
string username = Common.FilterString(Common.GetStringOfForm("username"));
//�dzƿ��������κ��ַ�������Ҫ��������HTML���룬��ֹ����ľ��ű��ַ���������"'"Ϊ"''"������SQLע��ʽ����
string nickname = Server.HtmlEncode(Common.GetStringOfForm("nickname").Replace("'", "''"));
string sex = Common.FilterString(Common.GetStringOfForm("sex"));
string pwd = Common.FilterString(Common.GetStringOfForm("pwd"));//Common.FilterString( Common.GetStringOfForm( "hidPwd" ) );//
string ejpwd ="";//Common.FilterString( Common.GetStringOfForm( "hidPwd2" ) );//
string email ="";
string mobile = Common.FilterString(Common.GetStringOfForm("mobile"));//�绰���浽TUserInfo���PhoneNum��
string promoter = Common.FilterString(Common.GetStringOfForm("promoter"));
string logoid = Common.FilterString(Common.GetStringOfForm("logoid"));
string idcard = Common.FilterString(Common.GetStringOfForm("idcard"));
string signDsc = Server.HtmlEncode(Common.GetStringOfForm("sign").Replace("'", "''"));
string qqnum = "";
string realname ="";
if (string.IsNullOrEmpty(sex) || !CommonManager.String.IsInteger(sex))
sex = "1";
if (string.IsNullOrEmpty(logoid) || !CommonManager.String.IsInteger(logoid))
logoid = "1";
//������ע��ʱѡ��ְҵ�͵���
//string occu = CommonManager.Web.RequestForm( "txtOccuPation", "" );
//string prov = CommonManager.Web.RequestForm( "hidProvince", "" );
//string city = CommonManager.Web.RequestForm( "hidCity", "" );
//string address = Server.HtmlEncode( CommonManager.Web.RequestForm( "txtAddress", "" ) );
//�����������Ϊ�գ��Ͱ�����Ϊ��¼����
if (ejpwd.Trim().Length == 0)
{
ejpwd = pwd;
}
BLL.Member member = new BLL.Member();
int dbLogoId = member.SetLogoID(int.Parse(sex), int.Parse(logoid));
/*
string userId = Utility.SqlHelper.GetMaxID("UserID", "TUsers").ToString();
//1.����TUsers��
member.Add2TUsers( userId, username, nickname, pwd, ejpwd, int.Parse( sex ), dbLogoId );
//2.����TUserInfo��
int walletMoney = BLL.Config.GoldCountOfReg();
BLL.Promotion promo = new BLL.Promotion();
bool isTg = false;
if( promoter.Trim().Length > 0 )
{
if( member.ExistName( promoter ) && promo.ExistTGUser( promoter ) )
{
isTg = true;
walletMoney += BLL.Config.GoldCountOfRegTG();
}
}*/
#region �����ж��Ƿ��������������ڼ�
/*
bool isaction = false;
if (RookiePresentConfig.Config.IsEnable)
{
if (RookiePresentConfig.Config.BeginDate <= DateTime.Now && RookiePresentConfig.Config.EndDate >= DateTime.Now)
{
isaction = true;
//walletMoney += RookiePresentConfig.Config.Money;
//���͵���
if (RookiePresentConfig.Config.PropPresent.Rows.Count > 0)
{
string select = "select Count(PropID) from TPropDefine where PropID=@PropID;";
string sql = "insert into TUserProp (UserID,PropID,HoldCount) values ({0},{1},{2});";
StringBuilder sqlCollection = new StringBuilder();
foreach (DataRow row in RookiePresentConfig.Config.PropPresent.Rows)
{
int tmpcount = DbSession.Default.FromSql(select).AddInputParameter("@PropID", DbType.Int32, row["PropID"]).ToScalar<int>();
if (tmpcount <= 0)
continue;
sqlCollection.AppendFormat(sql, userId, row["PropID"].ToString(), row["Amount"].ToString());
}
if (sqlCollection.ToString().Length > 0)
{
DbSession.Default.FromSql(sqlCollection.ToString()).Execute();
}
}
}
else
{
isaction = false;
RookiePresentConfig.Config.IsEnable = false;
RookiePresentConfig.Save(RookiePresentConfig.Config);
}
}*/
#endregion
/*member.Add2TUserInfo(userId, walletMoney, Common.RequestIP);
//��Ϊ���·�����
//member.Add2TUserInfo( userId, walletMoney, Common.RequestIP, occu, prov, city, address, mobile );
//3.����Web_Users��
member.Add2Web_Users(userId, email, mobile, Common.RequestIP, idcard);
//member.Add2Web_Users( userId, email, "", Common.RequestIP );
//4.�����ƹ���־��Ϣ
if( isTg )
{
promo.AddLog( promoter, userId );
}
*/
string agencyName = UiCommon.StringConfig.GetAgencyNameByTwoDname(); //��ȡ������ȡ�������˺�
int userId =Convert.ToInt32(member.Add_UserInfo(username, nickname, promoter, int.Parse(sex), dbLogoId, pwd, ejpwd, idcard, mobile, email, Common.RequestIP, qqnum, realname,agencyName,signDsc)["UserID"]);
if (userId > 0)
{
//5.�����û���Ϣ
UiCommon.UserLoginInfo.SetInfo(userId.ToString(), username);
//�����û���½��Ϣ
new BLL.Member().UpdateLastLogin(username, Utility.Common.RequestIP);
//6.��¼��ǰ�ͻ������ϵ�ע��ʱ�䵽cookies
BCSTCache.Default.Save<CookiesCache>("RegDateTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
//Limit.outMsgBox("��ܰ��ʾ��\\n\\n��Աע��ɹ���", "bzwp://regsucceed?username="******"", true);
//Response.Write("<script language=javascript>window.alert('" + Message + "');" + str + "</script>");
string ieEvent = "bzwp://regsucceed?username="******"&userid=" + userId;
Response.Write("<script language=javascript>window.location.href='" + ieEvent + "';</script>");
}
else
{
Label1.Text = "��Ǹ��ע��ʧ�ܣ������Ƿ�������æ�����Ժ����ԣ�";
return;
}
/*
if (isaction)
{
Response.Write("<script language=javascript>alert('�����ǻ�ڼ䣬�����ϵͳ�������ĵ��ߣ�\\r\\n�쵽��Ϸ�ĵ�������ȥ�������ǵĵ��߰ɣ�');window.location.href='" + ieEvent + "';</script>");
}
else
{
Response.Write("<script language=javascript>window.location.href='" + ieEvent + "';</script>");
}
*/
}
protected void Edit_Users(object sender, EventArgs e)
{
if (!CommonManager.Web.CheckPostSource())
{
return;
}
if (UserID == 0)
{
return;
}
DataRow row = new BLL.Member().GetInfo(UserID.ToString());
if (row == null)
{
return;
}
using (DbTrans trans = DbSession.Default.BeginTrans())
{
try
{
#region 对TUsers表的修改
if (txtNickName.Text.Trim() == "")
{
CommonManager.Web.RegJs(this, "alert('昵称不能为空！');location.href=location.href;", false);
return;
}
string nickName = txtNickName.Text.Trim();
StringBuilder sql = new StringBuilder("update TUsers set ");
sql.Append(" Sex=@Sex,");
sql.Append(" Disabled=@Disabled,");
sql.Append(" NickName=@NickName ");
if (!string.IsNullOrEmpty(txtPassWord.Text.Trim()))
{
sql.Append(" ,Pass=@Password");
}
if (!string.IsNullOrEmpty(txtTwoPassWord.Text.Trim()))
{
sql.Append(" ,TwoPassword=@TwoPassword");
}
sql.Append(" where UserID=@UserID;");
SqlSection sect = trans.FromSql(sql.ToString())
.AddInputParameter("@Sex", DbType.Int16, rdolSex.SelectedItem.Value)
.AddInputParameter("@Disabled", DbType.Int32, rdolDisabled.SelectedItem.Value)
.AddInputParameter("@UserID", DbType.Int32, UserID)
.AddInputParameter("@NickName", DbType.Int32, nickName);
if (!string.IsNullOrEmpty(txtPassWord.Text.Trim()))
{
sect.AddInputParameter("@Password", DbType.String, Utility.Common.md5(txtPassWord.Text.Trim()) /*CommonManager.String.EncryptMD5SystemDefaultMethod(txtPassWord.Text.Trim(),false,true)*/);
}
if (!string.IsNullOrEmpty(txtTwoPassWord.Text.Trim()))
{
sect.AddInputParameter("@TwoPassword", DbType.String, Utility.Common.md5(txtTwoPassWord.Text.Trim()) /*CommonManager.String.EncryptMD5SystemDefaultMethod( txtTwoPassWord.Text.Trim(), false, true )*/);
}
sect.Execute();
#endregion
#region 判断是否需要修改TMatchTable
if (row["Master"].ToString() != ddlMaster.SelectedItem.Value)
{
sql = new StringBuilder();
if (ddlMaster.SelectedItem.Value == "3")
{
sql.Append("update TMatchTable set MasterPower=268435455 where UserID=@UserID;");
}
else if (ddlMaster.SelectedItem.Value == "0")
{
sql.Append("update TMatchTable set MasterPower=0 where UserID=@UserID;");
}
trans.FromSql(sql.ToString()).AddInputParameter("@UserID", DbType.Int32, UserID).Execute();
}
#endregion
#region 计算VIP时间
int addvip = (int)row["VipTime"]; //得到原来的时间，秒数
if (rdolVip.SelectedIndex != -1 || (!string.IsNullOrEmpty(txtCustomVIP.Text.Trim())))
{
int tmp = 0;
if (rdolVip.SelectedIndex != -1) //预设值优先
{
tmp = int.Parse(rdolVip.SelectedItem.Value);
}
else
{
if (!CommonManager.String.IsInteger(txtCustomVIP.Text.Trim()))
{
CommonManager.Web.RegJs(this, "alert('自定义天数必须为数字！');location.href=location.href;", false);
return;
}
tmp = (int.Parse(txtCustomVIP.Text.Trim()) * 24 * 3600);
}
//如果不是取消vip，则补齐时间差
if (tmp > 0)
{
DateTime curVIP = (DateTime)row["VipTime2"]; //得到原来时间的DateTime格式
if (curVIP == new DateTime(1970, 1, 1, 8, 0, 0))
{
//从未设置过vip时间，则用当前时间与初始时间的时间差加上要增加的时间。
addvip = (int)(DateTime.Now - new DateTime(1970, 1, 1, 8, 0, 0)).TotalSeconds + tmp;
}
else if (curVIP < DateTime.Now)
{
//有过vip，但已到期，则补齐时间差
addvip += (int)(DateTime.Now - curVIP).TotalSeconds + tmp;
}
else
{
//有vip，且未到期，则在原来基础上增加
addvip += tmp;
}
}
else
{
//取消vip
addvip = 0;
}
}
#endregion
Int64 mon;
Int64 bmon;
#region 判断是否需要插入金币修改表
if (!Int64.TryParse(txtWalletMoney.Text.Trim(), out mon))
{
CommonManager.Web.RegJs(this, "alert('钱包金币数必须为数字,或超出整数范围');location.href=location.href;", false);
return;
}
if (!Int64.TryParse(txtBankMoney.Text.Trim(), out bmon))
{
CommonManager.Web.RegJs(this, "alert('银行金币数必须为数字，或超出整数范围');location.href=location.href;", false);
return;
}
if (!CommonManager.String.IsInteger(txtFascination.Text.Trim()))
{
CommonManager.Web.RegJs(this, "alert('魅力数必须为数字！');location.href=location.href;", false);
return;
}
string newWM = string.IsNullOrEmpty(txtWalletMoney.Text.Trim()) ? "0" : txtWalletMoney.Text.Trim();
string newBM = string.IsNullOrEmpty(txtBankMoney.Text.Trim()) ? "0" : txtBankMoney.Text.Trim();
#region Old code
/*
* if( row["WalletMoney"].ToString() != newWM )
* {
* sql = new StringBuilder();
* sql.Append( "insert into Web_MoneyChangeLog (userid,username,frontmoney,aftermoney,changetype,addtime,adduser)" );
* sql.Append( " values (@UserID,@UserName,@OldWalletMoney,@WalletMoney,0,getdate(),@AdminName);" );
*
* trans.FromSql( sql.ToString() )
* .AddInputParameter( "@UserID", DbType.Int32, UserID )
* .AddInputParameter( "@UserName", DbType.String, row["UserName"].ToString() )
* .AddInputParameter("@OldWalletMoney", DbType.Int32, row["WalletMoney"])
* .AddInputParameter("@WalletMoney", DbType.Int32, newWM)
* .AddInputParameter( "@AdminName", DbType.Int16, AdminInfo["UserName"].ToString() )
* .Execute();
* //int dvalue = int.Parse( newWM ) - (int)row["WalletMoney"];
* //if( dvalue > 0 )
* //{
* // MoneyOperator.Default.Add_Web_Record_MoneyIncrease( dvalue, Session["AdminName"].ToString() + "管理员手动给玩家" + row["UserName"].ToString() + "添加钱包金币" );
* //}
* //else
* //{
* // MoneyOperator.Default.Add_Web_Record_MoneyDecrease( Math.Abs( dvalue ), Session["AdminName"].ToString() + "管理员手动减去玩家" + row["UserName"].ToString() + "钱包金币" );
* //}
* }
* if( row["BankMoney"].ToString() != newBM )
* {
* sql = new StringBuilder();
* sql.Append( "insert into Web_MoneyChangeLog (userid,username,frontmoney,aftermoney,changetype,addtime,adduser)" );
* sql.Append( " values (@UserID,@UserName,@OldBankMoney,@BankMoney,0,getdate(),@AdminName);" );
*
* trans.FromSql( sql.ToString() )
* .AddInputParameter( "@UserID", DbType.Int32, UserID )
* .AddInputParameter( "@UserName", DbType.String, row["UserName"].ToString() )
* .AddInputParameter("@OldBankMoney", DbType.Int32, row["WalletMoney"])
* .AddInputParameter("@BankMoney", DbType.Int32, newBM)
* .AddInputParameter( "@AdminName", DbType.Int16, AdminInfo["UserName"].ToString() )
* .Execute();
*
* //int dvalue = int.Parse( newBM ) - (int)row["BankMoney"];
* //if( dvalue > 0 )
* //{
* // MoneyOperator.Default.Add_Web_Record_MoneyIncrease( dvalue, Session["AdminName"].ToString() + "管理员手动给玩家" + row["UserName"].ToString() + "添加银行金币" );
* //}
* //else
* //{
* // MoneyOperator.Default.Add_Web_Record_MoneyDecrease( Math.Abs( dvalue ), Session["AdminName"].ToString() + "管理员手动减去玩家" + row["UserName"].ToString() + "银行金币" );
* //}
*
* }
*/
#endregion
if (row["WalletMoney"].ToString() != newWM || row["BankMoney"].ToString() != newBM) //如果修改金币，则插入金币变化日志
{
Int64 startMoney = Convert.ToInt64(row["WalletMoney"]) + Convert.ToInt64(row["BankMoney"]);
Int64 changeMoney = (Convert.ToInt64(newWM) + Convert.ToInt64(newBM)) - startMoney;
string remark = ChineseMessage.adminManageNameMessage + AdminUserName + " " + ChineseMessage.adminManageIdMessage + AdminUserID;
BLL.Member.WriteMoneyExChangeLog(UserID.ToString(), startMoney, changeMoney, (int)Library.MoneyChangeType.管理员修改金币, remark);
}
#endregion
#region 对TUserInfo表的修改
sql = new StringBuilder();
sql.Append("update TUserInfo set ");
sql.Append(" Member=@Member,");
sql.Append(" Master=@Master,");
sql.Append(" WalletMoney=@WalletMoney,");
sql.Append(" BankMoney=@BankMoney,");
sql.Append(" Fascination=@Fascination,");
sql.Append(" Viptime=@Viptime,");
sql.Append(" UserType=@UserType,");
sql.Append(" Trader=@Trader");
sql.Append(" where UserID=@UserID;");
trans.FromSql(sql.ToString())
.AddInputParameter("@Member", DbType.Int32, ddlMember.SelectedItem.Value)
.AddInputParameter("@Master", DbType.Int32, ddlMaster.SelectedItem.Value)
.AddInputParameter("@WalletMoney", DbType.Int32, newWM)
.AddInputParameter("@BankMoney", DbType.Int32, newBM)
.AddInputParameter("@Fascination", DbType.Int32, string.IsNullOrEmpty(txtFascination.Text.Trim()) ? "0" : txtFascination.Text.Trim())
.AddInputParameter("@UserType", DbType.Int32, ddlUserType.SelectedItem.Value)
.AddInputParameter("@Viptime", DbType.Int32, addvip)
.AddInputParameter("@Trader", DbType.Int32, rdoIsTrader.SelectedValue)
.AddInputParameter("@UserID", DbType.Int32, UserID)
.Execute();
#endregion
#region 对Web_Users表的修改
if (!CommonManager.String.IsInteger(txtLotteries.Text.Trim()))
{
CommonManager.Web.RegJs(this, "alert('" + UiCommon.StringConfig.GoldName + "数必须为数字！');location.href=location.href;", false);
return;
}
sql = new StringBuilder();
sql.Append("update Web_Users set ");
sql.Append(" Pwd_anw=@Pwd_anw,");
//sql.Append( " Pwd_ques=@Pwd_ques," );
sql.Append(" ZJ_type=@ZJ_type,");
sql.Append(" ZJ_Number=@ZJ_Number,");
sql.Append("RealName=@RealName,");
sql.Append(" Lotteries=@Lotteries ");
sql.Append(" where UserID=@UserID;");
trans.FromSql(sql.ToString())
.AddInputParameter("@Pwd_anw", DbType.String, txtPwd_anw.Text.Trim())
.AddInputParameter("@ZJ_Number", DbType.String, txtZJ_Number.Text.Trim())
.AddInputParameter("@ZJ_type", DbType.Int16, ddlZJ_Type.SelectedItem.Value)
.AddInputParameter("@RealName", DbType.String, txtUserRealName.Text.Trim())
.AddInputParameter("@Lotteries", DbType.Int32, txtLotteries.Text.Trim())
.AddInputParameter("@UserID", DbType.Int32, UserID)
.Execute();
#endregion
trans.Commit();
CommonManager.Web.RegJs(this, "alert('修改成功！');location.href=location.href;", false);
}
catch (Exception ex)
{
trans.Rollback();
CommonManager.Web.RegJs(this, "alert('发生错误，错误信息：" + ex.Message + "。\\r\\n未对数据库进行任何操作。');location.href=location.href;", false);
}
}
}