当前位置: 首页>>代码示例>>C#>>正文


C# QueryBuilder.MakeCustomizeQuery方法代码示例

本文整理汇总了C#中WMS.CustomClass.QueryBuilder.MakeCustomizeQuery方法的典型用法代码示例。如果您正苦于以下问题:C# QueryBuilder.MakeCustomizeQuery方法的具体用法?C# QueryBuilder.MakeCustomizeQuery怎么用?C# QueryBuilder.MakeCustomizeQuery使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在WMS.CustomClass.QueryBuilder的用法示例。


在下文中一共展示了QueryBuilder.MakeCustomizeQuery方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: Page_Load

 protected void Page_Load(object sender, EventArgs e)
 {
     if (!Page.IsPostBack)
     {
         String reportName = Request.QueryString["reportname"];
         List<string> list = Session["ReportSession"] as List<string>;
         FiltersModel fm = Session["FiltersModel"] as FiltersModel;
         User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
         QueryBuilder qb = new QueryBuilder();
         string query = qb.MakeCustomizeQuery(LoggedInUser);
         _dateFrom = list[0];
         string _dateTo = list[1];
         DateTime DateFrom = Convert.ToDateTime(list[0]);
         DateTime DateTo = Convert.ToDateTime(list[1]);
         string PathString = "";
         string consolidatedMonth = "";
         switch (reportName)
         {
             case "Strength":
                 List<DailySummary> _BadliList = contex.DailySummaries.Where(aa => aa.Date >= DateFrom && aa.Date <= DateTo).ToList();
                 List<DailySummary> _TempBadliList = new List<DailySummary>();
                 title = "Badli Report";
                 if (GlobalVariables.DeploymentType == false)
                     PathString = "/Reports/RDLC/DSEmpStrength.rdlc";
                 else
                     PathString = "/WMS/Reports/RDLC/DSEmpStrength.rdlc";
                 LoadReport(PathString, ReportsFilterImplementation(fm, _TempBadliList, _BadliList),_dateFrom+" TO "+_dateTo);
                 break;
             case "WorkTime":
                 _BadliList = contex.DailySummaries.Where(aa => aa.Date >= DateFrom && aa.Date <= DateTo).ToList();
                 _TempBadliList = new List<DailySummary>();
                 title = "Badli Report";
                 if (GlobalVariables.DeploymentType == false)
                     PathString = "/Reports/RDLC/DSWorkSummary.rdlc";
                 else
                     PathString = "/WMS/Reports/RDLC/DSWorkSummary.rdlc";
                 LoadReport(PathString, ReportsFilterImplementation(fm, _TempBadliList, _BadliList), _dateFrom + " TO " + _dateTo);
                 break;
             case "Consolidated":
                 _BadliList = contex.DailySummaries.Where(aa => aa.Date >= DateFrom && aa.Date <= DateTo).ToList();
                 _TempBadliList = new List<DailySummary>();
                 title = "Badli Report";
                 if (GlobalVariables.DeploymentType == false)
                     PathString = "/Reports/RDLC/DSConsolidated.rdlc";
                 else
                     PathString = "/WMS/Reports/RDLC/DSConsolidated.rdlc";
                 LoadReport(PathString, ReportsFilterImplementation(fm, _TempBadliList, _BadliList), _dateFrom + " TO " + _dateTo);
                 break;
         }
     }
 }
开发者ID:qq5013,项目名称:WMS-Fatima,代码行数:51,代码来源:SummaryReports.aspx.cs

示例2: Page_Load

 protected void Page_Load(object sender, EventArgs e)
 {
     if (!Page.IsPostBack)
     {
         DivGridSection.Visible = false;
         DivGridCrew.Visible = false;
         DivGridDept.Visible = false;
         DivGridEmp.Visible = false;
         DivShiftGrid.Visible = false;
         DivLocGrid.Visible = false;
         DivTypeGrid.Visible = false;
         ReportViewer1.Visible = true;
         ReportViewer1.Width = 1050;
         ReportViewer1.Height = 700;
         DivGridComapny.Visible = false;
         SelectedComps.Clear();
         SelectedTypes.Clear();
         SelectedCrews.Clear();
         SelectedDepts.Clear();
         SelectedEmps.Clear();
         SelectedLocs.Clear();
         SelectedSections.Clear();
         SelectedShifts.Clear();
         LoadGridViews();
         RefreshLabels();
         DateTime date = DateTime.Today.Date;
         if (GlobalVariables.DeploymentType == false)
         {
             PathString = "/Reports/RDLC/DROverTime.rdlc";
         }
         else
             PathString = "/WMS/Reports/RDLC/DROverTime.rdlc";
         User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
         QueryBuilder qb = new QueryBuilder();
         string query = qb.MakeCustomizeQuery(LoggedInUser);
         DataTable dt = qb.GetValuesfromDB("select * from ViewAttData " + query + " and AttDate = '" + date.Date.Year.ToString() + "-" + date.Date.Month.ToString() + "-" + date.Date.Day.ToString() + "'" + " and ( StatusOT=1 or StatusGZOT = 1 ) ");
         List<ViewAttData> _View = dt.ToList<ViewAttData>();
         LoadReport(PathString, _View);
     }
 }
开发者ID:qq5013,项目名称:WMS-Fatima,代码行数:40,代码来源:DOverTime.aspx.cs

