Ejemplo n.º 1
0
        /// <summary>
        /// 根据工作日历主键索引,删除与工作日历关联的列外日期记录
        /// </summary>
        /// <param name="strVacationId">工作日历主键索引</param>
        /// <returns></returns>
        public string DeleteByVacationID(string strVacationId)
        {
            string strMsg = string.Empty;

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

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

                strFilter.Append(" T_HR_VACATIONSET.VACATIONID == @0");

                objArgs.Add(strVacationId);

                OutPlanDaysDAL dalOutPlanDays = new OutPlanDaysDAL();
                flag = dalOutPlanDays.IsExistsRd(strFilter.ToString(), objArgs.ToArray());

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

                string strOrderBy = " OUTPLANDAYID ";
                var    q          = dalOutPlanDays.GetOutPlanDaysRdListByMultSearch(strOrderBy, strFilter.ToString(), objArgs.ToArray());

                if (q == null)
                {
                    return(strMsg);
                }

                if (q.Count() == 0)
                {
                    return(strMsg);
                }

                foreach (T_HR_OUTPLANDAYS item in q)
                {
                    dalOutPlanDays.Delete(item);
                }

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

            return(strMsg);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 根据主键索引,删除列外日期信息(注:暂定为物理删除)
        /// </summary>
        /// <param name="strVacationId">主键索引</param>
        /// <returns></returns>
        public string DeleteOutPlanDays(string strOutPlanDaysId)
        {
            string strMsg = string.Empty;

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

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

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

                objArgs.Add(strOutPlanDaysId);

                OutPlanDaysDAL dalOutPlanDays = new OutPlanDaysDAL();
                flag = dalOutPlanDays.IsExistsRd(strFilter.ToString(), objArgs.ToArray());

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

                T_HR_OUTPLANDAYS entDel = dalOutPlanDays.GetOutPlanDaysRdByMultSearch(strFilter.ToString(), objArgs.ToArray());

                dalOutPlanDays.Delete(entDel);

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

            return(strMsg);
        }