/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(yonghuModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update yonghu set ");
strSql.Append("nvc_username=@nvc_username,");
strSql.Append("nvc_pwd=@nvc_pwd,");
strSql.Append("int_right=@int_right,");
strSql.Append("dt_register=@dt_register");
strSql.Append(" where nc_uid=@nc_uid ");
SqlParameter[] parameters =
{
new SqlParameter("@nvc_username", SqlDbType.NVarChar, 50),
new SqlParameter("@nvc_pwd", SqlDbType.NVarChar, 50),
new SqlParameter("@int_right", SqlDbType.Int, 4),
new SqlParameter("@dt_register", SqlDbType.DateTime),
new SqlParameter("@nc_uid", SqlDbType.NChar, 20)
};
parameters[0].Value = model.nvc_username;
parameters[1].Value = model.nvc_pwd;
parameters[2].Value = model.int_right;
parameters[3].Value = model.dt_register;
parameters[4].Value = model.nc_uid;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public yonghuModel DataRowToModel(DataRow row)
{
yonghuModel model = new yonghuModel();
if (row != null)
{
if (row["nc_uid"] != null)
{
model.nc_uid = row["nc_uid"].ToString();
}
if (row["nvc_username"] != null)
{
model.nvc_username = row["nvc_username"].ToString();
}
if (row["nvc_pwd"] != null)
{
model.nvc_pwd = row["nvc_pwd"].ToString();
}
if (row["int_right"] != null && row["int_right"].ToString() != "")
{
model.int_right = int.Parse(row["int_right"].ToString());
}
if (row["dt_register"] != null && row["dt_register"].ToString() != "")
{
model.dt_register = DateTime.Parse(row["dt_register"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(yonghuModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into yonghu(");
strSql.Append("nvc_username,nvc_pwd,int_right)");
strSql.Append(" values (");
strSql.Append("@nvc_username,@nvc_pwd,@int_right)");
SqlParameter[] parameters =
{
new SqlParameter("@nvc_username", SqlDbType.NVarChar, 50),
new SqlParameter("@nvc_pwd", SqlDbType.NVarChar, 50),
new SqlParameter("@int_right", SqlDbType.Int, 4)
};
parameters[0].Value = model.nvc_username;
parameters[1].Value = model.nvc_pwd;
parameters[2].Value = model.int_right;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public yonghuModel GetModelByUsername(string username)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 nc_uid,nvc_username,nvc_pwd,int_right,dt_register from yonghu ");
strSql.Append(" where nvc_username=@nvc_username ");
SqlParameter[] parameters =
{
new SqlParameter("@nvc_username", SqlDbType.NVarChar, 50)
};
parameters[0].Value = username;
yonghuModel model = new yonghuModel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string caozuo = null;
if (!string.IsNullOrEmpty(Request.Form["action"]))//获取数据类型
{
caozuo = Request.Form["action"];
}
if (caozuo == "Register")
{
#region 注册
#region 用户名
string uname = null;
if (!string.IsNullOrEmpty(Request.Form["CreateUsername"]))//获取数据类型
{
string un = Request.Form["CreateUsername"];
if (un.Length > 0 && un.Length <= 20)
{
if (Regex.IsMatch(un, @"^([\u4e00-\u9fa5]|[a-zA-Z]|[0-9]|-){0,}$") || Regex.IsMatch(un, @"^[_\.0-9a-zA-Z-]+@([0-9a-zA-Z][0-9a-zA-Z-]+\.)+[a-zA-Z]{2,4}$"))
{
uname = un;
}
}
}
#endregion
#region 密码
string pwd = null;
if (!string.IsNullOrEmpty(Request.Form["CreatePassword"]))//获取数据类型
{
string up = Request.Form["CreatePassword"];
if (up.Length > 6 && up.Length <= 16 && up != "123456" && up != "654321" && up != "111222")
{
pwd = up;
}
}
#endregion
#region 重复密码
string repwd = null;
if (!string.IsNullOrEmpty(Request.Form["CreateRePassword"]))//获取数据类型
{
string urd = Request.Form["CreateRePassword"];
if (urd == pwd)
{
repwd = urd;
}
}
#endregion
#region 操作
string action = null;
if (!string.IsNullOrEmpty(Request.Form["RegisterSubmit"]))//获取数据类型
{
action = Request.Form["RegisterSubmit"];
}
#endregion
if (pwd == repwd && action == "创建账户" && string.IsNullOrEmpty(uname) != null)
{
//添加一条记录
yonghuModel yhm = new yonghuModel();
yhm.nvc_username = uname;
yhm.nvc_pwd = new MD5Encrypt().GetMD5(pwd + uname);
yhm.int_right = 1;
bool isInsertOk = new yonghuDAL().Add(yhm);
if (isInsertOk == true)
{
Response.Write("<script>javascript:alert('注册成功！');window.parent.location.reload();</script>");
}
}
else
{
Response.Write("<script>javascript:alert('注册失败！请重试！');</script>");
}
#endregion
Response.End();
}
Page.DataBind();
}
