public static Model.CustomerSetting GetCustomerSetting(int customerSysNo)
{
IDataCommand dataCommand = DataCommandManager.GetCommand("Customer_GetCustomerSetting");
dataCommand.SetParameter("@CustomerSysNo", customerSysNo);
return(dataCommand.ExecuteEntity <Model.CustomerSetting>());
}
public static Model.RetrieveTask RetrieveTask(int customerSysNo)
{
IDataCommand dataCommand = DataCommandManager.GetCommand("Task_RetrieveTask");
dataCommand.SetParameter("@CustomerSysNo", customerSysNo);
return(dataCommand.ExecuteEntity <Model.RetrieveTask>());
}
/// <summary>
/// 获取单个ProductPrice信息
/// </summary>
public ProductPrice LoadProductPrice(int sysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve<IDataCommand>();
cmd.CreateCommand("LoadProductPrice");
//DataCommand cmd = new DataCommand("LoadProductPrice");
cmd.SetParameter("@SysNo", DbType.Int32, sysNo);
ProductPrice result = cmd.ExecuteEntity<ProductPrice>();
return result;
}
public SOMaster GetSOMaster(int sosysno)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("GetSOMaster");
//DataCommand cmd = new DataCommand("GetSOMaster");
cmd.SetParameter("@SysNo", DbType.Int32, sosysno);
return(cmd.ExecuteEntity <SOMaster>());
}
public static Model.Customer CustomerDetail(Model.Customer customer)
{
IDataCommand dataCommand = DataCommandManager.GetCommand("Customer_CustomerDetail");
dataCommand.SetParameter("@CustomerID", customer.CustomerID);
Model.Customer customerInfo = dataCommand.ExecuteEntity <Model.Customer>();
return(customerInfo);
}
public SORefund GetSORefund(int sysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("Order_GetSORefund");
//DataCommand cmd = new DataCommand("Order_GetSORefund");
cmd.SetParameter("@SysNo", DbType.Int32, sysNo);
return(cmd.ExecuteEntity <SORefund>());
}
public QR_ProductCommentStatistics QueryProductCommentStatistics(int productSysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("QueryProductCommentStatistics");
//var cmd = new DataCommand("QueryProductCommentStatistics");
cmd.SetParameter("ProductSysNo", DbType.Int32, productSysNo);
return(cmd.ExecuteEntity <QR_ProductCommentStatistics>());
}
public CountdownInfo LoadCountdown(int productSysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("Seckill_LoadCountDown");
//DataCommand dataCommand = new DataCommand("Seckill_LoadCountDown");
cmd.SetParameter("@ProductSysNo", DbType.Int32, productSysNo);
return(cmd.ExecuteEntity <CountdownInfo>());
}
/// <summary>
/// 根据订单号和商品编号加载RMAMaster信息
/// </summary>
/// <param name="rmasysno"></param>
/// <param name="productSysNo"></param>
/// <returns></returns>
public static RMAMaster GetRMAMasterBySOSysNoAndProductSysNo(int sosysno, int productSysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("GetRMAMasterBySOSysNoAndProductSysNo");
//var cmd = new DataCommand("GetRMAMasterBySOSysNoAndProductSysNo");
cmd.SetParameter("@SOSysNo", DbType.Int32, sosysno);
cmd.SetParameter("@ProductSysNo", DbType.Int32, productSysNo);
return(cmd.ExecuteEntity <RMAMaster>());
}
/// <summary>
/// 通过订单编号和商品编号获得商品评论
/// </summary>
/// <param name="sosysno"></param>
/// <param name="productSysNo"></param>
/// <returns></returns>
public ProductComment GetProductCommentBySoSysNoAndProductSysNo(int sosysno, int productSysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("GetProductCommentBySoSysNoAndProductSysNo");
//var cmd = new DataCommand("GetProductCommentBySoSysNoAndProductSysNo");
cmd.SetParameter("@SoSysNo", DbType.Int32, sosysno);
cmd.SetParameter("@ProductSysNo", DbType.Int32, productSysNo);
return(cmd.ExecuteEntity <ProductComment>());
}
public CellPhoneConfirmTemp GetVerifyVodeByCellNumber(string cellNumber)
{
IDataCommand datacommand = IocManager.Instance.Resolve <IDataCommand>();
datacommand.CreateCommand("GetVerifyVodeByCellNumber");
//DataCommand datacommand = new DataCommand("GetVerifyVodeByCellNumber");
datacommand.SetParameter("@CellNumber", DbType.String, cellNumber);
CellPhoneConfirmTemp result = datacommand.ExecuteEntity <CellPhoneConfirmTemp>();
return(result);
}
public RechargeRequest LoadRechargeRequest(int sysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist");
cmd.CreateCommand("LoadRechargeRequest");
//DataCommand cmd = new DataCommand("LoadRechargeRequest");
cmd.SetParameter("@SysNo", DbType.Int32, sysNo);
RechargeRequest result = cmd.ExecuteEntity <RechargeRequest>();
return(result);
}
public Area LoadArea(int sysno)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("LoadArea");
//DataCommand datacommand = new DataCommand("LoadArea");
cmd.SetParameter("@SysNo", DbType.Int32, sysno);
Area result = cmd.ExecuteEntity <Area>();
return(result);
}
/// <summary>
/// 获取单个Topic信息
/// </summary>
public Topic LoadTopic(int sysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("LoadTopic");
//DataCommand cmd = new DataCommand("LoadTopic");
cmd.SetParameter("@SysNo", DbType.Int32, sysNo);
Topic result = cmd.ExecuteEntity <Topic>();
return(result);
}
public static RechargeRequest InsertRecharge(RechargeRequest entity)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("InsertRecharge");
//DataCommand cmd = new DataCommand("InsertRecharge");
cmd.SetParameter <RechargeRequest>(entity);
RechargeRequest result = cmd.ExecuteEntity <RechargeRequest>();
return(result);
}
public static RechargeRequest LoadRecharge(int sosysno)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("LoadRecharge");
//DataCommand cmd = new DataCommand("LoadRecharge");
cmd.SetParameter("@SoSysNo", DbType.Int32, sosysno);
RechargeRequest result = cmd.ExecuteEntity <RechargeRequest>();
return(result);
}
/// <summary>
/// 获取单个Authentication信息
/// </summary>
public Authentication LoadAuthentication(int customerSysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist");
cmd.CreateCommand("LoadAuthentication");
//DataCommand cmd = new DataCommand("LoadAuthentication");
cmd.SetParameter("@CustomerSysNo", DbType.Int32, customerSysNo);
Authentication result = cmd.ExecuteEntity <Authentication>();
return(result);
}
/// <summary>
/// 获取单个RMAMaster信息
/// </summary>
public static RMAMaster LoadRMAMaster(int sysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("LoadRMAMaster");
//DataCommand cmd = new DataCommand("LoadRMAMaster");
cmd.SetParameter("@SysNo", DbType.Int32, sysNo);
RMAMaster result = cmd.ExecuteEntity <RMAMaster>();
return(result);
}
/// <summary>
/// 插入预约记录
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public static QR_ReservationRecords InsertReservationRecords(QR_ReservationRecords entity)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("InsertReservationRecords");
//DataCommand cmd = new DataCommand("InsertReservationRecords");
cmd.SetParameter <QR_ReservationRecords>(entity);
QR_ReservationRecords result = cmd.ExecuteEntity <QR_ReservationRecords>();
return(result);
}
public CustomerInfo GetCustomerInfoByCustomerID(string tel)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist");
cmd.CreateCommand("GetCustomerInfoByCustomerID");
//DataCommand cmd = new DataCommand("GetCustomerInfoByCustomerID");
cmd.SetParameter("@CustomerID", DbType.String, tel);
CustomerInfo result = cmd.ExecuteEntity <CustomerInfo>();
return(result);
}
/// <summary>
/// 获取单个PromotionTemplates信息
/// </summary>
public PromotionTemplates LoadPromotionTemplates(int sysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("LoadPromotionTemplates");
//DataCommand cmd = new DataCommand("LoadPromotionTemplates");
cmd.SetParameter("@SysNo", DbType.Int32, sysNo);
PromotionTemplates result = cmd.ExecuteEntity <PromotionTemplates>();
return(result);
}
/// <summary>
/// 根据sysno 查询消费记录信息
/// </summary>
/// <param name="sysNo"></param>
/// <returns></returns>
public static NursingDiaryItem LoadNursingDiaryItem(int sysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("LoadNursingDiaryItem");
//DataCommand cmd = new DataCommand("LoadNursingDiaryItem");
cmd.SetParameter("@SysNo", DbType.Int32, sysNo);
NursingDiaryItem result = cmd.ExecuteEntity <NursingDiaryItem>();
return(result);
}
/// <summary>
/// 获取单个CustomerInfo信息
/// </summary>
public CustomerInfo LoadCustomerInfo(int sysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist");
cmd.CreateCommand("LoadCustomerInfo");
//DataCommand cmd = new DataCommand("LoadCustomerInfo");
cmd.SetParameter("@SysNo", DbType.Int32, sysNo);
CustomerInfo result = cmd.ExecuteEntity <CustomerInfo>();
return(result);
}
/// <summary>
/// 获取单个ShippingAddress信息
/// </summary>
public ShippingAddress LoadShippingAddress(int sysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("LoadShippingAddress");
//DataCommand cmd = new DataCommand("LoadShippingAddress");
cmd.SetParameter("@SysNo", DbType.Int32, sysNo);
ShippingAddress result = cmd.ExecuteEntity <ShippingAddress>();
return(result);
}
public CustomerMapping LoadCustomerMappingForCustomer(int customerSysno, int thridtype)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist");
cmd.CreateCommand("LoadCustomerMappingForCustomer");
//DataCommand cmd = new DataCommand("LoadCustomerMappingForCustomer");
cmd.SetParameter("@CustomerSysNo", DbType.Int32, customerSysno);
cmd.SetParameter("@ThirdType", DbType.Int32, thridtype);
CustomerMapping result = cmd.ExecuteEntity <CustomerMapping>();
return(result);
}
/// <summary>
/// 获取单个CustomerMapping信息
/// </summary>
public CustomerMapping LoadCustomerMapping(string openid, int thridtype)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist");
cmd.CreateCommand("LoadCustomerMapping");
//DataCommand cmd = new DataCommand("LoadCustomerMapping");
cmd.SetParameter("@OpenID", DbType.String, openid);
cmd.SetParameter("@ThirdType", DbType.Int32, thridtype);
CustomerMapping result = cmd.ExecuteEntity <CustomerMapping>();
return(result);
}
/// 获取单个Coupon信息
/// </summary>
public Coupon LoadCoupon(int sysNo, int userSysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("LoadCoupon");
//DataCommand cmd = new DataCommand("LoadCoupon");
cmd.SetParameter("@SysNo", DbType.Int32, sysNo);
cmd.SetParameter("@UserSysNo", DbType.Int32, userSysNo);
Coupon result = cmd.ExecuteEntity <Coupon>();
return(result);
}
public static QR_ReservationRecords QuerySO(int customerSysNo, int productSysNo)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("QuerySO");
//DataCommand cmd = new DataCommand("QuerySO");
cmd.SetParameter("@CustomerSysNo", DbType.Int32, customerSysNo);
cmd.SetParameter("@ProductSysNo", DbType.Int32, productSysNo);
QR_ReservationRecords result = cmd.ExecuteEntity <QR_ReservationRecords>();
return(result);
}
