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