///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public bool UpdateTemplate(ReportPro pro) { SqlCommand sqlCommand = new SqlCommand("dbo.[Report_UpdateTemplate]", MainConnection); sqlCommand.CommandType = CommandType.StoredProcedure; try { sqlCommand.Parameters.Add(new SqlParameter("@RepID", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.RepID)); sqlCommand.Parameters.Add(new SqlParameter("@RepTemp", SqlDbType.VarChar, 50000, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.RepTemp)); sqlCommand.Parameters.Add(new SqlParameter("@Lang", SqlDbType.VarChar, 500, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.Lang)); sqlCommand.Parameters.Add(new SqlParameter("@ModifiedBy", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.ModifiedBy)); //sqlCommand.Parameters.Add(new SqlParameter("@ModifiedDate", SqlDbType.DateTime, 14, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.ModifiedDate)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { throw new Exception(ex.Message, ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public ActionResult getDataChart(int y = 2016) { List <ReportPro> p = new List <ReportPro>(); int s = 0; string tt = ""; List <int> quantityofRes = new List <int>(); List <int> QuanOder = new List <int>(); using (var db = new QLBHEntities()) { var c = db.Categories.OrderBy(it => it.CatID).ToList(); foreach (var item in c) { ReportPro t = new ReportPro() { CatName = item.CatName }; var pro = db.OrderDetails.Include("Product") .Where(it => it.Order.OrderDate.Year == y && it.Product.CatID == item.CatID) .OrderBy(it => it.Order.OrderDate.Month) .ToList(); var st = 0; foreach (var it in new List <int>() { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 }) { t.Month.Add(it); var tm = pro.Where(itm => itm.Order.OrderDate.Month == it).Count(); st += tm; t.QuanTity.Add(tm); } //s = st > s ? st : s; if (st > s) { s = st; tt = item.CatName; } p.Add(t); } foreach (var item in new List <int>() { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 }) { var qr = db.Users.Where(u => u.f_Day_Rerister.Value.Month == item).Count(); quantityofRes.Add(qr); var qqo = db.Orders.Where(od => od.OrderDate.Day == item).Count(); QuanOder.Add(qqo); } } return(Json(new { lbl = p.Select(i => i.CatName).ToList(), sre = p.Select(i => i.QuanTity).ToList(), ma = s, pn = tt, us_q = new List <List <int> > { quantityofRes, QuanOder } })); }