示例3: btnGenerateReport_Click

        protected void btnGenerateReport_Click(object sender, EventArgs e)
        {
            RefreshLabels();
            DivGridSection.Visible = false;
            DivGridCrew.Visible = false;
            DivGridDept.Visible = false;
            DivGridEmp.Visible = false;
            DivShiftGrid.Visible = false;
            DivLocGrid.Visible = false;
            DivTypeGrid.Visible = false;
            ReportViewer1.Visible = true;
            DivGridComapny.Visible = false;
            DivGridComapny.Visible = false;
            List<ViewAttData> _TempViewList = new List<ViewAttData>();

            User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
            QueryBuilder qb = new QueryBuilder();
            string query = qb.MakeCustomizeQuery(LoggedInUser);
            string _dateTo = "'" + DateTo.Date.Year.ToString() + "-" + DateTo.Date.Month.ToString() + "-" + DateTo.Date.Day.ToString() + "'";
            string _dateFrom = "'" + DateFrom.Date.Year.ToString() + "-" + DateFrom.Date.Month.ToString() + "-" + DateFrom.Date.Day.ToString() + "'";
            DataTable dt = qb.GetValuesfromDB("select * from ViewAttData " + query + " and (AttDate >= " + _dateFrom + " and AttDate <= " + _dateTo + " )" + " and ( StatusOT=1 " + "or StatusGZOT = 1) ");

            List<ViewAttData> _ViewList = dt.ToList<ViewAttData>();
            //_ViewList = context.ViewAttDatas.Where(aa => aa.AttDate >= DateFrom.Date && aa.AttDate <= DateTo.Date && (aa.StatusOT == true || aa.StatusGZOT == true)).ToList();
            if (SelectedEmps.Count > 0)
            {
                foreach (var emp in SelectedEmps)
                {
                    _TempViewList.AddRange(_ViewList.Where(aa => aa.EmpID == emp.EmpID).ToList());
                }
                _ViewList = _TempViewList.ToList();
            }
            else
                _TempViewList = _ViewList.ToList();

            _TempViewList.Clear();
            //for department
            if (SelectedDepts.Count > 0)
            {
                foreach (var dept in SelectedDepts)
                {
                    _TempViewList.AddRange(_ViewList.Where(aa => aa.DeptName == dept.DeptName).ToList());
                }
                _ViewList = _TempViewList.ToList();
            }
            else
                _TempViewList = _ViewList.ToList();
            _TempViewList.Clear();

            //for company
            if (SelectedComps.Count > 0)
            {
                foreach (var comp in SelectedComps)
                {
                    _TempViewList.AddRange(_ViewList.Where(aa => aa.CompName == comp.CompName).ToList());
                }
                _ViewList = _TempViewList.ToList();
            }
            else
                _TempViewList = _ViewList.ToList();
            _TempViewList.Clear();

            //for sections
            if (SelectedSections.Count > 0)
            {
                foreach (var sec in SelectedSections)
                {
                    _TempViewList.AddRange(_ViewList.Where(aa => aa.SectionName == sec.SectionName).ToList());
                }
                _ViewList = _TempViewList.ToList();
            }
            else
                _TempViewList = _ViewList.ToList();

            _TempViewList.Clear();

            //for crews
            if (SelectedCrews.Count > 0)
            {
                foreach (var cre in SelectedCrews)
                {
                    _TempViewList.AddRange(_ViewList.Where(aa => aa.CrewName == cre.CrewName).ToList());
                }
                _ViewList = _TempViewList.ToList();
            }
            else
                _TempViewList = _ViewList.ToList();
            _TempViewList.Clear();

            //for location
            if (SelectedLocs.Count > 0)
            {
                foreach (var loc in SelectedLocs)
                {
                    _TempViewList.AddRange(_ViewList.Where(aa => aa.LocName == loc.LocName).ToList());
                }
                _ViewList = _TempViewList.ToList();
            }
            else
                _TempViewList = _ViewList.ToList();
//.........这里部分代码省略.........
开发者ID:qq5013,项目名称:WMS-Fatima,代码行数:101,代码来源:DOverTime.aspx.cs

示例4: Page_Load

        protected void Page_Load(object sender, EventArgs e)
        {
            String reportName = Request.QueryString["reportname"];
            String type = Request.QueryString["type"];
            if (!Page.IsPostBack)
            {
                List<string> list = Session["ReportSession"] as List<string>;
                FiltersModel fm = Session["FiltersModel"] as FiltersModel;
                CreateDataTable();
                User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
                QueryBuilder qb = new QueryBuilder();
                string query = qb.MakeCustomizeQuery(LoggedInUser);
                _dateFrom = list[0];
                string _dateTo = list[1];
                companyimage = GetCompanyImages(fm);
                string PathString = "";
                string consolidatedMonth = "";
                switch (reportName)
                {
                    case "badli_report":
                        DataTable badlidt = qb.GetValuesfromDB("select * from ViewBadli where (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'" + _dateTo + "'" + " )");
                        List<ViewBadli> _BadliList = badlidt.ToList<ViewBadli>();
                        List<ViewBadli> _TempBadliList = new List<ViewBadli>();
                        title = "Badli Report";
                        if (GlobalVariables.DeploymentType == false)
                            PathString = "/Reports/RDLC/BadliReport.rdlc";
                        else
                            PathString = "/WMS/Reports/RDLC/BadliReport.rdlc";
                        LoadReport(PathString, ReportsFilterImplementation(fm, _TempBadliList, _BadliList), _dateFrom + " TO " + _dateTo);
                        break;
                    //please modify the first case
                    case "summarized_monthly_report":
                        List<TASReportDataSet.SummarizedMonthlyReportDataTable> AttDeptdummy = new List<TASReportDataSet.SummarizedMonthlyReportDataTable>().ToList();
                        title = "Department Attendace Summary";
                        if (GlobalVariables.DeploymentType == false)
                            PathString = "/Reports/RDLC/SummarizedMonthlyReport.rdlc";
                        else
                            PathString = "/WMS/Reports/RDLC/SummarizedMonthlyReport.rdlc";

                        LoadReport(PathString, AttDeptdummy, _dateFrom + " TO " + _dateTo);

                        break;
                    case "Employee_Att_Summary_New_report": DataTable dt4  = qb.GetValuesfromDB("select * from ViewAttData " + query + " and Status=1" + " and (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'" + _dateTo + "'" + " )");
                        List<ViewAttData> ListOfAttDate = new List<ViewAttData>();
                        List<ViewAttData> TempList = new List<ViewAttData>();
                        title = "Employee Attendace Summary New";
                        if (GlobalVariables.DeploymentType == false)
                            PathString = "/Reports/RDLC/EmpAttSummaryNew.rdlc";
                        else
                            PathString = "/WMS/Reports/RDLC/EmpAttSummaryNew.rdlc";
                        ListOfAttDate = dt4.ToList<ViewAttData>();
                        TempList = new List<ViewAttData>();

                        LoadReport(PathString, ReportsFilterImplementation(fm, TempList, ListOfAttDate), _dateFrom + " TO " + _dateTo);

                        break;
                    //case "department_attendance_summary": HRReportsMaker hrm = new HRReportsMaker();
                    //    List<AttDeptSummary> AttDept = hrm.GetListForAttDepartmentsSummary(Session["FiltersModel"] as FiltersModel, _dateFrom, _dateTo);
                    //    title = "Department Attendace Summary";
                    //    if (GlobalVariables.DeploymentType == false)
                    //        PathString = "/Reports/RDLC/AttDepartmentSummary.rdlc";
                    //    else
                    //        PathString = "/WMS/Reports/RDLC/AttDepartmentSummary.rdlc";

                    //    LoadReport(PathString, AttDept, _dateFrom + " TO " + _dateTo);

                    //    break;
                    case "emp_record": DataTable dt = qb.GetValuesfromDB("select * from EmpView " + query + " and Status=1 ");
                        List<EmpView> _ViewList = dt.ToList<EmpView>();
                        List<EmpView> _TempViewList = new List<EmpView>();
                        title = "Employee Record Report";
                        if (GlobalVariables.DeploymentType == false)
                            PathString = "/Reports/RDLC/Employee.rdlc";
                        else
                            PathString = "/WMS/Reports/RDLC/Employee.rdlc";

                        LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList, _ViewList), _dateFrom + " TO " + _dateTo);

                        break;
                    case "emp_record_active": dt = qb.GetValuesfromDB("select * from EmpView " + query+ " and Status=1 ");
                        _ViewList = dt.ToList<EmpView>();
                        _TempViewList = new List<EmpView>();
                        title = "Active Employees Record Report";
                        if (GlobalVariables.DeploymentType == false)
                            PathString = "/Reports/RDLC/Employee.rdlc";
                        else
                            PathString = "/WMS/Reports/RDLC/Employee.rdlc";

                        LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList, _ViewList), _dateFrom + " TO " + _dateTo);

                        break;
                    case "emp_record_inactive": dt = qb.GetValuesfromDB("select * from EmpView " + query + " and Status=0 ");
                        _ViewList = dt.ToList<EmpView>();
                        _TempViewList = new List<EmpView>();
                        title = "Inactive Employees Record Report";
                        if (GlobalVariables.DeploymentType == false)
                            PathString = "/Reports/RDLC/Employee.rdlc";
                        else
                            PathString = "/WMS/Reports/RDLC/Employee.rdlc";

