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 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 IList <Task> GetTaskList()
{
DynamicParameters paras = new DynamicParameters();
IList <Task> list = DapperSqlHelper.FindToList <Task>(@"select * from [dbo].[Task] where VersionEndTime is null ", null, false);
return(list);
}
public DocumentoClienteDados InserirDocumentoClienteDados(DocumentoClienteDados documentoClienteDados_)
{
Int64 recordId = new DapperSqlHelper().InsertWithReturnId(documentoClienteDados_);
documentoClienteDados_.DocCliDadosId = recordId;
return(documentoClienteDados_);
}
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 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 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 IList <RechargeRecord> GetRechargeRecordList()
{
DynamicParameters paras = new DynamicParameters();
IList <RechargeRecord> list = DapperSqlHelper.FindToList <RechargeRecord>(@"select * from [dbo].[RechargeRecord]", null, false);
return(list);
}
public IList <CouponType> GetCouponTypeList()
{
DynamicParameters paras = new DynamicParameters();
IList <CouponType> list = DapperSqlHelper.FindToList <CouponType>(@"select * from [dbo].[CouponType] where Status=1", null, false);
return(list);
}
public DocumentoClienteDadosDoc Insert(DocumentoClienteDadosDoc DocumentoClienteDadosDoc)
{
Int64 recordId = new DapperSqlHelper().InsertWithReturnId(DocumentoClienteDadosDoc);
DocumentoClienteDadosDoc.DocCliDadosDocId = recordId;
return(DocumentoClienteDadosDoc);
}
public IList <ExperienceVoucher> GetExperienceVoucherList()
{
DynamicParameters paras = new DynamicParameters();
IList <ExperienceVoucher> list = DapperSqlHelper.FindToList <ExperienceVoucher>(@"select * from [dbo].[ExperienceVoucher] where VersionEndTime is null ", null, false);
return(list);
}
/// <summary>
/// Consulta os usuarios cadastrados na base de dados
/// </summary>
/// <param name="usuPerfilId"></param>
/// <param name="clienteId"></param>
/// <param name="usuPerfilNome"></param>
/// <param name="usuPerfilDescricao"></param>
/// <returns></returns>
public IEnumerable <Usuario> ConsultarUsuario(string usuarioId, string usuarioLogin, string usuarioNome, string usuarioEmail,
string usuarioSenha, string usuarioAtivo, string usuPerfilId, string usuClienteId, string allowedOrigin)
{
var parameters = new DynamicParameters();
parameters.Add("@pUsuarioId", usuarioId, DbType.Int16, null);
parameters.Add("@pUsuarioLogin", usuarioLogin, DbType.String, null);
parameters.Add("@pUsuarioNome", usuarioNome, DbType.String, null);
parameters.Add("@pUsuarioEmail", usuarioEmail, DbType.String, null);
parameters.Add("@pUsuarioSenha", usuarioSenha, DbType.String, null);
parameters.Add("@pUsuarioAtivo", usuarioAtivo, DbType.Byte, null);
parameters.Add("@pUsuPerfilId", usuPerfilId, DbType.Int16, null);
parameters.Add("@pClienteId", usuClienteId, DbType.Int16, null);
parameters.Add("@pAllowedOrigin", allowedOrigin, DbType.String, null);
Usuario usuarioLogado = new Usuario();
IEnumerable <Usuario> listaUsuarios = null;
using (var connection = new DapperSqlHelper().NewSqlConnection)
{
using (SqlMapper.GridReader reader = connection.QueryMultiple("ConsultarUsuario", parameters, commandType: CommandType.StoredProcedure))
{
//recupera dados do cliente e informações referenciadas
listaUsuarios = reader.Read <Usuario, UsuarioPerfil, Usuario>((usuario, usuarioPerfil) =>
{
usuario.UsuarioPerfil = usuarioPerfil;
return(usuario);
}, splitOn: "UsuarioId, UsuPerfilNome");
}
}
return(listaUsuarios);
}
public IList <RecordsOfConsumption> GetRecordsOfConsumptionList()
{
DynamicParameters paras = new DynamicParameters();
IList <RecordsOfConsumption> list = DapperSqlHelper.FindToList <RecordsOfConsumption>(@"select * from [dbo].[RecordsOfConsumption]", null, false);
return(list);
}
public static int NewUser(ApplicationUser objUser)
{
List <ParameterInfo> parameters = new List <ParameterInfo>();
parameters.Add(new ParameterInfo()
{
ParameterName = "Id", ParameterValue = objUser.Id
});
parameters.Add(new ParameterInfo()
{
ParameterName = "UserName", ParameterValue = objUser.UserName
});
parameters.Add(new ParameterInfo()
{
ParameterName = "Email", ParameterValue = objUser.Email
});
parameters.Add(new ParameterInfo()
{
ParameterName = "Password", ParameterValue = objUser.Password
});
parameters.Add(new ParameterInfo()
{
ParameterName = "Status", ParameterValue = objUser.Status
});
int success = DapperSqlHelper.ExecuteQuery("spNew_Account", parameters);
return(success);
}
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 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 DocumentoCliente Insert(DocumentoCliente DocumentoCliente)
{
Int64 recordId = new DapperSqlHelper().InsertWithReturnId(DocumentoCliente);
DocumentoCliente.ClienteId = recordId;
return(DocumentoCliente);
}
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 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 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 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 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 IList <TopupOrder> GetTopupOrderbyuserCode(string userCode)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@userCode", userCode, System.Data.DbType.String);
IList <TopupOrder> userone = DapperSqlHelper.FindToList <TopupOrder>("select * from [dbo].[TopupOrder] where userCode=@userCode", paras, false);
return(userone);
}
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 IList <MembershipScore> GetMembershipScoreListByUserCode(string userCode)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@userCode", userCode, System.Data.DbType.String);
IList <MembershipScore> list = DapperSqlHelper.FindToList <MembershipScore>(@"select * from [dbo].[MembershipScore] where UserCode=@userCode", paras, false);
return(list);
}
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 IList <ProductList> GetProductList(string listCode)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@listCode", listCode, System.Data.DbType.String);
IList <ProductList> list = DapperSqlHelper.FindToList <ProductList>("select * from [dbo].[ProductList] where ListCode=@listCode and Status =1", paras, false);
return(list);
}
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);
}
