/// <summary> /// 根据条件,获取T_FB_PERSONACCOUNT信息 /// </summary> /// <param name="strVacName"></param> /// <param name="strVacYear"></param> /// <param name="strCountyType"></param> /// <param name="strSortKey"></param> /// <returns></returns> public static IQueryable <T_FB_PERSONACCOUNT> GetAllPersonAccountRdListByMultSearch(string strFilter, List <object> objArgs, string strSortKey) { PersonAccountDAL dalPersonAccount = new PersonAccountDAL(); string strOrderBy = string.Empty; if (!string.IsNullOrEmpty(strSortKey)) { strOrderBy = strSortKey; } else { strOrderBy = " PERSONACCOUNTID "; } var q = dalPersonAccount.GetPersonAccountRdListByMultSearch(strOrderBy, strFilter, objArgs.ToArray()); return(q); }
public static List <T_FB_REPAYAPPLYDETAIL> GetAllPersonAccountRdListByMultSearchForMobile(string strFilter, List <object> objArgs, string strSortKey, string employeeID) { List <T_FB_REPAYAPPLYDETAIL> repDtlobj = new List <T_FB_REPAYAPPLYDETAIL>(); try { PersonAccountDAL dalPersonAccount = new PersonAccountDAL(); string strOrderBy = string.Empty; if (!string.IsNullOrEmpty(strSortKey)) { strOrderBy = strSortKey; } else { strOrderBy = " PERSONACCOUNTID "; } var q = dalPersonAccount.GetPersonAccountRdListByMultSearch(strOrderBy, strFilter, objArgs.ToArray()); Tracer.Debug("GetAllPersonAccountRdListByMultSearchForMobile- q的数量:" + q.Count()); if (q.Count() > 0) { T_FB_PERSONACCOUNT PerEntity = new T_FB_PERSONACCOUNT(); PerEntity = q.FirstOrDefault(); if (PerEntity.SIMPLEBORROWMONEY > 0) { T_FB_REPAYAPPLYDETAIL repay = new T_FB_REPAYAPPLYDETAIL(); repay.BORROWMONEY = PerEntity.SIMPLEBORROWMONEY.Value; repay.CREATEDATE = DateTime.Now; repay.CREATEUSERID = employeeID; repay.REMARK = ""; repay.REPAYAPPLYDETAILID = System.Guid.NewGuid().ToString(); repay.REPAYMONEY = 0; repay.REPAYTYPE = 1; repay.UPDATEDATE = DateTime.Now; repay.UPDATEUSERID = employeeID; repDtlobj.Add(repay); } if (PerEntity.BACKUPBORROWMONEY > 0) { T_FB_REPAYAPPLYDETAIL repay = new T_FB_REPAYAPPLYDETAIL(); repay.BORROWMONEY = PerEntity.BACKUPBORROWMONEY.Value; repay.CREATEDATE = DateTime.Now; repay.CREATEUSERID = employeeID; repay.REMARK = ""; repay.REPAYAPPLYDETAILID = System.Guid.NewGuid().ToString(); repay.REPAYMONEY = 0; repay.REPAYTYPE = 2; repay.UPDATEDATE = DateTime.Now; repay.UPDATEUSERID = employeeID; repDtlobj.Add(repay); } if (PerEntity.SPECIALBORROWMONEY > 0) { T_FB_REPAYAPPLYDETAIL repay = new T_FB_REPAYAPPLYDETAIL(); repay.BORROWMONEY = PerEntity.SPECIALBORROWMONEY.Value; repay.CREATEDATE = DateTime.Now; repay.CREATEUSERID = employeeID; repay.REMARK = ""; repay.REPAYAPPLYDETAILID = System.Guid.NewGuid().ToString(); repay.REPAYMONEY = 0; repay.REPAYTYPE = 3; repay.UPDATEDATE = DateTime.Now; repay.UPDATEUSERID = employeeID; repDtlobj.Add(repay); } } } catch (Exception ex) { Tracer.Debug("GetAllPersonAccountRdListByMultSearchForMobile-出现错误:" + ex.ToString()); } return(repDtlobj); }