//.........这里部分代码省略.........
开发者ID:ahsinanwar,项目名称:SingleCompany,代码行数:101,代码来源:ReportContainer.aspx.cs

示例5: Index

        // GET: /Emp/
        public ActionResult Index(string sortOrder, string searchString, string currentFilter, int? page)
        {
            ViewBag.CurrentSort = sortOrder;
            ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
            ViewBag.DesigSortParm = sortOrder == "designation" ? "designation_desc" : "designation";
            ViewBag.LocSortParm = sortOrder == "location" ? "location_desc" : "location";
            ViewBag.SectionSortParm = sortOrder == "section" ? "section_desc" : "section";
            ViewBag.DepartmentSortParm = sortOrder == "wing" ? "wing_desc" : "wing";
            ViewBag.ShiftSortParm = sortOrder == "shift" ? "shift_desc" : "shift";
            ViewBag.TypeSortParm = sortOrder == "type" ? "type_desc" : "type";
            //List<EmpView> emps = new List<EmpView>();
            if (searchString != null)
            {
                page = 1;
            }
            else
            {
                searchString = currentFilter;
            }
            User LoggedInUser = Session["LoggedUser"] as User;
            QueryBuilder qb = new QueryBuilder();
            string query = qb.MakeCustomizeQuery(LoggedInUser);
            DataTable dt = qb.GetValuesfromDB("select * from EmpView"+query);
            List<EmpView> emps = dt.ToList<EmpView>();

            ViewBag.CurrentFilter = searchString;

            if (!String.IsNullOrEmpty(searchString))
            {
                if (searchString == "Active" || searchString == "active")
                {
                    emps = emps.Where(aa => aa.Status == true).ToList();
                }
                else if (searchString == "Inactive" || searchString == "inactive")
                {
                    emps = emps.Where(aa => aa.Status == false).ToList();
                }
                else
                {
                    try
                    {
                        emps = emps.Where(s => s.EmpName.ToUpper().Contains(searchString.ToUpper())
                         || s.EmpNo.Contains(searchString.ToUpper())
                         || s.SectionName.ToUpper().Contains(searchString.ToUpper())
                         || s.ShiftName.ToUpper().Contains(searchString.ToUpper())
                         || s.DesignationName.ToUpper().Contains(searchString.ToUpper())).ToList();
                    }
                    catch(Exception ex)
                    {

                    }
                }
            }

            switch (sortOrder)
            {
                case "name_desc":
                    emps = emps.OrderByDescending(s => s.EmpName).ToList();
                    break;
                case "designation_desc":
                    emps = emps.OrderByDescending(s => s.DesignationName).ToList();
                    break;
                case "designation":
                    emps = emps.OrderBy(s => s.DesignationName).ToList();
                    break;
                case "location_desc":
                    emps = emps.OrderByDescending(s => s.LocName).ToList();
                    break;
                case "location":
                    emps = emps.OrderBy(s => s.LocName).ToList();
                    break;
                case "section_desc":
                    emps = emps.OrderByDescending(s => s.SectionName).ToList();
                    break;
                case "section":
                    emps = emps.OrderBy(s => s.SectionName).ToList();
                    break;
                //case "wing_desc":
                //    emps = emps.OrderByDescending(s => s.sec.DeptName).ToList();
                //    break;
                //case "wing":
                //    emps = emps.OrderBy(s => s.DeptName).ToList();
                //    break;
                case "shift_desc":
                    emps = emps.OrderByDescending(s => s.ShiftName).ToList();
                    break;
                case "shift":
                    emps = emps.OrderBy(s => s.ShiftName).ToList();
                    break;
                case "type_desc":
                    emps = emps.OrderByDescending(s => s.TypeName).ToList();
                    break;
                case "type":
                    emps = emps.OrderBy(s => s.TypeName).ToList();
                    break;
                default:
                    emps = emps.OrderBy(s => s.EmpName).ToList();
                    break;
            }
//.........这里部分代码省略.........
开发者ID:ahsinanwar,项目名称:SingleCompany,代码行数:101,代码来源:EmpController.cs

示例6: Page_Load

 protected void Page_Load(object sender, EventArgs e)
 {
     if (!Page.IsPostBack)
     {
         DivGridSection.Visible = false;
         DivGridCrew.Visible = false;
         DivGridDept.Visible = false;
         DivGridEmp.Visible = false;
         DivShiftGrid.Visible = false;
         DivLocGrid.Visible = false;
         DivTypeGrid.Visible = false;
         ReportViewer1.Visible = true;
         ReportViewer1.Width = 1050;
         ReportViewer1.Height = 700;
         SelectedTypes.Clear();
         SelectedCrews.Clear();
         SelectedDepts.Clear();
         SelectedEmps.Clear();
         SelectedLocs.Clear();
         SelectedSections.Clear();
         SelectedShifts.Clear();
         RefreshLabels();
         LoadGridViews();
         if (GlobalVariables.DeploymentType == false)
         {
             PathString = "/Reports/RDLC/YLvConsumed.rdlc";
         }
         else
             PathString = "/WMS/Reports/RDLC/YLvConsumed.rdlc";
         User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
         QueryBuilder qb = new QueryBuilder();
         string query = qb.MakeCustomizeQuery(LoggedInUser);
         DataTable dt = qb.GetValuesfromDB("select * from ViewLvConsumed " + query);
         List<ViewLvConsumed> _ViewList = dt.ToList<ViewLvConsumed>();
         LoadReport(PathString, _ViewList);
     }
 }
开发者ID:qq5013,项目名称:WMS-Fatima,代码行数:37,代码来源:YLvConsumed.aspx.cs

示例7: Page_Load

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {

                DateTime date = DateTime.Today.Date.AddDays(-1);
                if (GlobalVariables.DeploymentType == false)
                {
                    PathString = "/Reports/RDLC/DRDetailed.rdlc";
                }
                else
                    PathString = "/WMS/Reports/RDLC/DRDetailed.rdlc";
                //List<ViewMultipleInOut> _View = new List<ViewMultipleInOut>();
                User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
                QueryBuilder qb = new QueryBuilder();
                string query = qb.MakeCustomizeQuery(LoggedInUser);
                DataTable dt = qb.GetValuesfromDB("select * from ViewMultipleInOut " + query +" and AttDate = '"+ date.Date.Year.ToString()+"-"+date.Date.Month.ToString()+"-"+date.Date.Day.ToString()+"'");
                List<ViewMultipleInOut> _View = dt.ToList<ViewMultipleInOut>();
                LoadReport(PathString, _View);
            }
        }
