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