/// <summary>
/// 删除
/// </summary>
/// <param name="cmd">Command对象</param>
/// <param name="jCUser">实体类对象</param>
/// <returns>影响的记录行数</returns>
internal static int ExcuteDeleteCommand(SqlCommand cmd, JCUser jCUser)
{
cmd.Parameters.Clear();
cmd.CommandText = "delete from JC_User where UserID=@UserID";
//从实体中取出值放入Command的参数列表
cmd.Parameters.Add(new SqlParameter("@UserID", jCUser.UserID));
return(cmd.ExecuteNonQuery());
}
/// <summary>
/// 不使用事务的删除方法
/// </summary>
/// <param name="jCUser">实体类对象</param>
/// <returns>影响的记录行数</returns>
internal static int Delete(JCUser jCUser)
{
using (SqlConnection conn = new SqlConnection(Connection.ConnectionString))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
return(ExcuteDeleteCommand(cmd, jCUser));
}
}
}
/// <summary>
/// 不使用事务的插入方法
/// </summary>
/// <param name="jCUser">实体类对象</param>
/// <returns>标识列值或影响的记录行数</returns>
internal static Guid Insert(JCUser jCUser)
{
using (SqlConnection conn = new SqlConnection(Connection.ConnectionString))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
return(Insert(cmd, jCUser));
}
}
}
/// <summary>
/// 从DataReader中取出值生成实体对象
/// </summary>
/// <param name="searcher">查询对象</param>
/// <returns>过滤条件字符串</returns>
private static JCUser DataReaderToEntity(SqlDataReader dr)
{
JCUser entity = new JCUser();
if (dr["UserID"] != System.DBNull.Value)
{
Guid tempGuid = new Guid(); Guid.TryParse(dr["UserID"].ToString(), out tempGuid); entity.UserID = tempGuid;;
}
if (dr["UserName"] != System.DBNull.Value)
{
entity.UserName = dr["UserName"].ToString();
}
if (dr["PassWord"] != System.DBNull.Value)
{
entity.PassWord = dr["PassWord"].ToString();
}
if (dr["NickName"] != System.DBNull.Value)
{
entity.NickName = dr["NickName"].ToString();
}
if (dr["TrueName"] != System.DBNull.Value)
{
entity.TrueName = dr["TrueName"].ToString();
}
if (dr["Email"] != System.DBNull.Value)
{
entity.Email = dr["Email"].ToString();
}
if (dr["Phone"] != System.DBNull.Value)
{
entity.Phone = dr["Phone"].ToString();
}
if (dr["QQ"] != System.DBNull.Value)
{
entity.QQ = dr["QQ"].ToString();
}
if (dr["CreateTime"] != System.DBNull.Value)
{
entity.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
}
if (dr["LastLoginTime"] != System.DBNull.Value)
{
entity.LastLoginTime = Convert.ToDateTime(dr["LastLoginTime"]);
}
if (dr["Birthday"] != System.DBNull.Value)
{
entity.Birthday = Convert.ToDateTime(dr["Birthday"]);
}
return(entity);
}
/// <summary>
/// 执行Command获取对象列表
/// </summary>
/// <param name="cmd">Command对象</param>
/// <param name="recursiveType">递归类型</param>
/// <param name="recursiveDepth">递归深度</param>
/// <returns>实体类对象列表</returns>
internal static List <JCUser> ExcuteSelectCommand(SqlCommand cmd, RecursiveType recursiveType, int recursiveDepth)
{
List <JCUser> jCUserList = new List <JCUser>();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
JCUser jCUser = DataReaderToEntity(dr);
jCUserList.Add(jCUser);
}
}
return(jCUserList);
}
/// <summary>
/// 递归查询单个实体
/// </summary>
/// <param name="cmd">Command对象</param>
/// <param name="recursiveType">递归类型</param>
/// <param name="recursiveDepth">递归深度</param>
/// <returns>实体对象</returns>
internal static JCUser ExcuteSelectSingleCommand(SqlCommand cmd, RecursiveType recursiveType, int recursiveDepth)
{
JCUser jCUser = null;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
jCUser = DataReaderToEntity(dr);
}
}
if (jCUser == null)
{
return(jCUser);
}
return(jCUser);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="cmd">Command对象</param>
/// <param name="jCUser">实体类对象</param>
/// <returns>影响的记录行数</returns>
internal static int ExcuteUpdateCommand(SqlCommand cmd, JCUser jCUser)
{
cmd.CommandText = "update JC_User set UserID=@UserID,UserName=@UserName,PassWord=@PassWord,NickName=@NickName,TrueName=@TrueName,Email=@Email,Phone=@Phone,QQ=@QQ,CreateTime=@CreateTime,LastLoginTime=@LastLoginTime,Birthday=@Birthday where UserID=@UserID";
//从实体中取出值放入Command的参数列表
cmd.Parameters.Add(new SqlParameter("@UserName", jCUser.UserName == null?(object)DBNull.Value:(object)jCUser.UserName));
cmd.Parameters.Add(new SqlParameter("@PassWord", jCUser.PassWord == null?(object)DBNull.Value:(object)jCUser.PassWord));
cmd.Parameters.Add(new SqlParameter("@NickName", jCUser.NickName == null?(object)DBNull.Value:(object)jCUser.NickName));
cmd.Parameters.Add(new SqlParameter("@TrueName", jCUser.TrueName == null?(object)DBNull.Value:(object)jCUser.TrueName));
cmd.Parameters.Add(new SqlParameter("@Email", jCUser.Email == null?(object)DBNull.Value:(object)jCUser.Email));
cmd.Parameters.Add(new SqlParameter("@Phone", jCUser.Phone == null?(object)DBNull.Value:(object)jCUser.Phone));
cmd.Parameters.Add(new SqlParameter("@QQ", jCUser.QQ == null?(object)DBNull.Value:(object)jCUser.QQ));
cmd.Parameters.Add(new SqlParameter("@CreateTime", jCUser.CreateTime.HasValue?(object)jCUser.CreateTime.Value:(object)DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@LastLoginTime", jCUser.LastLoginTime.HasValue?(object)jCUser.LastLoginTime.Value:(object)DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@Birthday", jCUser.Birthday.HasValue?(object)jCUser.Birthday.Value:(object)DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@UserID", jCUser.UserID));
return(cmd.ExecuteNonQuery());
}
/// <summary>
/// 插入
/// </summary>
/// <param name="cmd">Command对象</param>
/// <param name="jCUser">实体类对象</param>
/// <returns>标识列值或影响的记录行数</returns>
internal static Guid Insert(SqlCommand cmd, JCUser jCUser)
{
cmd.Parameters.Clear();
cmd.CommandText = "insert into JC_User (UserName,PassWord,NickName,TrueName,Email,Phone,QQ,CreateTime,LastLoginTime,Birthday) output inserted.UserID values (@UserName,@PassWord,@NickName,@TrueName,@Email,@Phone,@QQ,@CreateTime,@LastLoginTime,@Birthday)";
//从实体中取出值放入Command的参数列表
cmd.Parameters.Add(new SqlParameter("@UserID", jCUser.UserID == null?(object)DBNull.Value:(object)jCUser.UserID));
cmd.Parameters.Add(new SqlParameter("@UserName", jCUser.UserName == null?(object)DBNull.Value:(object)jCUser.UserName));
cmd.Parameters.Add(new SqlParameter("@PassWord", jCUser.PassWord == null?(object)DBNull.Value:(object)jCUser.PassWord));
cmd.Parameters.Add(new SqlParameter("@NickName", jCUser.NickName == null?(object)DBNull.Value:(object)jCUser.NickName));
cmd.Parameters.Add(new SqlParameter("@TrueName", jCUser.TrueName == null?(object)DBNull.Value:(object)jCUser.TrueName));
cmd.Parameters.Add(new SqlParameter("@Email", jCUser.Email == null?(object)DBNull.Value:(object)jCUser.Email));
cmd.Parameters.Add(new SqlParameter("@Phone", jCUser.Phone == null?(object)DBNull.Value:(object)jCUser.Phone));
cmd.Parameters.Add(new SqlParameter("@QQ", jCUser.QQ == null?(object)DBNull.Value:(object)jCUser.QQ));
cmd.Parameters.Add(new SqlParameter("@CreateTime", jCUser.CreateTime.HasValue?(object)jCUser.CreateTime.Value:(object)DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@LastLoginTime", jCUser.LastLoginTime.HasValue?(object)jCUser.LastLoginTime.Value:(object)DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@Birthday", jCUser.Birthday.HasValue?(object)jCUser.Birthday.Value:(object)DBNull.Value));
return(Guid.Parse(cmd.ExecuteScalar().ToString()));
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="jCUser">实体类对象</param>
/// <returns>影响的记录行数</returns>
public static int Update(JCUser jCUser)
{
return(DJCUser.Update(jCUser));
}
/// <summary>
/// 删除实体
/// </summary>
/// <param name="jCUser">实体类对象</param>
/// <returns>影响的记录行数</returns>
public static int Delete(JCUser jCUser)
{
return(DJCUser.Delete(jCUser));
}
/// <summary>
/// 插入实体
/// </summary>
/// <param name="jCUser">实体类对象</param>
/// <returns>标识列值或影响的记录行数</returns>
public static Guid Insert(JCUser jCUser)
{
return(DJCUser.Insert(jCUser));
}
/// <summary>
/// 使用事务的插入方法
/// </summary>
/// <param name="connection">实现共享Connection的对象</param>
/// <param name="jCUser">实体类对象</param>
/// <returns>标识列值或影响的记录行数</returns>
internal static Guid Insert(Connection connection, JCUser jCUser)
{
return(Insert(connection.Command, jCUser));
}
/// <summary>
/// 使用事务的更新方法
/// </summary>
/// <param name="connection">实现共享Connection的对象</param>
/// <param name="jCUser">实体类对象</param>
/// <returns>影响的记录行数</returns>
internal static int Update(Connection connection, JCUser jCUser)
{
return(ExcuteUpdateCommand(connection.Command, jCUser));
}
private void RegisterUser()
{
try
{
JCUser user = new JCUser();
#region 验证
string regNickName = conn.Request["regNickName"];
if (string.IsNullOrEmpty(regNickName))
{
json.success = false;
json.msg = "请输入昵称";
return;
}
string regUserName = conn.Request["regUserName"];
if (string.IsNullOrEmpty(regUserName))
{
json.success = false;
json.msg = "请输入账号";
return;
}
if (regUserName.Length < 6)
{
json.success = false;
json.msg = "长度不得小于6";
return;
}
if (regUserName.Length > 100)
{
json.success = false;
json.msg = "长度不得大于100";
return;
}
string regPassword = conn.Request["regPassword"];
if (string.IsNullOrEmpty(regPassword))
{
json.success = false;
json.msg = "请输入密码";
return;
}
if (regPassword.Length < 8)
{
json.success = false;
json.msg = "长度不得小于8";
return;
}
if (regPassword.Length > 100)
{
json.success = false;
json.msg = "长度不得大于100";
return;
}
string regPasswordCheck = conn.Request["regPasswordCheck"];
if (string.IsNullOrEmpty(regPasswordCheck))
{
json.success = false;
json.msg = "请输入密码确认";
return;
}
if (regPassword != regPasswordCheck)
{
json.success = false;
json.msg = "两次密码不一致";
return;
}
string regEmail = conn.Request["regEmail"];
if (string.IsNullOrEmpty(regEmail))
{
json.success = false;
json.msg = "请输入邮箱";
return;
}
if (!Common.Helper.Common.IsValidEmail(regEmail))
{
json.success = false;
json.msg = "邮箱格式不正确";
return;
}
// BJCUser.Select();
#endregion
bool isExist = BJCUser.Select("UserName=@UserName", new ParameterList("@UserName", regUserName)).Count > 0;
if (isExist)
{
json.success = false;
json.msg = "账号已存在，请重新输入";
return;
}
user.UserName = regUserName;
user.NickName = regNickName;
user.PassWord = Common.Helper.Common.GetSHA1EnryptStr(regPassword);
user.Email = regEmail;
user.CreateTime = DateTime.Now;
Guid tempGuid = BJCUser.Insert(user);
if (tempGuid != new Guid())
{
json.success = true;
json.msg = "新增成功";
}
else
{
json.success = false;
json.msg = "新增失败";
}
}
catch (Exception e)
{
json.success = false;
json.msg = e.Message;
}
}