开发者ID:ahsinanwar,项目名称:WMSNHA2016,代码行数:21,代码来源:DDetailed.aspx.cs

示例8: Page_Load

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                DivGridSection.Visible = false;
                DivGridCrew.Visible = false;
                DivGridDept.Visible = false;
                DivGridEmp.Visible = false;
                DivShiftGrid.Visible = false;
                DivLocGrid.Visible = false;
                DivTypeGrid.Visible = false;
                ReportViewer1.Visible = true;
                ReportViewer1.Width = 1050;
                ReportViewer1.Height = 700;
                SelectedTypes.Clear();
                SelectedCrews.Clear();
                SelectedDepts.Clear();
                SelectedEmps.Clear();
                SelectedLocs.Clear();
                SelectedSections.Clear();
                SelectedShifts.Clear();
                DivGridComapny.Visible = false;
                SelectedComps.Clear();

                RefreshLabels();
                LoadGridViews();
                string _period = DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString();
                if (GlobalVariables.DeploymentType == false)
                {
                    PathString = "/Reports/RDLC/MRDetailExcelC.rdlc";
                }
                else
                    PathString = "/WMS/Reports/RDLC/MRDetailExcelC.rdlc";
                List<ViewMonthlyData> _ViewList = new List<ViewMonthlyData>();
                User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
                QueryBuilder qb = new QueryBuilder();
                string query = qb.MakeCustomizeQuery(LoggedInUser);
                DataTable dt = qb.GetValuesfromDB("select * from ViewMonthlyData " + query + " and Period='" + _period+"'");
                _ViewList = dt.ToList<ViewMonthlyData>();
                LoadReport(PathString, _ViewList);
            }
        }
