//
// GET: /SalesPlan/
/// <summary>
/// 销售机会计划
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Index()
{
Chance_Plan_ViewModel search = new Chance_Plan_ViewModel();
ViewData["pagerHelper"] = new PageHelper <sal_plan>(new LinqHelper().GetList <sal_plan>(), 1, 3);
return(View(search));
}
public ActionResult Index(FormCollection forms)
{
int curPage = int.Parse(forms["curPage"]);
Dictionary <string, object> dic = new Dictionary <string, object>();
//存储搜索条件，每次返回页面不会使条件消失
Chance_Plan_ViewModel search = new Chance_Plan_ViewModel
{
Chc_Cust_Name = forms["chc_cust_name"],
Chc_Linkman = forms["chc_linkman"],
Chc_Title = forms["chc_title"],
Start_Pla_Date = forms["start_pla_date"],
End_Pla_Date = forms["end_pla_date"],
};
//如果没有输入条件，直接返回全部的客户计划
if (string.IsNullOrEmpty(forms["chc_cust_name"]) && string.IsNullOrEmpty(forms["chc_title"]) && string.IsNullOrEmpty(forms["chc_linkman"]) &&
(string.IsNullOrEmpty(forms["start_pla_date"]) || string.IsNullOrEmpty(forms["end_pla_date"])))
{
var express = LinqHelper.GetExpress <sal_plan>(dic);
var li = new LinqHelper().Db.sal_plan.Where(express).ToList();
ViewData["pagerHelper"] = new PageHelper <sal_plan>(li, curPage, 3);
return(View(search));
}
//只查询日期
if (!string.IsNullOrEmpty(forms["start_pla_date"]) && !string.IsNullOrEmpty(forms["end_pla_date"]) &&
string.IsNullOrEmpty(forms["chc_cust_name"]) && string.IsNullOrEmpty(forms["chc_title"]) && string.IsNullOrEmpty(forms["chc_linkman"]))
{
DateTime start_pla_date = Convert.ToDateTime(forms["start_pla_date"]);
DateTime end_pla_date = Convert.ToDateTime(forms["end_pla_date"]);
var li = new LinqHelper().Db.sal_plan.Where(p => p.pla_date >= start_pla_date && p.pla_date <= end_pla_date).ToList();
ViewData["pagerHelper"] = new PageHelper <sal_plan>(li, curPage, 3);
return(View(search));
}
//日期为空时
List <sal_plan> plans = new List <sal_plan>();
foreach (var key in forms.AllKeys)
{
dic.Add(key, forms[key]);
}
var expression = LinqHelper.GetExpress <sal_chance>(dic);
plans = new LinqHelper().Db.sal_chance.Include(p => p.sal_plan).Where(expression).SelectMany(c => c.sal_plan).ToList();
if (string.IsNullOrEmpty(forms["start_pla_date"]) || string.IsNullOrEmpty(forms["end_pla_date"]))
{
ViewData["pagerHelper"] = new PageHelper <sal_plan>(plans, curPage, 3);
}
//查询日期和其他条件的情况
else
{
DateTime start_pla_date = Convert.ToDateTime(forms["start_pla_date"]);
DateTime end_pla_date = Convert.ToDateTime(forms["end_pla_date"]);
var li = plans.Where(p => p.pla_date >= start_pla_date && p.pla_date <= end_pla_date).ToList();
ViewData["pagerHelper"] = new PageHelper <sal_plan>(li, curPage, 3);
}
return(View(search));
}
