/// <summary> /// 获取采集表行 /// </summary> /// <param name="entity">任务信息管理实体</param> /// <returns></returns> public IEnumerable <MyTableRowModel> GetCollectionTableRow(BpcSp002Entity entity) { List <DbParameter> parameter = new List <DbParameter>(); StringBuilder strSql = new StringBuilder(); strSql.Append(@"SELECT C1.[HXBM] ,C1.[NAME] ,C1.[SFZD] ,C1.[HCODE] ,C1.[PARENT] ,C1.[GRADE] ,C1.[PX] FROM [HQPAS].[BPMS].[BPC_SC001] C1 WITH (NOLOCK) LEFT JOIN [HQPAS].[BPMS].[BPC_SC002] C2 WITH (NOLOCK) ON C1.[HXBM] = C2.[HXBM] AND C1.[STATUS] = C2.[STATUS] WHERE C1.[STATUS] = '1' AND C2.[CJBBM] = @CJBBM AND C2.[ND] = @ND"); parameter.Add(DbParameters.CreateDbParameter("@CJBBM", entity.CJBBM)); parameter.Add(DbParameters.CreateDbParameter("@ND", entity.ND)); return(this.HQPASRepository().FindList <MyTableRowModel>(strSql.ToString(), parameter.ToArray())); }
/// <summary> /// 获取采集表表头 /// </summary> /// <param name="entity">任务信息管理实体</param> /// <returns></returns> public IEnumerable <MyTableHeaderModel> GetCollectionTableHeader(BpcSp002Entity entity) { List <DbParameter> parameter = new List <DbParameter>(); StringBuilder strSql = new StringBuilder(); strSql.Append(@"SELECT [LBM] ,[LMC] ,[LCODE] ,[EDITABLE] ,[AUTOWIDTH] ,[WIDTH] ,[TYPE] ,[TEXTALIGN] ,[FORMATSTR] ,[ISMERGE] ,[VISIBLE] ,[INDEXNUM] FROM [HQPAS].[BPMS].[BPC_SC003] WITH (NOLOCK) WHERE [STATUS] = '1' AND [CJBBM] = @CJBBM AND [ND] = @ND ORDER BY [INDEXNUM]"); parameter.Add(DbParameters.CreateDbParameter("@CJBBM", entity.CJBBM)); parameter.Add(DbParameters.CreateDbParameter("@ND", entity.ND)); return(this.HQPASRepository().FindList <MyTableHeaderModel>(strSql.ToString(), parameter.ToArray())); }
/// <summary> /// 获取采集表数据 /// </summary> /// <param name="entity">任务信息管理实体</param> /// <returns></returns> public IEnumerable <MyTableDataModel> GetCollectionTableData(BpcSp002Entity entity) { List <DbParameter> parameter = new List <DbParameter>(); StringBuilder strSql = new StringBuilder(); strSql.Append(@"SELECT [XH] ,[RWBH] ,[LCODE] ,[HCODE] ,[CCVALUE] FROM [HQPAS].[BPMS].[BPC_SC004] WITH (NOLOCK) WHERE [STATUS] = '1' AND [CJBBM] = @CJBBM AND [RWBH] = @RWBH AND [JXND] = @JXND AND [JXYD] = @JXYD"); parameter.Add(DbParameters.CreateDbParameter("@CJBBM", entity.CJBBM)); parameter.Add(DbParameters.CreateDbParameter("@RWBH", entity.RWBH)); parameter.Add(DbParameters.CreateDbParameter("@JXND", entity.ND)); parameter.Add(DbParameters.CreateDbParameter("@JXYD", entity.YD)); return(this.HQPASRepository().FindList <MyTableDataModel>(strSql.ToString(), parameter.ToArray())); }
/// <summary> /// 任务生成 /// </summary> /// <param name="jxbm"></param> /// <param name="year"></param> public void CreateTask(string jxbm, string year) { var yearTables = _bpcSp003Bll.GetTableListByYear(year); var collectionTimes = _bpcSm003Bll.GetList(year, "").ToList(); var tableParameters = _bpcSp008Bll.GetList().ToList(); //没配置科室的。暂用机构编码 var org = GetOrganization(); var initYear = DateTime.Parse(year + "-01-01"); List <BpcSp002Entity> sp002Entities = new List <BpcSp002Entity>(); foreach (var e in yearTables) { var timeObject = collectionTimes.FirstOrDefault(c => c.PLBH == e.CJPL); var tbParameter = tableParameters.FirstOrDefault(m => m.CJBBM == e.CJBBM); var officeId = tbParameter != null ? tbParameter.DWCSBM : ""; if (officeId.IsEmpty()) { officeId = org.ORGID;//.OrganizeId; } DateTime startTime; DateTime endTime; BpcSp002Entity entity; timeObject = timeObject == null ? new BpcSm003Entity() { SX = 0, XX = 0 } : timeObject; decimal decimalYear = 0; decimal.TryParse(year, out decimalYear); switch (e.CJPL) { case "3": //月度 for (int i = 1; i <= 12; i++) { startTime = initYear.AddMonths(i).AddDays(-timeObject.XX); endTime = initYear.AddMonths(i).AddDays(timeObject.SX); entity = new BpcSp002Entity() { KSSJ = startTime, JZSJ = endTime, ND = decimalYear, CJBBM = e.CJBBM, JGDM = officeId, YD = i, STATUS = "1", JXBM = jxbm }; sp002Entities.Add(entity); } break; case "4": //季度 for (int i = 1; i <= 12; i++) { if (i == 3 || i == 6 || i == 9) { startTime = initYear.AddMonths(i).AddDays(-timeObject.XX); endTime = initYear.AddMonths(i).AddDays(timeObject.SX); entity = new BpcSp002Entity() { KSSJ = startTime, JZSJ = endTime, ND = decimalYear, CJBBM = e.CJBBM, JGDM = officeId, YD = i, STATUS = "1", JXBM = jxbm }; sp002Entities.Add(entity); } } break; case "5": //半年 for (int i = 1; i <= 12; i++) { if (i == 6 || i == 12) { startTime = initYear.AddMonths(i).AddDays(-timeObject.XX); endTime = initYear.AddMonths(i).AddDays(timeObject.SX); entity = new BpcSp002Entity() { KSSJ = startTime, JZSJ = endTime, ND = decimalYear, CJBBM = e.CJBBM, JGDM = officeId, YD = i, STATUS = "1", JXBM = jxbm }; sp002Entities.Add(entity); } } break; case "6": //年度 startTime = initYear.AddMonths(12).AddDays(-timeObject.XX); endTime = initYear.AddMonths(12).AddDays(timeObject.SX); entity = new BpcSp002Entity() { KSSJ = startTime, JZSJ = endTime, ND = decimalYear, CJBBM = e.CJBBM, JGDM = officeId, YD = 12, STATUS = "1", JXBM = jxbm }; sp002Entities.Add(entity); break; } } _service.CreateTask(year, sp002Entities); }
public void AdjustTaskDate(BpcSp002Entity entity) { _service.AdjustTaskDate(entity); }
public ActionResult AdjustTaskDate(BpcSp002Entity entity) { _bpcSp002Bll.AdjustTaskDate(entity); return(Success("操作成功")); }