public string GetMaxCode() { var userStore = DapperSqlHelper.FindOne <UserStore>("SELECT MAX(UserStoreCode) UserStoreCode FROM [dbo].[UserStore]", null, false); var code = userStore != null?Convert.ToInt32(userStore.UserStoreCode) + 1 : 1; return(code.ToString()); }
public string GetMaxCode() { var v = DapperSqlHelper.FindOne <ExperienceVoucher>("SELECT MAX(ExperienceVoucherCode) ExperienceVoucherCode FROM [dbo].[ExperienceVoucher]", null, false); var code = v != null?Convert.ToInt32(v.ExperienceVoucherCode) + 1 : 1; return(code.ToString()); }
public string GetMaxCode() { var record = DapperSqlHelper.FindOne <IntegralRecord>("SELECT MAX(IntegralRecordCode) IntegralRecordCode FROM [dbo].[IntegralRecord]", null, false); var code = record != null?Convert.ToInt32(record.IntegralRecordCode) + 1 : 1; return(code.ToString()); }
public string GetMaxCode() { var task = DapperSqlHelper.FindOne <UserTask>("SELECT MAX(UserTaskCode) UserTaskCode FROM [dbo].[UserTask]", null, false); var code = task != null?Convert.ToInt32(task.UserTaskCode) + 1 : 1; return(code.ToString()); }
public string GetMaxCode() { var order = DapperSqlHelper.FindOne <Order>("SELECT MAX(OrderCode) OrderCode FROM [dbo].[Order]", null, false); var code = order != null?Convert.ToInt32(order.OrderCode) + 1 : 1; return(code.ToString()); }
public string GetMaxCode() { var coupon = DapperSqlHelper.FindOne <Coupon>("SELECT MAX(CouponCode) CouponCode FROM [dbo].[Coupon]", null, false); //var code = coupon != null ? Convert.ToInt32(coupon.CouponCode) + 1 : 1; return(Guid.NewGuid().ToString()); }
public Coupon GetgivedCoupon() { DynamicParameters paras = new DynamicParameters(); Coupon record = DapperSqlHelper.FindOne <Coupon>("select a.*,b.CouponTypeName from [dbo].[Coupon] a,[dbo].[CouponType] b where IsGiveed=true and a.UserCode=null", paras, false); return(record); }
public string GetMaxCode() { var sc = DapperSqlHelper.FindOne <MembershipScore>("SELECT MAX(MembershipScoreCode) MembershipScoreCode FROM [dbo].[MembershipScore]", null, false); var code = sc != null?Convert.ToInt32(sc.MembershipScoreCode) + 1 : 1; return(code.ToString()); }
public RechargeType GetRechargeTypeByCode(string code) { DynamicParameters paras = new DynamicParameters(); paras.Add("@code", code, System.Data.DbType.String); RechargeType task = DapperSqlHelper.FindOne <RechargeType>("select * from [dbo].[RechargeType] where RechargeTypeCode=@code and Status=1", paras, false); return(task); }
public User GetUserById(string id) { DynamicParameters paras = new DynamicParameters(); paras.Add("@UserId", id, System.Data.DbType.String); User userone = DapperSqlHelper.FindOne <User>("select Id,UserName,PassWord,Project from User_Info where UserId=@UserId", paras, false); return(userone); }
public ExperienceVoucher GetExperienceVoucherByCode(string code) { DynamicParameters paras = new DynamicParameters(); paras.Add("@code", code, System.Data.DbType.String); ExperienceVoucher v = DapperSqlHelper.FindOne <ExperienceVoucher>("select * from [dbo].[ExperienceVoucher] where ExperienceVoucherCode=@code ", paras, false); return(v); }
public MembershipScore GetMembershipScoreByCode(string code) { DynamicParameters paras = new DynamicParameters(); paras.Add("@code", code, System.Data.DbType.String); MembershipScore record = DapperSqlHelper.FindOne <MembershipScore>("select * from [dbo].[MembershipScore] where MembershipScoreCode=@code", paras, false); return(record); }
public UserStore GetUserStorebyUserCode(string userCode) { DynamicParameters paras = new DynamicParameters(); paras.Add("@userCode", userCode, System.Data.DbType.String); UserStore userone = DapperSqlHelper.FindOne <UserStore>("select * from [dbo].[UserStore] where UserCode=@userCode", paras, false); return(userone); }
public Coupon GetCouponByCode(string code) { DynamicParameters paras = new DynamicParameters(); paras.Add("@CouponUseCode", code, System.Data.DbType.String); Coupon record = DapperSqlHelper.FindOne <Coupon>("select a.*,b.CouponTypeName from [dbo].[Coupon] a,[dbo].[CouponType] b where a.CouponUseCode=@CouponUseCode and a.CouponTypeCode=b.CouponTypeCode", paras, false); return(record); }
public Task GetTaskByCode(string code) { DynamicParameters paras = new DynamicParameters(); paras.Add("@taskCode", code, System.Data.DbType.String); Task task = DapperSqlHelper.FindOne <Task>("select * from [dbo].[Task] where TaskCode=@taskCode and VersionEndTime is null", paras, false); return(task); }
public bool IsExistProduct(string code) { DynamicParameters paras = new DynamicParameters(); paras.Add("@productCode", code, System.Data.DbType.String); ProductInfo productInfo = DapperSqlHelper.FindOne <ProductInfo>("select * from [dbo].[ProductInfo] where ProductCode=@productCode and isnull(VersionEndTime,'9999-09-09')>getdate()", paras, false); return(productInfo != null); }
public User GetUserByCode(string code) { DynamicParameters paras = new DynamicParameters(); paras.Add("@Code", code, System.Data.DbType.String); User userone = DapperSqlHelper.FindOne <User>("select * from [dbo].[User] where Code=@Code", paras, false); return(userone); }
public UserStore GetUserStoreby(string openId) { DynamicParameters paras = new DynamicParameters(); paras.Add("@OpenID", openId, System.Data.DbType.String); UserStore userone = DapperSqlHelper.FindOne <UserStore>("select * from [dbo].[UserStore] where OpenID=@OpenID", paras, false); return(userone); }
public CustomerService GetCustomerService(string code) { DynamicParameters paras = new DynamicParameters(); paras.Add("@storeCode", code, System.Data.DbType.String); CustomerService list = DapperSqlHelper.FindOne <CustomerService>("select * from [dbo].[CustomerService] where StoreCode=@storeCode and Status =1", paras, false); return(list); }
public Order GetOrderInfo(string orderCode) { DynamicParameters paras = new DynamicParameters(); paras.Add("@OrderCode", orderCode, System.Data.DbType.String); Order order = DapperSqlHelper.FindOne <Order>(@"select * from [dbo].[Order] where OrderCode=@OrderCode", paras, false); return(order); }
public Store GetStore(string code) { DynamicParameters paras = new DynamicParameters(); paras.Add("@storeCode", code, System.Data.DbType.String); Store list = DapperSqlHelper.FindOne <Store>("select * from [dbo].[Store] where StoreCode=@storeCode", paras, false); return(list); }
public RecordsOfConsumption GetRecordsOfConsumptionByOrderCode(string OrderCode) { DynamicParameters paras = new DynamicParameters(); paras.Add("@OrderCode", OrderCode, System.Data.DbType.String); RecordsOfConsumption rechargeRecord = DapperSqlHelper.FindOne <RecordsOfConsumption>("select * from [dbo].[RecordsOfConsumption] where OrderCode=@OrderCode", paras, false); return(rechargeRecord); }
public DoctorInfor GetDoctorInfor(string id) { DynamicParameters paras = new DynamicParameters(); paras.Add("@UserId", id, System.Data.DbType.String); DoctorInfor userone = DapperSqlHelper.FindOne <DoctorInfor>("select * from user_doctor where doctorID=@UserId", paras, false); return(userone); }
public void UpdateUserCertificationByCertificationCode(Certification certification) { DynamicParameters paras = new DynamicParameters(); paras.Add("@CertificationCode", certification.CertificationCode, System.Data.DbType.String); paras.Add("@AccessToken", certification.AccessToken, System.Data.DbType.String); paras.Add("@ReAccessToken", certification.ReAccessToken, System.Data.DbType.String); paras.Add("@CreateTime", certification.CreateTime, System.Data.DbType.DateTime); Certification userone = DapperSqlHelper.FindOne<Certification>("UPDATE [dbo].[Certification] SET AccessToken=@AccessToken, ReAccessToken=@ReAccessToken,CreateTime=@CreateTime WHERE CertificationCode=@CertificationCode", paras, false); }
public IntegralRecord GetStoreByCode(string code) { DynamicParameters paras = new DynamicParameters(); paras.Add("@code", code, System.Data.DbType.String); IntegralRecord list = DapperSqlHelper.FindOne <IntegralRecord>("select * from [dbo].[IntegralRecord] where IntegralRecordCode=@code", null, false); return(list); }
public TopupOrder GetTopupOrderbyWallePrCode(string WallePrCode) { DynamicParameters paras = new DynamicParameters(); paras.Add("@WallePrCode", WallePrCode, System.Data.DbType.String); TopupOrder userone = DapperSqlHelper.FindOne <TopupOrder>("select * from [dbo].[TopupOrder] where WallePrCode=@WallePrCode", paras, false); return(userone); }
public RechargeRecord GetRechargeRecordByCode(string code) { DynamicParameters paras = new DynamicParameters(); paras.Add("@rechargeRecord", code, System.Data.DbType.String); RechargeRecord rechargeRecord = DapperSqlHelper.FindOne <RechargeRecord>("select * from [dbo].[RechargeRecord] where RechargeRecordCode=@rechargeRecord", paras, false); return(rechargeRecord); }
public CouponType GetCouponTypeByCode(string code) { DynamicParameters paras = new DynamicParameters(); paras.Add("@code", code, System.Data.DbType.String); CouponType record = DapperSqlHelper.FindOne <CouponType>("select * from [dbo].[CouponType] where CouponTypeCode=@code", paras, false); return(record); }
public CouponType GetCouponTypeByIsGivedType(string taskcode) { DynamicParameters paras = new DynamicParameters(); paras.Add("@taskcode", taskcode, System.Data.DbType.String); CouponType record = DapperSqlHelper.FindOne <CouponType>("select * from [dbo].[CouponType] where IsGivedType=1 and TaskType=@taskcode", paras, false); return(record); }
public void CreateUserCertification(Certification certification) { DynamicParameters paras = new DynamicParameters(); paras.Add("@CertificationCode", certification.CertificationCode, System.Data.DbType.String); paras.Add("@OpenID", certification.OpenID, System.Data.DbType.String); paras.Add("@AccessToken", certification.AccessToken, System.Data.DbType.String); paras.Add("@CreateTime", certification.CreateTime, System.Data.DbType.DateTime); paras.Add("@ReAccessToken", certification.ReAccessToken, System.Data.DbType.String); Certification userone = DapperSqlHelper.FindOne<Certification>("INSERT INTO[dbo].[Certification] ([CertificationCode] ,[OpenID] ,[AccessToken] ,[CreateTime],[ReAccessToken]) VALUES (@CertificationCode ,@OpenID ,@AccessToken,@CreateTime,@ReAccessToken)", paras, false); }