开发者ID:qq5013,项目名称:WMS-Fatima,代码行数:42,代码来源:MDetailExcelC.aspx.cs

示例9: JobCardList

        public ActionResult JobCardList(string sortOrder, string searchString, string currentFilter, int? page)
        {
            ViewBag.CurrentSort = sortOrder;
            ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
            ViewBag.DesigSortParm = sortOrder == "designation" ? "designation_desc" : "designation";
            ViewBag.SectionSortParm = sortOrder == "section" ? "section_desc" : "section";
            //List<EmpView> emps = new List<EmpView>();
            if (searchString != null)
            {
                page = 1;
            }
            else
            {
                searchString = currentFilter;
            }
            User LoggedInUser = Session["LoggedUser"] as User;
            QueryBuilder qb = new QueryBuilder();
            string query = qb.MakeCustomizeQuery(LoggedInUser);
            DataTable dt = qb.GetValuesfromDB("select * from ViewJobCardApp " + query);
            List<ViewJobCardApp> jobCardsApps = dt.ToList<ViewJobCardApp>();

            // List<EmpView> emps = db.EmpViews.ToList();
            ViewBag.CurrentFilter = searchString;

            if (!String.IsNullOrEmpty(searchString))
            {
                try
                {

                    jobCardsApps = jobCardsApps.Where(s => s.EmpName.ToUpper().Contains(searchString.ToUpper())
                        || s.EmpNo.ToUpper().Contains(searchString.ToUpper()) || s.DesignationName.ToString().Contains(searchString)
                    ).OrderByDescending(aa=>aa.DateCreated).ToList();
                }
                catch (Exception ex)
                {

                    }
            }

            switch (sortOrder)
            {
                case "name_desc":
                    jobCardsApps = jobCardsApps.OrderByDescending(s => s.EmpName).ToList();
                    break;
                case "designation_desc":
                    jobCardsApps = jobCardsApps.OrderByDescending(s => s.DesignationName).ToList();
                    break;
                case "designation":
                    jobCardsApps = jobCardsApps.OrderBy(s => s.DesignationName).ToList();
                    break;
                case "section_desc":
                    jobCardsApps = jobCardsApps.OrderByDescending(s => s.SectionName).ToList();
                    break;
                case "section":
                    jobCardsApps = jobCardsApps.OrderBy(s => s.SectionName).ToList();
                    break;
                default:
                    jobCardsApps = jobCardsApps.OrderBy(s => s.EmpName).ToList();
                    break;
            }
            int pageSize = 10;
            int pageNumber = (page ?? 1);
            return View(jobCardsApps.ToPagedList(pageNumber, pageSize));
        }
开发者ID:linkstatic12,项目名称:NHAWMS,代码行数:64,代码来源:JobCardController.cs

