예제 #1
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(hidId.Value))
            {
                var userinfo = AccountInfoBLL.Instance.GetSingle(new AccountInfoPara()
                {
                    Id = int.Parse(hidId.Value)
                });
                if (userinfo != null)
                {
                    UserFinanceHistoryVO userfin = new UserFinanceHistoryVO();
                    userfin.CreateDate   = DateTime.Now;
                    userfin.CreateUserId = Account.UserId;
                    userfin.Money        = decimal.Parse(txtMoney.Value);
                    userfin.MoneyType    = 0;
                    userfin.RechargeType = 0;
                    userfin.UserId       = userinfo.Id;

                    if (UserFinanceHistoryBLL.Instance.Add(userfin))
                    {
                        //userinfo.Money = userinfo.Money + userfin.Money;
                        userinfo.LastMoneyDate = DateTime.Now;
                        AccountInfoBLL.Instance.Edit(userinfo);
                    }
                }
            }
        }
        public override bool Edit(UserFinanceHistoryVO m)
        {
            CodeCommand command = new CodeCommand();

            command.CommandText = EDIT;

            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@RechargeType", Value = ParameterHelper.ConvertValue(m.RechargeType)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@Money", Value = ParameterHelper.ConvertValue(m.Money)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@MoneyType", Value = ParameterHelper.ConvertValue(m.MoneyType)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@Id", Value = ParameterHelper.ConvertValue(m.Id)
            });


            int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);

            if (result >= 1)
            {
                return(true);
            }

            return(false);
        }
        public override int InsertIdentityId(UserFinanceHistoryVO m)
        {
            CodeCommand command = new CodeCommand();

            command.CommandText = INSERT + "; select @@Identity";

            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@RechargeType", Value = ParameterHelper.ConvertValue(m.RechargeType)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@Money", Value = ParameterHelper.ConvertValue(m.Money)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@MoneyType", Value = ParameterHelper.ConvertValue(m.MoneyType)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
            });


            var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);

            return(int.Parse(result.ToString()));
        }
 public override string GetOtherConditionByModel(UserFinanceHistoryVO m)
 {
     return("");
 }
 public override string GetOrderByModel(UserFinanceHistoryVO m)
 {
     return("");
 }