/// <summary>
/// 获得所有的权限组列表
/// </summary>
/// <returns></returns>
public IList <BPrivilegeGroup> GetPrivilegeGroupList()
{
string sql = ORMapping.GetSelectSql <BPrivilegeGroup>(TSqlBuilder.Instance);
sql += " WHERE " + base.NotDeleted;
return(ExecuteQuery(sql));
}
public IList <Sys_Config> GetSysConfigList()
{
string sql = ORMapping.GetSelectSql <Sys_Config>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
return(ExecuteQuery(sql));
}
public IList <B_TargetPlanDetail> GetTargetPlandetailList()
{
string sql = ORMapping.GetSelectSql <B_TargetPlanDetail>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
return(ExecuteQuery(sql));
}
public IList <C_DocumentTree> GetDocumentTreeList()
{
string sql = ORMapping.GetSelectSql <C_DocumentTree>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
return(ExecuteQuery(sql));
}
public IList <Model.Enum> GetList(string type)
{
string sql = ORMapping.GetSelectSql <Model.Enum>(TSqlBuilder.Instance);
sql += "WHERE EnumType='" + SafeQuote(type) + "' and " + base.NotDeleted + " ORDER BY DisplayOrder ";
return(ExecuteQuery(sql));
}
public IList <TemplateTask> GetList()
{
string sql = ORMapping.GetSelectSql <TemplateTask>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
return(ExecuteQuery(sql));
}
public IList <A_MissTargetActualRpt> GetMisstargetactualrptList()
{
string sql = ORMapping.GetSelectSql <A_MissTargetActualRpt>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
return(ExecuteQuery(sql));
}
public IList <B_Subscription> GeSubscriptionList()
{
string sql = ORMapping.GetSelectSql <B_Subscription>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
return(ExecuteQuery(sql));
}
public IList <A_MonthlyReport> GetMonthlyreportList()
{
string sql = ORMapping.GetSelectSql <A_MonthlyReport>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
return(ExecuteQuery(sql));
}
/// <summary>
/// 获得指定权限项组下的权限项
/// </summary>
/// <param name="groupID"></param>
/// <returns></returns>
public List <BPrivilege> GetPrivilegesOfGroup(string groupID)
{
string sql = ORMapping.GetSelectSql <BPrivilege>(TSqlBuilder.Instance);
sql += " WHERE " + base.NotDeleted;
sql += string.Format(" AND groupID='{0}'", SqlTextHelper.SafeQuote(groupID));
return(ExecuteQuery(sql));
}
public Attachment GetModelByCode(string fileCode)
{
string sql = ORMapping.GetSelectSql <Attachment>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += " AND AttachmentPath=@AttachmentPath";
return(ExecuteQuery(sql, CreateSqlParameter("@AttachmentPath", System.Data.DbType.String, fileCode)).FirstOrDefault());
}
public IList <C_Target> GetTargetList()
{
string sql = ORMapping.GetSelectSql <C_Target>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += " AND VersionStart <= GETDATE() AND GETDATE()< VersionEnd ";
sql += " ORDER BY Sequence";
return(ExecuteQuery(sql));
}
/// <summary>
/// 通过父ID 获取子级List
/// </summary>
/// <param name="ParentID"></param>
/// <returns></returns>
public IList <C_SystemTree> GetSystemTreeListByID(Guid ParentID)
{
string sql = ORMapping.GetSelectSql <C_SystemTree>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += " AND ParentID=@ParentID ";
SqlParameter _ParentID = CreateSqlParameter("@ParentID", System.Data.DbType.Guid, ParentID);
return(ExecuteQuery(sql, new SqlParameter[] { _ParentID }));
}
public IList <A_MonthlyReport> GetMonthlyreportListID(Guid MonthlyreportID)
{
string sql = ORMapping.GetSelectSql <A_MonthlyReport>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += " AND ID=@MonthlyreportID ";
SqlParameter pMonthlyreportID = CreateSqlParameter("@MonthlyreportID", System.Data.DbType.Guid, MonthlyreportID);
return(ExecuteQuery(sql, pMonthlyreportID));
}
public IList <B_SystemBatch> GetSystemBatchList(int minMonth)
{
string sql = ORMapping.GetSelectSql <B_SystemBatch>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += " and WFBatchStatus='Approved' and FinMonth>=" + minMonth;
return(ExecuteQuery(sql));
}
/// <summary>
/// 获取分解指标版本类型集合
/// </summary>
/// <param name="systemID"></param>
/// <param name="year"></param>
/// <param name="month"></param>
/// <returns></returns>
public IList <B_TargetPlan> GetTargetVersion(string systemID, int year, int month, string wfStatus)
{
var start = new DateTime(year, month + 1, 1);
var end = new DateTime(year, month + 1, 1).AddDays(-1);
string sql = ORMapping.GetSelectSql <B_TargetPlan>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += " and SystemID =@SystemID AND VersionStart<@StartDate and Versionend>@EndDate and WFStatus=@WFStatus";
return(ExecuteQuery(sql, CreateSqlParameter("@SystemID", System.Data.DbType.Guid, systemID.ToGuid()), CreateSqlParameter("@StartDate", System.Data.DbType.DateTime, start), CreateSqlParameter("@EndDate", System.Data.DbType.DateTime, end), CreateSqlParameter("@WFStatus", System.Data.DbType.String, wfStatus)));
}
public CollectUserTaskView LoadByID(string id)
{
string sql = ORMapping.GetSelectSql <CollectUserTaskView>(TSqlBuilder.Instance);
sql += " WHERE ID=@ID";
return(ExecuteQuery(sql
,
CreateSqlParameter("@ID", System.Data.DbType.String, id)
).FirstOrDefault());
}
public IList <C_System> GetSystemList(DateTime CurrentDate)
{
string sql = ORMapping.GetSelectSql <C_System>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += "AND VersionStart <= @CurrentDate and @CurrentDate < VersionEnd ";
sql += " ORDER BY Sequence ASC ";
return(ExecuteQuery(sql, CreateSqlParameter("@CurrentDate", System.Data.DbType.DateTime, CurrentDate)));
}
internal IList <A_MonthlyReportDetail> GetAMonthlyreportdetailList(Guid MonthlyReportID)
{
string sql = ORMapping.GetSelectSql <A_MonthlyReportDetail>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += " and MonthlyReportID=@MonthlyReportID";
SqlParameter pMonthlyReportID = CreateSqlParameter("@MonthlyReportID", System.Data.DbType.Guid, MonthlyReportID);
return(ExecuteQuery(sql, pMonthlyReportID));
}
/// <summary>
/// 获取汇总分组数据
/// </summary>
/// <returns></returns>
public List <C_SystemTree> GetSysTreeExcelGroup()
{
//string sql = "SELECT ID,TreeNodeName,ExcelGroup FROM C_SystemTree ";
string sql = ORMapping.GetSelectSql <C_SystemTree>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += " AND ExcelGroup IS NOT Null ";
sql += " ORDER BY ExcelGroup ";
return(ExecuteQuery(sql));
}
public IList <A_TargetPlanDetail> GetTargetplandetailList(int FinYear)
{
string sql = ORMapping.GetSelectSql <A_TargetPlanDetail>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += "AND FinYear=@FinYear";
SqlParameter pFinYear = CreateSqlParameter("@FinYear", System.Data.DbType.Int64, FinYear);
return(ExecuteQuery(sql, pFinYear));
}
public IList <A_TargetPlanDetail> GetTargetplandetailList(Guid TargetPlanID)
{
string sql = ORMapping.GetSelectSql <A_TargetPlanDetail>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += "AND TargetPlanID=@TargetPlanID";
SqlParameter pTargetPlanID = CreateSqlParameter("@TargetPlanID", System.Data.DbType.Guid, TargetPlanID);
return(ExecuteQuery(sql, pTargetPlanID));
}
/// <summary>
/// 通过系统ID，获取全年的数据
/// </summary>
/// <param name="SystemID"></param>
/// <param name="Year"></param>
/// <returns></returns>
internal IList <A_MonthlyReportDetail> GetAMonthlyreportdetailList(Guid SystemID, int Year)
{
string sql = ORMapping.GetSelectSql <A_MonthlyReportDetail>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += " and SystemID=@SystemID and FinYear=@Year";
SqlParameter _SystemID = CreateSqlParameter("@SystemID", System.Data.DbType.Guid, SystemID);
SqlParameter _FinYear = CreateSqlParameter("@Year", System.Data.DbType.Int32, Year);
return(ExecuteQuery(sql, _SystemID, _FinYear));
}
public IList <A_TargetPlan> GetTargetplanListByRecalculation(DateTime OperatorTime)
{
string sql = ORMapping.GetSelectSql <A_TargetPlan>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += "AND CreateTime >=@OperatorTime ";
SqlParameter temp_OperatorTime = CreateSqlParameter("@OperatorTime", System.Data.DbType.DateTime, OperatorTime);
return(ExecuteQuery(sql, new SqlParameter[] { temp_OperatorTime }));
}
public IList <B_TargetPlanAction> GetActionByTargetplanID(Guid TargetPlanID)
{
string sql = ORMapping.GetSelectSql <B_TargetPlanAction>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += " AND TargetPlanID=@TargetPlanID";
sql += " ORDER BY CreateTime DESC";
SqlParameter pSystemID = CreateSqlParameter("@TargetPlanID", System.Data.DbType.Guid, TargetPlanID);
return(ExecuteQuery(sql, pSystemID));
}
/// <summary>
/// 通过批次获取，月度数据填报表
/// </summary>
/// <param name="SystemBatchID"></param>
/// <returns></returns>
public List <B_MonthlyReport> GetMonthlyreportList(Guid SystemBatchID)
{
string sql = ORMapping.GetSelectSql <B_MonthlyReport>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += " and SystemBatchID=@SystemBatchID ";
SqlParameter pSystemBatchID = CreateSqlParameter("@SystemBatchID", System.Data.DbType.Guid, SystemBatchID);
return(ExecuteQuery(sql, pSystemBatchID));
}
public IList <B_Attachment> GetAttachmentList(Guid businessID)
{
string sql = ORMapping.GetSelectSql <B_Attachment>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += " AND businessID=@BusinessID ";
sql += " ORDER BY CreateTime DESC";
SqlParameter pBusinessID = CreateSqlParameter("@BusinessID", System.Data.DbType.Guid, businessID);
return(ExecuteQuery(sql, pBusinessID));
}
/// <summary>
/// 获取年度指标
/// </summary>
/// <param name="systemID"></param>
/// <returns></returns>
public IList <C_TargetKpi> GetTargetkpiList(int FinYear)
{
string sql = ORMapping.GetSelectSql <C_TargetKpi>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += " AND FinYear=@FinYear ";
sql += " ORDER BY CreateTime DESC";
SqlParameter pFinYear = CreateSqlParameter("@FinYear", System.Data.DbType.Int16, FinYear);
return(ExecuteQuery(sql, pFinYear));
}
/// <summary>
/// 通过父ID和名称 获取List
/// </summary>
/// <param name="ParentID"></param>
/// <returns></returns>
public IList <C_SystemTree> GetSystemTreeListByName(string ParentID, string TreeName)
{
string sql = ORMapping.GetSelectSql <C_SystemTree>(TSqlBuilder.Instance);
StringBuilder sqla = new StringBuilder(sql);
sqla.Append(" WHERE" + base.NotDeleted);
sqla.AppendFormat(" AND ParentID='{0}' AND TreeNodeName LIKE '%{1}%'", ParentID, TreeName);
return(ExecuteQuery(sqla.ToString()));
}
public IList <C_Company> GetCompanyList(Guid SystemID)
{
string sql = ORMapping.GetSelectSql <C_Company>(TSqlBuilder.Instance);
sql += "WHERE " + base.NotDeleted;
sql += "AND Systemid=@SystemID";
sql += " ORDER BY Sequence ASC ";
SqlParameter pSystemID = CreateSqlParameter("@SystemID", System.Data.DbType.Guid, SystemID);
return(ExecuteQuery(sql, pSystemID));
}
