Esempio n. 1
0
        /// <summary>
        /// 新增员工考勤年度结算信息
        /// </summary>
        /// <param name="entTemp"></param>
        /// <returns></returns>
        public string AddYearlyBalance(T_HR_ATTENDYEARLYBALANCE entTemp)
        {
            string strMsg = string.Empty;

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

                bool flag = false;

                AttendYearlyBalanceDAL dalAttendYearlyBalance = new AttendYearlyBalanceDAL();
                flag = dalAttendYearlyBalance.IsExistsRd(entTemp.EMPLOYEEID, entTemp.BALANCEYEAR.Value);

                if (flag)
                {
                    return("{ALREADYEXISTSRECORD}");
                }

                dalAttendYearlyBalance.Add(entTemp);

                strMsg = "{SAVESUCCESSED}";
            }
            catch (Exception ex)
            {
                strMsg = ex.ToString();
                Utility.SaveLog(strMsg);
            }

            return(strMsg);
        }
Esempio n. 2
0
        /// <summary>
        /// 根据条件,获取员工考勤年度结算信息
        /// </summary>
        /// <param name="strOwnerID">权限控制所有人的员工序号</param>
        /// <param name="strEmployeeID">员工序号</param>
        /// <param name="dBalanceYear">结算年份</param>
        /// <param name="strSortKey">排序字段</param>
        /// <returns>员工考勤年度结算信息</returns>
        public IQueryable <T_HR_ATTENDYEARLYBALANCE> GetAllAttendYearlyBalanceRdListByMultSearch(string strOwnerID, string strEmployeeID, decimal dBalanceYear, string strSortKey)
        {
            AttendYearlyBalanceDAL dalAttendYearlyBalance = new AttendYearlyBalanceDAL();
            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);
            }

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

            string filterString = strfilter.ToString();

            SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "T_HR_ATTENDYEARLYBALANCE");


            var q = dalAttendYearlyBalance.GetAttendYearlyBalanceRdListByMultSearch(strOrderBy, dBalanceYear, filterString, objArgs.ToArray());

            return(q);
        }
Esempio n. 3
0
        /// <summary>
        /// 根据主键索引,删除员工考勤年度结算信息(注:暂定为物理删除)
        /// </summary>
        /// <param name="strYearlyBalanceId">主键索引</param>
        /// <returns></returns>
        public string DeleteYearlyBalance(string strYearlyBalanceId)
        {
            string strMsg = string.Empty;

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

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

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

                objArgs.Add(strYearlyBalanceId);

                AttendYearlyBalanceDAL dalAttendYearlyBalance = new AttendYearlyBalanceDAL();
                flag = dalAttendYearlyBalance.IsExistsRd(strFilter.ToString(), objArgs.ToArray());

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

                T_HR_ATTENDYEARLYBALANCE entDel = dalAttendYearlyBalance.GetAttendYearlyBalanceRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
                dalAttendYearlyBalance.Delete(entDel);

                strMsg = "{DELETESUCCESSED}";
            }
            catch (Exception ex)
            {
                strMsg = ex.Message.ToString();
                if (ex.InnerException == null)
                {
                    Utility.SaveLog(ex.Message);
                }
                else
                {
                    Utility.SaveLog(ex.InnerException.Message);
                }
            }

            return(strMsg);
        }
Esempio n. 4
0
        /// <summary>
        /// 修改员工考勤年度结算信息
        /// </summary>
        /// <param name="entTemp"></param>
        /// <returns></returns>
        public string ModifyYearlyBalance(T_HR_ATTENDYEARLYBALANCE 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(" YEARLYBALANCEID == @0");

                objArgs.Add(entTemp.YEARLYBALANCEID);

                AttendYearlyBalanceDAL dalAttendYearlyBalance = new AttendYearlyBalanceDAL();
                flag = dalAttendYearlyBalance.IsExistsRd(strFilter.ToString(), objArgs.ToArray());

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

                T_HR_ATTENDYEARLYBALANCE entUpdate = dalAttendYearlyBalance.GetAttendYearlyBalanceRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
                Utility.CloneEntity(entTemp, entUpdate);

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

            return(strMsg);
        }
Esempio n. 5
0
        /// <summary>
        /// 获取员工考勤年度结算信息
        /// </summary>
        /// <param name="strYearlyBalanceId">主键索引</param>
        /// <returns></returns>
        public T_HR_ATTENDYEARLYBALANCE GetAttendYearlyBalanceByID(string strYearlyBalanceId)
        {
            if (string.IsNullOrEmpty(strYearlyBalanceId))
            {
                return(null);
            }

            AttendYearlyBalanceDAL dalAttendYearlyBalance = new AttendYearlyBalanceDAL();
            StringBuilder          strfilter = new StringBuilder();
            List <string>          objArgs   = new List <string>();

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

            T_HR_ATTENDYEARLYBALANCE entRd = dalAttendYearlyBalance.GetAttendYearlyBalanceRdByMultSearch(strfilter.ToString(), objArgs.ToArray());

            return(entRd);
        }