/// <summary> /// 获取考勤异常上报页面数据源 /// </summary> /// <param name="obj"></param> /// <returns></returns> public TableModel GetExcptionUpSoure(object obj) { FormCollection param = (FormCollection)obj; int rows = int.Parse(param["rows"]); int page = int.Parse(param["page"]); TableModel model = new TableModel(); string UnitID = param["UnitID"]; if (string.IsNullOrEmpty(UnitID)) { var dataUnit = new B01BLL().GetPerUnitByUserID(HCQ2UI_Helper.OperateContext.Current.Usr.user_id); UnitID = string.Join("','", dataUnit.Select(o => o.UnitID)); } List <View_A02> attList = DBSession.IView_A02DAL.GetAttendsByUnit("'" + UnitID + "'"); if (!string.IsNullOrEmpty(param["txtSreachName"])) { string txtName = param["txtSreachName"]; attList = attList.Where(o => o.A0101.Contains(txtName)).ToList(); } model.total = attList.Count(); model.rows = attList.Skip((rows * page) - rows).Take(rows); return(model); }
/// <summary> /// 获取页面显示的数据源 /// </summary> /// <param name="obj"></param> /// <returns></returns> public TableModel GetPageViewSoure(object obj) { FormCollection param = (FormCollection)obj; int rows = int.Parse(param["rows"]); int page = int.Parse(param["page"]); int user_id = HCQ2UI_Helper.OperateContext.Current.Usr.user_id; List <B01> unitList = new B01BLL().GetPerUnitByUserID(user_id); string unitidInfo = "'" + string.Join("','", unitList.Select(o => o.UnitID)) + "'"; List <T_PayAccount> payList = new List <T_PayAccount>(); StringBuilder sbSql = new StringBuilder(); sbSql.AppendFormat("select * from T_PayAccount where if_remove=0 and UnitID in ({0}) ", unitidInfo); if (!string.IsNullOrEmpty(param["bank_name"])) { sbSql.AppendFormat(" and khh like '{0}' ", param["bank_name"]); } DataTable dt = HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sbSql.ToString()); payList = HCQ2_Common.Data.DataTableHelper.DataTableToIList <T_PayAccount>(dt); TableModel model = new TableModel(); model.rows = payList.Skip((rows * page) - rows).Take(rows); model.total = payList.Count(); return(model); }
/// <summary> /// 根据用户ID获取所分配权限项目的所有征信记录 /// </summary> /// <param name="user_id"></param> /// <returns></returns> public List <T_EnterDetail> GetEnterByUserid(int user_id) { StringBuilder sbSql = new StringBuilder(); List <B01> unitList = new B01BLL().GetPerUnitByUserID(user_id); string strUnit = "'" + string.Join("','", unitList.Select(o => o.UnitID)) + "'"; sbSql.AppendFormat("select b.* from ( select * from T_CompProInfo where com_id in"); sbSql.AppendFormat(" ( select in_compay from b01 where UnitID in ({0})))a ", strUnit); sbSql.AppendFormat(" inner join T_EnterDetail b on a.com_id=b.ent_id where b.is_success=0 and b.solve_type=0 "); sbSql.AppendFormat(" union all "); sbSql.AppendFormat(" select b.* from ( select * from T_CompProInfo where QXLB<>'01' and QXLB<>'02')a "); sbSql.AppendFormat(" inner join T_EnterDetail b on a.com_id=b.ent_id where b.is_success=0 and b.solve_type=0 "); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <T_EnterDetail>( HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sbSql.ToString()))); }