public bool Upgrade(int id) { if (!this.Exists(id)) { return(false); } Rain.Model.users model = this.GetModel(id); Rain.Model.user_groups upgrade = new user_groups().GetUpgrade(model.group_id, model.exp); if (upgrade == null) { return(false); } if (this.UpdateField(id, "group_id=" + (object)upgrade.id) > 0) { if (upgrade.point > 0) { new user_point_log().Add(model.id, model.user_name, upgrade.point, "升级获得积分", true); } if (upgrade.amount > new Decimal(0)) { new user_amount_log().Add(model.id, model.user_name, upgrade.amount, "升级赠送金额"); } } return(true); }
private void UserPage_Init(object sender, EventArgs e) { if (!this.IsUserLogin()) { HttpContext.Current.Response.Redirect(this.linkurl("login")); } else { this.userModel = this.GetUserInfo(); this.groupModel = new Rain.BLL.user_groups().GetModel(this.userModel.group_id); if (this.groupModel == null) { this.groupModel = new Rain.Model.user_groups(); } this.InitPage(); } }
private bool DoAdd() { bool flag = false; Rain.Model.users model = new Rain.Model.users(); Rain.BLL.users users = new Rain.BLL.users(); model.group_id = int.Parse(this.ddlGroupId.SelectedValue); model.status = int.Parse(this.rblStatus.SelectedValue); if (users.Exists(this.txtUserName.Text.Trim())) { return(false); } model.user_name = Utils.DropHTML(this.txtUserName.Text.Trim()); model.salt = Utils.GetCheckCode(6); model.password = DESEncrypt.Encrypt(this.txtPassword.Text.Trim(), model.salt); model.email = Utils.DropHTML(this.txtEmail.Text); model.nick_name = Utils.DropHTML(this.txtNickName.Text); model.avatar = Utils.DropHTML(this.txtAvatar.Text); model.sex = this.rblSex.SelectedValue; DateTime result; if (DateTime.TryParse(this.txtBirthday.Text.Trim(), out result)) { model.birthday = new DateTime?(result); } model.telphone = Utils.DropHTML(this.txtTelphone.Text.Trim()); model.mobile = Utils.DropHTML(this.txtMobile.Text.Trim()); model.qq = Utils.DropHTML(this.txtQQ.Text); model.msn = Utils.DropHTML(this.txtMsn.Text); model.address = Utils.DropHTML(this.txtAddress.Text.Trim()); model.amount = Decimal.Parse(this.txtAmount.Text.Trim()); model.point = int.Parse(this.txtPoint.Text.Trim()); model.exp = int.Parse(this.txtExp.Text.Trim()); model.reg_time = DateTime.Now; model.reg_ip = DTRequest.GetIP(); if (users.Add(model) > 0) { this.AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加用户:" + model.user_name); flag = true; } return(flag); }
private bool DoEdit(int _id) { bool flag = false; Rain.BLL.users users = new Rain.BLL.users(); Rain.Model.users model = users.GetModel(_id); model.group_id = int.Parse(this.ddlGroupId.SelectedValue); model.status = int.Parse(this.rblStatus.SelectedValue); if (this.txtPassword.Text.Trim() != this.defaultpassword) { model.password = DESEncrypt.Encrypt(this.txtPassword.Text.Trim(), model.salt); } model.email = Utils.DropHTML(this.txtEmail.Text); model.nick_name = Utils.DropHTML(this.txtNickName.Text); model.avatar = Utils.DropHTML(this.txtAvatar.Text); model.sex = this.rblSex.SelectedValue; DateTime result; if (DateTime.TryParse(this.txtBirthday.Text.Trim(), out result)) { model.birthday = new DateTime?(result); } model.telphone = Utils.DropHTML(this.txtTelphone.Text.Trim()); model.mobile = Utils.DropHTML(this.txtMobile.Text.Trim()); model.qq = Utils.DropHTML(this.txtQQ.Text); model.msn = Utils.DropHTML(this.txtMsn.Text); model.address = Utils.DropHTML(this.txtAddress.Text.Trim()); model.amount = Utils.StrToDecimal(this.txtAmount.Text.Trim(), new Decimal(0)); model.point = Utils.StrToInt(this.txtPoint.Text.Trim(), 0); model.exp = Utils.StrToInt(this.txtExp.Text.Trim(), 0); if (users.Update(model)) { this.AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改用户信息:" + model.user_name); flag = true; } return(flag); }
protected void payment_Init(object sender, EventArgs e) { this.action = DTRequest.GetString("action"); this.order_no = DTRequest.GetString("order_no"); if (this.order_no.ToUpper().StartsWith("R")) { this.order_type = DTEnums.AmountTypeEnum.Recharge.ToString().ToLower(); } else if (this.order_no.ToUpper().StartsWith("B")) { this.order_type = DTEnums.AmountTypeEnum.BuyGoods.ToString().ToLower(); } switch (this.action) { case "confirm": if (string.IsNullOrEmpty(this.action) || string.IsNullOrEmpty(this.order_no)) { HttpContext.Current.Response.Redirect(this.linkurl("error", (object)("?msg=" + Utils.UrlEncode("出错啦,URL传输参数有误!")))); break; } this.userModel = new BasePage().GetUserInfo(); if (this.orderConfig.anonymous == 0 || this.order_no.ToUpper().StartsWith("R")) { if (this.userModel == null) { HttpContext.Current.Response.Redirect(this.linkurl(nameof(payment), (object)"?action=login")); break; } } else if (this.userModel == null) { this.userModel = new Rain.Model.users(); } if (this.order_no.ToUpper().StartsWith("R")) { this.rechargeModel = new Rain.BLL.user_recharge().GetModel(this.order_no); if (this.rechargeModel == null) { HttpContext.Current.Response.Redirect(this.linkurl("error", (object)("?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!")))); break; } if (this.rechargeModel.status == 1) { HttpContext.Current.Response.Redirect(this.linkurl(nameof(payment), (object)("?action=succeed&order_no=" + this.rechargeModel.recharge_no))); break; } this.payModel = new Rain.BLL.payment().GetModel(this.rechargeModel.payment_id); if (this.payModel == null) { HttpContext.Current.Response.Redirect(this.linkurl("error", (object)("?msg=" + Utils.UrlEncode("出错啦,支付方式不存在或已删除!")))); break; } if (this.payModel.type == 2) { HttpContext.Current.Response.Redirect(this.linkurl("error", (object)("?msg=" + Utils.UrlEncode("出错啦,账户充值不允许线下支付!")))); break; } this.order_amount = this.rechargeModel.amount; break; } if (this.order_no.ToUpper().StartsWith("B")) { this.orderModel = new Rain.BLL.orders().GetModel(this.order_no); if (this.orderModel == null) { HttpContext.Current.Response.Redirect(this.linkurl("error", (object)("?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!")))); break; } if (this.orderModel.payment_status == 2) { HttpContext.Current.Response.Redirect(this.linkurl(nameof(payment), (object)("?action=succeed&order_no=" + this.orderModel.order_no))); break; } this.payModel = new Rain.BLL.payment().GetModel(this.orderModel.payment_id); if (this.payModel == null) { HttpContext.Current.Response.Redirect(this.linkurl("error", (object)("?msg=" + Utils.UrlEncode("出错啦,支付方式不存在或已删除!")))); break; } if (this.orderModel.payment_status == 0) { HttpContext.Current.Response.Redirect(this.linkurl(nameof(payment), (object)("?action=succeed&order_no=" + this.orderModel.order_no))); break; } if (this.orderModel.order_amount == new Decimal(0)) { if (!new Rain.BLL.orders().UpdateField(this.orderModel.order_no, "status=2,payment_status=2,payment_time='" + (object)DateTime.Now + "'")) { HttpContext.Current.Response.Redirect(this.linkurl(nameof(payment), (object)"?action=error")); break; } HttpContext.Current.Response.Redirect(this.linkurl(nameof(payment), (object)("?action=succeed&order_no=" + this.orderModel.order_no))); break; } this.order_amount = this.orderModel.order_amount; break; } HttpContext.Current.Response.Redirect(this.linkurl("error", (object)("?msg=" + Utils.UrlEncode("出错啦,找不到您要提交的订单类型!")))); break; case "succeed": if (this.order_no.ToUpper().StartsWith("R")) { this.rechargeModel = new Rain.BLL.user_recharge().GetModel(this.order_no); if (this.rechargeModel != null) { break; } HttpContext.Current.Response.Redirect(this.linkurl("error", (object)("?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!")))); break; } if (this.order_no.ToUpper().StartsWith("B")) { this.orderModel = new Rain.BLL.orders().GetModel(this.order_no); if (this.orderModel != null) { break; } HttpContext.Current.Response.Redirect(this.linkurl("error", (object)("?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!")))); break; } HttpContext.Current.Response.Redirect(this.linkurl("error", (object)("?msg=" + Utils.UrlEncode("出错啦,找不到您要提交的订单类型!")))); break; } }
public bool Update(Rain.Model.users model) { return(this.dal.Update(model)); }
public int Add(Rain.Model.users model) { return(this.dal.Add(model)); }
public int Add(Rain.Model.users model) { int maxId; using (OleDbConnection oleDbConnection = new OleDbConnection(DbHelperOleDb.connectionString)) { oleDbConnection.Open(); using (OleDbTransaction trans = oleDbConnection.BeginTransaction()) { try { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("insert into " + this.databaseprefix + "users("); stringBuilder.Append("group_id,user_name,salt,[password],mobile,email,avatar,nick_name,sex,birthday,telphone,area,address,qq,msn,amount,point,exp,status,reg_time,reg_ip)"); stringBuilder.Append(" values ("); stringBuilder.Append("@group_id,@user_name,@salt,@password,@mobile,@email,@avatar,@nick_name,@sex,@birthday,@telphone,@area,@address,@qq,@msn,@amount,@point,@exp,@status,@reg_time,@reg_ip)"); OleDbParameter[] oleDbParameterArray = new OleDbParameter[21] { new OleDbParameter("@group_id", OleDbType.Integer, 4), new OleDbParameter("@user_name", OleDbType.VarChar, 100), new OleDbParameter("@salt", OleDbType.VarChar, 20), new OleDbParameter("@password", OleDbType.VarChar, 100), new OleDbParameter("@mobile", OleDbType.VarChar, 20), new OleDbParameter("@email", OleDbType.VarChar, 50), new OleDbParameter("@avatar", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@nick_name", OleDbType.VarChar, 100), new OleDbParameter("@sex", OleDbType.VarChar, 20), new OleDbParameter("@birthday", OleDbType.Date), new OleDbParameter("@telphone", OleDbType.VarChar, 50), new OleDbParameter("@area", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@address", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@qq", OleDbType.VarChar, 20), new OleDbParameter("@msn", OleDbType.VarChar, 100), new OleDbParameter("@amount", OleDbType.Decimal, 5), new OleDbParameter("@point", OleDbType.Integer, 4), new OleDbParameter("@exp", OleDbType.Integer, 4), new OleDbParameter("@status", OleDbType.Integer, 4), new OleDbParameter("@reg_time", OleDbType.Date), new OleDbParameter("@reg_ip", OleDbType.VarChar, 20) }; oleDbParameterArray[0].Value = (object)model.group_id; oleDbParameterArray[1].Value = (object)model.user_name; oleDbParameterArray[2].Value = (object)model.salt; oleDbParameterArray[3].Value = (object)model.password; oleDbParameterArray[4].Value = (object)model.mobile; oleDbParameterArray[5].Value = (object)model.email; oleDbParameterArray[6].Value = (object)model.avatar; oleDbParameterArray[7].Value = (object)model.nick_name; oleDbParameterArray[8].Value = (object)model.sex; if (model.birthday.HasValue) { oleDbParameterArray[9].Value = (object)model.birthday; } else { oleDbParameterArray[9].Value = (object)DBNull.Value; } oleDbParameterArray[10].Value = (object)model.telphone; oleDbParameterArray[11].Value = (object)model.area; oleDbParameterArray[12].Value = (object)model.address; oleDbParameterArray[13].Value = (object)model.qq; oleDbParameterArray[14].Value = (object)model.msn; oleDbParameterArray[15].Value = (object)model.amount; oleDbParameterArray[16].Value = (object)model.point; oleDbParameterArray[17].Value = (object)model.exp; oleDbParameterArray[18].Value = (object)model.status; oleDbParameterArray[19].Value = (object)model.reg_time; oleDbParameterArray[20].Value = (object)model.reg_ip; DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder.ToString(), oleDbParameterArray); maxId = this.GetMaxId(oleDbConnection, trans); trans.Commit(); } catch { trans.Rollback(); return(-1); } } } return(maxId); }
public Rain.Model.users DataRowToModel(DataRow row) { Rain.Model.users users = new Rain.Model.users(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { users.id = int.Parse(row["id"].ToString()); } if (row["group_id"] != null && row["group_id"].ToString() != "") { users.group_id = int.Parse(row["group_id"].ToString()); } if (row["user_name"] != null) { users.user_name = row["user_name"].ToString(); } if (row["salt"] != null) { users.salt = row["salt"].ToString(); } if (row["password"] != null) { users.password = row["password"].ToString(); } if (row["mobile"] != null) { users.mobile = row["mobile"].ToString(); } if (row["email"] != null) { users.email = row["email"].ToString(); } if (row["avatar"] != null) { users.avatar = row["avatar"].ToString(); } if (row["nick_name"] != null) { users.nick_name = row["nick_name"].ToString(); } if (row["sex"] != null) { users.sex = row["sex"].ToString(); } if (row["birthday"] != null && row["birthday"].ToString() != "") { users.birthday = new DateTime?(DateTime.Parse(row["birthday"].ToString())); } if (row["telphone"] != null) { users.telphone = row["telphone"].ToString(); } if (row["area"] != null) { users.area = row["area"].ToString(); } if (row["address"] != null) { users.address = row["address"].ToString(); } if (row["qq"] != null) { users.qq = row["qq"].ToString(); } if (row["msn"] != null) { users.msn = row["msn"].ToString(); } if (row["amount"] != null && row["amount"].ToString() != "") { users.amount = Decimal.Parse(row["amount"].ToString()); } if (row["point"] != null && row["point"].ToString() != "") { users.point = int.Parse(row["point"].ToString()); } if (row["exp"] != null && row["exp"].ToString() != "") { users.exp = int.Parse(row["exp"].ToString()); } if (row["status"] != null && row["status"].ToString() != "") { users.status = int.Parse(row["status"].ToString()); } if (row["reg_time"] != null && row["reg_time"].ToString() != "") { users.reg_time = DateTime.Parse(row["reg_time"].ToString()); } if (row["reg_ip"] != null) { users.reg_ip = row["reg_ip"].ToString(); } } return(users); }
public bool Delete(int id) { Rain.Model.users model = this.GetModel(id); if (model == null) { return(false); } Hashtable SQLStringList = new Hashtable(); StringBuilder stringBuilder1 = new StringBuilder(); stringBuilder1.Append("delete from " + this.databaseprefix + "user_point_log "); stringBuilder1.Append(" where user_id=@id"); OleDbParameter[] oleDbParameterArray1 = new OleDbParameter[1] { new OleDbParameter("@id", OleDbType.Integer, 4) }; oleDbParameterArray1[0].Value = (object)id; SQLStringList.Add((object)stringBuilder1.ToString(), (object)oleDbParameterArray1); StringBuilder stringBuilder2 = new StringBuilder(); stringBuilder2.Append("delete from " + this.databaseprefix + "user_amount_log "); stringBuilder2.Append(" where user_id=@id"); OleDbParameter[] oleDbParameterArray2 = new OleDbParameter[1] { new OleDbParameter("@id", OleDbType.Integer, 4) }; oleDbParameterArray2[0].Value = (object)id; SQLStringList.Add((object)stringBuilder2.ToString(), (object)oleDbParameterArray2); StringBuilder stringBuilder3 = new StringBuilder(); stringBuilder3.Append("delete from " + this.databaseprefix + "user_attach_log"); stringBuilder3.Append(" where user_id=@id"); OleDbParameter[] oleDbParameterArray3 = new OleDbParameter[1] { new OleDbParameter("@id", OleDbType.Integer, 4) }; oleDbParameterArray3[0].Value = (object)id; SQLStringList.Add((object)stringBuilder3.ToString(), (object)oleDbParameterArray3); StringBuilder stringBuilder4 = new StringBuilder(); stringBuilder4.Append("delete from " + this.databaseprefix + "user_message "); stringBuilder4.Append(" where post_user_name=@post_user_name or accept_user_name=@accept_user_name"); OleDbParameter[] oleDbParameterArray4 = new OleDbParameter[2] { new OleDbParameter("@post_user_name", OleDbType.VarChar, 100), new OleDbParameter("@accept_user_name", OleDbType.VarChar, 100) }; oleDbParameterArray4[0].Value = (object)model.user_name; oleDbParameterArray4[1].Value = (object)model.user_name; SQLStringList.Add((object)stringBuilder4.ToString(), (object)oleDbParameterArray4); StringBuilder stringBuilder5 = new StringBuilder(); stringBuilder5.Append("delete from " + this.databaseprefix + "user_code "); stringBuilder5.Append(" where user_id=@id"); OleDbParameter[] oleDbParameterArray5 = new OleDbParameter[1] { new OleDbParameter("@id", OleDbType.Integer, 4) }; oleDbParameterArray5[0].Value = (object)id; SQLStringList.Add((object)stringBuilder5.ToString(), (object)oleDbParameterArray5); StringBuilder stringBuilder6 = new StringBuilder(); stringBuilder6.Append("delete from " + this.databaseprefix + "user_login_log "); stringBuilder6.Append(" where user_id=@id"); OleDbParameter[] oleDbParameterArray6 = new OleDbParameter[1] { new OleDbParameter("@id", OleDbType.Integer, 4) }; oleDbParameterArray6[0].Value = (object)id; SQLStringList.Add((object)stringBuilder6.ToString(), (object)oleDbParameterArray6); StringBuilder stringBuilder7 = new StringBuilder(); stringBuilder7.Append("delete from " + this.databaseprefix + "user_oauth "); stringBuilder7.Append(" where user_id=@id"); OleDbParameter[] oleDbParameterArray7 = new OleDbParameter[1] { new OleDbParameter("@id", OleDbType.Integer, 4) }; oleDbParameterArray7[0].Value = (object)id; SQLStringList.Add((object)stringBuilder7.ToString(), (object)oleDbParameterArray7); StringBuilder stringBuilder8 = new StringBuilder(); stringBuilder8.Append("delete from " + this.databaseprefix + "user_recharge "); stringBuilder8.Append(" where user_id=@id"); OleDbParameter[] oleDbParameterArray8 = new OleDbParameter[1] { new OleDbParameter("@id", OleDbType.Integer, 4) }; oleDbParameterArray8[0].Value = (object)id; SQLStringList.Add((object)stringBuilder8.ToString(), (object)oleDbParameterArray8); StringBuilder stringBuilder9 = new StringBuilder(); stringBuilder9.Append("delete from " + this.databaseprefix + "users "); stringBuilder9.Append(" where id=@id"); OleDbParameter[] oleDbParameterArray9 = new OleDbParameter[1] { new OleDbParameter("@id", OleDbType.Integer, 4) }; oleDbParameterArray9[0].Value = (object)id; SQLStringList.Add((object)stringBuilder9.ToString(), (object)oleDbParameterArray9); return(DbHelperOleDb.ExecuteSqlTran(SQLStringList)); }
public bool Update(Rain.Model.users model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update " + this.databaseprefix + "users set "); stringBuilder.Append("group_id=@group_id,"); stringBuilder.Append("user_name=@user_name,"); stringBuilder.Append("salt=@salt,"); stringBuilder.Append("[password]=@password,"); stringBuilder.Append("mobile=@mobile,"); stringBuilder.Append("email=@email,"); stringBuilder.Append("avatar=@avatar,"); stringBuilder.Append("nick_name=@nick_name,"); stringBuilder.Append("sex=@sex,"); stringBuilder.Append("birthday=@birthday,"); stringBuilder.Append("telphone=@telphone,"); stringBuilder.Append("area=@area,"); stringBuilder.Append("address=@address,"); stringBuilder.Append("qq=@qq,"); stringBuilder.Append("msn=@msn,"); stringBuilder.Append("amount=@amount,"); stringBuilder.Append("point=@point,"); stringBuilder.Append("exp=@exp,"); stringBuilder.Append("status=@status,"); stringBuilder.Append("reg_time=@reg_time,"); stringBuilder.Append("reg_ip=@reg_ip"); stringBuilder.Append(" where id=@id"); OleDbParameter[] oleDbParameterArray = new OleDbParameter[22] { new OleDbParameter("@group_id", OleDbType.Integer, 4), new OleDbParameter("@user_name", OleDbType.VarChar, 100), new OleDbParameter("@salt", OleDbType.VarChar, 20), new OleDbParameter("@password", OleDbType.VarChar, 100), new OleDbParameter("@mobile", OleDbType.VarChar, 20), new OleDbParameter("@email", OleDbType.VarChar, 50), new OleDbParameter("@avatar", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@nick_name", OleDbType.VarChar, 100), new OleDbParameter("@sex", OleDbType.VarChar, 20), new OleDbParameter("@birthday", OleDbType.Date), new OleDbParameter("@telphone", OleDbType.VarChar, 50), new OleDbParameter("@area", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@address", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@qq", OleDbType.VarChar, 20), new OleDbParameter("@msn", OleDbType.VarChar, 100), new OleDbParameter("@amount", OleDbType.Decimal, 5), new OleDbParameter("@point", OleDbType.Integer, 4), new OleDbParameter("@exp", OleDbType.Integer, 4), new OleDbParameter("@status", OleDbType.Integer, 4), new OleDbParameter("@reg_time", OleDbType.Date), new OleDbParameter("@reg_ip", OleDbType.VarChar, 20), new OleDbParameter("@id", OleDbType.Integer, 4) }; oleDbParameterArray[0].Value = (object)model.group_id; oleDbParameterArray[1].Value = (object)model.user_name; oleDbParameterArray[2].Value = (object)model.salt; oleDbParameterArray[3].Value = (object)model.password; oleDbParameterArray[4].Value = (object)model.mobile; oleDbParameterArray[5].Value = (object)model.email; oleDbParameterArray[6].Value = (object)model.avatar; oleDbParameterArray[7].Value = (object)model.nick_name; oleDbParameterArray[8].Value = (object)model.sex; if (model.birthday.HasValue) { oleDbParameterArray[9].Value = (object)model.birthday; } else { oleDbParameterArray[9].Value = (object)DBNull.Value; } oleDbParameterArray[10].Value = (object)model.telphone; oleDbParameterArray[11].Value = (object)model.area; oleDbParameterArray[12].Value = (object)model.address; oleDbParameterArray[13].Value = (object)model.qq; oleDbParameterArray[14].Value = (object)model.msn; oleDbParameterArray[15].Value = (object)model.amount; oleDbParameterArray[16].Value = (object)model.point; oleDbParameterArray[17].Value = (object)model.exp; oleDbParameterArray[18].Value = (object)model.status; oleDbParameterArray[19].Value = (object)model.reg_time; oleDbParameterArray[20].Value = (object)model.reg_ip; oleDbParameterArray[21].Value = (object)model.id; return(DbHelperOleDb.ExecuteSql(stringBuilder.ToString(), oleDbParameterArray) > 0); }