Example #1
0
        /// <summary>
        /// 权限更新
        /// </summary>
        /// <param name="userCode"></param>
        /// <param name="list"></param>
        /// <returns></returns>
        public bool UpdatePermission(string userCode, List <Sys_UserPermission> list)
        {
            List <Sys_UserPermission> oldlist = GetListByCode(string.Format("AND PU_UserCode='{0}'", userCode));

            foreach (var u in oldlist)
            {
                var mo = list.FirstOrDefault(o => o.PU_FunCode == u.PU_FunCode);
                if (mo != null)
                {
                    u.PU_IsCheck = "1";
                    Update(u);
                    list.Remove(mo);
                }
                else
                {
                    u.Stat       = 1;
                    u.PU_IsCheck = "0";
                    // u.PU_IsCheck = "0";
                    Update(u);
                }
            }
            foreach (var uu in list)
            {
                Sys_UserPermission per = new Sys_UserPermission();
                per.PU_Code     = GenereatePermissionCode();
                per.PU_UserCode = userCode;
                per.PU_FunCode  = uu.PU_FunCode;
                per.PU_IsCheck  = "1";
                Insert(per);
            }
            return(true);
        }
Example #2
0
        public bool AddOrUpdatePermission(string userName,List<Sys_UserPermission> list)
        {
            List<Sys_UserPermission> oldlist = GetUserPermissionList(userName);
            foreach (Sys_UserPermission item in oldlist)
            {
                var temp = list.FirstOrDefault(o => o.PU_Code == item.PU_Code);
                if (temp != null)
                {
                    list.Remove(temp);
                }
                else
                {
                    DeleteUserPermission(item);
                }
            }

            foreach (var it in list)
            {
                Sys_UserPermission bs = new Sys_UserPermission();
                bs = it;
                bs.PU_Code = GeneratePermissioCode();
                AddUserPermission(bs);
            }

            return true;
        }
Example #3
0
        public ActionResult UpdatePermission(string id)
        {
            string ids = Request["data"];
            List <Sys_UserPermission> list = new List <Sys_UserPermission>();

            if (!string.IsNullOrEmpty(ids))
            {
                var array = ids.TrimEnd(',').Split(',');
                foreach (var p in array)
                {
                    Sys_UserPermission s = new Sys_UserPermission();
                    s.PU_FunCode = p;
                    list.Add(s);
                }

                var flag = upInstance.UpdatePermission(id, list);
                return(new JsonResult {
                    Data = new { result = "Success", Msg = "数据更新成功!" }
                });
            }
            else
            {
                List <Sys_UserPermission> list1 = new List <Sys_UserPermission>();
                var flag = upInstance.UpdatePermission(id, list1);
                return(new JsonResult {
                    Data = new { result = "Success", Msg = "数据更新成功!" }
                });
            }

            //return new JsonResult { Data = new { result = "Fail", Msg = "数据更新失败!" } };
        }
Example #4
0
        public void RegisterUser(string firstName, string lastName, string email, string password)
        {
            if (String.IsNullOrEmpty(firstName))
            {
                throw new IntiGeneralException("Du måste ange ett förnamn");
            }

            if (String.IsNullOrEmpty(lastName))
            {
                throw new IntiGeneralException("Du måste ange ett efternamn");
            }

            if (String.IsNullOrEmpty(email))
            {
                throw new IntiGeneralException("Du måste ange en epostadress");
            }

            if (String.IsNullOrEmpty(password))
            {
                throw new IntiGeneralException("Du måste ange ett lösenord");
            }

            using (var db = new IntiDataContext(_connectionString))
            {
                //username/email must be unique
                var users = from u in db.Sys_User
                            where u.UserName.ToLower() == email.ToLower()
                            select u;

                if (users.ToList().Count > 0)
                {
                    throw new IntiGeneralException("Det finns redan en användare med den epostadressen");
                }


                var user = new Sys_User {
                    FirstName = firstName, LastName = lastName, UserName = email, Password = password
                };

                db.Sys_User.InsertOnSubmit(user);

                //default permissions
                var defaultPermissions = from p in db.Sys_Permission
                                         where p.Name == "USER" || p.Name == "USER_PVTTOUR"
                                         select p;

                foreach (var perm in defaultPermissions.ToList())
                {
                    var userPerm = new Sys_UserPermission();
                    userPerm.UserGUID       = user.GUID;
                    userPerm.PermissionGUID = perm.GUID;
                    db.Sys_UserPermission.InsertOnSubmit(userPerm);
                }

                db.SubmitChanges();
            }
        }
