/// <summary>
        /// 删除一条记录
        /// </summary>
        /// <param name="entity">待删除的实体对象</param>
        /// <returns>true:删除成功 false:删除失败</returns>
        public virtual bool Delete(Mod_Online_YearPlanEntity entity)
        {
            SQL sql = SQL.Build("DELETE FROM Mod_Online_YearPlan WHERE PlanId=?", entity.PlanId);

            return(SqlMap <Mod_Online_YearPlanEntity> .ParseSql(sql).Execute() > 0);
        }
        /// <summary>
        /// 添加一条记录
        /// </summary>
        /// <param name="entity">待添加的实体对象</param>
        /// <returns>true:添加成功 false:添加失败</returns>
        public bool Add(Mod_Online_School_MajorEntity entity, IDataProvider provider)
        {
            SQL sql = SQL.Build("INSERT INTO Mod_Online_School_Major(SchoolMajorId,SchoolMajorName,SchoolId,SchoolName,StateFlag,OrderIndex,DeleteFlag,ExtFlag) VALUES(?,?,?,?,?,?,?,?)", entity.SchoolMajorId, entity.SchoolMajorName, entity.SchoolId, entity.SchoolName, entity.StateFlag, entity.OrderIndex, entity.DeleteFlag, entity.ExtFlag);

            return(SqlMap <Mod_Online_School_MajorEntity> .ParseSql(sql).Execute(provider) > 0);
        }
Beispiel #3
0
        /// <summary>
        /// 更新一条记录
        /// </summary>
        /// <param name="entity">待更新的实体对象</param>
        /// <returns>true:更新成功 false:更新失败</returns>
        public bool Update(Base_UserEntity entity, IDataProvider provider)
        {
            SQL sql = SQL.Build("UPDATE Base_User SET UserName=?,Sex=?,Account=?,Pwd=?,UserTypeId=?,CreateDeptId=?,StateFlag=?,DeleteFlag=?,OrderIndex=?,ExtFlag=? WHERE UserId=?", entity.UserName, entity.Sex, entity.Account, entity.Pwd, entity.UserTypeId, entity.CreateDeptId, entity.StateFlag, entity.DeleteFlag, entity.OrderIndex, entity.ExtFlag, entity.UserId);

            return(SqlMap <Base_UserEntity> .ParseSql(sql).Execute(provider) > 0);
        }
        /// <summary>
        /// 删除一条记录
        /// </summary>
        /// <param name="entity">待删除的实体对象</param>
        /// <returns>true:删除成功 false:删除失败</returns>
        public virtual bool Delete(Mod_Online_School_MajorEntity entity)
        {
            SQL sql = SQL.Build("DELETE FROM Mod_Online_School_Major WHERE SchoolMajorId=?", entity.SchoolMajorId);

            return(SqlMap <Mod_Online_School_MajorEntity> .ParseSql(sql).Execute() > 0);
        }
        /// <summary>
        /// 根据主键获取Json对象
        /// </summary>
        /// <param name="schoolMajorId">学校专业编号</param>
        /// <returns>Json对象</returns>
        public virtual string GetJsonModel(string schoolMajorId)
        {
            SQL sql = SQL.Build("SELECT * FROM Mod_Online_School_Major WHERE SchoolMajorId=?", schoolMajorId);

            return(SqlMap <Mod_Online_School_MajorEntity> .ParseSql(sql).ToJsonObject());
        }
Beispiel #6
0
        /// <summary>
        /// 获取Json对象列表
        /// </summary>
        /// <returns>Json对象列表</returns>
        public virtual string GetJsonList()
        {
            SQL sql = SQL.Build("SELECT * FROM Mod_Online_ApplicationType");

            return(SqlMap <Mod_Online_ApplicationTypeEntity> .ParseSql(sql).ToJsonList());
        }
