public static IncomeList Find(int userID, int bussinessID, IncomeFilter filter = null, int? max = 100) { var result = new IncomeList("", filter); using (var con = Repo.DB.SKtimeManagement) { result.Data = con.Query<IncomeInfo>(FindQuery(userID, bussinessID, filter, max)).ToList(); } return result; }
public ActionResult List(IncomeFilter filter) { var data = IncomeInfo.Find(UserID, Employee.ID, Employee.BussinessID, "", filter, true); if (Request.IsAjaxRequest()) { return(Json(new { result = true, html = RenderPartialViewToString(Views.ListPartial, data) }, JsonRequestBehavior.AllowGet)); } return(View(Views.List, data)); }
public ActionResult Download(IncomeFilter filter) { var result = false; try { var data = IncomeInfo.Find(UserID, Employee.ID, Employee.BussinessID, "", filter, true, null); if (data != null) { var fileName = String.Format("Incomes_{0}.xls", DateTime.Now.ToString("ddMMyyyyHHmmss")); var file = String.Format("{0}/Content/Download/{1}", SiteConfiguration.ApplicationPath, fileName); Functions.CheckDirectory(String.Format("{0}/Content/Download/", SiteConfiguration.ApplicationPath)); SaveDownload(file, data.Data); Session[SessionKey.Download] = fileName; result = true; } } catch { } return(Json(new { result = result }, JsonRequestBehavior.DenyGet)); }
public static string FindQuery(int userID, int bussinessID, IncomeFilter filter = null, int? max = 100) { var conditions = new List<string>(); if (filter != null) { if (!String.IsNullOrEmpty(filter.Code)) conditions.Add(String.Format("and i.Code like N'%{0}%'", filter.Code)); if (filter.EmployeeID.HasValue) conditions.Add(String.Format("and i.EmployeeID = {0}", filter.EmployeeID.Value)); if (filter.WarehouseID.HasValue) conditions.Add(String.Format("and i.WarehouseID = {0}", filter.WarehouseID.Value)); if (filter.From.HasValue) conditions.Add(String.Format("and i.SubmitDate >= '{0}'", filter.From.Value.ToString(Constants.DatabaseDatetimeString))); if (filter.To.HasValue) conditions.Add(String.Format("and i.SubmitDate <= '{0}'", filter.To.Value.ToString(Constants.DatabaseDatetimeString))); } return String.Format( @"select {3} i.*, e.Name as [EmployeeName], w.Name as [WarehouseName] from Income i join Employee e on i.EmployeeID = e.ID join Warehouse w on i.WarehouseID = w.ID and w.Status = 'active' and ((select Username from Login where ID = {2}) = 'admin' or w.ID in (select WarehouseID from LoginWarehouse where LoginID = {2})) where i.Status = 'active' and i.BussinessID = {0} {1} order by i.ID desc", bussinessID, String.Join(" ", conditions), userID, max.HasValue ? String.Format("top {0}", max.Value) : ""); }
public IncomeList(string message = "", IncomeFilter filter = null) { Data = new List<IncomeInfo>(); Filter = filter != null ? filter : new IncomeFilter(); Message = message; }
public static IncomeList Find(int userID, int employeeID, int bussinessID, string message = "", IncomeFilter filter = null, bool log = false, int? max = 100) { QueryOutput queryResult; var result = new IncomeList(message, filter); result.Data = Query<IncomeInfo>(new DbQuery(userID, employeeID, DbAction.Income.View, FindQuery(userID, bussinessID, filter, max), log), out queryResult); return result; }