protected void viewTop(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["MyDbConn"].ToString();
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand("ViewTop", conn);
cmd.CommandType = CommandType.StoredProcedure;
string MVT = MonthVT.Text;
cmd.Parameters.Add(new SqlParameter("@HR", Session["Username"].ToString()));
cmd.Parameters.Add(new SqlParameter("@month", MVT));
conn.Open();
cmd.ExecuteNonQuery();
GridViewTop.EmptyDataText = "No Records Found";
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
if (ds.Tables.Count == 0)
{
GridViewTop.Visible = false;
Response.Write("no records");
}
else
{
GridViewTop.DataSource = ds;
GridViewTop.DataBind();
GridViewTop.Visible = true;
}
conn.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
//string host = HttpContext.Current.Request.Url.Host + ":" + HttpContext.Current.Request.Url.Port;
//string CourseTimes = HttpGet("http://" + host + "/InterFace/custom.ashx?method=CourseTimesList&start="+ hidStartDate.Value+ "&end="+hidEndDate.Value, "application/json");
//JArray CourseTimesJ = JsonConvert.DeserializeObject<JArray>(CourseTimes);
DateTime StartTime = Convert.ToDateTime(hidStartDate.Value);
DateTime EndTime = Convert.ToDateTime(hidEndDate.Value);
//string area = DDarea.SelectedValue;
var ProjectModel = new ProjectCollection.WebUI.Models.ProjectCollectionEntities();
var AllOrder = (from o in ProjectModel.TempOrder
join c in ProjectModel.TempCourse on o.CourseId equals c.CourseId
where (c.type == "自筹") && (!string.IsNullOrEmpty(c.SourceCourseId)) &&
(c.SourceCourseId != "") && (c.CreateDate >= StartTime) && (c.CreateDate <= EndTime)
//&& o.TempCustomer.area == area
select new
{
name = c.title,
sourceid = c.SourceCourseId,
customid = o.CustomerId
});
var DistinctOrder = AllOrder.GroupBy(o => new { o.customid, o.sourceid })
.Select(g => g.FirstOrDefault());
var OrderCount = from o in DistinctOrder
group o by new { o.sourceid } into oc
orderby oc.Count() descending
select new
{
id = oc.Key.sourceid,
//title =(from c in ProjectModel.TempCourse where c.SourceCourseId == oc.Key.sourceid select c.title).Take(1),
count = oc.Count()
};
var OrderGroup = from o in OrderCount
group o by new { o.count } into oc
orderby oc.Key.count descending
select new
{
订购次数 = oc.Key.count,
课件数量 = oc.Count()
};
GridViewTop.DataSource = OrderGroup.ToList();
GridViewTop.DataBind();
}