Beispiel #7
0
        /// <summary>
        /// 更新一条记录
        /// </summary>
        /// <param name="entity">待更新的实体对象</param>
        /// <returns>true:更新成功 false:更新失败</returns>
        public virtual bool Update(Mod_Online_ApplicationTypeEntity entity)
        {
            SQL sql = SQL.Build("UPDATE Mod_Online_ApplicationType SET AppTypeName=?,StateFlag=?,OrderIndex=?,DeleteFlag=?,ExtFlag=? WHERE AppTypeId=?", entity.AppTypeName, entity.StateFlag, entity.OrderIndex, entity.DeleteFlag, entity.ExtFlag, entity.AppTypeId);

            return(SqlMap <Mod_Online_ApplicationTypeEntity> .ParseSql(sql).Execute() > 0);
        }
        /// <summary>
        /// 删除一条记录
        /// </summary>
        /// <param name="id">主键编号</param>
        /// <returns>true:删除成功 false:删除失败</returns>
        public bool Delete(string id, IDataProvider provider)
        {
            SQL sql = SQL.Build("DELETE FROM Mod_Online_YearPlan_Detail_MajorCode WHERE Id=?", id);

            return(SqlMap <Mod_Online_YearPlan_Detail_MajorCodeEntity> .ParseSql(sql).Execute(provider) > 0);
        }
        /// <summary>
        /// 删除一条记录
        /// </summary>
        /// <param name="entity">待删除的实体对象</param>
        /// <returns>true:删除成功 false:删除失败</returns>
        public virtual bool Delete(Mod_Online_YearPlan_Detail_MajorCodeEntity entity)
        {
            SQL sql = SQL.Build("DELETE FROM Mod_Online_YearPlan_Detail_MajorCode WHERE Id=?", entity.Id);

            return(SqlMap <Mod_Online_YearPlan_Detail_MajorCodeEntity> .ParseSql(sql).Execute() > 0);
        }
        /// <summary>
        /// 添加一条记录
        /// </summary>
        /// <param name="entity">待添加的实体对象</param>
        /// <returns>true:添加成功 false:添加失败</returns>
        public virtual bool Add(Mod_Online_YearPlanEntity entity)
        {
            SQL sql = SQL.Build("INSERT INTO Mod_Online_YearPlan(PlanId,YearId,PlanName,StateFlag,OrderIndex,DeleteFlag,ExtFlag) VALUES(?,?,?,?,?,?,?)", entity.PlanId, entity.YearId, entity.PlanName, entity.StateFlag, entity.OrderIndex, entity.DeleteFlag, entity.ExtFlag);

            return(SqlMap <Mod_Online_YearPlanEntity> .ParseSql(sql).Execute() > 0);
        }
Beispiel #11
0
        /// <summary>
        /// 获取学校列表
        /// </summary>
        /// <param name="shcoolNameStr">学校名称列表</param>
        /// <returns>学校列表</returns>
        public List <Mod_Online_SchoolEntity> GetSchoolList(string shcoolNameStr)
        {
            SQL sql = SQL.Format("SELECT * FROM Mod_Online_School WHERE SchoolName IN({0})", shcoolNameStr);

            return(SqlMap <Mod_Online_SchoolEntity> .ParseSql(sql).ToList());
        }
        /// <summary>
        /// 获取对象列表
        /// </summary>
        /// <returns>对象列表</returns>
        public virtual List <Mod_Online_YearPlanEntity> GetList()
        {
            SQL sql = SQL.Build("SELECT * FROM Mod_Online_YearPlan");

            return(SqlMap <Mod_Online_YearPlanEntity> .ParseSql(sql).ToList());
        }
        /// <summary>
        /// 根据主键获取Json对象
        /// </summary>
        /// <param name="planId">计划编号</param>
        /// <returns>Json对象</returns>
        public virtual string GetJsonModel(string planId)
        {
            SQL sql = SQL.Build("SELECT * FROM Mod_Online_YearPlan WHERE PlanId=?", planId);

            return(SqlMap <Mod_Online_YearPlanEntity> .ParseSql(sql).ToJsonObject());
        }
        /// <summary>
        /// 根据主键判断该记录是否存在
        /// </summary>
        /// <param name="planId">计划编号</param>
        /// <returns>true:存在,false:不存在</returns>
        public virtual bool Exists(string planId)
        {
            SQL sql = SQL.Build("SELECT COUNT(*) FROM Mod_Online_YearPlan WHERE PlanId=?", planId);

            return(Convert.ToInt32(SqlMap <Mod_Online_YearPlanEntity> .ParseSql(sql).First()) > 0);
        }
Beispiel #15
0
        /// <summary>
        /// 根据主键判断该记录是否存在
        /// </summary>
        /// <param name="appTypeId">类型编号</param>
        /// <returns>true:存在,false:不存在</returns>
        public virtual bool Exists(string appTypeId)
        {
            SQL sql = SQL.Build("SELECT COUNT(*) FROM Mod_Online_ApplicationType WHERE AppTypeId=?", appTypeId);

            return(Convert.ToInt32(SqlMap <Mod_Online_ApplicationTypeEntity> .ParseSql(sql).First()) > 0);
        }
        /// <summary>
        /// 根据主键判断该记录是否存在
        /// </summary>
        /// <param name="id">主键编号</param>
        /// <returns>true:存在,false:不存在</returns>
        public virtual bool Exists(string id)
        {
            SQL sql = SQL.Build("SELECT COUNT(*) FROM Mod_Online_YearPlan_Detail_MajorCode WHERE Id=?", id);

            return(Convert.ToInt32(SqlMap <Mod_Online_YearPlan_Detail_MajorCodeEntity> .ParseSql(sql).First()) > 0);
        }
