/// <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);
}
/// <summary>
/// 获取T_FB_PERSONACCOUNT信息
/// </summary>
/// <param name="strPersonAccountId">主键索引</param>
/// <returns></returns>
public T_FB_PERSONACCOUNT GetPersonAccountByID(string strPersonAccountId)
{
if (string.IsNullOrEmpty(strPersonAccountId))
{
return(null);
}
PersonAccountDAL dalPersonAccount = new PersonAccountDAL();
StringBuilder strFilter = new StringBuilder();
List <string> objArgs = new List <string>();
if (!string.IsNullOrEmpty(strPersonAccountId))
{
strFilter.Append(" PERSONACCOUNTID == @0");
objArgs.Add(strPersonAccountId);
}
T_FB_PERSONACCOUNT entRd = dalPersonAccount.GetPersonAccountRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
return(entRd);
}
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);
}
