public List <PaymentOrderItem> GetListSimpleByRequest(HttpRequestBase httpRequest) { Request = new ParramRequest(httpRequest); var query = from o in FDIDB.Payments_Order orderby o.ID descending select new PaymentOrderItem { ID = o.ID, OrderCode = o.OrderCode, DateCreate = o.DateCreate, Customername = string.IsNullOrEmpty(o.Shop_Orders.CustomerName) ? string.IsNullOrEmpty(o.Shop_Orders.CompanyName) ? o.Shop_Orders.CompanyName : "(Khách lẻ)" : "(Khách lẻ)", Phonenumber = o.Shop_Orders.Mobile, TotalPrice = o.TotalPrice, Method = o.Payment_Method.Name, }; query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <WalletItem> GetListSimpleByRequest(HttpRequestBase httpRequest, int agencyId) { Request = new ParramRequest(httpRequest); var query = from c in FDIDB.Wallets where c.AgencyId == agencyId orderby c.WalletCus descending select new WalletItem { ID = c.ID, CustomerID = c.CustomerID, CustomerName = c.Customer.FullName, Customerphone = c.Customer.Phone, WalletCus = c.WalletCus, WalletOrder = c.WalletOrder, }; query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <SupplierAmountProductItem> GetListSimpleByRequest(HttpRequestBase httpRequest) { Request = new ParramRequest(httpRequest); var query = from o in FDIDB.SupplierAmountProducts where o.IsDelete == false orderby o.AmountEstimate descending select new SupplierAmountProductItem { ID = o.ID, CategoryName = o.Category.Name, AmountEstimate = o.AmountEstimate, AmountPayed = o.AmountPayed, SupplierName = o.DN_Supplier.Name, PublicationDate = o.PublicationDate }; query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <SourceItem> GetListSimpleByRequest(HttpRequestBase httpRequest) { Request = new ParramRequest(httpRequest); var query = from o in FDIDB.Sources where o.IsDeleted != true && o.IsShow == true orderby o.ID descending select new SourceItem { ID = o.ID, Name = o.Name, SupplierName = o.StorageProduct.DN_Supplier.Name, Description = o.Description, IsShow = o.IsShow, Code = o.Code, DateCreate = o.DateCreate, }; query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <ProduceItem> GetListSimpleByRequest(HttpRequestBase httpRequest) { Request = new ParramRequest(httpRequest); var query = from o in FDIDB.Produces where o.Isdelete == false orderby o.ID descending select new ProduceItem() { ID = o.ID, ProductId = o.ProductId, Quantity = o.Quantity, Status = (ProduceStatus)o.Status, ProductName = o.Category.Name, DateProduce = o.DateProduce }; query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <DiscountItem> GetListSimple(HttpRequestBase httpRequest, int AgencyId) { Request = new ParramRequest(httpRequest); var query = from o in FDIDB.Discounts where o.AgencyID == AgencyId orderby o.ID descending select new DiscountItem { ID = o.ID, DateEnd = o.DateEnd, DateStart = o.DateStart, IsActive = o.IsActive, IsAll = o.IsAll, Percent = o.Percent, PriceE = o.PriceE, PriceS = o.PriceS }; query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <StorageFreightWarehouseItem> GetListSimpleByRequestRecive(HttpRequestBase httpRequest, int agencyId) { Request = new ParramRequest(httpRequest); var from = httpRequest["fromDate"]; var to = httpRequest["toDate"]; var fromDate = !string.IsNullOrEmpty(from) ? from.StringToDate().TotalSeconds() : 0; var toDate = !string.IsNullOrEmpty(to) ? to.StringToDate().AddDays(1).TotalSeconds() : DateTime.Now.TotalSeconds(); var query = from o in FDIDB.StorageFreightWarehouses where o.AgencyReceiveID == agencyId && o.DateCreated >= fromDate && o.DateCreated <= toDate && (!o.IsDelete.HasValue || o.IsDelete == false) orderby o.ID descending select new StorageFreightWarehouseItem() { ID = o.ID, Code = o.Code, TotalPrice = o.TotalPrice ?? 0, Payment = o.Payment ?? 0, DateCreated = o.DateCreated, DateImport = o.DateImport, UserID = o.UserID, KeyGuid = o.keyreq, AgencyReceiveID = o.AgencyReceiveID, Note = o.Note, IsActive = o.IsActive, IsDelete = o.IsDelete, Status = o.Status, IsOrder = o.IsOrder, UsernameActive = o.DN_Users1.UserName, DateActive = o.DateActive, UsernameCreate = o.DN_Users.UserName, }; var status = httpRequest["IsDelete"]; if (!string.IsNullOrEmpty(status)) { var tus = int.Parse(status); query = query.Where(c => c.Status == tus); } query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <CustomerPolicyAppIG4Item> GetListSimpleByRequest(HttpRequestBase httpRequest) { Request = new ParramRequest(httpRequest); var query = from o in FDIDB.Customer_Policy where o.IsShow == true && (!o.IsDeleted.HasValue || o.IsDeleted == false) orderby o.ID descending select new CustomerPolicyAppIG4Item { ID = o.ID, Name = o.Name.Trim(), IsDeleted = o.IsDeleted, IsShow = o.IsShow, Number = o.Number, //StageName = o.Stage.Name, StartMoney = o.StartMoney, EndMoney = o.EndMoney, }; query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <TotalProductToDayItem> GetListSimpleByRequest(HttpRequestBase httpRequest, decimal code, int productId) { Request = new ParramRequest(httpRequest); var query = from o in FDIDB.TotalProductToDays where o.ToDayCode == code && o.ProductId == productId orderby o.ID descending select new TotalProductToDayItem() { ID = o.ID, Quantity = o.Quantity, SupplierName = o.DN_Supplier.Name, SupplierId = o.SupplierId, ProductId = o.SupplierId, ProductName = o.Category.Name, Note = o.Note, Status = o.Status }; query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <WardsItem> GetListbyRequest(HttpRequestBase httpRequest) { Request = new ParramRequest(httpRequest); var query = from c in FDIDB.Wards where c.IsDeleted != true && c.IsShow == true orderby c.Name select new WardsItem { ID = c.ID, Name = c.Name, DistrictID = c.DistrictID }; var dis = httpRequest["districtId"]; if (!string.IsNullOrEmpty(dis)) { var disId = int.Parse(dis); query = query.Where(c => c.DistrictID == disId); } query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <DistrictItem> GetListbyRequest(HttpRequestBase httpRequest) { Request = new ParramRequest(httpRequest); var query = from c in FDIDB.System_District where c.IsDeleted != true && c.IsShow == true orderby c.Name select new DistrictItem { ID = c.ID, Name = c.Name, CityID = c.CityID, }; var city = httpRequest["CityID"]; if (!string.IsNullOrEmpty(city)) { var cityId = int.Parse(city); query = query.Where(c => c.CityID == cityId); } query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <DNRequestWareHouseItem> GetListSimpleAllByRequest(HttpRequestBase httpRequest, int area) { Request = new ParramRequest(httpRequest); var from = httpRequest["fromDate"]; var query = from o in FDIDB.DN_RequestWare where (!o.IsDelete.HasValue || o.IsDelete == false) && o.AreaID == area // && o.StorageProductID == 1 orderby o.Hour descending select new DNRequestWareHouseItem { GID = o.GID, ProductName = o.Category.Name, Today = o.Today, Hours = o.Hour, DateUpdate = o.DateUpdate, UserUpdate = o.UserUpdate, Quantity = o.Quantity, QuantityActive = o.QuantityActive, //Usercreate = o.StorageWarehousing.DN_Users.LoweredUserName, Date = o.Date, }; if (!string.IsNullOrEmpty(from)) { var fromDate = ConvertDate.TotalSeconds(ConvertUtil.ToDateTime(from)); query = query.Where(c => c.Today == fromDate); } var hours = httpRequest["hours"]; if (!string.IsNullOrEmpty(hours)) { var h = int.Parse(hours); query = query.Where(c => c.Hours == h); } query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <WorkShopItem> GetListSimpleByRequest(HttpRequestBase httpRequest) { Request = new ParramRequest(httpRequest); var query = from c in FDIDB.P_Workshop where (!c.IsDeleted.HasValue || c.IsDeleted == false) orderby c.ID descending select new WorkShopItem { ID = c.ID, Name = c.Name, Address = c.Address, IsActive = c.IsActive, CompanyName = c.Company.Name, DateActive = c.DateActive, UserName = c.DN_Users.UserName, DateCreated = c.DateCreated, Latitute = c.Latitute, Longitude = c.Longitude, }; query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <CarItem> GetListSimpleByRequest(HttpRequestBase httpRequest) { Request = new ParramRequest(httpRequest); var query = from o in FDIDB.Cars where o.IsDelete == false orderby o.ID descending select new CarItem() { ID = o.ID, Quantity = o.Quantity, Name = o.Name, Address = o.Address, CarType = o.CarType, Latitude = o.Latitude, Longitude = o.Longitude, Phone = o.Phone, UnitID = o.UnitID, UnitName = o.DN_Unit.Name }; query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <TemplateDocumentItem> GetListSimpleByRequest(HttpRequestBase httpRequest) { Request = new ParramRequest(httpRequest); var id = int.Parse(httpRequest["type_T"] ?? "0"); var query = from o in FDIDB.TemplateDocuments where o.IsDelete != true && o.IsShow == true orderby o.ID descending select new TemplateDocumentItem { ID = o.ID, Name = o.Name, DateCreate = o.DateCreate, Type = o.Type, Description = o.Description, }; if (id > 0) { query = query.Where(c => c.Type == id); } query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <SaleCodeItem> GetListSimpleByRequestCode(HttpRequestBase httpRequest, int agencyId, int id) { Request = new ParramRequest(httpRequest); var query = from c in FDIDB.SaleCodes where c.SaleID == id orderby c.ID descending select new SaleCodeItem { ID = c.ID, DateUser = c.DateUse, IsUser = c.IsUse, Code = c.Code, }; var use = httpRequest["IsUser_"]; if (!string.IsNullOrEmpty(use)) { var isUse = use != "0"; query = query.Where(c => c.IsUser == isUse); } query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <CompanyItem> GetListSimpleByRequest(HttpRequestBase httpRequest) { Request = new ParramRequest(httpRequest); var query = from c in FDIDB.Companies where (!c.IsDeleted.HasValue || c.IsDeleted == false) orderby c.ID descending select new CompanyItem { ID = c.ID, Name = c.Name, Address = c.Address, DateCreate = c.DateCreate, DateUpdate = c.DateUpdate, UserName = c.DN_Users.UserName, NameRepresent = c.NameRepresent, NumberBank = c.NumberBank, TaxCode = c.TaxCode, Bank = c.Bank, }; query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <WalletItem> GetListCustomerByRequest(HttpRequestBase httpRequest, int agencyId) { Request = new ParramRequest(httpRequest); var from = httpRequest["fromDate"]; var to = httpRequest["toDate"]; var fromDate = !string.IsNullOrEmpty(from) ? from.StringToDecimal(0) : 0; var toDate = !string.IsNullOrEmpty(from) ? to.StringToDecimal(1) : DateTime.Now.TotalSeconds(); var query = from c in FDIDB.Customers where c.WalletCustomers.Any(x => x.DateCreate >= fromDate && x.DateCreate <= toDate) orderby c.ID select new WalletItem { ID = c.ID, CustomerName = c.FullName, Customerphone = c.Phone, CashOut = c.Wallets.Sum(a => a.CashOutWallet), WalletCus = c.Wallets.Sum(a => a.WalletCus), WalletOrder = c.Wallets.Sum(a => a.WalletOrder), Username = c.UserName }; query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }
public List <DNSalesItem> GetListSimpleByRequest(HttpRequestBase httpRequest, int agencyId) { Request = new ParramRequest(httpRequest); var query = from c in FDIDB.DN_Sale where c.AgencyId == agencyId && (!c.IsDeleted.HasValue || c.IsDeleted == false) && c.IsShow == true orderby c.ID descending select new DNSalesItem { ID = c.ID, Name = c.Name, DateEnd = c.DateEnd, DateStart = c.DateStart, Price = c.Price, Percent = c.Percent, AgencyId = c.AgencyId, Username = c.DN_Users.UserName, IsAgency = c.IsAgency, IsAll = c.IsAll, QuantityCode = c.QuantityCode, }; query = query.SelectByRequest(Request, ref TotalRecord); return(query.ToList()); }