Example #5
0
        public bool AddUserPermission(Sys_UserPermission p)
        {
            bool flag = false;

            if (perInstance.Add(p) > 0)
            {
                flag = true;
            }

            return flag;
        }
Example #6
0
        /// <summary>
        /// 更新数据
        /// </summary>
        /// <param name='model'>实体</param>
        /// <returns>bool</returns>
        public bool Update(Sys_UserPermission model)
        {
            bool result  = false;
            var  e       = new ModelExceptions();
            int  _rseult = instance.Update(model);

            if (_rseult > 0)
            {
                result = true;
            }
            return(result);
        }
Example #7
0
        public bool DeleteUserPermission(Sys_UserPermission p)
        {
            bool flag = false;

            p.Stat = 1;

            if (perInstance.Update(p) > 0)
            {
                flag = true;
            }

            return flag;
        }
Example #8
0
        /// <summary>
        /// 获取实体数据
        /// </summary>
        /// <param name='strCondition'>条件(AND Code='11')</param>
        /// <returns>model</returns>
        public Sys_UserPermission GetModel(string strCondition)
        {
            List <Sys_UserPermission> list  = instance.GetListByWhere(strCondition);
            Sys_UserPermission        model = new Sys_UserPermission();

            if (list != null && list.Count > 0)
            {
                model = list[0];
            }
            else
            {
                model = null;
            }
            return(model);
        }
Example #9
0
        /// <summary>
        /// 插入数据
        /// </summary>
        /// <param name='model'>实体</param>
        /// <param name='model'>是否完成验证</param>
        /// <returns>bool</returns>
        public bool Insert(Sys_UserPermission model, bool IsValid)
        {
            var  e      = new ModelExceptions();
            bool result = false;

            if (e.IsValid && IsValid)
            {
                //完成了验证,开始更新数据库了
                int _result = instance.Add(model);
                if (_result > 0)
                {
                    result = true;
                }
            }
            return(result);
        }
Example #10
0
        /// <summary>
        /// 逻辑删除数据
        /// </summary>
        /// <param name='model'>model</param>
        /// <returns>bool</returns>
        public bool Delete(string Condition)
        {
            bool result = false;
            List <Sys_UserPermission> list = instance.GetListByWhere(Condition);

            if (list.Count > 0)
            {
                Sys_UserPermission model = list[0];
                model.Stat = 1;
                int _rseult = instance.Update(model);
                if (_rseult > 0)
                {
                    result = true;
                }
            }
            return(result);
        }
