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