コード例 #1
0
        //public static DataTable ListDataByCode(string TableName, string filter)
        //{
        //    ADOSys_Config_ListPage instance = new ADOSys_Config_ListPage();
        //    string sql = "SELECT * FROM " + TableName + " WHERE (Stat is null or Stat=0) AND " + filter;
        //    return instance.idb.ReturnDataTable(sql);
        //}

        ///// <summary>
        ///// 获取编码
        ///// </summary>
        ///// <param name="sTable"></param>
        ///// <returns></returns>
        //public string GetTableKeyCode(string sTable)
        //{
        //    SqlParameter x1 = new SqlParameter("@sTable", SqlDbType.NChar, 40);
        //    x1.Value = sTable.Trim();
        //    SqlParameter[] param = new SqlParameter[] { x1 };
        //    IDbDataParameter[] parames = param as IDbDataParameter[];
        //    DataTable dt = idb.RunProcReturnDatatable("findnewid", parames);
        //    return dt.Rows[0][0].ToString();
        //}
        ////ADOSys_UserPermission PermissionInstance = new ADOSys_UserPermission();

        /// <summary>
        /// 用户权限列表
        /// </summary>
        /// <param name="UserId">用户编码</param>
        /// <returns>用户权限List</returns>
        //public  List<Sys_UserPermission> UserPermissionList(string UserId)
        //{

        //    List<Sys_UserPermission> ListPermission = PermissionInstance
        //        .GetUserPerimission(UserId);//.Where(o => o.PU_IsCheck == "1" && (!o.PU_FunCode.StartsWith("C"))).ToList();
        //    return ListPermission;
        //}

        //public List<Sys_UserPermission> UserNotPermisionnList(string UserId)
        //{

        //    List<Sys_UserPermission> ListPermission = PermissionInstance
        //        .GetUserPerimission(UserId);//.Where(o => (string.IsNullOrEmpty(o.PU_IsCheck) || o.PU_IsCheck != "1") && (!o.PU_FunCode.StartsWith("C"))).ToList();
        //    return ListPermission;
        //}

        //public  string[] UserPermissionArray(string UserId)
        //{
        //    List<Sys_UserPermission> ListPermission = UserPermissionList(UserId);
        //    string[] StrPermission = new string[ListPermission.Count];
        //    for (var i = 0; i < ListPermission.Count; i++)
        //    {
        //        StrPermission[i] = ListPermission[i].PU_FunCode;
        //    }
        //    return StrPermission;
        //}

        public string GenTableKeyCode(string sTable)
        {
            SqlParameter x1 = new SqlParameter("@sTable", SqlDbType.NChar, 40);

            x1.Value = sTable.Trim();
            SqlParameter[]     param   = new SqlParameter[] { x1 };
            IDbDataParameter[] parames = param as IDbDataParameter[];
            DataTable          dt      = idb.RunProcReturnDatatable("findnewid", parames);

            return(dt.Rows[0][0].ToString());
        }