Beispiel #17
0
        /// <summary>
        /// 根据主键获取Json对象
        /// </summary>
        /// <param name="appTypeId">类型编号</param>
        /// <returns>Json对象</returns>
        public virtual string GetJsonModel(string appTypeId)
        {
            SQL sql = SQL.Build("SELECT * FROM Mod_Online_ApplicationType WHERE AppTypeId=?", appTypeId);

            return(SqlMap <Mod_Online_ApplicationTypeEntity> .ParseSql(sql).ToJsonObject());
        }
        /// <summary>
        /// 根据主键获取Json对象
        /// </summary>
        /// <param name="id">主键编号</param>
        /// <returns>Json对象</returns>
        public virtual string GetJsonModel(string id)
        {
            SQL sql = SQL.Build("SELECT * FROM Mod_Online_YearPlan_Detail_MajorCode WHERE Id=?", id);

            return(SqlMap <Mod_Online_YearPlan_Detail_MajorCodeEntity> .ParseSql(sql).ToJsonObject());
        }
Beispiel #19
0
        /// <summary>
        /// 添加一条记录
        /// </summary>
        /// <param name="entity">待添加的实体对象</param>
        /// <returns>true:添加成功 false:添加失败</returns>
        public bool Add(Mod_Online_ApplicationTypeEntity entity, IDataProvider provider)
        {
            SQL sql = SQL.Build("INSERT INTO Mod_Online_ApplicationType(AppTypeId,AppTypeName,StateFlag,OrderIndex,DeleteFlag,ExtFlag) VALUES(?,?,?,?,?,?)", entity.AppTypeId, entity.AppTypeName, entity.StateFlag, entity.OrderIndex, entity.DeleteFlag, entity.ExtFlag);

            return(SqlMap <Mod_Online_ApplicationTypeEntity> .ParseSql(sql).Execute(provider) > 0);
        }
        /// <summary>
        /// 获取Json对象列表
        /// </summary>
        /// <returns>Json对象列表</returns>
        public virtual string GetJsonList()
        {
            SQL sql = SQL.Build("SELECT * FROM Mod_Online_YearPlan_Detail_MajorCode");

            return(SqlMap <Mod_Online_YearPlan_Detail_MajorCodeEntity> .ParseSql(sql).ToJsonList());
        }
        /// <summary>
        /// 删除一条记录
        /// </summary>
        /// <param name="schoolMajorId">学校专业编号</param>
        /// <returns>true:删除成功 false:删除失败</returns>
        public bool Delete(string schoolMajorId, IDataProvider provider)
        {
            SQL sql = SQL.Build("DELETE FROM Mod_Online_School_Major WHERE SchoolMajorId=?", schoolMajorId);

            return(SqlMap <Mod_Online_School_MajorEntity> .ParseSql(sql).Execute(provider) > 0);
        }
        /// <summary>
        /// 添加一条记录
        /// </summary>
        /// <param name="entity">待添加的实体对象</param>
        /// <returns>true:添加成功 false:添加失败</returns>
        public bool Add(Mod_Online_YearPlan_Detail_MajorCodeEntity entity, IDataProvider provider)
        {
            SQL sql = SQL.Build("INSERT INTO Mod_Online_YearPlan_Detail_MajorCode(Id,DetailId,PlanId,YearId,CodeId,CodeName,StateFlag,OrderIndex,DeleteFlag,ExtFlag) VALUES(?,?,?,?,?,?,?,?,?,?)", entity.Id, entity.DetailId, entity.PlanId, entity.YearId, entity.CodeId, entity.CodeName, entity.StateFlag, entity.OrderIndex, entity.DeleteFlag, entity.ExtFlag);

            return(SqlMap <Mod_Online_YearPlan_Detail_MajorCodeEntity> .ParseSql(sql).Execute(provider) > 0);
        }
        /// <summary>
        /// 根据主键判断该记录是否存在
        /// </summary>
        /// <param name="schoolMajorId">学校专业编号</param>
        /// <returns>true:存在,false:不存在</returns>
        public virtual bool Exists(string schoolMajorId)
        {
            SQL sql = SQL.Build("SELECT COUNT(*) FROM Mod_Online_School_Major WHERE SchoolMajorId=?", schoolMajorId);

            return(Convert.ToInt32(SqlMap <Mod_Online_School_MajorEntity> .ParseSql(sql).First()) > 0);
        }
        /// <summary>
        /// 更新一条记录
        /// </summary>
        /// <param name="entity">待更新的实体对象</param>
        /// <returns>true:更新成功 false:更新失败</returns>
        public virtual bool Update(Mod_Online_YearPlan_Detail_MajorCodeEntity entity)
        {
            SQL sql = SQL.Build("UPDATE Mod_Online_YearPlan_Detail_MajorCode SET DetailId=?,PlanId=?,YearId=?,CodeId=?,CodeName=?,StateFlag=?,OrderIndex=?,DeleteFlag=?,ExtFlag=? WHERE Id=?", entity.DetailId, entity.PlanId, entity.YearId, entity.CodeId, entity.CodeName, entity.StateFlag, entity.OrderIndex, entity.DeleteFlag, entity.ExtFlag, entity.Id);

            return(SqlMap <Mod_Online_YearPlan_Detail_MajorCodeEntity> .ParseSql(sql).Execute() > 0);
        }
        /// <summary>
        /// 获取Json对象列表
        /// </summary>
        /// <returns>Json对象列表</returns>
        public virtual string GetJsonList()
        {
            SQL sql = SQL.Build("SELECT * FROM Mod_Online_School_Major");

            return(SqlMap <Mod_Online_School_MajorEntity> .ParseSql(sql).ToJsonList());
        }
