public static void SaveCustomerSetting(Model.CustomerSetting customerSetting) { IDataCommand dataCommand = DataCommandManager.GetCommand("Customer_SaveCustomerSetting"); dataCommand.SetParameter("@CustomerSysNo", customerSetting.CustomerSysNo); dataCommand.SetParameter("@Setting", customerSetting.Setting); dataCommand.ExecuteNonQuery(); customerSetting.SysNo = Convert.ToInt32(dataCommand.Parameters["@SysNo"].Value); }
/// <summary> /// 充值增加账户余额 /// </summary> public void UpdateCustomerBalance(int CustomerSysNo, decimal BalancePayAmount) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist"); cmd.CreateCommand("UpdateCustomerBalance"); //DataCommand cmd = new DataCommand("UpdateCustomerBalance"); cmd.SetParameter("@CustomerSysNo", DbType.Int32, CustomerSysNo); cmd.SetParameter("@Balance", DbType.Decimal, BalancePayAmount); cmd.ExecuteNonQuery(); }
public static bool Login(Model.Customer customer) { IDataCommand dataCommand = DataCommandManager.GetCommand("Customer_Login"); dataCommand.SetParameter("@CustomerID", customer.CustomerID); dataCommand.SetParameter("@Password", customer.Password); int result = dataCommand.ExecuteScalar <int>(); return(result == 1); }
/// <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> /// 删除FavoriteProduct信息 /// </summary> public void DeleteFavoriteProduct(int usersysno, int productsysno) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("DeleteFavoriteProduct"); //DataCommand cmd = new DataCommand("DeleteFavoriteProduct"); cmd.SetParameter("@ProductSysNo", DbType.Int32, productsysno); cmd.SetParameter("@CustomerSysNo", DbType.Int32, usersysno); cmd.ExecuteNonQuery(); }
public static void UpdateRetrieveTaskStatus(Model.RetrieveTask retrieveTask) { IDataCommand dataCommand = DataCommandManager.GetCommand("Task_UpdateRetrieveTaskStatus"); dataCommand.SetParameter("@TaskSysNo", retrieveTask.RunTaskSysNo); dataCommand.SetParameter("@RetrieveTask", retrieveTask.SysNo); dataCommand.SetParameter("@Status", retrieveTask.Status); dataCommand.SetParameter("@Description", retrieveTask.Description); dataCommand.ExecuteNonQuery(); }
/// <summary> /// 订单是否存在护理日志 /// </summary> /// <param name="soSysNo"></param> /// <param name="status"></param> /// <returns></returns> public int IsExsitNursingDaily(int soSysNo, int status) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("Order_IsExistsNursingDiary"); //DataCommand cmd = new DataCommand("Order_IsExistsNursingDiary"); cmd.SetParameter("@OrderSysNo", DbType.Int32, soSysNo); cmd.SetParameter("@NursingStatus", DbType.Int32, status); return(Convert.ToInt32(cmd.ExecuteScalar())); }
/// <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>()); }
/// <summary> /// 确认消费记录 /// </summary> public static void Confirmconsum(int sysno, int score) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("Confirmconsum"); //DataCommand cmd = new DataCommand("Confirmconsum"); cmd.SetParameter("@SysNo", DbType.Int32, sysno); cmd.SetParameter("@Rate", DbType.Int32, score); cmd.ExecuteNonQuery(); }
//注册送积分 public void UpdateCustomerPoint(int SysNo, int point) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist"); cmd.CreateCommand("UpdateCustomerPoint"); //DataCommand cmd = new DataCommand("UpdateCustomerPoint"); cmd.SetParameter("@SysNo", DbType.Int32, SysNo); cmd.SetParameter("@point", DbType.Int32, point); cmd.ExecuteNonQuery(); }
public void UpdateCellPhoneConfirmTempStatus(CellPhoneConfirmTemp item) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist"); cmd.CreateCommand("UpdateCellPhoneConfirmTempStatus"); //DataCommand cmd = new DataCommand("UpdateCellPhoneConfirmTempStatus"); cmd.SetParameter("@SysNo", DbType.Int32, item.SysNo); cmd.SetParameter("@Status", DbType.Int32, item.Status); cmd.ExecuteNonQuery(); }
/// <summary> /// 检查商品评价是否存在 /// </summary> /// <param name="sosysno"></param> /// <param name="productSysNo"></param> /// <returns></returns> public bool CheckProductCommentExists(int sosysno, int productSysNo) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("CheckProductCommentExists"); //var cmd = new DataCommand("CheckProductCommentExists"); cmd.SetParameter("@SOSysNo", DbType.Int32, sosysno); cmd.SetParameter("@ProductSysNo", DbType.Int32, productSysNo); return(cmd.ExecuteScalar <bool>()); }
public void AbandonOrderAdjustCountDownProductInventory(int soSysNo) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("AbandonOrderAdjustCountDownProductInventory"); //DataCommand cmd = new DataCommand("AbandonOrderAdjustCountDownProductInventory"); cmd.SetParameter("@SOSysNo", DbType.Int32, soSysNo); cmd.SetParameter("@PromotionType", DbType.Int32, (int)PromotionType.Countdown); cmd.ExecuteNonQuery(); }
public void UpdateRefundCallback(int refundSysNo, SOIncomeBillStatus sOIncomeBillStatus) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("UpdateRefundCallback"); //DataCommand cmd = new DataCommand("UpdateRefundCallback"); cmd.SetParameter("@RefundSysNo", DbType.Int32, refundSysNo); cmd.SetParameter("@SOIncomeBillStatus", DbType.Int32, sOIncomeBillStatus); cmd.ExecuteScalar <int>(); }
public bool CheckIpCount(string ip, int day, int count) { IDataCommand dataCommand = IocManager.Instance.Resolve <IDataCommand>(); dataCommand.CreateCommand("CustomerCheckIpCount"); //DataCommand dataCommand = new DataCommand("CustomerCheckIpCount"); dataCommand.SetParameter("@IP", DbType.String, ip); dataCommand.SetParameter("@day", DbType.Int32, day); var result = dataCommand.ExecuteScalar(); return(result != null && int.Parse(result.ToString()) >= count); }
public int IsFavoriteProduct(int customerSysNo, int productSysNo) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("IsFavoriteProduct"); //DataCommand cmd = new DataCommand("IsFavoriteProduct"); cmd.SetParameter("@CustomerSysNo", DbType.Int32, customerSysNo); cmd.SetParameter("@ProductSysNo", DbType.Int32, productSysNo); return(Convert.ToInt32(cmd.ExecuteScalar())); }
/// <summary> /// 添加Token /// </summary> /// <param name="commonToken"></param> /// <param name="expiresIn"></param> public void AddWeiXinCommonToken(string commonToken, int expiresIn) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("AddWeiXinCommonToken"); //DataCommand cmd = new DataCommand("AddWeiXinCommonToken"); cmd.SetParameter("@CommonToken", DbType.String, commonToken); cmd.SetParameter("@ExpiresIn", DbType.Int32, expiresIn); cmd.ExecuteNonQuery(); }
public int UpdateRechargeRequestStatus(int sysNo, RechargeStatus oldStatus, RechargeStatus newStatus) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist"); cmd.CreateCommand("UpdateRechargeRequestStatus"); //DataCommand cmd = new DataCommand("UpdateRechargeRequestStatus"); cmd.SetParameter("@SysNo", DbType.Int32, sysNo); cmd.SetParameter("@OldStatus", DbType.Int32, (Int32)oldStatus); cmd.SetParameter("@NewStatus", DbType.Int32, (Int32)newStatus); return(Convert.ToInt32(cmd.ExecuteScalar())); }
/// <summary> /// 修改绑定的设备号 /// </summary> /// <param name="customerSysNo"></param> /// <param name="channelId"></param> /// <param name="deviceType"></param> public void UpdateMemberDevice(int customerSysNo, string channelId, int deviceType) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("UpdateMemberDevice"); //DataCommand cmd = new DataCommand("UpdateMemberDevice"); cmd.SetParameter("@CustomerSysNo", DbType.Int32, customerSysNo); cmd.SetParameter("@ChannelID", DbType.String, channelId); cmd.SetParameter("@DeviceType", DbType.Int32, deviceType); cmd.ExecuteNonQuery(); }
public void UpdateSOStatus(int soSysNo, SOStatus newStatus, SOStatus oldStatus) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("Order_UpdateSOStatus"); //DataCommand cmd = new DataCommand("Order_UpdateSOStatus"); cmd.SetParameter("@SOSysNo", DbType.Int32, soSysNo); cmd.SetParameter("@NewStatus", DbType.Int32, (int)newStatus); cmd.SetParameter("@OldStatus", DbType.Int32, (int)oldStatus); cmd.ExecuteNonQuery(); }
public void UpdatePwdByCustomerID(string cellNumber, string pwd, string pwdSalt) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist"); cmd.CreateCommand("UpdatePwdByCustomerID"); //DataCommand cmd = new DataCommand("UpdatePwdByCustomerID"); cmd.SetParameter("@CustomerID", DbType.String, cellNumber); cmd.SetParameter("@Pwd", DbType.String, pwd); cmd.SetParameter("@PwdSalt", DbType.String, pwdSalt); cmd.ExecuteNonQuery(); }
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); }
/// 获取单个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); }
/// <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); }
public bool UpdateSOStatusToAbandon(int soSysNo, SOStatus soStatus, int userSysNo, string userName) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("UpdateSOStatusToAbandon"); //DataCommand cmd = new DataCommand("UpdateSOStatusToAbandon"); cmd.SetParameter("@SOSysNo", DbType.Int32, soSysNo);; cmd.SetParameter("@OldStatus", DbType.Int32, soStatus); cmd.SetParameter("@EditUserSysNo", DbType.Int32, userSysNo); cmd.SetParameter("@EditUserName", DbType.AnsiString, userName, 40); return(cmd.ExecuteScalar <int>() > 0); }
public bool updateRechargePayType(int soSysNo, string payTypeID, int userSysNo, string userName) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("updateRechargePayType"); //DataCommand cmd = new DataCommand("updateRechargePayType"); cmd.SetParameter("@SOSysNo", DbType.Int32, soSysNo); cmd.SetParameter("@PayTypeID", DbType.Int32, payTypeID); cmd.SetParameter("@EditUserSysNo", DbType.Int32, userSysNo); cmd.SetParameter("@EditUserName", DbType.AnsiStringFixedLength, userName, 40); cmd.ExecuteNonQuery(); return(true); }
/// <summary> /// 创建销售收款单 /// </summary> /// <param name="soNetPay"></param> /// <param name="incomeType">收款单类型 0:正收款单 1:AO 2:RO</param> /// <returns></returns> public bool CreateSOIncome(SONetPay soNetPay, int incomeType, int status = 0) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("CreateSOIncome"); //DataCommand cmd = new DataCommand("CreateSOIncome"); cmd.SetParameter <SONetPay>(soNetPay); cmd.SetParameter("@PayAmount", DbType.Decimal, incomeType > 0 ? soNetPay.PayAmount : -soNetPay.PayAmount); cmd.SetParameter("@SOIncomeType", DbType.Int32, incomeType); cmd.SetParameter("@SOIncomeBillStatus", DbType.Int32, status); int result = cmd.ExecuteNonQuery(); return(result > 0); }
/// <summary> /// 获取广告信息 /// </summary> /// <param name="pageID">页面ID</param> /// <param name="pageType">页面类型</param> /// <param name="positionID">广告位ID</param> /// <returns>广告信息列表</returns> public List <PageRecommendInfo> GetBannerInfoByPositionID(int?pageID, PageType pageType, BannerPosition?positionID) { IDataCommand dataCommand = IocManager.Instance.Resolve <IDataCommand>(); dataCommand.CreateCommand("Content_GetBannerInfoByPositionID"); ///DataCommand dataCommand = new DataCommand("Content_GetBannerInfoByPositionID"); dataCommand.SetParameter("@PageID", DbType.AnsiStringFixedLength, pageID); dataCommand.SetParameter("@PageType", DbType.Int32, pageType); dataCommand.SetParameter("@PositionID", DbType.String, positionID); List <PageRecommendInfo> entitys = dataCommand.ExecuteEntityList <PageRecommendInfo>(); return(entitys); }
public List <SODiscountMaster> GetSODiscountBySOSysNo(int sosysno) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("GetSODiscountBySOSysNo"); //DataCommand cmd = new DataCommand("GetSODiscountBySOSysNo"); cmd.SetParameter("@SOSysNo", DbType.Int32, sosysno); DataSet ds = cmd.ExecuteDataSet(); List <SODiscountMaster> dmList = null; if (ds != null && ds.Tables.Count > 1) { dmList = DataMapperHelper.GetEntityList <SODiscountMaster, List <SODiscountMaster> >(ds.Tables[0].Rows); if (dmList != null && dmList.Count > 0) { List <SODiscountDetail> ddList = DataMapperHelper.GetEntityList <SODiscountDetail, List <SODiscountDetail> >(ds.Tables[1].Rows); foreach (var dm in dmList) { dm.Details = ddList.FindAll(dd => dd.MasterSysNo == dm.SysNo); } } } return(dmList); }