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