public int DeletOrderInfo(string orderCode)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@OrderCode", orderCode, System.Data.DbType.String);
return(DapperSqlHelper.ExcuteNonQuery <Order>(@"delete [dbo].[Order] where OrderCode=@OrderCode", paras, false));
}
public bool Insert(financialStatements model)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@Code", model.Code, System.Data.DbType.String);
paras.Add("@CreateTime", model.CreateTime, System.Data.DbType.String);
paras.Add("@UserPhone", model.UserPhone, System.Data.DbType.String);
paras.Add("@UserCreateTime", model.UserCreateTime, System.Data.DbType.String);
paras.Add("@StoreName", model.StoreName, System.Data.DbType.String);
paras.Add("@ProductionType", model.ProductionType, System.Data.DbType.String);
paras.Add("@Cstname", model.Cstname, System.Data.DbType.String);
paras.Add("@ProductionCode", model.ProductionCode, System.Data.DbType.String);
paras.Add("@ProductionName", model.ProductionName, System.Data.DbType.String);
paras.Add("@Iquantity", model.Iquantity, System.Data.DbType.String);
paras.Add("@Itaxunitprice", model.Itaxunitprice, System.Data.DbType.String);
paras.Add("@Isum", model.Isum, System.Data.DbType.String);
paras.Add("@CpersonName", model.CpersonName, System.Data.DbType.String);
paras.Add("@PayType", model.PayType, System.Data.DbType.String);
paras.Add("@AmountOfIncome", model.AmountOfIncome, System.Data.DbType.String);
paras.Add("@DonationAmount", model.DonationAmount, System.Data.DbType.String);
paras.Add("@CouponUseCode", model.CouponUseCode, System.Data.DbType.String);
paras.Add("@CouponUseMoney", model.CouponUseMoney, System.Data.DbType.String);
paras.Add("@GetCouponTime", model.GetCouponTime, System.Data.DbType.String);
paras.Add("@UseWalletMoney", model.UseWalletMoney, System.Data.DbType.String);
paras.Add("@Ratio", model.Ratio, System.Data.DbType.String);
paras.Add("@RecordsOfConsumptionCreateTime", model.RecordsOfConsumptionCreateTime, System.Data.DbType.String);
paras.Add("@WriteOffUser", model.WriteOffUser, System.Data.DbType.String);
paras.Add("@ProductionCode1", model.ProductionCode1, System.Data.DbType.String);
paras.Add("@ProductionName1", model.ProductionName1, System.Data.DbType.String);
paras.Add("@ExperiencePrice", model.ExperiencePrice, System.Data.DbType.String);
paras.Add("@Iquantity1", model.Iquantity1, System.Data.DbType.String);
paras.Add("@RecordsMoney", model.RecordsMoney, System.Data.DbType.String);
paras.Add("@CouponUseMoney1", model.CouponUseMoney1, System.Data.DbType.String);
paras.Add("@ActualConsumption", model.ActualConsumption, System.Data.DbType.String);
paras.Add("@UseWalletMoney1", model.UseWalletMoney1, System.Data.DbType.String);
paras.Add("@UseWalletAccountPrincipal", model.UseWalletAccountPrincipal, System.Data.DbType.String);
paras.Add("@FinancialRevenueAccounting", model.FinancialRevenueAccounting, System.Data.DbType.String);
paras.Add("@Imoney", model.Imoney, System.Data.DbType.String);
paras.Add("@ProductInfoRate", model.ProductInfoRate, System.Data.DbType.String);
paras.Add("@Itax", model.Itax, System.Data.DbType.String);
paras.Add("@GrossProfit", model.GrossProfit, System.Data.DbType.String);
paras.Add("@OrderNo", model.OrderNo, System.Data.DbType.String);
string sql = (@"INSERT INTO dbo.financialStatements
(Code,CreateTime ,UserPhone,UserCreateTime,StoreName ,ProductionType,Cstname ,ProductionCode,ProductionName
,Iquantity,Itaxunitprice,Isum,CpersonName,PayType,AmountOfIncome ,DonationAmount
,CouponUseCode,CouponUseMoney,GetCouponTime,UseWalletMoney,Ratio,RecordsOfConsumptionCreateTime
,WriteOffUser,ProductionCode1,ProductionName1,ExperiencePrice,Iquantity1
,RecordsMoney ,CouponUseMoney1 ,ActualConsumption ,UseWalletMoney1,UseWalletAccountPrincipal
,FinancialRevenueAccounting,Imoney ,ProductInfoRate ,Itax ,GrossProfit,OrderNo)
values(@Code,@CreateTime ,@UserPhone,@UserCreateTime,@StoreName ,@ProductionType,@Cstname ,@ProductionCode,@ProductionName
,@Iquantity,@Itaxunitprice,@Isum,@CpersonName,@PayType,@AmountOfIncome ,@DonationAmount
,@CouponUseCode,@CouponUseMoney,@GetCouponTime,@UseWalletMoney,@Ratio,@RecordsOfConsumptionCreateTime
,@WriteOffUser,@ProductionCode1,@ProductionName1,@ExperiencePrice,@Iquantity1
,@RecordsMoney ,@CouponUseMoney1 ,@ActualConsumption ,@UseWalletMoney1,@UseWalletAccountPrincipal
,@FinancialRevenueAccounting,@Imoney ,@ProductInfoRate ,@Itax ,@GrossProfit,@OrderNo)");
DapperSqlHelper.ExcuteNonQuery <Coupon>(sql, paras, false);
return(true);
}
public int Delete(string orderCode)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@orderCode", orderCode, System.Data.DbType.String);
return(DapperSqlHelper.ExcuteNonQuery <Verification>(@"delete [dbo].[WriteOff] where orderCode=@orderCode", paras, false));
}
public int UpdateReferenceNumber(string userCode, string ReferenceNumber)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@ReferenceNumber", ReferenceNumber, System.Data.DbType.String);
paras.Add("@Code", userCode, System.Data.DbType.String);
return(DapperSqlHelper.ExcuteNonQuery <User>(@"Update [dbo].[User] set ReferenceNumber=@ReferenceNumber where Code=@Code", paras, false));
}
public int Delete(string phone)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@phone", phone, System.Data.DbType.String);
return(DapperSqlHelper.ExcuteNonQuery <Verification>(@"delete [dbo].[Verification] where phone=@phone", paras, false));
}
public bool UpdateUserTask(string UserTaskCode, int IsComplete)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@UserTaskCode", UserTaskCode, System.Data.DbType.String);
paras.Add("@IsComplete", IsComplete, System.Data.DbType.Int32);
string sql = "update [dbo].[UserTask] set IsComplete=@IsComplete ,TaskEndTime=getDate() where UserTaskCode=@UserTaskCode";
DapperSqlHelper.ExcuteNonQuery <UserTask>(sql, paras, false);
return(true);
}
public bool UpdateData(string userCode, decimal money, string OrderCode, out decimal?recordsaccountPrincipalTemp)
{
IRecordsOfConsumptionService _recordsOfConsumption = new RecordsOfConsumptionService();
decimal total = 0;
decimal? kouchumoney = 0m;
IList <UseWallet> list = GetUseWallet(userCode);
list = list.OrderBy(t => t.Sort).ToList();
decimal?recordsdonationAmount = 0m;
decimal?recordsaccountPrincipal = 0m;
foreach (var w in list)
{
if (w.AccountPrincipal > 0)
{
//var ratio = decimal.Parse(w.Ratio);
var ratio = Convert.ToDecimal(w.Ratio);
var tempTotal = decimal.Parse((w.AccountPrincipal + w.DonationAmount).ToString());
total = total + tempTotal;
var tempmoney = money - total;
decimal?donationAmount = 0;
decimal?accountPrincipal = 0;
if (tempmoney >= 0)
{
donationAmount = 0;
accountPrincipal = 0;
kouchumoney = kouchumoney + w.AccountPrincipal + w.DonationAmount;
recordsdonationAmount = recordsdonationAmount + w.DonationAmount;
recordsaccountPrincipal = recordsaccountPrincipal + w.AccountPrincipal;
}
else
{
donationAmount = w.DonationAmount - ((money - kouchumoney) - ((money - kouchumoney) * (1 - ratio)));
accountPrincipal = w.AccountPrincipal - (money - kouchumoney) * (1 - ratio);
recordsdonationAmount = recordsdonationAmount + ((money - kouchumoney) - ((money - kouchumoney) * (1 - ratio)));
recordsaccountPrincipal = recordsaccountPrincipal + (money - kouchumoney) * (1 - ratio);
}
DynamicParameters paras = new DynamicParameters();
paras.Add("@WalletCode", w.WalletCode, System.Data.DbType.String);
paras.Add("@DonationAmount", donationAmount, System.Data.DbType.Decimal);
paras.Add("@AccountPrincipal", accountPrincipal, System.Data.DbType.Decimal);
string sql = "update [dbo].[UseWallet] set AccountPrincipal=@AccountPrincipal,DonationAmount=@DonationAmount where WalletCode=@WalletCode";
int i = DapperSqlHelper.ExcuteNonQuery <UseWallet>(sql, paras, false);
}
if (total >= money)
{
_recordsOfConsumption.InsertRecore("0", userCode, money, "", recordsdonationAmount, recordsaccountPrincipal, OrderCode, false);
recordsaccountPrincipalTemp = recordsaccountPrincipal;
return(true);
}
}
recordsaccountPrincipalTemp = recordsaccountPrincipal;
return(true);
}
public int UpdateByuserCodePhone(string userCode, string phone, DateTime birthday, string idcard)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@phone", phone, System.Data.DbType.String);
paras.Add("@Code", userCode, System.Data.DbType.String);
paras.Add("@birthday", birthday, System.Data.DbType.DateTime);
paras.Add("@IsMember", true, System.Data.DbType.Boolean);
paras.Add("@ReferenceNumber", idcard, System.Data.DbType.String);
return(DapperSqlHelper.ExcuteNonQuery <User>(@"Update [dbo].[User] set phone=@phone,birthday=@birthday,IsMember=@IsMember,ReferenceNumber=@ReferenceNumber where Code=@Code", paras, false));
}
public int UpdateTopupOrder(string prepayid, DateTime?payDatetime)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@PayDatetime", payDatetime, System.Data.DbType.DateTime);
paras.Add("@WallePrCode", prepayid, System.Data.DbType.String);
string sql = @"update [dbo].[TopupOrder] set PayDatetime=@PayDatetime
where WallePrCode=@WallePrCode";
return(DapperSqlHelper.ExcuteNonQuery <Order>(sql, paras, false));
}
/// <summary>
/// 使用
/// </summary>
/// <param name="couponCode"></param>
public bool UsedUpdate(string couponCode, string userCode, string orderCode)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@CouponUseCode", couponCode, System.Data.DbType.String);
paras.Add("@userCode", userCode, System.Data.DbType.String);
paras.Add("@orderCode", orderCode, System.Data.DbType.String);
string sql = "update [dbo].[Coupon] set IsUsed=1, UseTime=getdate(),userCode=@userCode,orderCode=@orderCode where CouponUseCode=@CouponUseCode";
DapperSqlHelper.ExcuteNonQuery <Coupon>(sql, paras, false);
return(true);
}
public int CreateWriteOff(WriteOff writeOff)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@writeOffCode", writeOff.WriteOffCode, System.Data.DbType.String);
paras.Add("@orderCode", writeOff.OrderCode, System.Data.DbType.String);
paras.Add("@CreateTime", DateTime.Now, System.Data.DbType.DateTime);
return(DapperSqlHelper.ExcuteNonQuery <WriteOff>(@"INSERT INTO [dbo].[WriteOff]([WriteOffCode],[OrderCode],[CreateTime] )
VALUES ( @writeOffCode,
@orderCode,
@CreateTime )", paras, false));
}
public int UpdateStoreaccessToken(Store store)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@accessToken", store.accessToken, System.Data.DbType.String);
paras.Add("@jsapi_ticket", store.jsapi_ticket, System.Data.DbType.String);
paras.Add("@api_ticket", store.api_ticket, System.Data.DbType.String);
paras.Add("@accessTokenCreateTime", store.accessTokenCreateTime, System.Data.DbType.DateTime);
paras.Add("@StoreCode", store.StoreCode, System.Data.DbType.String);
string sql = @"update [dbo].[Store] set accessToken=@accessToken,jsapi_ticket=@jsapi_ticket,accessTokenCreateTime=@accessTokenCreateTime,api_ticket= @api_ticket
where StoreCode=@StoreCode";
return(DapperSqlHelper.ExcuteNonQuery <Store>(sql, paras, false));
}
public int CreateVerification(Verification verification)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@Code", verification.code, System.Data.DbType.String);
paras.Add("@phone", verification.Phone, System.Data.DbType.String);
paras.Add("@verificationCode", verification.VerificationCode, System.Data.DbType.String);
paras.Add("@CreateTime", DateTime.Now, System.Data.DbType.DateTime);
return(DapperSqlHelper.ExcuteNonQuery <Verification>(@"INSERT INTO [dbo].[Verification]([Code],[phone],[verificationCode] ,[CreateTime] )
VALUES ( @Code,
@phone,
@verificationCode,
@CreateTime )", paras, false));
}
public bool InsertUseWallet(UseWallet wallet)
{
string sql = "";
DynamicParameters parasuser = new DynamicParameters();
parasuser.Add("@userCode", wallet.UserCode, System.Data.DbType.String);
var tempWallet = DapperSqlHelper.FindOne <UseWallet>("SELECT MAX(WalletCode) WalletCode,MAX(Sort) Sort FROM [dbo].[UseWallet]where UserCode=@userCode ", parasuser, false);
if (tempWallet != null)
{
//wallet.WalletCode = Guid.NewGuid().ToString();
if (tempWallet.Sort == null)
{
wallet.Sort = 1;
}
else
{
wallet.Sort = tempWallet.Sort + 1;
}
}
else
{
wallet.WalletCode = "1";
wallet.Sort = 1;
}
sql = @"INSERT INTO [dbo].[UseWallet]([WalletCode],[UserCode] ,[AccountPrincipal] ,[DonationAmount] ,
[Ratio] ,[Status] ,[Sort])
VALUES ( @WalletCode,
@UserCode,
@AccountPrincipal,
@DonationAmount,
@Ratio,
1,
@Sort)";
DynamicParameters paras = new DynamicParameters();
paras.Add("@WalletCode", wallet.WalletCode, System.Data.DbType.String);
paras.Add("@UserCode", wallet.UserCode, System.Data.DbType.String);
paras.Add("@AccountPrincipal", wallet.AccountPrincipal, System.Data.DbType.String);
paras.Add("@DonationAmount", wallet.DonationAmount, System.Data.DbType.String);
paras.Add("@Ratio", wallet.Ratio, System.Data.DbType.String);
paras.Add("@Sort", wallet.Sort, System.Data.DbType.Int32);
int i = DapperSqlHelper.ExcuteNonQuery <UseWallet>(sql, paras, false);
return(true);
}
/// <summary>
/// 赠送
/// </summary>
/// <param name="couponCode"></param>
public bool GiveedUpdate(string couponCode, string userCode)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@CouponUseCode", couponCode, System.Data.DbType.String);
string sql1 = "select * from [dbo].[Coupon] where CouponUseCode=@code ";
Coupon coupon = DapperSqlHelper.FindOne <Coupon>(sql1, paras, false);
string sql = "update [dbo].[Coupon] set IsGiveed=1, GiveedTime=getdate() where CouponUseCode=@CouponUseCode";
DapperSqlHelper.ExcuteNonQuery <Coupon>(sql, paras, false);
coupon.CouponCode = GetMaxCode();
coupon.UserCode = userCode;
Insert(coupon);
return(true);
}
public void Insert(MembershipScore membershipScore)
{
DynamicParameters paras = new DynamicParameters();
if (string.IsNullOrEmpty(membershipScore.MembershipScoreCode))
{
membershipScore.MembershipScoreCode = GetMaxCode();
}
paras.Add("@MembershipScoreCode", membershipScore.MembershipScoreCode, System.Data.DbType.String);
paras.Add("@UserCode", membershipScore.UserCode, System.Data.DbType.String);
paras.Add("@Score", membershipScore.Score, System.Data.DbType.Int16);
string sql = (@"insert into [dbo].[MembershipScore] (MembershipScoreCode,UserCode,Score)
values(@MembershipScoreCode,@UserCode,@Score");
DapperSqlHelper.ExcuteNonQuery <Coupon>(sql, paras, false);
}
public int CreateUser(User user)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@Code", user.Code, System.Data.DbType.String);
paras.Add("@UserName", user.UserName, System.Data.DbType.String);
paras.Add("@UserIamgeUrl", user.UserIamgeUrl, System.Data.DbType.String);
paras.Add("@Sex", user.Sex, System.Data.DbType.Int32);
paras.Add("@CreateTime", user.CreateTime, System.Data.DbType.DateTime);
return(DapperSqlHelper.ExcuteNonQuery <User>(@"INSERT INTO [dbo].[User]([Code],[UserName],[UserIamgeUrl] ,[Sex] ,[CreateTime] )
VALUES ( @Code,
@UserName,
@UserIamgeUrl,
@Sex,
@CreateTime )", paras, false));
}
public int UpdateByPhone(string userCode, string phone, DateTime birthday, string ReferenceNumber, string recommendedPhone = null)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@phone", phone, System.Data.DbType.String);
paras.Add("@Code", userCode, System.Data.DbType.String);
paras.Add("@birthday", birthday, System.Data.DbType.DateTime);
paras.Add("@ReferenceNumber", ReferenceNumber, System.Data.DbType.String);
if (!string.IsNullOrEmpty(recommendedPhone))
{
paras.Add("@recommendedPhone", recommendedPhone, System.Data.DbType.String);
return(DapperSqlHelper.ExcuteNonQuery <User>(@"Update [dbo].[User] set phone=@phone,birthday=@birthday,ReferenceNumber=@ReferenceNumber ,recommendedPhone=@recommendedPhone where Code=@Code", paras, false));
}
else
{
return(DapperSqlHelper.ExcuteNonQuery <User>(@"Update [dbo].[User] set phone=@phone,birthday=@birthday,ReferenceNumber=@ReferenceNumber where Code=@Code", paras, false));
}
}
public bool UpdatebycouponCode(string couponCode)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@CouponUseCode", couponCode, System.Data.DbType.String);
string sql1 = "select * from [dbo].[Coupon] where CouponUseCode=@CouponUseCode ";
Coupon coupon = DapperSqlHelper.FindOne <Coupon>(sql1, paras, false);
if (coupon == null || coupon.VersionEndTime < DateTime.Now)
{
return(false);
}
else
{
string sql = "update [dbo].[Coupon] set IsUsed=0 where CouponUseCode=@CouponUseCode";
DapperSqlHelper.ExcuteNonQuery <Coupon>(sql, paras, false);
}
return(true);
}
public void Insert(ExperienceVoucher v)
{
DynamicParameters paras = new DynamicParameters();
if (string.IsNullOrEmpty(v.ExperienceVoucherCode))
{
v.ExperienceVoucherCode = GetMaxCode();
}
paras.Add("@ExperienceVoucherCode", v.ExperienceVoucherCode, System.Data.DbType.String);
paras.Add("@ProductCode", v.ProductCode, System.Data.DbType.String);
paras.Add("@ExperienceNo", v.ExperienceNo, System.Data.DbType.Int32);
paras.Add("@ExperiencePrice", v.ExperiencePrice, System.Data.DbType.Decimal);
paras.Add("@VersionStartTime", v.VersionStartTime, System.Data.DbType.DateTime);
paras.Add("@VersionEndTime", v.VersionEndTime, System.Data.DbType.DateTime);
string sql = @"insert into [dbo].[ExperienceVoucher](ExperienceVoucherCode,ProductCode,ExperienceNo,ExperiencePrice,VersionStartTime,VersionEndTime)
values(@ExperienceVoucherCode,@ProductCode,@ExperienceNo,@ExperiencePrice,@VersionStartTime,@VersionEndTime)";
DapperSqlHelper.ExcuteNonQuery <ExperienceVoucher>(sql, paras, false);
}
public bool InsertRecore(string typeCode, string userCode, decimal?recordsMoney, string explain, decimal?recordsdonationAmount, decimal?recordsaccountPrincipal, string OrderCode, bool IsRecharging = true)
{
var tempRecord = DapperSqlHelper.FindOne <RecordsOfConsumption>("SELECT MAX(RecordsOfConsumptionCode) RecordsOfConsumptionCode FROM [dbo].[RecordsOfConsumption]", null, false);
if (tempRecord != null && !string.IsNullOrEmpty(tempRecord.RecordsOfConsumptionCode))
{
tempRecord.RecordsOfConsumptionCode = Guid.NewGuid().ToString();
}
else
{
tempRecord.RecordsOfConsumptionCode = "1";
}
DynamicParameters paras = new DynamicParameters();
paras.Add("@IsRecharging", IsRecharging, System.Data.DbType.String);
paras.Add("@UserCode", userCode, System.Data.DbType.String);
paras.Add("@RechargeTypeCode", typeCode, System.Data.DbType.String);
paras.Add("@RecordsMoney", recordsMoney, System.Data.DbType.Decimal);
paras.Add("@Explain", explain, System.Data.DbType.String);
paras.Add("@IsRecharging", IsRecharging, System.Data.DbType.Int16);
paras.Add("@RecordsOfConsumptionCode", tempRecord.RecordsOfConsumptionCode, System.Data.DbType.String);
paras.Add("@recordsdonationAmount", recordsdonationAmount, System.Data.DbType.Decimal);
paras.Add("@recordsaccountPrincipal", recordsaccountPrincipal, System.Data.DbType.Decimal);
paras.Add("@OrderCode", OrderCode, System.Data.DbType.String);
var n = DapperSqlHelper.ExcuteNonQuery <RecordsOfConsumption>(@"INSERT INTO [dbo].[RecordsOfConsumption]
([RecordsOfConsumptionCode],[UserCode] ,[RechargeTypeCode] ,[RecordsMoney],Explain,CreateTime,IsRecharging,RecordsDonationAmountMoney,RecordsAccountPrincipalMoney,OrderCode)
VALUES ( @RecordsOfConsumptionCode,
@UserCode,
@RechargeTypeCode,
@RecordsMoney,
@Explain,
getdate(),@IsRecharging,@recordsdonationAmount,@recordsaccountPrincipal,@OrderCode)", paras, false);
if (n > 0)
{
return(true);
}
else
{
return(false);
}
}
public int InsertTopupOrder(string userCode, string prepayid, string typeCode, decimal?money = 0)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@TopupOrderCode", Guid.NewGuid().ToString(), System.Data.DbType.String);
paras.Add("@UserCode", userCode, System.Data.DbType.String);
paras.Add("@RecordsOfConsumptionCode", Guid.NewGuid().ToString(), System.Data.DbType.String);
paras.Add("@WallePrCode", prepayid, System.Data.DbType.String);
paras.Add("@OutTradeNo", WxPayApi.GenerateOutTradeNo().ToString(), System.Data.DbType.String);
paras.Add("@PayDatetime", null, System.Data.DbType.DateTime);
paras.Add("@RechargeTypeCode", typeCode, System.Data.DbType.String);
paras.Add("@RecordsMoney", money, System.Data.DbType.String);
paras.Add("@CreateTime", null, System.Data.DbType.DateTime);
string sql = @"insert into [dbo].[TopupOrder](TopupOrderCode,UserCode,RecordsOfConsumptionCode,
WallePrCode,OutTradeNo,PayDatetime,RechargeTypeCode,RecordsMoney,CreateTime)
values(@TopupOrderCode,@UserCode,@RecordsOfConsumptionCode,@WallePrCode,
@OutTradeNo,@PayDatetime,@RechargeTypeCode,@RecordsMoney,@CreateTime)";
return(DapperSqlHelper.ExcuteNonQuery <Order>(sql, paras, false));
}
public int CreateUserStore(UserStore userStore)
{
DynamicParameters paras = new DynamicParameters();
if (string.IsNullOrEmpty(userStore.UserStoreCode))
{
userStore.UserStoreCode = GetMaxCode();
}
paras.Add("@UserStoreCode", userStore.UserStoreCode, System.Data.DbType.String);
paras.Add("@OpenID", userStore.OpenID, System.Data.DbType.String);
paras.Add("@UserCode", userStore.UserCode, System.Data.DbType.String);
paras.Add("@MembershipCardStore", userStore.MembershipCardStore, System.Data.DbType.Int32);
return(DapperSqlHelper.ExcuteNonQuery <User>(@"INSERT INTO [dbo].[UserStore]([UserStoreCode],[OpenID],[UserCode] ,[MembershipCardStore] )
VALUES ( @UserStoreCode,
@OpenID,
@UserCode,
@MembershipCardStore)", paras, false));
}
public int UpdateOrderbyWxorder(Order order)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@OrderCode", order.OrderCode, System.Data.DbType.String);
paras.Add("@UserCode", order.UserCode, System.Data.DbType.String);
paras.Add("@ProductCode", order.ProductCode, System.Data.DbType.String);
paras.Add("@Number", order.Number, System.Data.DbType.Int32);
paras.Add("@Money", order.Money, System.Data.DbType.Decimal);
paras.Add("@StoreCode", order.StoreCode, System.Data.DbType.String);
paras.Add("@PayTime", order.PayTime, System.Data.DbType.DateTime);
paras.Add("@AppointmentTime", order.AppointmentTime, System.Data.DbType.DateTime);
paras.Add("@ExperienceVoucherCode", order.ExperienceVoucherCode, System.Data.DbType.String);
paras.Add("@OrderNO", order.OrderNO, System.Data.DbType.String);
paras.Add("@WxPrepayId", order.WxPrepayId, System.Data.DbType.String);
string sql = @"update [dbo].[Order] set UserCode=@UserCode,ProductCode=@ProductCode,Number=@Number,
Money=@Money,StoreCode=@StoreCode,PayTime=@PayTime,AppointmentTime=@AppointmentTime,ExperienceVoucherCode=@ExperienceVoucherCode,WxPrepayId=@WxPrepayId,OrderNO=@OrderNO
where OrderCode=@OrderCode";
return(DapperSqlHelper.ExcuteNonQuery <Order>(sql, paras, false));
}
public bool InsertUserTask(string userCode, string type)
{
DynamicParameters paras = new DynamicParameters();
UserTask userTask = new UserTask();
if (string.IsNullOrEmpty(userTask.UserTaskCode))
{
userTask.UserTaskCode = Guid.NewGuid().ToString();
userTask.UserCode = userCode;
userTask.TaskCode = type;
userTask.TaskStartTime = DateTime.Now;
userTask.TaskEndTime = DateTime.MaxValue;
userTask.IsComplete = false;
}
paras.Add("@UserTaskCode", userTask.UserTaskCode, System.Data.DbType.String);
paras.Add("@TaskCode", userTask.TaskCode, System.Data.DbType.String);
paras.Add("@IsComplete", userTask.IsComplete, System.Data.DbType.Boolean);
paras.Add("@TaskStartTime", userTask.TaskStartTime, System.Data.DbType.String);
paras.Add("@TaskEndTime", userTask.TaskEndTime, System.Data.DbType.String);
paras.Add("@UserCode", userTask.UserCode, System.Data.DbType.String);
int count = DapperSqlHelper.ExcuteNonQuery <UserTask>(@"INSERT INTO [dbo].[UserTask]
([UserTaskCode],[TaskCode] ,[IsComplete] ,[TaskStartTime] ,
[TaskEndTime],[UserCode])
VALUES ( @UserTaskCode,
@TaskCode,
@IsComplete,
@TaskStartTime,
@TaskEndTime,
@UserCode
)", paras, false);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
public int CreateUserStore(IntegralRecord record)
{
DynamicParameters paras = new DynamicParameters();
if (string.IsNullOrEmpty(record.IntegralRecordCode))
{
record.IntegralRecordCode = GetMaxCode();
}
paras.Add("@IntegralRecordCode", record.IntegralRecordCode, System.Data.DbType.String);
paras.Add("@UserCode", record.UserCode, System.Data.DbType.String);
paras.Add("@RecordType", record.RecordType, System.Data.DbType.String);
paras.Add("@Integral", record.Integral, System.Data.DbType.Int32);
paras.Add("@Explain", record.Explain, System.Data.DbType.String);
return(DapperSqlHelper.ExcuteNonQuery <IntegralRecord>(@"INSERT INTO [dbo].[IntegralRecord]
([IntegralRecordCode],[UserCode],[RecordType] ,[Integral],[Explain],[CreateTime] )
VALUES ( @IntegralRecordCode,
@UserCode,
@RecordType,
@Integral,
@Explain,getdate())", paras, false));
}
public void Update(string userCode, int score)
{
var list = GetMembershipScoreListByUserCode(userCode);
if (list == null || list.Count == 0)
{
MembershipScore membershipScore = new MembershipScore()
{
UserCode = userCode, Score = score
};
Insert(membershipScore);
}
else
{
MembershipScore membershipScore = list[0];
membershipScore.Score = membershipScore.Score + score;
DynamicParameters paras = new DynamicParameters();
paras.Add("@code", membershipScore.MembershipScoreCode, System.Data.DbType.String);
paras.Add("@Score", membershipScore.Score, System.Data.DbType.Int32);
string sql = "update [dbo].[MembershipScore] set Score=@Score where MembershipScoreCode=@code";
DapperSqlHelper.ExcuteNonQuery <MembershipScore>(sql, paras, false);
}
}
public bool Insert(Coupon coupon)
{
DynamicParameters paras = new DynamicParameters();
if (string.IsNullOrEmpty(coupon.CouponCode))
{
coupon.CouponCode = GetMaxCode();
}
paras.Add("@CouponCode", coupon.CouponCode, System.Data.DbType.String);
paras.Add("@UserCode", coupon.UserCode, System.Data.DbType.String);
paras.Add("@CouponTypeCode", coupon.CouponTypeCode, System.Data.DbType.String);
paras.Add("@IsGiveed", coupon.IsGiveed, System.Data.DbType.String);
paras.Add("@StratTime", coupon.StratTime, System.Data.DbType.String);
paras.Add("@VersionEndTime", coupon.VersionEndTime, System.Data.DbType.String);
paras.Add("@CouponUseCode", coupon.CouponUseCode, System.Data.DbType.String);
string sql = (@"insert into [dbo].[Coupon] (CouponCode,UserCode,CouponTypeCode,CreateTime,
StratTime,VersionEndTime,IsUsed,IsGiveed,UseTime,GiveedTime,CouponUseCode)
values(@CouponCode,@UserCode,@CouponTypeCode,getdate(),@StratTime,@VersionEndTime,
0,@IsGiveed, null,getdate(),@CouponUseCode)");
DapperSqlHelper.ExcuteNonQuery <Coupon>(sql, paras, false);
return(true);
}
public string InsertOrder(Order order)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@OrderCode", order.OrderCode, System.Data.DbType.String);
paras.Add("@UserCode", order.UserCode, System.Data.DbType.String);
paras.Add("@ProductCode", order.ProductCode, System.Data.DbType.String);
paras.Add("@Number", order.Number, System.Data.DbType.Int32);
paras.Add("@Money", order.Money, System.Data.DbType.Decimal);
paras.Add("@StoreCode", order.StoreCode, System.Data.DbType.String);
paras.Add("@PayTime", order.PayTime, System.Data.DbType.DateTime);
paras.Add("@AppointmentTime", order.AppointmentTime, System.Data.DbType.DateTime);
paras.Add("@ExperienceVoucherCode", order.ExperienceVoucherCode, System.Data.DbType.String);
paras.Add("@OrderNO", order.OrderNO, System.Data.DbType.String);
paras.Add("@WxPrepayId", order.WxPrepayId, System.Data.DbType.String);
string sql = @"insert into [dbo].[Order](OrderCode,UserCode,ProductCode,Number,Money,StoreCode,
CreateTime,PayTime,AppointmentTime,ExperienceVoucherCode,OrderNO,WxPrepayId)
values(@OrderCode,@UserCode,@ProductCode,@Number,@Money,@StoreCode,
getdate(),@PayTime,@AppointmentTime,@ExperienceVoucherCode,@OrderNO,@WxPrepayId)";
DapperSqlHelper.ExcuteNonQuery <Order>(sql, paras, false);
return(order.OrderCode);
}
