//获取借用信息
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;
}