示例10: Index

        // GET: /JobCard/
        public ActionResult Index(string sortOrder, string searchString, string currentFilter, int? page)
        {
            ViewBag.CurrentSort = sortOrder;
            ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
            ViewBag.DesigSortParm = sortOrder == "designation" ? "designation_desc" : "designation";
            ViewBag.LocSortParm = sortOrder == "location" ? "location_desc" : "location";
            ViewBag.SectionSortParm = sortOrder == "section" ? "section_desc" : "section";
            ViewBag.DepartmentSortParm = sortOrder == "wing" ? "wing_desc" : "wing";
            ViewBag.ShiftSortParm = sortOrder == "shift" ? "shift_desc" : "shift";
            ViewBag.TypeSortParm = sortOrder == "type" ? "type_desc" : "type";
            //List<EmpView> emps = new List<EmpView>();
            if (searchString != null)
            {
                page = 1;
            }
            else
            {
                searchString = currentFilter;
            }
            User LoggedInUser = Session["LoggedUser"] as User;
            QueryBuilder qb = new QueryBuilder();
            string query = qb.MakeCustomizeQuery(LoggedInUser);
            DataTable dt = qb.GetValuesfromDB("select * from EmpView " + query);
            List<EmpView> emps = dt.ToList<EmpView>();

            // List<EmpView> emps = db.EmpViews.ToList();
            ViewBag.CurrentFilter = searchString;

            if (!String.IsNullOrEmpty(searchString))
            {
                if (searchString == "Active" || searchString == "active")
                {
                    emps = emps.Where(aa => aa.Status == true).ToList();
                }
                else if (searchString == "Inactive" || searchString == "inactive")
                {
                    emps = emps.Where(aa => aa.Status == false).ToList();
                }
                else
                {
                    try
                    {

                        emps = emps.Where(s => s.EmpName.ToUpper().Contains(searchString.ToUpper())
                         || s.EmpNo.ToUpper().Contains(searchString.ToUpper()) || s.DesignationName.ToString().Contains(searchString)
                        ).ToList();
                    }
                    catch (Exception ex)
                    {

                    }
                }
            }

            switch (sortOrder)
            {
                case "name_desc":
                    emps = emps.OrderByDescending(s => s.EmpName).ToList();
                    break;
                case "designation_desc":
                    emps = emps.OrderByDescending(s => s.DesignationName).ToList();
                    break;
                case "designation":
                    emps = emps.OrderBy(s => s.DesignationName).ToList();
                    break;
                case "location_desc":
                    emps = emps.OrderByDescending(s => s.LocName).ToList();
                    break;
                case "location":
                    emps = emps.OrderBy(s => s.LocName).ToList();
                    break;
                case "section_desc":
                    emps = emps.OrderByDescending(s => s.SectionName).ToList();
                    break;
                case "section":
                    emps = emps.OrderBy(s => s.SectionName).ToList();
                    break;
                case "wing_desc":
                    emps = emps.OrderByDescending(s => s.DeptName).ToList();
                    break;
                case "wing":
                    emps = emps.OrderBy(s => s.DeptName).ToList();
                    break;
                case "shift_desc":
                    emps = emps.OrderByDescending(s => s.ShiftName).ToList();
                    break;
                case "shift":
                    emps = emps.OrderBy(s => s.ShiftName).ToList();
                    break;
                case "type_desc":
                    emps = emps.OrderByDescending(s => s.TypeName).ToList();
                    break;
                case "type":
                    emps = emps.OrderBy(s => s.TypeName).ToList();
                    break;
                default:
                    emps = emps.OrderBy(s => s.EmpName).ToList();
                    break;
            }
//.........这里部分代码省略.........
开发者ID:linkstatic12,项目名称:NHAWMS,代码行数:101,代码来源:JobCardController.cs

示例11: EditAttJobCard

 public ActionResult EditAttJobCard()
 {
     User LoggedInUser = Session["LoggedUser"] as User;
     string Message = "";
     QueryBuilder qb = new QueryBuilder();
     string query = qb.MakeCustomizeQuery(LoggedInUser);
     DataTable dt = qb.GetValuesfromDB("select * from EmpView " + query);
     List<EmpView> emps = dt.ToList<EmpView>();
     try
     {
         string _EmpNo = "";
         // int CompID = Convert.ToInt16(Request.Form["CompanyID"].ToString());
         List<EmpView> _Emp = new List<EmpView>();
         short _WorkCardID = Convert.ToInt16(Request.Form["JobCardType"].ToString());
         //First Save Job Card Application
         JobCardApp jobCardApp = new JobCardApp();
         jobCardApp.CardType = _WorkCardID;
         jobCardApp.DateCreated = DateTime.Now;
         jobCardApp.DateStarted = Convert.ToDateTime(Request.Form["JobDateFrom"]);
         jobCardApp.DateEnded = Convert.ToDateTime(Request.Form["JobDateTo"]);
         jobCardApp.Status = false;
         jobCardApp.UserID = LoggedInUser.UserID;
         _EmpNo = Request.Form["JobEmpNo"];
         _Emp = emps.Where(aa => aa.EmpNo == _EmpNo).ToList();
         if (_Emp.Count > 0)
         {
             jobCardApp.CriteriaData = _Emp.FirstOrDefault().EmpID;
             jobCardApp.JobCardCriteria = "E";
             if (ValidateJobCard(jobCardApp))
             {
                 db.JobCardApps.Add(jobCardApp);
                 if (db.SaveChanges() > 0)
                 {
                     AddJobCardAppToJobCardData();
                     Message = "Job Card Created Sucessfully.";
                 }
             }
             else
                 Message = "Job Card already created for FPID: " + _EmpNo;
         }
         else
             Message = "No Employee found, Please enter a valid FPID";
         //Add Job Card to JobCardData and Mark Legends in Attendance Data if attendance Created
         Session["EditAttendanceDate"] = DateTime.Today.Date.ToString("yyyy-MM-dd");
         ViewData["datef"] = Session["EditAttendanceDate"].ToString();
         ViewData["JobDateFrom"] = DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd");
         ViewData["JobDateTo"] = DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd");
         ViewBag.JobCardType = new SelectList(db.JobCards, "WorkCardID", "WorkCardName");
     }
     catch (Exception ex)
     {
         Message = "An Error occured while creating Job Card of " + Request.Form["JobCardType"].ToString();
     }
         //List<EmpView> emps = new List<EmpView>();
         ViewData["JobDateFrom"] = DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd");
         ViewData["JobDateTo"] = DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd");
         ViewBag.JobCardType = new SelectList(db.JobCards, "WorkCardID", "WorkCardName");
         ViewBag.CMessage = Message;
         ViewBag.CurrentFilter = "";
         int pageSize = 10;
         int? page = 1;
         int pageNumber = (page ?? 1);
     return View("Index",emps.ToPagedList(pageNumber, pageSize));
 }
开发者ID:linkstatic12,项目名称:NHAWMS,代码行数:64,代码来源:JobCardController.cs

示例12: Page_Load

 protected void Page_Load(object sender, EventArgs e)
 {
     if (!Page.IsPostBack)
     {
         DivGridSection.Visible = false;
         DivGridCrew.Visible = false;
         DivGridDept.Visible = false;
         DivGridEmp.Visible = false;
         DivShiftGrid.Visible = false;
         DivLocGrid.Visible = false;
         DivTypeGrid.Visible = false;
         ReportViewer1.Visible = true;
         DivGridComapny.Visible = false;
         SelectedComps.Clear();
         ReportViewer1.Width = 1050;
         ReportViewer1.Height = 700;
         SelectedTypes.Clear();
         SelectedCrews.Clear();
         SelectedDepts.Clear();
         SelectedEmps.Clear();
         SelectedLocs.Clear();
         SelectedSections.Clear();
         SelectedShifts.Clear();
         RefreshLabels();
         LoadGridViews();
         DateTime date = DateTime.Today.Date.AddDays(-1);
         if (GlobalVariables.DeploymentType == false)
         {
             PathString = "/Reports/RDLC/DRMultipleInOut.rdlc";
         }
         else
             PathString = "/WMS/Reports/RDLC/DRMultipleInOut.rdlc";
         User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
         QueryBuilder qb = new QueryBuilder();
         string query = qb.MakeCustomizeQuery(LoggedInUser);
         DataTable datatable = qb.GetValuesfromDB("select * from ViewDetailAttData " + query + " and (AttDate = " + "'" + date.ToString("yyyy-MM-dd") + "')" + " and (Tin1 is not null or TOut1 is not null)");
         List<ViewDetailAttData> _View = datatable.ToList<ViewDetailAttData>();
         LoadReport(PathString, _View);
     }
 }
开发者ID:qq5013,项目名称:WMS-Fatima,代码行数:40,代码来源:DMultipleInOut.aspx.cs

示例13: btnGenerateReport_Click

        protected void btnGenerateReport_Click(object sender, EventArgs e)
        {
            RefreshLabels();
            DivGridSection.Visible = false;
            DivGridCrew.Visible = false;
            DivGridDept.Visible = false;
            DivGridEmp.Visible = false;
            DivShiftGrid.Visible = false;
            DivLocGrid.Visible = false;
            DivTypeGrid.Visible = false;
            ReportViewer1.Visible = true;
            DivGridComapny.Visible = false;
            List<EmpView> _TempViewList = new List<EmpView>();
            User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
            QueryBuilder qb = new QueryBuilder();
            string query = qb.MakeCustomizeQuery(LoggedInUser);
            DataTable dt = qb.GetValuesfromDB("select * from EmpView " + query);
            List<EmpView> _ViewList = dt.ToList<EmpView>();
            if (SelectedEmps.Count > 0)
            {
                foreach (var emp in SelectedEmps)
                {
                    _TempViewList.AddRange(_ViewList.Where(aa => aa.EmpID == emp.EmpID).ToList());
                }
                _ViewList = _TempViewList.ToList();
            }
            else
                _TempViewList = _ViewList.ToList();

            _TempViewList.Clear();
            //for department
            if (SelectedDepts.Count > 0)
            {
                foreach (var dept in SelectedDepts)
                {
                    _TempViewList.AddRange(_ViewList.Where(aa => aa.DeptName == dept.DeptName).ToList());
                }
                _ViewList = _TempViewList.ToList();
            }
            else
                _TempViewList = _ViewList.ToList();
            _TempViewList.Clear();

            //for sections
            if (SelectedSections.Count > 0)
            {
                foreach (var sec in SelectedSections)
                {
                    _TempViewList.AddRange(_ViewList.Where(aa => aa.SectionName == sec.SectionName).ToList());
                }
                _ViewList = _TempViewList.ToList();
            }
            else
                _TempViewList = _ViewList.ToList();

            _TempViewList.Clear();

            //for company
            if (SelectedComps.Count > 0)
            {
                foreach (var comp in SelectedComps)
                {
                    _TempViewList.AddRange(_ViewList.Where(aa => aa.CompName == comp.CompName).ToList());
                }
                _ViewList = _TempViewList.ToList();
            }
            else
                _TempViewList = _ViewList.ToList();

            _TempViewList.Clear();

            //for crews
            if (SelectedCrews.Count > 0)
            {
                foreach (var cre in SelectedCrews)
                {
                    _TempViewList.AddRange(_ViewList.Where(aa => aa.CrewName == cre.CrewName).ToList());
                }
                _ViewList = _TempViewList.ToList();
            }
            else
                _TempViewList = _ViewList.ToList();
            _TempViewList.Clear();

            //for location
            if (SelectedLocs.Count > 0)
            {
                foreach (var loc in SelectedLocs)
                {
                    _TempViewList.AddRange(_ViewList.Where(aa => aa.LocName == loc.LocName).ToList());
                }
                _ViewList = _TempViewList.ToList();
            }
            else
                _TempViewList = _ViewList.ToList();
            _TempViewList.Clear();

            //for shifts
            if (SelectedShifts.Count > 0)
            {
//.........这里部分代码省略.........
开发者ID:qq5013,项目名称:WMS-Fatima,代码行数:101,代码来源:EmployeeDetail.aspx.cs

示例14: Index

        // GET: /LvApp/
        public ActionResult Index(string sortOrder, string searchString, string currentFilter, int? page)
        {
            ViewBag.CurrentSort = sortOrder;
            ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
            ViewBag.TypeSortParm = sortOrder == "LvType" ? "LvType_desc" : "LvType";
            ViewBag.DateSortParm = sortOrder == "Date" ? "Date_desc" : "Date";
            if (searchString != null)
            {
                page = 1;
            }
            else
            {
                searchString = currentFilter;
            }
            User LoggedInUser = Session["LoggedUser"] as User;
            QueryBuilder qb = new QueryBuilder();
            string query = qb.MakeCustomizeQuery(LoggedInUser);
            DateTime dt1 = DateTime.Today;
            DateTime dt2 = new DateTime(dt1.Year, 1, 1);
            string date = dt2.Year.ToString()+"-"+dt2.Month.ToString()+"-"+dt2.Day.ToString()+" ";
            DataTable dt = qb.GetValuesfromDB("select * from ViewLvApplication " + query + " and (ToDate >= '" + date + "')");
            List<ViewLvApplication> lvapplications = dt.ToList<ViewLvApplication>();

            ViewBag.CurrentFilter = searchString;
            //var lvapplications = db.LvApplications.Where(aa=>aa.ToDate>=dt2).Include(l => l.Emp).Include(l => l.LvType1);
            if (!String.IsNullOrEmpty(searchString))
            {
                lvapplications = lvapplications.Where(s => s.EmpName.ToUpper().Contains(searchString.ToUpper())
                     || s.EmpNo.ToUpper().Contains(searchString.ToUpper())).ToList();
            }

            switch (sortOrder)
            {
                case "name_desc":
                    lvapplications = lvapplications.OrderByDescending(s => s.EmpName).ToList();
                    break;

                case "LvType_desc":
                    lvapplications = lvapplications.OrderByDescending(s => s.LvType).ToList();
                    break;
                case "LvType":
                    lvapplications = lvapplications.OrderBy(s => s.LvType).ToList();
                    break;
                case "Date_desc":
                    lvapplications = lvapplications.OrderByDescending(s => s.LvDate).ToList();
                    break;
                case "Date":
                    lvapplications = lvapplications.OrderBy(s => s.LvDate).ToList();
                    break;
                default:
                    lvapplications = lvapplications.OrderBy(s => s.EmpName).ToList();
                    break;
            }
            int pageSize = 8;
            int pageNumber = (page ?? 1);
            return View(lvapplications.OrderBy(aa=>aa.LvDate).ToPagedList(pageNumber, pageSize));
        }
开发者ID:ahsinanwar,项目名称:SingleCompany,代码行数:58,代码来源:LvAppController.cs

示例15: EditAttJobCard

 public ActionResult EditAttJobCard()
 {
     User LoggedInUser = Session["LoggedUser"] as User;
     string Message = "";
     QueryBuilder qb = new QueryBuilder();
     string query = qb.MakeCustomizeQuery(LoggedInUser);
     DataTable dt = qb.GetValuesfromDB("select * from EmpView " + query);
     List<EmpView> emps = dt.ToList<EmpView>();
     try
     {
         string _EmpNo = "";
         // int CompID = Convert.ToInt16(Request.Form["CompanyID"].ToString());
         List<EmpView> _Emp = new List<EmpView>();
         short _WorkCardID = Convert.ToInt16(Request.Form["JobCardType"].ToString());
         //First Save Job Card Application
         JobCardTime jobCardTime = new JobCardTime();
         jobCardTime.JobCardID = _WorkCardID;
         jobCardTime.CreatedDate = DateTime.Now;
         jobCardTime.DutyDate = Convert.ToDateTime(Request.Form["JobDate"]);
         string STime = Request.Form["SHour"].ToString();
         string ETime = Request.Form["EHour"].ToString();
         string STimeH = STime.Substring(0, 2);
         string STimeM = STime.Substring(2, 2);
         string ETimeH = ETime.Substring(0, 2);
         string ETimeM = ETime.Substring(2, 2);
         jobCardTime.CreatedBy = LoggedInUser.UserID;
         jobCardTime.AssignedBy = Convert.ToInt16(Request.Form["JobCardDesignation"].ToString());
         jobCardTime.StartTime = new TimeSpan(Convert.ToInt32(STimeH), Convert.ToInt32(STimeM), 0);
         jobCardTime.EndTime = new TimeSpan(Convert.ToInt32(ETimeH), Convert.ToInt32(ETimeM), 0);
         jobCardTime.TTime = (jobCardTime.EndTime - jobCardTime.StartTime);
         //jobCardTime.StartTime = Convert.toti(Request.Form["SHour"]);
         //jobCardTime.EndTime = Convert.ToDateTime(Request.Form["EHour"]);
         string Remakrs = Request.Form["Remakrs"].ToString();
         if (Remakrs != "")
             jobCardTime.Remarks = Remakrs;
         jobCardTime.CreatedBy = LoggedInUser.UserID;
         _EmpNo = Request.Form["JobEmpNo"];
         _Emp = emps.Where(aa => aa.EmpNo == _EmpNo).ToList();
         if (_Emp.Count > 0)
         {
             jobCardTime.EmpID = _Emp.FirstOrDefault().EmpID;
             //if ((jobCardTime.EndTime - jobCardTime.StartTime).TotalMinutes > 0)
             //{
                 if (ValidateJobCard(jobCardTime))
                 {
                     db.JobCardTimes.Add(jobCardTime);
                     if (db.SaveChanges() > 0)
                     {
                         AddJobCardTimeInAttData(jobCardTime);
                         Message = "Job Card Created Sucessfully";
                     }
                     else
                         Message = "Job Card is not created due to server error";
                 }
                 else
                     Message = "Job Card already created for FPID: " + _EmpNo;
             //}
         }
         else
             Message = "No Employee found, Please enter a valid FPID";
         //Add Job Card to JobCardData and Mark Legends in Attendance Data if attendance Created
         Session["EditAttendanceDate"] = DateTime.Today.Date.ToString("yyyy-MM-dd");
         ViewData["datef"] = Session["EditAttendanceDate"].ToString();
         ViewData["JobDate"] = DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd");
         ViewBag.JobCardType = new SelectList(db.JobCards, "WorkCardID", "WorkCardName");
         ViewBag.JobCardDesignation = new SelectList(db.Designations, "DesignationID", "DesignationName");
     }
     catch (Exception ex)
     {
         Message = "An Error occured while creating Job Card of " + Request.Form["JobCardType"].ToString();
     }
     //List<EmpView> emps = new List<EmpView>();
     ViewData["JobDate"] = DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd");
     ViewBag.JobCardType = new SelectList(db.JobCards, "WorkCardID", "WorkCardName");
     ViewBag.JobCardDesignation = new SelectList(db.Designations, "DesignationID", "DesignationName");
     ViewBag.CMessage = Message;
     ViewBag.CurrentFilter = "";
     int pageSize = 10;
     int? page = 1;
     int pageNumber = (page ?? 1);
     return View("Index", emps.ToPagedList(pageNumber, pageSize));
 }
开发者ID:ahsinanwar,项目名称:WMSNHA2016,代码行数:82,代码来源:JobCardTimeController.cs


注:本文中的WMS.CustomClass.QueryBuilder.MakeCustomizeQuery方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。