Esempio n. 1
0
        //public System.Data.Objects.DataClasses.EntityObject[] GetLookupData(Dictionary<string, string> args)
        //{
        //    ShiftDefineDAL dalShiftDefine = new ShiftDefineDAL();
        //    StringBuilder strfilter = new StringBuilder();
        //    List<string> objArgs = new List<string>();
        //    string strOrderBy = string.Empty;
        //    strOrderBy = " SHIFTDEFINEID ";

        //    IQueryable<T_HR_SHIFTDEFINE> ents = dalShiftDefine.GetShiftDefineListByMultSearch(strOrderBy, strfilter.ToString(), objArgs);

        //    return ents.Count() > 0 ? ents.ToArray() : null;
        //}


        public EntityObject[] GetLookupData(int pageIndex, int pageSize, string sort, string filterString, IList <object> paras, ref int pageCount, string userID)
        {
            //TODO:实现分页
            ShiftDefineDAL dalShiftDefine = new ShiftDefineDAL();
            StringBuilder  strfilter      = new StringBuilder();
            List <object>  objArgs        = new List <object>();

            if (!string.IsNullOrWhiteSpace(filterString))
            {
                strfilter.Append(filterString);
            }

            if (paras != null)
            {
                if (paras.Count() > 0 && !string.IsNullOrWhiteSpace(filterString))
                {
                    objArgs.AddRange(paras);
                }
            }

            string strfilterString = strfilter.ToString();

            SetOrganizationFilter(ref strfilterString, ref objArgs, userID, "T_HR_SHIFTDEFINE");

            string strOrderBy = string.Empty;

            strOrderBy = " SHIFTDEFINEID ";

            IQueryable <T_HR_SHIFTDEFINE> ents = dalShiftDefine.GetShiftDefineListByMultSearch(strOrderBy, strfilterString, objArgs.ToArray());

            return(ents.Count() > 0 ? ents.ToArray() : null);
        }
Esempio n. 2
0
        /// <summary>
        /// 修改T_HR_SHIFTDEFINE信息
        /// </summary>
        /// <param name="entLTRd"></param>
        /// <returns></returns>
        public string ModifyShiftDefine(T_HR_SHIFTDEFINE 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(" SHIFTDEFINEID == @0");

                objArgs.Add(entTemp.SHIFTDEFINEID);

                ShiftDefineDAL dalShiftDefine = new ShiftDefineDAL();
                flag = dalShiftDefine.IsExistsRd(strFilter.ToString(), objArgs.ToArray());

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

                T_HR_SHIFTDEFINE entUpdate = dalShiftDefine.GetShiftDefineRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
                Utility.CloneEntity(entTemp, entUpdate);

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

            return(strMsg);
        }
Esempio n. 3
0
        /// <summary>
        /// 获取T_HR_SHIFTDEFINE信息
        /// </summary>
        /// <param name="strShiftDefineId">主键索引</param>
        /// <returns></returns>
        public T_HR_SHIFTDEFINE GetShiftDefineByID(string strShiftDefineID)
        {
            if (string.IsNullOrEmpty(strShiftDefineID))
            {
                return(null);
            }

            ShiftDefineDAL dalShiftDefine = new ShiftDefineDAL();
            StringBuilder  strfilter      = new StringBuilder();
            List <string>  objArgs        = new List <string>();

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

            T_HR_SHIFTDEFINE entRd = dalShiftDefine.GetShiftDefineRdByMultSearch(strfilter.ToString(), objArgs.ToArray());

            return(entRd);
        }
Esempio n. 4
0
        /// <summary>
        /// 根据主键索引,删除T_HR_SHIFTDEFINE信息(注:暂定为物理删除)
        /// </summary>
        /// <param name="strVacationId">主键索引</param>
        /// <returns></returns>
        public string DeleteShiftDefine(string strShiftDefineId)
        {
            string strMsg = string.Empty;

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

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

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

                objArgs.Add(strShiftDefineId);

                ShiftDefineDAL dalShiftDefine = new ShiftDefineDAL();
                flag = dalShiftDefine.IsExistsRd(strFilter.ToString(), objArgs.ToArray());

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

                T_HR_SHIFTDEFINE entDel = dalShiftDefine.GetShiftDefineRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
                dalShiftDefine.Delete(entDel);

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

            return(strMsg);
        }
Esempio n. 5
0
        /// <summary>
        /// 新增T_HR_SHIFTDEFINE信息
        /// </summary>
        /// <param name="entLTRd"></param>
        /// <returns></returns>
        public string AddShiftDefine(T_HR_SHIFTDEFINE 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(" SHIFTNAME == @0");

                objArgs.Add(entTemp.SHIFTNAME);

                ShiftDefineDAL dalShiftDefine = new ShiftDefineDAL();
                flag = dalShiftDefine.IsExistsRd(strFilter.ToString(), objArgs.ToArray());

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

                dalShiftDefine.Add(entTemp);

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

            return(strMsg);
        }
Esempio n. 6
0
        /// <summary>
        /// 获取考勤班次信息
        /// </summary>
        /// <param name="strShiftdEfineID">考勤班次序号</param>
        /// <param name="strShiftdEfineName">考勤班次名称</param>
        /// <param name="strCompanyID">公司序号</param>
        /// <param name="strSortKey">排序字段</param>
        /// <returns>返回考勤班次信息</returns>
        public IQueryable <T_HR_SHIFTDEFINE> GetAllShiftDefineListByMultSearch(string strOwnerID, string strShiftDefineName, string strCompanyID, string strSortKey)
        {
            ShiftDefineDAL dalShiftdEfine = new ShiftDefineDAL();

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

            if (!string.IsNullOrEmpty(strShiftDefineName))
            {
                strfilter.Append(" @0.Contains(SHIFTNAME)");
                objArgs.Add(strShiftDefineName);
            }

            if (!string.IsNullOrEmpty(strCompanyID))
            {
                if (string.IsNullOrEmpty(strfilter.ToString()))
                {
                    strfilter.Append(" AND");
                }

                if (objArgs.Count() > 0)
                {
                    iIndex = objArgs.Count();
                }

                strfilter.Append(" COMPANYID == @" + iIndex.ToString());
                objArgs.Add(strCompanyID);
            }

            if (!string.IsNullOrEmpty(strCompanyID))
            {
                if (string.IsNullOrEmpty(strfilter.ToString()))
                {
                    strfilter.Append(" AND");
                }

                if (objArgs.Count() > 0)
                {
                    iIndex = objArgs.Count();
                }

                strfilter.Append(" COMPANYID == @" + iIndex.ToString());
                objArgs.Add(strCompanyID);
            }

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

            string filterString = strfilter.ToString();

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

            var q = dalShiftdEfine.GetShiftDefineListByMultSearch(strOrderBy, filterString, objArgs.ToArray());

            return(q);
        }