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