Esempio n. 1
0
 protected void getDataByPage(int _pageIndex,int _pageSize)
 {
     DataSet ds = new DataSet();
     DALBase dal = new DALBase();
     ds = dal.GetPagingDataSet("t_Test", " 1=1", "order by d desc", " * ", _pageIndex, _pageSize);
     DataTable dt = ds.Tables[0];
     DataRow[] drs = dt.Select("B='b10'");
     foreach(DataRow dr in drs)
     {
         dr["B"] = "X"+dr["B"].ToString();
     }
     Response.Write(Common.ConvertU.Ds2Json(ds));
     Response.End();
 }
Esempio n. 2
0
        public List <PlanAgentLevel> List()
        {
            List <PlanAgentLevel> list = new DALBase <PlanAgentLevel, DataContext>().List(null, m => m.id);

            return(list);
        }
Esempio n. 3
0
        public List <SubMenu> GetAllSubMenu()
        {
            List <SubMenu> subMenus = DALBase.ExtecuteProcedureReturnData(connectionstring, "spGetSubMenu", r => r.TranslateAsSubMenuList());

            return(subMenus);
        }
        public List <SystemModuleSetMealValidityLog> ListByOrder(long orderId)
        {
            List <SystemModuleSetMealValidityLog> list = new DALBase <SystemModuleSetMealValidityLog, DataContext>().List(m => m.OrderId == orderId, m => m.id);

            return(list);
        }
        public List <SystemModuleSetMealValidityLog> ListByCompany(long companyId)
        {
            List <SystemModuleSetMealValidityLog> list = new DALBase <SystemModuleSetMealValidityLog, DataContext>().List(m => m.CompanyId == companyId, m => m.id);

            return(list);
        }
        public List <CompanyFastModule> ListByUser(long companyId, long userId)
        {
            List <CompanyFastModule> list = new DALBase <CompanyFastModule, DataContext>().List(m => m.CompanyId == companyId && m.UserId == userId, m => m.id);

            return(list);
        }
Esempio n. 7
0
        public int VerifyCheck(long companyId, long userId, int moduleId, int fnId)
        {
            //return 0;
            DALBase <CompanyModule, DataContext> bll = new DALBase <CompanyModule, DataContext>();
            CompanyModule info = bll.Info(m => m.ModuleId == moduleId && m.CompanyId == companyId);
            DALBase <SystemModule, DataContext>     baseModuleBll = new DALBase <SystemModule, DataContext>();
            Expression <Func <SystemModule, bool> > baseCondition = m => m.IsDefault == true;
            List <SystemModule> baseList = baseModuleBll.List(baseCondition, m => m.id);

            Camel.ApiModel.CompanyManageUser userModule = Camel.ApiUserBLL.UserPowerExBLL.CompanyManageGet(companyId, userId);
            if (baseList.Where(m => m.id == moduleId).ToArray().Length > 0)//模块为基本模块
            {
                if (userId == 0)
                {
                    return(0);
                }
                Camel.ApiModel.UserActionType result = Camel.ApiUserBLL.UserPowerExBLL.UserPowerExGet(companyId, userId, moduleId);
                if (userModule.RoleTypeId == 1)//当前为总管理用户
                {
                    return(0);
                }
                if (result == Camel.ApiModel.UserActionType.View)//仅能查看
                {
                    return(1);
                }
                else if (result == Camel.ApiModel.UserActionType.All)//可编辑
                {
                    return(0);
                }
                else
                {
                    return(-3);
                }
            }
            if (info == null)//无购买模块
            {
                return(-1);
            }
            if (info.ValidityDateEnd.CompareTo(DateTime.Now) > -1 && info.ValidityDateStart.CompareTo(DateTime.Now) < 1)
            {
                if (userId == 0)
                {
                    return(0);
                }
                if (userModule.RoleTypeId == 1)//当前为总管理用户
                {
                    return(0);
                }
                Camel.ApiModel.UserActionType result = Camel.ApiUserBLL.UserPowerExBLL.UserPowerExGet(companyId, userId, moduleId);
                if (result == Camel.ApiModel.UserActionType.View)//仅能查看
                {
                    return(1);
                }
                else if (result == Camel.ApiModel.UserActionType.All)//可编辑
                {
                    return(0);
                }
                else
                {
                    return(-3);
                }
            }
            else//模块过期
            {
                return(-2);
            }
        }
Esempio n. 8
0
 protected BLLBase(DALBase dal)
     : this()
 {
     this.dal = dal;
 }