Example #1
0
        /// <summary>
        /// 获取T_FB_BORROWAPPLYDETAIL信息
        /// </summary>
        /// <param name="strBorrowApplyDetailId">主键索引</param>
        /// <returns></returns>
        public T_FB_BORROWAPPLYDETAIL GetBorrowApplyDetailByID(string strBorrowApplyDetailId)
        {
            if (string.IsNullOrEmpty(strBorrowApplyDetailId))
            {
                return(null);
            }

            BorrowApplyDetailDAL dalBorrowApplyDetail = new BorrowApplyDetailDAL();
            StringBuilder        strFilter            = new StringBuilder();
            List <string>        objArgs = new List <string>();

            if (!string.IsNullOrEmpty(strBorrowApplyDetailId))
            {
                strFilter.Append(" BORROWAPPLYDETAILID == @0");
                objArgs.Add(strBorrowApplyDetailId);
            }
            T_FB_BORROWAPPLYDETAIL entRd = new T_FB_BORROWAPPLYDETAIL();

            try
            {
                entRd = dalBorrowApplyDetail.GetBorrowApplyDetailRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
            }
            catch (Exception ex)
            {
                string ErrInfo = this.GetType().ToString() + ":GetBorrowApplyDetailByID," + System.DateTime.Now.ToString() + "," + ex.Message;
                Tracer.Debug(ErrInfo);
            }
            return(entRd);
        }
Example #2
0
        /// <summary>
        /// 根据条件,获取T_FB_BORROWAPPLYDETAIL信息
        /// </summary>
        /// <param name="strVacName"></param>
        /// <param name="strVacYear"></param>
        /// <param name="strCountyType"></param>
        /// <param name="strSortKey"></param>
        /// <returns></returns>
        public static IQueryable <T_FB_BORROWAPPLYDETAIL> GetAllBorrowApplyDetailRdListByMultSearch(string strFilter, List <object> objArgs, string strSortKey)
        {
            try
            {
                BorrowApplyDetailDAL dalBorrowApplyDetail = new BorrowApplyDetailDAL();
                string strOrderBy = string.Empty;

                if (!string.IsNullOrEmpty(strSortKey))
                {
                    strOrderBy = strSortKey;
                }
                else
                {
                    strOrderBy = " BORROWAPPLYDETAILID ";
                }

                var q = dalBorrowApplyDetail.GetBorrowApplyDetailRdListByMultSearch(strOrderBy, strFilter, objArgs.ToArray());
                return(q);
            }
            catch (Exception ex)
            {
                string ErrInfo = new BorrowApplyDetailBLL().GetType().ToString() + ":GetAllBorrowApplyDetailRdListByMultSearch," + System.DateTime.Now.ToString() + "," + ex.Message;
                Tracer.Debug(ErrInfo);
            }
            return(null);
        }
Example #3
0
        /// <summary>
        /// 获取T_FB_BORROWAPPLYDETAIL信息   add by zl
        /// </summary>
        /// <param name="strBorrowApplyMasterId">主表主键索引</param>
        /// <returns></returns>
        public List <T_FB_BORROWAPPLYDETAIL> GetBorrowApplyDetailByMasterID(List <object> objBorrowApplyMasterId)
        {
            if (objBorrowApplyMasterId.Count <= 0)
            {
                return(null);
            }

            List <T_FB_BORROWAPPLYDETAIL> entRdlist            = new List <T_FB_BORROWAPPLYDETAIL>();
            BorrowApplyDetailDAL          dalBorrowApplyDetail = new BorrowApplyDetailDAL();
            StringBuilder strFilter = new StringBuilder();
            List <string> objArgs   = new List <string>();

            try
            {
                if (objBorrowApplyMasterId.Count >= 0)
                {
                    foreach (string strBorrowApplyMasterId in objBorrowApplyMasterId.ToArray())
                    {
                        strFilter.Append(" T_FB_BORROWAPPLYMASTER.BORROWAPPLYMASTERID == @0");
                        objArgs.Add(strBorrowApplyMasterId);
                        IQueryable <T_FB_BORROWAPPLYDETAIL> entRd = GetBorrowApplySubjectDetailRdList("UPDATEDATE", strFilter.ToString(), objArgs.ToArray());
                        foreach (T_FB_BORROWAPPLYDETAIL da in entRd)
                        {
                            entRdlist.Add(da);
                        }
                        strFilter.Clear();
                        objArgs.Clear();
                    }
                }
            }
            catch (Exception ex)
            {
                string ErrInfo = this.GetType().ToString() + ":GetBorrowApplyDetailByMasterID," + System.DateTime.Now.ToString() + "," + ex.Message;
                Tracer.Debug(ErrInfo);
            }
            return(entRdlist);
        }