public DataTables <Ecard.Infrastructure.Models.OrderView> Query(OrderRequest request) { if (request.orderState == 0) { request.orderState = null; } if (request.payState == 0) { request.payState = null; } if (request.distributionstate == 0) { request.distributionstate = null; } SqlParameter[] param = { new SqlParameter("@orderNo", request.orderNo), new SqlParameter("@name", request.name), new SqlParameter("@orderState", request.orderState), new SqlParameter("@payState", request.payState), new SqlParameter("@distributionstate", request.distributionstate), new SqlParameter("@startSubmitTime", request.startSubmitTime), new SqlParameter("@endSubmitTime", request.endSubmitTime), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("P_getOrder", param); return(_databaseInstance.GetTables <Ecard.Infrastructure.Models.OrderView>(sp)); }
public DataTables <Ticketss> GetList(int userId, int pageIndex = 1, int pageSize = 10) { SqlParameter[] param = { new SqlParameter("@userId", userId), new SqlParameter("@pageIndex", pageIndex), new SqlParameter("@pageSize", pageSize) }; StoreProcedure sp = new StoreProcedure("P_getTickets", param); return(_databaseInstance.GetTables <Ticketss>(sp)); }
public DataTables <Commodity> Query(JuMeiMallIndexRequest request) { SqlParameter[] param = { new SqlParameter("@commodityName", null), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), new SqlParameter("@commodityState", CommodityStates.putaway), }; StoreProcedure sp = new StoreProcedure("P_getAllMallGoods", param); return(_databaseInstance.GetTables <Commodity>(sp)); }
public Infrastructure.DataTables <Models.Reviewss> MicroMallQuery(Requests.ReviewRequest request) { SqlParameter[] param = { new SqlParameter("@CommodityId", request.CommodityId), new SqlParameter("@State", request.State), new SqlParameter("@UserId", request.UserId), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("P_getMicroMallReviews", param); return(_databaseInstance.GetTables <Reviewss>(sp)); }
public DataTables <AccountModel> Query(AccountRequest request) { SqlParameter[] param = { new SqlParameter("@DisplayName", request.DisplayName), new SqlParameter("@Mobile", request.Mobile), new SqlParameter("@startTime", request.startTime), new SqlParameter("@endTime", request.endTime), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("P_getAccounts", param); return(_databaseInstance.GetTables <AccountModel>(sp)); }
public DataTables <RecommendLogModel> Query(MemberRecommendLogRequest request) { SqlParameter[] param = { new SqlParameter("@salerName", request.salerName), new SqlParameter("@userName", request.userName), new SqlParameter("@startTime", request.startTime), new SqlParameter("@endTime", request.endTime), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("P_getRecommendLogs", param); return(_databaseInstance.GetTables <RecommendLogModel>(sp)); }
/// <summary> /// 获取角色列表 /// </summary> /// <param name="roleRequest"></param> /// <returns></returns> public DataTables <Role> GetRoles(RoleRequest roleRequest) { SqlParameter[] param = { new SqlParameter("@Name", roleRequest.Name), new SqlParameter("@pageIndex", roleRequest.PageIndex), new SqlParameter("@pageSize", roleRequest.PageSize), new SqlParameter("@DisplayNameWith", roleRequest.DisplayNameWith), new SqlParameter("@NameWith", roleRequest.NameWith), new SqlParameter("@UserId", roleRequest.UserId), new SqlParameter("@State", roleRequest.State) }; StoreProcedure sp = new StoreProcedure("P_getRoles", param); return(_databaseInstance.GetTables <Role>(sp)); }
public DataTables <WithdrawModel> Query(WithdrawRequest request) { if (request.state == 0) { request.state = null; } SqlParameter[] param = { new SqlParameter("@Operator", request.Operator), new SqlParameter("@UserId", request.UserId), new SqlParameter("@state", request.state), new SqlParameter("@startTime", request.startTime), new SqlParameter("@endTime", request.endTime), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("P_getfWithdrawss", param); return(_databaseInstance.GetTables <WithdrawModel>(sp)); }
//public int Insert(Models.CommoditySales item) //{ // throw new NotImplementedException(); //} //public int CanCel(int commoditySalesId) //{ // throw new NotImplementedException(); //} public Infrastructure.DataTables <CommoditySalesStatistics> Query(Requests.CommoditySalesStatisticsRequest request) { SqlParameter[] param = { new SqlParameter("@name", ""), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("P_getCommoditySales", param); return(_databaseInstance.GetTables <CommoditySalesStatistics>(sp)); }
public Infrastructure.DataTables <fz_CommodityCategorys> Query(Requests.CommodityCategorysRequest request) { SqlParameter[] param = { new SqlParameter("@name", request.name), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("Pro_getCommodityCategory", param); return(_databaseInstance.GetTables <fz_CommodityCategorys>(sp)); }
public DataTables <UserAddress> GetByUserId(UserAddressRequest request) { SqlParameter[] param = { new SqlParameter("@UserId", request.UserId), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("P_getFz_UserAddressByUserId", param); return(_databaseInstance.GetTables <UserAddress>(sp)); }
public Infrastructure.DataTables <Models.SecondKillCommoditysss> Query(Requests.SecondKillCommoditysRequest request) { SqlParameter[] param = { new SqlParameter("@commodityNo", request.commodityNo), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("P_getSecondKillCommoditys", param); return(_databaseInstance.GetTables <SecondKillCommoditysss>(sp)); }
public DataTables <OrderDetail> GetByOrderId(OrderDetailRequest request) { SqlParameter[] param = { new SqlParameter("@orderId", request.orderNo), new SqlParameter("@PageIndex", request.PageIndex), new SqlParameter("@PageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("P_getOrdrDetailByOrderId", param); return(_databaseInstance.GetTables <OrderDetail>(sp)); }
public Infrastructure.DataTables <Models.Grades> Query(Requests.GradesRequest request) { SqlParameter[] param = { new SqlParameter("@name", request.name), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("P_getGrades", param); return(_databaseInstance.GetTables <Grades>(sp)); }
public DataTables <Specification> Query(SpecificationRequest request) { SqlParameter[] param = { new SqlParameter("@Name", request.Name), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("P_getSpecification", param); return(_databaseInstance.GetTables <Specification>(sp)); }
public DataTables <Commodity> Query(CommodityRequest request) { if (request.commodityState == 0) { request.commodityState = null; } SqlParameter[] param = { new SqlParameter("@commodityName", request.commodityName), new SqlParameter("@commdityKeyword", request.commdityKeyword), new SqlParameter("@commodityNo", request.commodityNo), new SqlParameter("@commodityState", request.commodityState), new SqlParameter("@startSubmitTime", request.startSubmitTime), new SqlParameter("@endSubmitTime", request.endSubmitTime), new SqlParameter("@commodityCategoryId", request.commodityCategoryId), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("P_getCommodity", param); return(_databaseInstance.GetTables <Commodity>(sp)); }
public DataTables <Log> NewQuery(LogRequest request) { SqlParameter[] param = { new SqlParameter("@UserName", request.UserName), new SqlParameter("@ContentWith", request.ContentWith), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), new SqlParameter("@LogType", request.LogType) }; StoreProcedure sp = new StoreProcedure("P_getLogs", param); return(_databaseInstance.GetTables <Log>(sp)); }
public Infrastructure.DataTables <Models.fz_OperationAmountLogs> GetByUserId(OperationAmountLogUserIdRequest request) { SqlParameter[] param = { new SqlParameter("@userId", request.userId), new SqlParameter("@startTime", request.startTime), new SqlParameter("@endTime", request.endTime), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("P_getOperationAmountLog", param); return(_databaseInstance.GetTables <fz_OperationAmountLogs>(sp)); }
public DataTables <OperationPointLogModel> Query(OperationPointLogRequest request) { SqlParameter[] param = { new SqlParameter("@userId", request.userId), new SqlParameter("@startTime", request.startTime), new SqlParameter("@endTime", request.endTime), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("P_getOperationPointLogs", param); return(_databaseInstance.GetTables <OperationPointLogModel>(sp)); }
public DataTables <PosEndPoint> New_Query(PosEndPointRequest request) { SqlParameter[] param = { new SqlParameter("@Name", request.Name), new SqlParameter("@NameWith", request.NameWith), new SqlParameter("@State", request.State), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), new SqlParameter("@ShopId", request.ShopId) }; StoreProcedure sp = new StoreProcedure("P_getPosEndPoints", param); return(_databaseInstance.GetTables <PosEndPoint>(sp)); }
public DataTables <AdmissionTicket> Query(Requests.AdmissionTicketRequest request) { SqlParameter[] param = { new SqlParameter("@name", request.name), new SqlParameter("@state", request.state), new SqlParameter("@startTime", request.startTime), new SqlParameter("@endTime", request.endTime), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("P_getAdmissionTickets", param); return(_databaseInstance.GetTables <AdmissionTicket>(sp)); }
public DataTables <Shop> NewQuery(ShopRequest request) { SqlParameter[] param = { new SqlParameter("@Name", request.Name), new SqlParameter("@NameWith", request.NameWith), new SqlParameter("@DisplayNameWith", request.DisplayNameWith), new SqlParameter("@State", request.State), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), new SqlParameter("@IsMobileAvailable", request.IsMobileAvailable) }; StoreProcedure sp = new StoreProcedure("P_getShops", param); return(_databaseInstance.GetTables <Shop>(sp)); }
public DataTables <TicketOffs> Query(TicketOffRequest request) { SqlParameter[] param = { new SqlParameter("@type", request.type), new SqlParameter("@Bdate", request.Bdate), new SqlParameter("@Edate", request.Edate), new SqlParameter("@mobile", request.mobile), new SqlParameter("@shopDisplayName", request.shopDisplayName), new SqlParameter("@shopName", request.shopName), new SqlParameter("@pageIndex", request.pageIndex), new SqlParameter("@pageSize", request.pageSize) }; StoreProcedure sp = new StoreProcedure("P_getTicketOff", param); return(_databaseInstance.GetTables <TicketOffs>(sp)); }
public Infrastructure.DataTables <Models.Coupons> Query(Requests.CouponsRequest request) { SqlParameter[] param = { new SqlParameter("@name", request.name), new SqlParameter("@code", request.code), new SqlParameter("@couponsType", request.couponsType), new SqlParameter("@state", request.state), new SqlParameter("@startTime", request.startTime), new SqlParameter("@endTime", request.endTime), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("P_getCoupons", param); return(_databaseInstance.GetTables <Coupons>(sp)); }
public DataTables <WindowTicketings> Query(WindowTicketingRequest request) { SqlParameter[] param = { new SqlParameter("@admissionTicketId", request.admissionTicketId), new SqlParameter("@shopId", request.shopId), new SqlParameter("@Bdate", request.Bdate), new SqlParameter("@Edate", request.Edate), new SqlParameter("@mobile", request.mobile), new SqlParameter("@payType", request.payType), new SqlParameter("@shopName", request.shopName), new SqlParameter("@pageIndex", request.pageIndex), new SqlParameter("@pageSize", request.pageSize) }; StoreProcedure sp = new StoreProcedure("P_getWindowTicketings", param); return(_databaseInstance.GetTables <WindowTicketings>(sp)); }
public DataTables <HandRingPrint> GetList(HandRingPrintRequest request) { SqlParameter[] param = { new SqlParameter("@Bdate", request.Bdate), new SqlParameter("@code", request.code), new SqlParameter("@Edate", request.Edate), new SqlParameter("@mobile", request.mobile), new SqlParameter("@babyName", request.babyName), new SqlParameter("@state", request.state), new SqlParameter("@shopId", request.shopId), new SqlParameter("@ticketType", request.ticketType), new SqlParameter("@pageIndex", request.pageIndex), new SqlParameter("@pageSize", request.pageSize) }; StoreProcedure sp = new StoreProcedure("P_getHandRingPrint", param); return(_databaseInstance.GetTables <HandRingPrint>(sp)); }
public DataTables <Ad> Query(AdRequest request) { if (request.state == 0) { request.state = null; } SqlParameter[] param = { new SqlParameter("@title", request.title), new SqlParameter("@state", request.state), new SqlParameter("@startSubmitTime", request.startSubmitTime), new SqlParameter("@endSubmitTime", request.endSubmitTime), new SqlParameter("@pageIndex", request.PageIndex), new SqlParameter("@pageSize", request.PageSize), }; StoreProcedure sp = new StoreProcedure("P_getAds", param); return(_databaseInstance.GetTables <Ad>(sp)); }
public DataTables <Ordersss> Query(OrdersRequest request) { SqlParameter[] param = { new SqlParameter("@userId", request.userId), new SqlParameter("@mobile", request.mobile), new SqlParameter("@orderNo", request.orderNo), new SqlParameter("@orderState", request.orderState), new SqlParameter("@type", request.type), new SqlParameter("@useScope", request.useScope), new SqlParameter("@Bdate", request.Bdate), new SqlParameter("@Edate", request.Edate), new SqlParameter("@pageIndex", request.pageIndex), new SqlParameter("@pageSize", request.pageSize) }; StoreProcedure sp = new StoreProcedure("P_getOrders", param); return(_databaseInstance.GetTables <Ordersss>(sp)); }
public DataTables <AccountWithOwner> NewQuery(AccountRequest Request) { SqlParameter[] param = { new SqlParameter("@Name", Request.Name), new SqlParameter("@ShopId", Request.ShopId), new SqlParameter("@AccountToken", Request.AccountToken), new SqlParameter("@Ids", Request.Ids), new SqlParameter("@AccountTypeId", Request.AccountTypeId), new SqlParameter("@pageIndex", Request.PageIndex), new SqlParameter("@pageSize", Request.PageSize), new SqlParameter("@IsMobileAvailable", Request.IsMobileAvailable), new SqlParameter("@NameWith", Request.NameWith), new SqlParameter("@Content", Request.Content), new SqlParameter("@State", Request.State), new SqlParameter("@MobileWith", Request.Mobile) }; StoreProcedure sp = new StoreProcedure("P_getAccounts", param); return(_databaseInstance.GetTables <AccountWithOwner>(sp)); }
public DataTables <Distributor> New_InnerQuery() { StoreProcedure sp = new StoreProcedure("P_getDistributors", null); return(_databaseInstance.GetTables <Distributor>(sp)); }