public List <DebtPeopleResultModel> GetDebtPeopleDetail(DebtMoneyPeopleModel model)
{
if (null == model)
{
return(null);
}
return(DBSession.IView_QXTJDAL.GetDebtPeopleDetail(model));
}
/// <summary>
/// 1.2 查询欠薪人数
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public object SelDebtPeople(DebtMoneyPeopleModel model)
{
if (!ModelState.IsValid)
{
return(operateContext.RedirectWebApi(WebResultCode.Exception, GlobalConstant.参数异常.ToString(), false));
}
List <DebtPeopleResultModel> list = operateContext.bllSession.View_QXTJ.GetDebtPeopleDetail(model);
if (null == list)
{
return(operateContext.RedirectWebApi(WebResultCode.Exception, GlobalConstant.操作异常.ToString(), false));
}
return(operateContext.RedirectWebApi(WebResultCode.Ok, GlobalConstant.操作成功.ToString(), list));
}
/// <summary>
/// 根据单位/项目代码查询欠薪人数详细信息
/// </summary>
/// <param name="page"></param>
/// <param name="size"></param>
/// <param name="orgid"></param>
/// <returns></returns>
public List <DebtPeopleResultModel> GetDebtPeopleDetail(DebtMoneyPeopleModel model)
{
if (string.IsNullOrEmpty(model.orgid))
{
return(null);
}
StringBuilder sb = new StringBuilder();
sb.Append(string.Format(@"select top {0} * from(
select w2.WGJG01RowID,b1.UnitID,b1.UnitName,w2.A0101,w2.PersonID,w2.QXTJ01,ROW_NUMBER() OVER(order by WGJG01RowID,PersonID) as DispOrder from
(select UnitName,UnitID from B01) b1 inner join
(select RowID,UnitID from WGJG01 where UnitID=@orgid) w1 on b1.UnitID=w1.UnitID inner join
(select PersonID,A0101,WGJG01RowID,CONVERT(decimal(18, 2),ISNULL(WGJG0208, 0)) AS QXTJ01 from WGJG02
where ISNULL(WGJG0211,'2')='2') w2 on w1.RowID=w2.WGJG01RowID
)as A where A.DispOrder>{1};", model.size, (model.page - 1) * model.size));
_param?.Clear();
_param.Add("@orgid", model.orgid);
DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param));
return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <DebtPeopleResultModel>(dt));
}