Beispiel #26
0
        /// <summary>
        /// 删除一条记录
        /// </summary>
        /// <param name="appTypeId">类型编号</param>
        /// <returns>true:删除成功 false:删除失败</returns>
        public bool Delete(string appTypeId, IDataProvider provider)
        {
            SQL sql = SQL.Build("DELETE FROM Mod_Online_ApplicationType WHERE AppTypeId=?", appTypeId);

            return(SqlMap <Mod_Online_ApplicationTypeEntity> .ParseSql(sql).Execute(provider) > 0);
        }
        /// <summary>
        /// 更新一条记录
        /// </summary>
        /// <param name="entity">待更新的实体对象</param>
        /// <returns>true:更新成功 false:更新失败</returns>
        public virtual bool Update(Mod_Online_School_MajorEntity entity)
        {
            SQL sql = SQL.Build("UPDATE Mod_Online_School_Major SET SchoolMajorName=?,SchoolId=?,SchoolName=?,StateFlag=?,OrderIndex=?,DeleteFlag=?,ExtFlag=? WHERE SchoolMajorId=?", entity.SchoolMajorName, entity.SchoolId, entity.SchoolName, entity.StateFlag, entity.OrderIndex, entity.DeleteFlag, entity.ExtFlag, entity.SchoolMajorId);

            return(SqlMap <Mod_Online_School_MajorEntity> .ParseSql(sql).Execute() > 0);
        }
Beispiel #28
0
        /// <summary>
        /// 删除一条记录
        /// </summary>
        /// <param name="entity">待删除的实体对象</param>
        /// <returns>true:删除成功 false:删除失败</returns>
        public virtual bool Delete(Mod_Online_ApplicationTypeEntity entity)
        {
            SQL sql = SQL.Build("DELETE FROM Mod_Online_ApplicationType WHERE AppTypeId=?", entity.AppTypeId);

            return(SqlMap <Mod_Online_ApplicationTypeEntity> .ParseSql(sql).Execute() > 0);
        }
Beispiel #29
0
        /// <summary>
        /// 删除一条记录
        /// </summary>
        /// <param name="userId">用户编号</param>
        /// <returns>true:删除成功 false:删除失败</returns>
        public virtual bool Delete(string userId)
        {
            SQL sql = SQL.Build("DELETE FROM Base_User WHERE UserId=?", userId);

            return(SqlMap <Base_UserEntity> .ParseSql(sql).Execute() > 0);
        }
        /// <summary>
        /// 删除一条记录
        /// </summary>
        /// <param name="planId">计划编号</param>
        /// <returns>true:删除成功 false:删除失败</returns>
        public bool Delete(string planId, IDataProvider provider)
        {
            SQL sql = SQL.Build("DELETE FROM Mod_Online_YearPlan WHERE PlanId=?", planId);

            return(SqlMap <Mod_Online_YearPlanEntity> .ParseSql(sql).Execute(provider) > 0);
        }