public ActionResult Search(SearchParam param)
{
var list = dc.Set <V_Resource>().Where(a => a.ResourceKindID == 4 && ParkList.Contains(a.Loc1));
if (!string.IsNullOrEmpty(param.Park))
{
list = list.Where(a => a.Loc1 == param.Park);
}
if (!string.IsNullOrEmpty(param.ID))
{
list = list.Where(a => a.ID.Contains(param.ID));
}
if (!string.IsNullOrEmpty(param.Name))
{
list = list.Where(a => a.Name.Contains(param.Name));
}
if (!string.IsNullOrEmpty(param.Cust))
{
list = list.Where(a => a.CustLongName.Contains(param.Cust));
}
if (!string.IsNullOrEmpty(param.Group))
{
list = list.Where(a => a.GroupName.Contains(param.Group));
}
int count = list.Count();
list = list.OrderBy(a => a.ID).Skip((param.PageIndex - 1) * param.PageSize).Take(param.PageSize);
return(Json(new { count = count, data = list.ToList() }, JsonRequestBehavior.AllowGet));
}
public JsonResult Search(SearchParam param)
{
var list = dc.Set <V_Stage>().Where(a => ParkList.Contains(a.ParkID));
if (!string.IsNullOrEmpty(param.Park))
{
list = list.Where(a => a.ParkID == param.Park);
}
if (!string.IsNullOrEmpty(param.ID))
{
list = list.Where(a => a.ID.Contains(param.ID));
}
if (!string.IsNullOrEmpty(param.Name))
{
list = list.Where(a => a.Name.Contains(param.Name));
}
if (param.Enable != null)
{
list = list.Where(a => a.Enable == param.Enable);
}
int count = list.Count();
list = list.OrderBy(a => a.ID).Skip((param.PageIndex - 1) * param.PageSize).Take(param.PageSize);
return(Json(new { count = count, data = list.ToList() }, JsonRequestBehavior.AllowGet));
}
public JsonResult PublicSearch(SearchParam param)
{
string[] pubList = dc.Set <T_ResourcePublic>().Where(a => a.Status != 6).Select(a => a.ResourceID).ToArray();
var list = dc.Set <V_Resource>().Where(a => !pubList.Contains(a.ID));
if (!string.IsNullOrEmpty(param.Park))
{
list = list.Where(a => a.Loc1 == param.Park);
}
else
{
list = list.Where(a => ParkList.Contains(a.Loc1));
}
if (!string.IsNullOrEmpty(param.ID))
{
list = list.Where(a => a.ID.Contains(param.ID));
}
if (!string.IsNullOrEmpty(param.Name))
{
list = list.Where(a => a.Name.Contains(param.Name));
}
if (!string.IsNullOrEmpty(param.Group))
{
list = list.Where(a => a.GroupID == param.Group);
}
if (param.Kind != null)
{
list = list.Where(a => a.ResourceKindID == param.Kind);
}
int count = list.Count();
list = list.OrderBy(a => a.ResourceKindID).Skip((param.PageIndex - 1) * param.PageSize).Take(param.PageSize);
return(Json(new { count = count, data = list.ToList() }, JsonRequestBehavior.AllowGet));
}
public JsonResult Search(SearchParam param)
{
var list = dc.Set <V_Resource>().Where(a => a.ResourceKindID == 3 && ParkList.Contains(a.Loc1));
if (!string.IsNullOrEmpty(param.Park))
{
list = list.Where(a => a.Loc1 == param.Park);
}
if (!string.IsNullOrEmpty(param.ID))
{
list = list.Where(a => a.ID.Contains(param.ID));
}
if (!string.IsNullOrEmpty(param.Name))
{
list = list.Where(a => a.Name.Contains(param.Name));
}
int count = list.Count();
list = list.OrderBy(a => a.ID).Skip((param.PageIndex - 1) * param.PageSize).Take(param.PageSize);
var obj = list.Select(a => new
{
a.ID,
a.Name,
a.Loc1Name,
a.ResourceTypeName,
a.GroupName,
a.Enable,
a.RangeNum
}).ToList();
return(Json(new { count = count, data = obj }, JsonRequestBehavior.AllowGet));
}
public ContentResult Search(SearchParam param)
{
var list = dc.Set <V_Public>().Where(a => ParkList.Contains(a.Loc1));
if (!string.IsNullOrEmpty(param.Park))
{
list = list.Where(a => a.Loc1 == param.Park);
}
if (!string.IsNullOrEmpty(param.ID))
{
list = list.Where(a => a.ResourceID.Contains(param.ID));
}
if (!string.IsNullOrEmpty(param.Name))
{
list = list.Where(a => a.ResourceName.Contains(param.Name));
}
if (!string.IsNullOrEmpty(param.Group))
{
list = list.Where(a => a.GroupID == param.Group);
}
if (param.Stime != null)
{
list = list.Where(a => a.UpdateTime >= param.Stime);
}
if (param.Etime != null)
{
list = list.Where(a => a.UpdateTime <= param.Etime);
}
if (param.Kind != null)
{
list = list.Where(a => a.ResourceKindID == param.Kind);
}
if (param.Status != null)
{
list = list.Where(a => a.Status == param.Status);
}
int count = list.Count();
list = list.OrderByDescending(a => a.UpdateTime).Skip((param.PageIndex - 1) * param.PageSize).Take(param.PageSize);
JsonSerializerSettings setting = new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore,
DateFormatString = "yyyy-MM-dd HH:mm"
};
var obj = JsonConvert.SerializeObject(new { count = count, data = list.ToList() }, setting);
return(Content(obj));
}
public JsonResult Search(SearchParam param)
{
var list = from a in dc.Set <T_ResourceGroup>()
join b in dc.Set <T_Park>() on a.ParkID equals b.ID into t1
from park in t1.DefaultIfEmpty()
join c in dc.Set <T_ResourceKind>() on a.ResourceKindID equals c.ID into t2
from type in t2.DefaultIfEmpty()
select new
{
a.ID,
a.Name,
a.ParkID,
a.ResourceKindID,
a.Enable,
ParkName = park.Name,
ResourceKindName = type.Name
};
if (!string.IsNullOrEmpty(param.Park))
{
list = list.Where(a => a.ParkID == param.Park);
}
else
{
list = list.Where(a => ParkList.Contains(a.ParkID));
}
if (!string.IsNullOrEmpty(param.ID))
{
list = list.Where(a => a.ID.Contains(param.ID));
}
if (!string.IsNullOrEmpty(param.Name))
{
list = list.Where(a => a.Name.Contains(param.Name));
}
if (param.Kind != null)
{
list = list.Where(a => a.ResourceKindID == param.Kind);
}
if (param.Enable != null)
{
list = list.Where(a => a.Enable == param.Enable);
}
int count = list.Count();
list = list.OrderBy(a => a.ID).Skip((param.PageIndex - 1) * param.PageSize).Take(param.PageSize);
return(Json(new { count = count, data = list.ToList() }, JsonRequestBehavior.AllowGet));
}
public ActionResult RSSearch(SearchParam param)
{
var list = dc.Set <V_Resource>().Where(a => a.Enable == true);
if (!string.IsNullOrEmpty(param.Park))
{
list = list.Where(a => a.Loc1 == param.Park);
}
else
{
list = list.Where(a => ParkList.Contains(a.Loc1));
}
if (!string.IsNullOrEmpty(param.ID))
{
list = list.Where(a => a.ID.Contains(param.ID));
}
if (!string.IsNullOrEmpty(param.Name))
{
list = list.Where(a => a.Name.Contains(param.Name));
}
if (!string.IsNullOrEmpty(param.Group))
{
list = list.Where(a => a.GroupID == param.Group);
}
if (param.Kind != null)
{
list = list.Where(a => a.ResourceKindID == param.Kind);
}
int count = list.Count();
list = list.OrderByDescending(a => a.ResourceKindID).Skip((param.PageIndex - 1) * param.PageSize).Take(param.PageSize);
var result = list.Select(a => new { a.ID, a.Name, a.Loc1Name, a.GroupName, a.RentArea });
var obj = JsonConvert.SerializeObject(new { count = count, data = result.ToList() });
return(Content(obj));
}
public ActionResult Search(SearchParam param)
{
var list = dc.Set <V_ResourceStatus>().Where(a => true);
if (!string.IsNullOrEmpty(param.Park))
{
list = list.Where(a => a.Loc1 == param.Park);
}
else
{
list = list.Where(a => ParkList.Contains(a.Loc1));
}
if (!string.IsNullOrEmpty(param.ID))
{
list = list.Where(a => a.ResourceID.Contains(param.ID));
}
if (!string.IsNullOrEmpty(param.Name))
{
list = list.Where(a => a.ResourceName.Contains(param.Name));
}
if (!string.IsNullOrEmpty(param.Group))
{
list = list.Where(a => a.GroupID == param.Group);
}
if (param.Kind != null)
{
list = list.Where(a => a.ResourceKindID == param.Kind);
}
if (param.IType != null)
{
list = list.Where(a => a.BusinessType == param.IType);
}
if (param.Status != null)
{
list = list.Where(a => a.Status == param.Status);
}
if (param.Stime != null)
{
list = list.Where(a => param.Stime <= a.RentEndTime && param.Etime >= a.RentBeginTime);
}
int count = list.Count();
list = list.OrderByDescending(a => a.RentBeginTime).Skip((param.PageIndex - 1) * param.PageSize).Take(param.PageSize);
var result = list.Select(a => new
{
a.ID,
a.SysID,
a.Status,
a.ResourceID,
a.ResourceName,
a.ResourceKindName,
a.GroupName,
a.Loc1Name,
a.RentType,
a.BusinessType,
a.CustShortName,
a.RentBeginTime,
a.RentEndTime,
a.UpdateTime,
a.UpdateUser
});
JsonSerializerSettings setting = new JsonSerializerSettings
{
DateFormatString = "yyyy-MM-dd HH:mm"
};
var obj = JsonConvert.SerializeObject(new { count = count, data = result.ToList() }, setting).Replace(" 00:00", "");
return(Content(obj));
}
public ActionResult Search(SearchParam param)
{
try
{
if (param.Stime == null)
{
return(Json(Result.Fail(msg: "请选择时间！"), JsonRequestBehavior.AllowGet));
}
DateTime begin = Convert.ToDateTime(Convert.ToDateTime(param.Stime).ToString("yyyy-MM-dd") + " 09:00:00");
DateTime end = Convert.ToDateTime(Convert.ToDateTime(param.Stime).ToString("yyyy-MM-dd") + " 21:00:00");
DateTime selectTime1 = begin.Date;
DateTime selectTime2 = begin.Date.AddDays(1);
string tableStr = string.Empty;
string detailStr = string.Empty;
var crList = dc.Set <V_Resource>().Where(a => a.ResourceKindID == 3 && ParkList.Contains(a.Loc1));
//会议室数据
if (!string.IsNullOrEmpty(param.Park))
{
crList = crList.Where(a => a.Loc1 == param.Park);
}
var crTable = crList.Select(a => new { a.ID, a.Name }).ToList();
if (crTable.Count() <= 0)
{
tableStr += "<tr><td colspan='25' style='text-align:center;'>暂无数据</td></tr>";
}
foreach (var item in crTable)//遍历会议室
{
var tempTime = begin;
tableStr += string.Format("<tr><td>{0}</td>", item.Name);
var statusList = dc.Set <V_ResourceStatus>()
.Where(a => a.ResourceID == item.ID && selectTime1 < a.RentBeginTime && a.RentEndTime < selectTime2)
.OrderBy(a => a.RentBeginTime)
.ToList();
if (statusList.Count() > 0)
{
//存在数据
foreach (var status in statusList)
{
if (status.RentBeginTime <= tempTime)//小于正常开始时间
{
if (status.RentEndTime <= end)
{
tableStr += TimeSplit(tempTime, status.RentEndTime, status);
tempTime = Convert.ToDateTime(status.RentEndTime);
}
else//大于正常结束时间
{
tableStr += TimeSplit(tempTime, end, status);
tempTime = end;
}
}
else
{
tableStr += TimeSplit(tempTime, Convert.ToDateTime(status.RentBeginTime), null); //空隙
if (end < status.RentEndTime) //超越正常时间
{
tableStr += TimeSplit(tempTime, end, status);
tempTime = end;
}
else
{
tableStr += TimeSplit(Convert.ToDateTime(status.RentBeginTime), Convert.ToDateTime(status.RentEndTime), status);
tempTime = Convert.ToDateTime(status.RentEndTime);
}
}
//状态详情组装
detailStr += string.Format(@"<div class='detail' data-id='{0}'>
<p><span>资源编号：</span><span>{1}</span></p>
<p><span>公司(个人)：</span><span>{2}</span></p>
<p><span>联系电话：</span><span>{3}</span></p>
<p><span>开始时间：</span>{4}<span></span></p>
<p><span>结束时间：</span>{5}<span></span></p>
</div>",
status.ID,
status.ResourceID,
status.CustLongName,
status.CustTel,
status.RentBeginTime,
status.RentEndTime);
}
if (tempTime < end)//时间刻度数据组装：后面空格
{
tableStr += TimeSplit(tempTime, end, null);
}
}
else
{
//没有数据
tableStr += TimeSplit(begin, end, null);
}
}
return(Json(new { Flag = 1, table = tableStr, detail = detailStr }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(Result.Exception(exmsg: ex.StackTrace), JsonRequestBehavior.AllowGet));
}
}