コード例 #1
0
 public int Insert(User user, int roleId)
 {
     int success = 0;
     ITableRelationService tableRelationService=new TableRelationService();
     using(TransactionScope ts=new TransactionScope())
     {
         success = Insert(user);
         user.UserId = success;
         if(success>0)
         {
             success = tableRelationService.InsertUser_Role(user.UserId, roleId);
         }
         if(success>0)
         {
             ts.Complete();
         }
     }
     return success;
 }
コード例 #2
0
 public User GetUser(int userId)
 {
     using (DataCommand cmd = DataCommandManager.GetDataCommand("GetUser"))
     {
         cmd.SetParameterValue("@UserId", userId);
         User user = new User();
         using (IDataReader dr = cmd.ExecuteDataReader())
         {
             while (dr.Read())
             {
                 if (!Convert.IsDBNull(dr["UserId"]))
                 {
                     user.UserId = Convert.ToInt32(dr["UserId"]);
                 }
                 if (!Convert.IsDBNull(dr["NickName"]))
                 {
                     user.NickName = dr["NickName"].ToString();
                 }
                 if (!Convert.IsDBNull(dr["Name"]))
                 {
                     user.Name = dr["Name"].ToString();
                 }
                 if (!Convert.IsDBNull(dr["Password"]))
                 {
                     user.Password = dr["Password"].ToString();
                 }
                 if (!Convert.IsDBNull(dr["Sex"]))
                 {
                     //user.Sex = Convert.ToInt32(dr["Sex"]);
                 }
                 if (!Convert.IsDBNull(dr["Cellphone"]))
                 {
                     user.Cellphone = dr["Cellphone"].ToString();
                 }
                 if (!Convert.IsDBNull(dr["Telephone"]))
                 {
                     user.Telephone = dr["Telephone"].ToString();
                 }
                 if (!Convert.IsDBNull(dr["Email"]))
                 {
                     user.Email = dr["Email"].ToString();
                 }
                 if (!Convert.IsDBNull(dr["Activity"]))
                 {
                     user.Activity = Convert.ToBoolean(dr["Activity"]);
                 }
                 if (!Convert.IsDBNull(dr["Address"]))
                 {
                     user.Address = dr["Address"].ToString();
                 }
                 if (!Convert.IsDBNull(dr["QQ"]))
                 {
                     user.QQ = dr["QQ"].ToString();
                 }
                 if (!Convert.IsDBNull(dr["Fax"]))
                 {
                     user.Fax = dr["Fax"].ToString();
                 }
                 if (!Convert.IsDBNull(dr["Postcode"]))
                 {
                     user.Postcode = dr["Postcode"].ToString();
                 }
                 if (!Convert.IsDBNull(dr["InUserId"]))
                 {
                     user.InUserId = Convert.ToInt32(dr["InUserId"]);
                 }
                 if (!Convert.IsDBNull(dr["InDate"]))
                 {
                     user.InDate = Convert.ToDateTime(dr["InDate"]);
                 }
                 if (!Convert.IsDBNull(dr["EditUserId"]))
                 {
                     user.EditUserId = Convert.ToInt32(dr["EditUserId"]);
                 }
                 if (!Convert.IsDBNull(dr["EditDate"]))
                 {
                     user.EditDate = Convert.ToDateTime(dr["EditDate"]);
                 }
                 if (!Convert.IsDBNull(dr["Enabled"]))
                 {
                     //user.Enabled = dr["Enabled"].ToString();
                 }
                 if (!Convert.IsDBNull(dr["FirstVisit"]))
                 {
                     user.FirstVisit = Convert.ToDateTime(dr["FirstVisit"]);
                 }
                 if (!Convert.IsDBNull(dr["FirstVisit"]))
                 {
                     user.FirstVisit = Convert.ToDateTime(dr["FirstVisit"]);
                 }
                 if (!Convert.IsDBNull(dr["PreviousVisit"]))
                 {
                     user.PreviousVisit = Convert.ToDateTime(dr["PreviousVisit"]);
                 }
                 if (!Convert.IsDBNull(dr["LastVisit"]))
                 {
                     user.LastVisit = Convert.ToDateTime(dr["LastVisit"]);
                 }
                 if (!Convert.IsDBNull(dr["Question"]))
                 {
                     user.Question = dr["Question"].ToString();
                 }
                 if (!Convert.IsDBNull(dr["Answer"]))
                 {
                     user.Answer = dr["Answer"].ToString();
                 }
             }
         }
         return user;
     }
 }
コード例 #3
0
 public int UpdatePassword(User model)
 {
     using (DataCommand cmd = DataCommandManager.GetDataCommand("UpdatePassword"))
     {
         cmd.SetParameterValue("@Password", model.Password);
         cmd.SetParameterValue("@UserId", model.UserId);
         return cmd.ExecuteNonQuery();
     }
 }
