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