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