Example #11
0
        /// <summary>
        /// 插入数据
        /// </summary>
        /// <param name='model'>实体</param>
        /// <returns>bool</returns>
        public bool Insert(Sys_UserPermission model)
        {
            bool result = false;

            try
            {
                int _result = instance.Add(model);
                if (_result > 0)
                {
                    result = true;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(result);
        }
        /// <summary>
        /// 获取用户权限点列表
        /// </summary>
        /// <param name="UserId">用户编码</param>
        /// <returns>用户权限点列表(含有权限和没有权限的所有节点)</returns>
        public List <Sys_UserPermission> GetUserPerimission(string UserId)
        {
            List <Sys_UserPermission> ret = new List <Sys_UserPermission>();
            string        sql             = @"SELECT  PU_ID,PU_Code,PU_UserCode,PU_FunName,PU_FunCode,PU_FunPCode,PU_UDef1,PU_UDef2,PU_UDef3,PU_IsCheck,Fun_UDef1
                            FROM Sys_UserPermission p,Sys_Function f where
                            ISNULL(p.Stat,0)=0 AND ISNULL(f.Stat,0)=0
                            and f.Fun_Code=p.PU_FunCode
                            and p.PU_UserCode='" + UserId + "' ";
            SqlDataReader dr = null;

            try
            {
                dr = (SqlDataReader)idb.ReturnReader(sql);
                while (dr.Read())
                {
                    Sys_UserPermission sys_UserPermission = new Sys_UserPermission();
                    if (dr["PU_ID"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_ID = Convert.ToDecimal(dr["PU_ID"]);
                    }
                    if (dr["PU_Code"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_Code = Convert.ToString(dr["PU_Code"]);
                    }
                    if (dr["PU_UserCode"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_UserCode = Convert.ToString(dr["PU_UserCode"]);
                    }
                    if (dr["PU_FunName"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_FunName = Convert.ToString(dr["PU_FunName"]);
                    }
                    if (dr["PU_FunCode"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_FunCode = Convert.ToString(dr["PU_FunCode"]);
                    }
                    if (dr["PU_FunPCode"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_FunPCode = Convert.ToString(dr["PU_FunPCode"]);
                    }
                    if (dr["PU_UDef1"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_UDef1 = Convert.ToString(dr["PU_UDef1"]);
                    }
                    if (dr["PU_UDef2"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_UDef2 = Convert.ToString(dr["PU_UDef2"]);
                    }
                    if (dr["PU_UDef3"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_UDef3 = Convert.ToString(dr["PU_UDef3"]);
                    }
                    if (dr["PU_IsCheck"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_IsCheck = Convert.ToString(dr["PU_IsCheck"]);
                    }
                    //if (dr["Stat"] != DBNull.Value) sys_UserPermission.Stat = Convert.ToInt32(dr["Stat"]);
                    //if (dr["CreateDate"] != DBNull.Value) sys_UserPermission.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
                    //if (dr["UpdateDate"] != DBNull.Value) sys_UserPermission.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]);
                    //if (dr["DeleteDate"] != DBNull.Value) sys_UserPermission.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]);
                    if (dr["Fun_UDef1"] != DBNull.Value)
                    {
                        sys_UserPermission.Fun_UDef1 = Convert.ToString(dr["Fun_UDef1"]);
                    }

                    ret.Add(sys_UserPermission);
                }
            }
            catch (System.Exception ex) { throw ex; }
            finally { if (dr != null)
                      {
                          dr.Close();
                      }
                      if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
                      {
                          idb.GetConnection().Close();
                      }
            }
            return(ret);
        }
Example #13
0
        /// <summary>
        /// 获取实体数据
        /// </summary>
        /// <param name='strCondition'>条件(AND Code='11')</param>
        /// <returns>model</returns>
        public Sys_UserPermission GetModel(int id)
        {
            Sys_UserPermission model = instance.GetByKey(id);

            return(model);
        }
Example #14
0
        public void SaveUser(Guid userGuid, string userName, string firstName, string lastName, List <Guid> permissionGuids)
        {
            using (var db = new IntiDataContext(_connectionString))
            {
                var user = db.Sys_User.Single(u => u.GUID == userGuid);

                //is user name still unique?
                if (userName != user.UserName)
                {
                    var users = from u in db.Sys_User
                                where u.UserName == userName &&
                                u.GUID != userGuid
                                select u;

                    if (users.ToList().Count > 0)
                    {
                        throw new Exception(String.Format("The Username {0} not unique", userName));
                    }
                }

                var message = "";
                if (user.UserName != userName)
                {
                    message      += String.Format("Changed {0} from {1} to {2}. ", "UserName", user.UserName, userName);
                    user.UserName = userName;
                }

                if (user.FirstName != firstName)
                {
                    message       += String.Format("Changed {0} from {1} to {2}. ", "FirstName", user.FirstName, firstName);
                    user.FirstName = firstName;
                }

                if (user.LastName != lastName)
                {
                    message      += String.Format("Changed {0} from {1} to {2}. ", "LastName", user.LastName, lastName);
                    user.LastName = lastName;
                }

                if (!String.IsNullOrEmpty(message))
                {
                    LogEvent(userGuid, user.GetType(), SessionProperties.UserGuid, SessionProperties.ClientInfo, EventType.Change, message);
                }

                //clear permissions
                var userPermissions = from up in db.Sys_UserPermission
                                      where up.UserGUID == userGuid
                                      select up;

                foreach (Sys_UserPermission userPermission in userPermissions.ToList())
                {
                    if (permissionGuids.Contains(userPermission.PermissionGUID))
                    {
                        permissionGuids.Remove(userPermission.PermissionGUID);
                    }
                    else
                    {
                        db.Sys_UserPermission.DeleteOnSubmit(userPermission);
                        LogEvent(userGuid, user.GetType(), SessionProperties.UserGuid, SessionProperties.ClientInfo, EventType.Change, "Removed permission " + userPermission.Sys_Permission.Name);
                    }
                }

                foreach (Guid permissionGuid in permissionGuids)
                {
                    var userPermission = new Sys_UserPermission();
                    userPermission.UserGUID       = userGuid;
                    userPermission.PermissionGUID = permissionGuid;

                    Guid guid       = permissionGuid;
                    var  permission = db.Sys_Permission.Single(p => p.GUID == guid);
                    LogEvent(userGuid, user.GetType(), SessionProperties.UserGuid, SessionProperties.ClientInfo, EventType.Change, "Added permission " + permission.Name);

                    db.Sys_UserPermission.InsertOnSubmit(userPermission);
                }

                db.SubmitChanges();
            }
        }
Example #15
0
        /// <summary>
        /// 获取所有的Sys_UserPermission对象(即:一条记录
        /// </summary>
        public List <Sys_UserPermission> GetAll()
        {
            List <Sys_UserPermission> ret = new List <Sys_UserPermission>();
            string        sql             = "SELECT  PU_ID,PU_Code,PU_UserCode,PU_FunName,PU_FunCode,PU_FunPCode,PU_UDef1,PU_UDef2,PU_UDef3,PU_IsCheck,Stat,CreateDate,UpdateDate,DeleteDate FROM Sys_UserPermission where 1=1 AND ((Stat is null) or (Stat=0) ) ";
            SqlDataReader dr = null;

            try {
                dr = (SqlDataReader)idb.ReturnReader(sql);
                while (dr.Read())
                {
                    Sys_UserPermission sys_UserPermission = new Sys_UserPermission();
                    if (dr["PU_ID"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_ID = Convert.ToDecimal(dr["PU_ID"]);
                    }
                    if (dr["PU_Code"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_Code = Convert.ToString(dr["PU_Code"]);
                    }
                    if (dr["PU_UserCode"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_UserCode = Convert.ToString(dr["PU_UserCode"]);
                    }
                    if (dr["PU_FunName"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_FunName = Convert.ToString(dr["PU_FunName"]);
                    }
                    if (dr["PU_FunCode"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_FunCode = Convert.ToString(dr["PU_FunCode"]);
                    }
                    if (dr["PU_FunPCode"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_FunPCode = Convert.ToString(dr["PU_FunPCode"]);
                    }
                    if (dr["PU_UDef1"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_UDef1 = Convert.ToString(dr["PU_UDef1"]);
                    }
                    if (dr["PU_UDef2"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_UDef2 = Convert.ToString(dr["PU_UDef2"]);
                    }
                    if (dr["PU_UDef3"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_UDef3 = Convert.ToString(dr["PU_UDef3"]);
                    }
                    if (dr["PU_IsCheck"] != DBNull.Value)
                    {
                        sys_UserPermission.PU_IsCheck = Convert.ToString(dr["PU_IsCheck"]);
                    }
                    if (dr["Stat"] != DBNull.Value)
                    {
                        sys_UserPermission.Stat = Convert.ToInt32(dr["Stat"]);
                    }
                    if (dr["CreateDate"] != DBNull.Value)
                    {
                        sys_UserPermission.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
                    }
                    if (dr["UpdateDate"] != DBNull.Value)
                    {
                        sys_UserPermission.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]);
                    }
                    if (dr["DeleteDate"] != DBNull.Value)
                    {
                        sys_UserPermission.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]);
                    }
                    ret.Add(sys_UserPermission);
                }
            }catch (System.Exception ex) { throw ex; }  finally { if (dr != null)
                                                                  {
                                                                      dr.Close();
                                                                  }
                                                                  if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
                                                                  {
                                                                      idb.GetConnection().Close();
                                                                  }
            }
            return(ret);
        }
Example #16
0
        /// <summary>
        /// 更新Sys_UserPermission对象(即:一条记录
        /// </summary>
        public int Update(Sys_UserPermission sys_UserPermission)
        {
            StringBuilder sbParameter = new StringBuilder();
            StringBuilder sb          = new StringBuilder();

            sb.Append(@"UPDATE       Sys_UserPermission       SET ");
            if (sys_UserPermission.PU_Code_IsChanged)
            {
                sbParameter.Append("PU_Code=@PU_Code, ");
            }
            if (sys_UserPermission.PU_UserCode_IsChanged)
            {
                sbParameter.Append("PU_UserCode=@PU_UserCode, ");
            }
            if (sys_UserPermission.PU_FunName_IsChanged)
            {
                sbParameter.Append("PU_FunName=@PU_FunName, ");
            }
            if (sys_UserPermission.PU_FunCode_IsChanged)
            {
                sbParameter.Append("PU_FunCode=@PU_FunCode, ");
            }
            if (sys_UserPermission.PU_FunPCode_IsChanged)
            {
                sbParameter.Append("PU_FunPCode=@PU_FunPCode, ");
            }
            if (sys_UserPermission.PU_UDef1_IsChanged)
            {
                sbParameter.Append("PU_UDef1=@PU_UDef1, ");
            }
            if (sys_UserPermission.PU_UDef2_IsChanged)
            {
                sbParameter.Append("PU_UDef2=@PU_UDef2, ");
            }
            if (sys_UserPermission.PU_UDef3_IsChanged)
            {
                sbParameter.Append("PU_UDef3=@PU_UDef3, ");
            }
            if (sys_UserPermission.PU_IsCheck_IsChanged)
            {
                sbParameter.Append("PU_IsCheck=@PU_IsCheck, ");
            }
            if (sys_UserPermission.Stat_IsChanged)
            {
                sbParameter.Append("Stat=@Stat, ");
            }
            if (sys_UserPermission.CreateDate_IsChanged)
            {
                sbParameter.Append("CreateDate=@CreateDate, ");
            }
            if (sys_UserPermission.UpdateDate_IsChanged)
            {
                sbParameter.Append("UpdateDate=@UpdateDate, ");
            }
            if (sys_UserPermission.DeleteDate_IsChanged)
            {
                sbParameter.Append("DeleteDate=@DeleteDate ");
            }
            sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
            sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0))   and PU_ID=@PU_ID; ");
            string sql = sb.ToString();

            if (sys_UserPermission.PU_Code_IsChanged)
            {
                if (string.IsNullOrEmpty(sys_UserPermission.PU_Code))
                {
                    idb.AddParameter("@PU_Code", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@PU_Code", sys_UserPermission.PU_Code);
                }
            }
            if (sys_UserPermission.PU_UserCode_IsChanged)
            {
                if (string.IsNullOrEmpty(sys_UserPermission.PU_UserCode))
                {
                    idb.AddParameter("@PU_UserCode", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@PU_UserCode", sys_UserPermission.PU_UserCode);
                }
            }
            if (sys_UserPermission.PU_FunName_IsChanged)
            {
                if (string.IsNullOrEmpty(sys_UserPermission.PU_FunName))
                {
                    idb.AddParameter("@PU_FunName", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@PU_FunName", sys_UserPermission.PU_FunName);
                }
            }
            if (sys_UserPermission.PU_FunCode_IsChanged)
            {
                if (string.IsNullOrEmpty(sys_UserPermission.PU_FunCode))
                {
                    idb.AddParameter("@PU_FunCode", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@PU_FunCode", sys_UserPermission.PU_FunCode);
                }
            }
            if (sys_UserPermission.PU_FunPCode_IsChanged)
            {
                if (string.IsNullOrEmpty(sys_UserPermission.PU_FunPCode))
                {
                    idb.AddParameter("@PU_FunPCode", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@PU_FunPCode", sys_UserPermission.PU_FunPCode);
                }
            }
            if (sys_UserPermission.PU_UDef1_IsChanged)
            {
                if (string.IsNullOrEmpty(sys_UserPermission.PU_UDef1))
                {
                    idb.AddParameter("@PU_UDef1", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@PU_UDef1", sys_UserPermission.PU_UDef1);
                }
            }
            if (sys_UserPermission.PU_UDef2_IsChanged)
            {
                if (string.IsNullOrEmpty(sys_UserPermission.PU_UDef2))
                {
                    idb.AddParameter("@PU_UDef2", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@PU_UDef2", sys_UserPermission.PU_UDef2);
                }
            }
            if (sys_UserPermission.PU_UDef3_IsChanged)
            {
                if (string.IsNullOrEmpty(sys_UserPermission.PU_UDef3))
                {
                    idb.AddParameter("@PU_UDef3", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@PU_UDef3", sys_UserPermission.PU_UDef3);
                }
            }
            if (sys_UserPermission.PU_IsCheck_IsChanged)
            {
                if (string.IsNullOrEmpty(sys_UserPermission.PU_IsCheck))
                {
                    idb.AddParameter("@PU_IsCheck", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@PU_IsCheck", sys_UserPermission.PU_IsCheck);
                }
            }
            if (sys_UserPermission.Stat_IsChanged)
            {
                if (sys_UserPermission.Stat == 0)
                {
                    idb.AddParameter("@Stat", 0);
                }
                else
                {
                    idb.AddParameter("@Stat", sys_UserPermission.Stat);
                }
            }
            if (sys_UserPermission.CreateDate_IsChanged)
            {
                if (sys_UserPermission.CreateDate == DateTime.MinValue)
                {
                    idb.AddParameter("@CreateDate", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@CreateDate", sys_UserPermission.CreateDate);
                }
            }
            if (sys_UserPermission.UpdateDate_IsChanged)
            {
                if (sys_UserPermission.UpdateDate == DateTime.MinValue)
                {
                    idb.AddParameter("@UpdateDate", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@UpdateDate", sys_UserPermission.UpdateDate);
                }
            }
            if (sys_UserPermission.DeleteDate_IsChanged)
            {
                if (sys_UserPermission.DeleteDate == DateTime.MinValue)
                {
                    idb.AddParameter("@DeleteDate", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@DeleteDate", sys_UserPermission.DeleteDate);
                }
            }

            idb.AddParameter("@PU_ID", sys_UserPermission.PU_ID);

            return(idb.ExeCmd(sql));
        }
Example #17
0
        /// <summary>
        /// 添加Sys_UserPermission对象(即:一条记录)
        /// </summary>
        public int Add(Sys_UserPermission sys_UserPermission)
        {
            string sql = "INSERT INTO Sys_UserPermission (PU_Code,PU_UserCode,PU_FunName,PU_FunCode,PU_FunPCode,PU_UDef1,PU_UDef2,PU_UDef3,PU_IsCheck,Stat,CreateDate,UpdateDate,DeleteDate) VALUES (@PU_Code,@PU_UserCode,@PU_FunName,@PU_FunCode,@PU_FunPCode,@PU_UDef1,@PU_UDef2,@PU_UDef3,@PU_IsCheck,@Stat,@CreateDate,@UpdateDate,@DeleteDate)";

            if (string.IsNullOrEmpty(sys_UserPermission.PU_Code))
            {
                idb.AddParameter("@PU_Code", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@PU_Code", sys_UserPermission.PU_Code);
            }
            if (string.IsNullOrEmpty(sys_UserPermission.PU_UserCode))
            {
                idb.AddParameter("@PU_UserCode", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@PU_UserCode", sys_UserPermission.PU_UserCode);
            }
            if (string.IsNullOrEmpty(sys_UserPermission.PU_FunName))
            {
                idb.AddParameter("@PU_FunName", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@PU_FunName", sys_UserPermission.PU_FunName);
            }
            if (string.IsNullOrEmpty(sys_UserPermission.PU_FunCode))
            {
                idb.AddParameter("@PU_FunCode", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@PU_FunCode", sys_UserPermission.PU_FunCode);
            }
            if (string.IsNullOrEmpty(sys_UserPermission.PU_FunPCode))
            {
                idb.AddParameter("@PU_FunPCode", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@PU_FunPCode", sys_UserPermission.PU_FunPCode);
            }
            if (string.IsNullOrEmpty(sys_UserPermission.PU_UDef1))
            {
                idb.AddParameter("@PU_UDef1", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@PU_UDef1", sys_UserPermission.PU_UDef1);
            }
            if (string.IsNullOrEmpty(sys_UserPermission.PU_UDef2))
            {
                idb.AddParameter("@PU_UDef2", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@PU_UDef2", sys_UserPermission.PU_UDef2);
            }
            if (string.IsNullOrEmpty(sys_UserPermission.PU_UDef3))
            {
                idb.AddParameter("@PU_UDef3", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@PU_UDef3", sys_UserPermission.PU_UDef3);
            }
            if (string.IsNullOrEmpty(sys_UserPermission.PU_IsCheck))
            {
                idb.AddParameter("@PU_IsCheck", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@PU_IsCheck", sys_UserPermission.PU_IsCheck);
            }
            if (sys_UserPermission.Stat == 0)
            {
                idb.AddParameter("@Stat", 0);
            }
            else
            {
                idb.AddParameter("@Stat", sys_UserPermission.Stat);
            }
            if (sys_UserPermission.CreateDate == DateTime.MinValue)
            {
                idb.AddParameter("@CreateDate", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@CreateDate", sys_UserPermission.CreateDate);
            }
            if (sys_UserPermission.UpdateDate == DateTime.MinValue)
            {
                idb.AddParameter("@UpdateDate", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@UpdateDate", sys_UserPermission.UpdateDate);
            }
            if (sys_UserPermission.DeleteDate == DateTime.MinValue)
            {
                idb.AddParameter("@DeleteDate", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@DeleteDate", sys_UserPermission.DeleteDate);
            }

            return(idb.ExeCmd(sql));
        }