/// <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("操作成功"));
}
