示例#1
0
        /// <summary>
        /// 日常打卡信息
        /// </summary>
        /// <param name="sType"></param>
        /// <param name="sValue"></param>
        /// <param name="strOwnerID"></param>
        /// <param name="strEmployeeID"></param>
        /// <param name="strAttendDateFrom"></param>
        /// <param name="strAttendDateTo"></param>
        /// <param name="strSortKey"></param>
        /// <returns></returns>
        public IQueryable <T_HR_ATTENDANCERECORD> GetAllAttendanceRdListByMultSearch(string sType, string sValue, string strOwnerID, string strEmployeeID, string strAttendDateFrom,
                                                                                     string strAttendDateTo, string strSortKey)
        {
            AttendanceRecordDAL dalAttendanceRecord = new AttendanceRecordDAL();

            StringBuilder strfilter  = new StringBuilder();
            List <object> objArgs    = new List <object>();
            string        strOrderBy = string.Empty;

            if (!string.IsNullOrEmpty(strEmployeeID))
            {
                strfilter.Append(" EMPLOYEEID == @0");
                objArgs.Add(strEmployeeID);
            }

            string filterString = strfilter.ToString();

            if (!string.IsNullOrEmpty(strOwnerID))
            {
                SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "T_HR_ATTENDANCERECORD");
            }

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

            var q = dalAttendanceRecord.GetAttendanceRdListByMultSearch(sType, sValue, strAttendDateFrom, strAttendDateTo, strOrderBy, filterString, objArgs.ToArray());

            return(q);
        }
示例#2
0
        /// <summary>
        /// 修改T_HR_ATTENDANCERECORD信息
        /// </summary>
        /// <param name="entLTRd"></param>
        /// <returns></returns>
        public string ModifyAttRd(T_HR_ATTENDANCERECORD entTemp)
        {
            string strMsg = string.Empty;

            try
            {
                if (entTemp == null)
                {
                    return("{REQUIREDFIELDS}");
                }

                bool          flag      = false;
                StringBuilder strFilter = new StringBuilder();
                List <string> objArgs   = new List <string>();

                strFilter.Append(" ATTENDANCERECORDID == @0");

                objArgs.Add(entTemp.ATTENDANCERECORDID);

                AttendanceRecordDAL dalAttendanceRecord = new AttendanceRecordDAL();
                flag = dalAttendanceRecord.IsExistsRd(strFilter.ToString(), objArgs.ToArray());

                if (!flag)
                {
                    return("{NOTFOUND}");
                }

                T_HR_ATTENDANCERECORD entUpdate = dalAttendanceRecord.GetAttendanceRecordRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
                Utility.CloneEntity(entTemp, entUpdate);

                dalAttendanceRecord.Update(entUpdate);
                strMsg = "{SAVESUCCESSED}";
            }
            catch (Exception ex)
            {
                strMsg = ex.ToString();
            }

            return(strMsg);
        }
示例#3
0
        /// <summary>
        /// 根据主键索引,删除T_HR_ATTENDANCERECORD信息(注:暂定为物理删除)
        /// </summary>
        /// <param name="strVacationId">主键索引</param>
        /// <returns></returns>
        public string DeleteAttRd(string strAttendanceRecordId)
        {
            string strMsg = string.Empty;

            try
            {
                if (string.IsNullOrEmpty(strAttendanceRecordId))
                {
                    return("{REQUIREDFIELDS}");
                }

                bool          flag      = false;
                StringBuilder strFilter = new StringBuilder();
                List <string> objArgs   = new List <string>();

                strFilter.Append(" ATTENDANCERECORDID == @0");

                objArgs.Add(strAttendanceRecordId);

                AttendanceRecordDAL dalAttendanceRecord = new AttendanceRecordDAL();
                flag = dalAttendanceRecord.IsExistsRd(strFilter.ToString(), objArgs.ToArray());

                if (!flag)
                {
                    return("{NOTFOUND}");
                }

                T_HR_ATTENDANCERECORD entDel = dalAttendanceRecord.GetAttendanceRecordRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
                dalAttendanceRecord.Delete(entDel);

                strMsg = "{DELETESUCCESSED}";
            }
            catch (Exception ex)
            {
                strMsg = ex.Message.ToString();
            }

            return(strMsg);
        }