/// <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); }
/// <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()); }
/// <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()); }
/// <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); }
/// <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); }
/// <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); }
/// <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()); }
/// <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()); }
/// <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); }
/// <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); }
/// <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); }