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