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));
}
