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