protected override void ShowPage() { this.action = DTRequest.GetQueryString("action"); this.username = DTRequest.GetQueryString("username"); this.username = Utils.DropHTML(this.username); if (this.action == "" && this.uconfig.regstatus == 0) { HttpContext.Current.Response.Redirect(this.linkurl(nameof(register), (object)"?action=close")); } else { if (!(this.action == "checkmail")) { return; } string queryString = DTRequest.GetQueryString("code"); Rain.BLL.user_code userCode = new Rain.BLL.user_code(); Rain.Model.user_code model = userCode.GetModel(queryString); if (model == null) { HttpContext.Current.Response.Redirect(this.linkurl(nameof(register), (object)"?action=checkerror")); } else { model.status = 1; userCode.Update(model); new Rain.BLL.users().UpdateField(model.user_id, "status=0"); } } }
public int Add(Rain.Model.user_code 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 + "user_code("); stringBuilder.Append("user_id,user_name,[type],str_code,[count],status,user_ip,eff_time,add_time)"); stringBuilder.Append(" values ("); stringBuilder.Append("@user_id,@user_name,@type,@str_code,@count,@status,@user_ip,@eff_time,@add_time)"); OleDbParameter[] oleDbParameterArray = new OleDbParameter[9] { new OleDbParameter("@user_id", OleDbType.Integer, 4), new OleDbParameter("@user_name", OleDbType.VarChar, 100), new OleDbParameter("@type", OleDbType.VarChar, 20), new OleDbParameter("@str_code", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@count", OleDbType.Integer, 4), new OleDbParameter("@status", OleDbType.Integer, 4), new OleDbParameter("@user_ip", OleDbType.VarChar, 20), new OleDbParameter("@eff_time", OleDbType.Date), new OleDbParameter("@add_time", OleDbType.Date) }; oleDbParameterArray[0].Value = (object)model.user_id; oleDbParameterArray[1].Value = (object)model.user_name; oleDbParameterArray[2].Value = (object)model.type; oleDbParameterArray[3].Value = (object)model.str_code; oleDbParameterArray[4].Value = (object)model.count; oleDbParameterArray[5].Value = (object)model.status; oleDbParameterArray[6].Value = (object)model.user_ip; oleDbParameterArray[7].Value = (object)model.eff_time; oleDbParameterArray[8].Value = (object)model.add_time; DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder.ToString(), oleDbParameterArray); maxId = this.GetMaxId(oleDbConnection, trans); trans.Commit(); } catch { trans.Rollback(); return(-1); } } } return(maxId); }
public Rain.Model.user_code DataRowToModel(DataRow row) { Rain.Model.user_code userCode = new Rain.Model.user_code(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { userCode.id = int.Parse(row["id"].ToString()); } if (row["user_id"] != null && row["user_id"].ToString() != "") { userCode.user_id = int.Parse(row["user_id"].ToString()); } if (row["user_name"] != null) { userCode.user_name = row["user_name"].ToString(); } if (row["type"] != null) { userCode.type = row["type"].ToString(); } if (row["str_code"] != null) { userCode.str_code = row["str_code"].ToString(); } if (row["count"] != null && row["count"].ToString() != "") { userCode.count = int.Parse(row["count"].ToString()); } if (row["status"] != null && row["status"].ToString() != "") { userCode.status = int.Parse(row["status"].ToString()); } if (row["user_ip"] != null) { userCode.user_ip = row["user_ip"].ToString(); } if (row["eff_time"] != null && row["eff_time"].ToString() != "") { userCode.eff_time = DateTime.Parse(row["eff_time"].ToString()); } if (row["add_time"] != null && row["add_time"].ToString() != "") { userCode.add_time = DateTime.Parse(row["add_time"].ToString()); } } return(userCode); }
public bool Update(Rain.Model.user_code model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update " + this.databaseprefix + "user_code set "); stringBuilder.Append("user_id=@user_id,"); stringBuilder.Append("user_name=@user_name,"); stringBuilder.Append("[type]=@type,"); stringBuilder.Append("str_code=@str_code,"); stringBuilder.Append("[count]=@count,"); stringBuilder.Append("status=@status,"); stringBuilder.Append("user_ip=@user_ip,"); stringBuilder.Append("eff_time=@eff_time,"); stringBuilder.Append("add_time=@add_time"); stringBuilder.Append(" where id=@id"); OleDbParameter[] oleDbParameterArray = new OleDbParameter[10] { new OleDbParameter("@user_id", OleDbType.Integer, 4), new OleDbParameter("@user_name", OleDbType.VarChar, 100), new OleDbParameter("@type", OleDbType.VarChar, 20), new OleDbParameter("@str_code", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@count", OleDbType.Integer, 4), new OleDbParameter("@status", OleDbType.Integer, 4), new OleDbParameter("@user_ip", OleDbType.VarChar, 20), new OleDbParameter("@eff_time", OleDbType.Date), new OleDbParameter("@add_time", OleDbType.Date), new OleDbParameter("@id", OleDbType.Integer, 4) }; oleDbParameterArray[0].Value = (object)model.user_id; oleDbParameterArray[1].Value = (object)model.user_name; oleDbParameterArray[2].Value = (object)model.type; oleDbParameterArray[3].Value = (object)model.str_code; oleDbParameterArray[4].Value = (object)model.count; oleDbParameterArray[5].Value = (object)model.status; oleDbParameterArray[6].Value = (object)model.user_ip; oleDbParameterArray[7].Value = (object)model.eff_time; oleDbParameterArray[8].Value = (object)model.add_time; oleDbParameterArray[9].Value = (object)model.id; return(DbHelperOleDb.ExecuteSql(stringBuilder.ToString(), oleDbParameterArray) > 0); }
public bool Update(Rain.Model.user_code model) { return(this.dal.Update(model)); }
public int Add(Rain.Model.user_code model) { return(this.dal.Add(model)); }