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