コード例 #4
0
 public int Insert(User user)
 {
     using (DataCommand cmd = DataCommandManager.GetDataCommand("InsertUser"))
     {
         cmd.SetParameterValue("@UserId", user.UserId);
         cmd.SetParameterValue("@NickName", user.NickName);
         cmd.SetParameterValue("@Name", user.Name);
         cmd.SetParameterValue("@Password", user.Password);
         cmd.SetParameterValue("@Sex", user.Sex);
         cmd.SetParameterValue("@Cellphone", user.Cellphone);
         cmd.SetParameterValue("@Telephone", user.Telephone);
         cmd.SetParameterValue("@Email", user.Email);
         cmd.SetParameterValue("@Activity", user.Activity);
         cmd.SetParameterValue("@Address", user.Address);
         cmd.SetParameterValue("@QQ", user.QQ);
         cmd.SetParameterValue("@Fax", user.Fax);
         cmd.SetParameterValue("@Postcode", user.Postcode);
         cmd.SetParameterValue("@InUserId", user.InUserId);
         cmd.SetParameterValue("@InDate", user.InDate);
         cmd.SetParameterValue("@EditUserId", user.EditUserId);
         cmd.SetParameterValue("@EditDate", user.EditDate);
         cmd.SetParameterValue("@Enabled", user.Enabled);
         cmd.SetParameterValue("@FirstVisit", user.FirstVisit);
         cmd.SetParameterValue("@PreviousVisit", user.PreviousVisit);
         cmd.SetParameterValue("@LastVisit", user.LastVisit);
         cmd.SetParameterValue("@Question", user.Question);
         cmd.SetParameterValue("@Answer", user.Answer);
         int result = cmd.ExecuteNonQuery();
         if (result > 0)
             return user.UserId;
         return result;
         // if (result != null)
         //     return Convert.ToInt32(result);
         //return -1;
     }
 }
コード例 #5
0
        public List<User> GetUsers(string sqlWhere)
        {
            List<User> users=new List<User>();
            using (DataCommand cmd = DataCommandManager.GetDataCommand("GetUsers"))
            {
                //cmd.CommandText = cmd.CommandText + " " + sqlWhere;
                if(!string.IsNullOrEmpty(sqlWhere))
                {
                    cmd.CommandText = cmd.CommandText+" " + sqlWhere;
                }
                using(IDataReader dr=cmd.ExecuteDataReader())
                {
                    while (dr.Read())
                    {
                        User user=new User();
                        if (!Convert.IsDBNull(dr["UserId"]))
                        {
                            user.UserId = Convert.ToInt32(dr["UserId"]);
                        }
                        if (!Convert.IsDBNull(dr["NickName"]))
                        {
                            user.NickName = dr["NickName"].ToString();
                        }
                        if (!Convert.IsDBNull(dr["Name"]))
                        {
                            user.Name = dr["Name"].ToString();
                        }
                        if (!Convert.IsDBNull(dr["Password"]))
                        {
                            user.Password =  dr["Password"].ToString();
                        }
                        if (!Convert.IsDBNull(dr["Sex"]))
                        {
                            user.Sex = Convert.ToBoolean(dr["Sex"]);
                        }
                        if (!Convert.IsDBNull(dr["Cellphone"]))
                        {
                            user.Cellphone = dr["Cellphone"].ToString();
                        }
                        if (!Convert.IsDBNull(dr["Telephone"]))
                        {
                            user.Telephone = dr["Telephone"].ToString();
                        }
                        if (!Convert.IsDBNull(dr["Email"]))
                        {
                            user.Email = dr["Email"].ToString();
                        }
                        if (!Convert.IsDBNull(dr["Activity"]))
                        {
                            user.Activity = Convert.ToBoolean(dr["Activity"]);
                        }
                        if (!Convert.IsDBNull(dr["Address"]))
                        {
                            user.Address = dr["Address"].ToString();
                        }
                        if (!Convert.IsDBNull(dr["QQ"]))
                        {
                            user.QQ = dr["QQ"].ToString();
                        }
                        if (!Convert.IsDBNull(dr["Fax"]))
                        {
                            user.Fax = dr["Fax"].ToString();
                        }
                        if (!Convert.IsDBNull(dr["Postcode"]))
                        {
                            user.Postcode = dr["Postcode"].ToString();
                        }
                        if (!Convert.IsDBNull(dr["InUserId"]))
                        {
                            user.InUserId = Convert.ToInt32(dr["InUserId"]);
                        }
                        if (!Convert.IsDBNull(dr["InDate"]))
                        {
                            user.InDate = Convert.ToDateTime(dr["InDate"]);
                        }
                        if (!Convert.IsDBNull(dr["EditUserId"]))
                        {
                            user.EditUserId = Convert.ToInt32(dr["EditUserId"]);
                        }
                        if (!Convert.IsDBNull(dr["EditDate"]))
                        {
                            user.EditDate = Convert.ToDateTime(dr["EditDate"]);
                        }
                        if (!Convert.IsDBNull(dr["Enabled"]))
                        {
                            //user.Enabled = dr["Enabled"].ToString();
                        }
                        if (!Convert.IsDBNull(dr["FirstVisit"]))
                        {
                            user.FirstVisit = Convert.ToDateTime(dr["FirstVisit"]);
                        }
                        if (!Convert.IsDBNull(dr["FirstVisit"]))
                        {
                            user.FirstVisit = Convert.ToDateTime(dr["FirstVisit"]);
                        }
                        if (!Convert.IsDBNull(dr["PreviousVisit"]))
                        {
                            user.PreviousVisit = Convert.ToDateTime(dr["PreviousVisit"]);
                        }
                        if (!Convert.IsDBNull(dr["LastVisit"]))
                        {
                            user.LastVisit = Convert.ToDateTime(dr["LastVisit"]);
                        }
                        if (!Convert.IsDBNull(dr["Question"]))
                        {
                            user.Question = dr["Question"].ToString();
                        }
                        if (!Convert.IsDBNull(dr["Answer"]))
                        {
                            user.Answer = dr["Answer"].ToString();
                        }
                        user.RoleName = !Convert.IsDBNull(dr["RoleName"]) ? dr["RoleName"].ToString() : string.Empty;
                        user.Organization = !Convert.IsDBNull(dr["FullName"]) ? dr["FullName"].ToString() : string.Empty;
                        users.Add(user);
                    }
                }

            }
            return users;
        }
コード例 #6
0
 public int UpdatePassword(User model)
 {
     return _dataAccess.UpdatePassword(model);
 }
コード例 #7
0
 public int Insert(User user)
 {
     return _dataAccess.Insert(user);
 }