//获取借用信息 public string GetMaterialBorrow(int page, int limit, ApplyFilter applyFilter) { DateTime[] applyTimes = applyFilter.GetStartAndEndTime(applyFilter.ApplyTime); DateTime? applyTime0 = applyTimes?[0]; DateTime? applyTime1 = applyTimes?[1]; DateTime[] startTimes = applyFilter.GetStartAndEndTime(applyFilter.StartTime); DateTime? startTime0 = startTimes?[0]; DateTime? startTime1 = startTimes?[1]; DateTime[] endTimes = applyFilter.GetStartAndEndTime(applyFilter.EndTime); DateTime? endTime0 = endTimes?[0]; DateTime? endTime1 = endTimes?[1]; int? status = applyFilter.Status == null ? (int?)null : Int32.Parse(applyFilter.Status); string teacher = applyFilter.Teacher == null ? null : _teacherBll.Find(applyFilter.Teacher).Teacher_Name; IUseApplyBll useApplyBll = UnityContainerHelper.Server <IUseApplyBll>(); List <Use_Apply> useApplies = useApplyBll.GetEntities(m => m.Is_Get == false && (applyFilter.Teacher == null || m.Teacher_Name == teacher) && (status == null || m.Apply_Status == status) && ((applyTime0 == null || applyTime1 == null) || m.Apply_Time >= applyTime0 && m.Apply_Time <= applyTime1) && ((startTime0 == null || startTime1 == null) || m.Start_Time >= startTime0 && m.Start_Time <= startTime1) && ((endTime0 == null || endTime1 == null) || m.End_Time >= endTime0 && m.End_Time <= endTime1)) .Skip((page - 1) * limit).Take(limit).ToList(); var msg = new { code = 0, msg = "", total = useApplies.Count, data = useApplies }; return(JsonConvert.SerializeObject(msg)); }
private void filterButton_Click(object sender, EventArgs e) { filter.Clear(); //status if (statusComboBox.SelectedItem != null) { if (statusComboBox.SelectedItem.ToString() != "") { string queryValue = statusComboBox.SelectedItem.ToString(); string queryName = "status_id"; foreach (KeyValuePair <string, string> myPair in _model.getStatusValue()) { if (myPair.Key == queryValue) { queryValue = myPair.Value; break; } } filter.Add(queryName, queryValue); } } //priority if (priorityComboBox.SelectedItem != null) { if (priorityComboBox.SelectedItem.ToString() != "") { string queryValue = priorityComboBox.SelectedItem.ToString(); string queryName = "priority_id"; foreach (KeyValuePair <string, string> myPair in _model.getPriorityValue()) { if (myPair.Key == queryValue) { queryValue = myPair.Value; break; } } filter.Add(queryName, queryValue); } } //project if (projectComboBox.SelectedItem != null) { if (projectComboBox.SelectedItem.ToString() != "") { string queryValue = projectComboBox.SelectedItem.ToString(); string queryName = "project_id"; foreach (KeyValuePair <string, string> myPair in _model.getProjectComboValue()) { if (myPair.Key == queryValue) { queryValue = myPair.Value; break; } } filter.Add(queryName, queryValue); } } //created_on if (createdOnComboBox.SelectedItem != null) { if (createdOnComboBox.SelectedItem.ToString() != "") { string queryValue = createdOnComboBox.SelectedItem.ToString(); string queryName = "created_on"; queryValue += dateTimePicker1.Value.Year + "-"; if (dateTimePicker1.Value.Month.ToString().Length == 1) { queryValue += "0" + dateTimePicker1.Value.Month + "-"; } else { queryValue += dateTimePicker1.Value.Month + "-"; } if (dateTimePicker1.Value.Day.ToString().Length == 1) { queryValue += "0" + dateTimePicker1.Value.Day; } else { queryValue += dateTimePicker1.Value.Day; } filter.Add(queryName, queryValue); } } ApplyFilter.Invoke(); }
public SearchStockCommand(IStockService stockService, Func<bool> canExecute, ApplyFilter applyFilter) { this.stockService = stockService; this.canExecute = canExecute; this.applyFilter = applyFilter; }