//获取资源统计GetSumEbookStatic
public JsonResult GetSumRescourseStatic()
{
UCResourceEntities ucr = new UCResourceEntities();
var rescourseStatic = ucr.View_StatisticAreaShiCount.ToList();
return(Json(rescourseStatic, JsonRequestBehavior.AllowGet));
}
public PartialViewResult GetResourceList(string schoolstages, string subjectss)
{
schoolstages = HttpUtility.UrlDecode(schoolstages);
subjectss = HttpUtility.UrlDecode(subjectss);
if (schoolstages != null)
{
string[] schoolstagearray = schoolstages.Split(',');
if (subjectss != null)
{
string[] subjectarray = subjectss.Split(',');
UCResourceEntities uc = new UCResourceEntities();
List <V_ResourceByLearn> resourceByLearns = uc.V_ResourceByLearn.Where(r => schoolstagearray.Contains(r.schoolstage) && subjectarray.Contains(r.Subject)).ToList();
return(PartialView("ResourceListByLearn", resourceByLearns));
}
}
return(PartialView("ResourceListByLearn", null));
}
public void ProcessRequest(HttpContext context)
{
UCResourceEntities ucr = new UCResourceEntities();
string learntype = HttpUtility.UrlDecode(context.Request.QueryString["learntype"]);
string top = context.Request.QueryString["top"];
int _top = Convert.ToInt32(top);
List <V_ResourceByLearn> resouces = ucr.V_ResourceByLearn.Where(r => r.learntype.Contains(learntype)).OrderByDescending(r => r.CreateTime).Take(_top).ToList();
string Newjson = "";
string split = string.Empty;
foreach (V_ResourceByLearn item in resouces)
{
Newjson += string.Format("{3}{{\"rname\":\"{0}\",\"rdate\":\"{1}\",\"rid\":\"{2}\"}}", item.Name,
item.CreateTime, item.id, split);
split = ",";
}
Newjson = string.Format("[{0}]", Newjson);
context.Response.ContentType = "text/plain";
context.Response.Write(Newjson);
}
public CityCenterController()
{
_uc = new UCHomeEntities();
_rec = new UCResourceEntities();
}
public DistrictCenterController()
{
_uc = new UCHomeEntities();
_rec = new UCResourceEntities();
}
public void ProcessRequest(HttpContext context)
{
UCResourceEntities ucr = new UCResourceEntities();
string useridGuid = string.Empty;
if (!string.IsNullOrEmpty(context.Request.QueryString["userid"]))
{
useridGuid = context.Request.QueryString["userid"];
}
string w_sec = string.Empty;
if (!string.IsNullOrEmpty(context.Request.QueryString["w_sec"]))
{
w_sec = HttpUtility.UrlDecode(context.Request.QueryString["w_sec"]);
}
string w_sub = string.Empty;
if (!string.IsNullOrEmpty(context.Request.QueryString["w_sub"]))
{
w_sub = HttpUtility.UrlDecode(context.Request.QueryString["w_sub"]);
}
string w_grade = string.Empty;
if (!string.IsNullOrEmpty(context.Request.QueryString["w_grade"]))
{
w_grade = HttpUtility.UrlDecode(context.Request.QueryString["w_grade"]);
}
string w_res = string.Empty;
if (!string.IsNullOrEmpty(context.Request.QueryString["w_res"]))
{
w_res = HttpUtility.UrlDecode(context.Request.QueryString["w_res"]);
}
string w_doc = string.Empty;
if (!string.IsNullOrEmpty(context.Request.QueryString["w_doc"]))
{
w_doc = HttpUtility.UrlDecode(context.Request.QueryString["w_doc"]);
}
string s_order = "hits";
if (!string.IsNullOrEmpty(context.Request.QueryString["s_order"]))
{
s_order = context.Request.QueryString["s_order"];
}
int top = 5;
if (!string.IsNullOrEmpty(context.Request["pagesize"]))
{
top = int.Parse(context.Request["pagesize"]);
}
int pageindex = 1;
if (!string.IsNullOrEmpty(context.Request["curpage"]))
{
pageindex = int.Parse(context.Request["curpage"]);
}
StringBuilder strwhere = new StringBuilder();
if (string.IsNullOrEmpty(w_sec) || w_sec == "全部")
{
w_sec = "";
//strwhere.AppendFormat("it.Hits>=0");
}
if (string.IsNullOrEmpty(w_sub) || w_sub == "全部")
{
w_sub = ""; //strwhere.AppendFormat(" and it.Subject='{0}'", w_sub);
}
if (string.IsNullOrEmpty(w_grade) || w_grade == "全部")
{
w_grade = ""; //strwhere.AppendFormat(" and it.Grade='{0}'", w_grade);
}
if (string.IsNullOrEmpty(w_res) || w_res == "全部")
{
w_res = ""; //strwhere.AppendFormat(" and it.ResourceType='{0}'", w_res);
}
if (string.IsNullOrEmpty(w_doc) || w_doc == "全部")
{
w_doc = ""; //strwhere.AppendFormat(" and it.ResourceFormat like '%{0}%'", w_doc);
}
if (!string.IsNullOrEmpty(useridGuid))
{
strwhere.AppendFormat("it.CreatorId='{0}'", useridGuid);
}
else
{
strwhere.AppendFormat("1=1");
}
SqlParameter[] paras = new SqlParameter[11];
paras[0] = new SqlParameter("@ordervalue", s_order);
paras[1] = new SqlParameter("@pageindex", pageindex - 1);
paras[2] = new SqlParameter("@pagesize", top);
paras[3] = new SqlParameter("@strwhere", strwhere.ToString());
paras[5] = new SqlParameter("@ResourceFormat", w_doc);
paras[6] = new SqlParameter("@ResourceType", w_res);
paras[7] = new SqlParameter("@schoolstage", w_sec);
paras[8] = new SqlParameter("@subject", w_sub);
paras[9] = new SqlParameter("@Grade", w_grade);
paras[10] = new SqlParameter("@CreatorId", useridGuid);
List <V_ResourceByLearn> resouces = ucr.ExecuteStoreQuery <V_ResourceByLearn>("exec proc_ResourceByPage @ordervalue,@pageindex,@pagesize,@strwhere,@learntype,@ResourceFormat,@ResourceType,@schoolstage,@subject,@Grade,@CreatorId",
paras).ToList();
//if (s_order == "hits")
// resouces = ucr.V_ResourceByLearn.Where(strwhere.ToString()).OrderByDescending(r => r.Hits).Skip(top * (pageindex - 1)).Take(top).ToList();
//else
// resouces = ucr.V_ResourceByLearn.Where(strwhere.ToString()).OrderByDescending(r => r.CreateTime).Skip(top * (pageindex - 1)).Take(top).ToList();
string Newjson = "";
string split = string.Empty;
SqlParameter[] parasclone = new SqlParameter[11];
for (int i = 0, j = 11; i < j; i++)
{
parasclone[i] = (SqlParameter)((ICloneable)paras[i]).Clone();
}
int rcount = ucr.ExecuteStoreQuery <int>("exec proc_ResourceCountByPage @ordervalue,@pageindex,@pagesize,@strwhere,@learntype,@ResourceFormat,@ResourceType,@schoolstage,@subject,@Grade,@CreatorId",
parasclone).ToList()[0];
//int rcount = ucr.V_ResourceByLearn.Where(strwhere.ToString()).OrderByDescending(r => r.Hits).Count();
foreach (V_ResourceByLearn item in resouces)
{
Newjson += string.Format("{11}{{\"pkid\":\"{0}\",\"name\":\"{1}\",\"createtime\":\"{2}\",\"creatorname\":\"{3}\",\"hits\":\"{4}\",\"learntype\":\"{5}\",\"schoolstage\":\"{6}\",\"grade\":\"{7}\",\"subject\":\"{8}\",\"ResourceFormat\":\"{9}\",\"ResourceType\":\"{10}\"}}",
item.id, item.Name, item.CreateTime, item.CreatorName, item.Hits, item.learntype, item.schoolstage, item.Grade, item.Subject, item.ResourceFormat, item.ResourceType, split);
split = ",";
}
Newjson = string.Format("[{{\"returncount\":\"{0}\",\"resourceinfo\":[{1}]}}]", rcount, Newjson);
context.Response.ContentType = "text/plain";
context.Response.Write(Newjson);
}
