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