/// <summary> /// 更新一条数据 /// </summary> public bool Update(MemberAmountDetailModel model) { bool reValue = true; int reCount = 0; StringBuilder strSql = new StringBuilder(); strSql.Append("update CORE.dbo.MemberAmountDetail set "); strSql.Append(" Memo = @Memo , "); strSql.Append(" MemberAmountChangeTypeId = @MemberAmountChangeTypeId , "); strSql.Append(" OldAmount = @OldAmount , "); strSql.Append(" NewAmount = @NewAmount , "); strSql.Append(" MemberId = @MemberId , "); strSql.Append(" UserId = @UserId , "); strSql.Append(" ChangeAmount = @ChangeAmount , "); strSql.Append(" CreateTime = @CreateTime , "); strSql.Append(" ReKey = @ReKey , "); strSql.Append(" ReKey2 = @ReKey2 "); strSql.Append(" where MemberAmountDetailId=@MemberAmountDetailId "); SqlParameter[] parameters = { new SqlParameter("@MemberAmountDetailId", SqlDbType.Decimal, 9), new SqlParameter("@Memo", SqlDbType.VarChar, 500), new SqlParameter("@MemberAmountChangeTypeId", SqlDbType.Int, 4), new SqlParameter("@OldAmount", SqlDbType.Decimal, 9), new SqlParameter("@NewAmount", SqlDbType.Decimal, 9), new SqlParameter("@MemberId", SqlDbType.Decimal, 9), new SqlParameter("@UserId", SqlDbType.VarChar, 50), new SqlParameter("@ChangeAmount", SqlDbType.Decimal, 9), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@ReKey", SqlDbType.VarChar, 50), new SqlParameter("@ReKey2", SqlDbType.VarChar, 50) }; parameters[0].Value = model.MemberAmountDetailId; parameters[1].Value = model.Memo; parameters[2].Value = model.MemberAmountChangeTypeId; parameters[3].Value = model.OldAmount; parameters[4].Value = model.NewAmount; parameters[5].Value = model.MemberId; parameters[6].Value = model.UserId; parameters[7].Value = model.ChangeAmount; parameters[8].Value = model.CreateTime; parameters[9].Value = model.ReKey; parameters[10].Value = model.ReKey2; try {//异常处理 reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters); } catch (Exception ex) { this.helper.Close(); throw ex; } if (reCount <= 0) { reValue = false; } return(reValue); }
/// <summary> /// 得到一个对象实体 /// </summary> public MemberAmountDetailModel GetModel(decimal MemberAmountDetailId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select MemberAmountDetailId, Memo, MemberAmountChangeTypeId, OldAmount, NewAmount, MemberId, UserId, ChangeAmount, CreateTime, ReKey, ReKey2 "); strSql.Append(" from CORE.dbo.MemberAmountDetail "); strSql.Append(" where MemberAmountDetailId=@MemberAmountDetailId"); SqlParameter[] parameters = { new SqlParameter("@MemberAmountDetailId", SqlDbType.Decimal) }; parameters[0].Value = MemberAmountDetailId; MemberAmountDetailModel model = new MemberAmountDetailModel(); DataSet ds = helper.ExecSqlReDs(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["MemberAmountDetailId"].ToString() != "") { model.MemberAmountDetailId = decimal.Parse(ds.Tables[0].Rows[0]["MemberAmountDetailId"].ToString()); } model.Memo = ds.Tables[0].Rows[0]["Memo"].ToString(); if (ds.Tables[0].Rows[0]["MemberAmountChangeTypeId"].ToString() != "") { model.MemberAmountChangeTypeId = int.Parse(ds.Tables[0].Rows[0]["MemberAmountChangeTypeId"].ToString()); } if (ds.Tables[0].Rows[0]["OldAmount"].ToString() != "") { model.OldAmount = decimal.Parse(ds.Tables[0].Rows[0]["OldAmount"].ToString()); } if (ds.Tables[0].Rows[0]["NewAmount"].ToString() != "") { model.NewAmount = decimal.Parse(ds.Tables[0].Rows[0]["NewAmount"].ToString()); } if (ds.Tables[0].Rows[0]["MemberId"].ToString() != "") { model.MemberId = decimal.Parse(ds.Tables[0].Rows[0]["MemberId"].ToString()); } model.UserId = ds.Tables[0].Rows[0]["UserId"].ToString(); if (ds.Tables[0].Rows[0]["ChangeAmount"].ToString() != "") { model.ChangeAmount = decimal.Parse(ds.Tables[0].Rows[0]["ChangeAmount"].ToString()); } if (ds.Tables[0].Rows[0]["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString()); } model.ReKey = ds.Tables[0].Rows[0]["ReKey"].ToString(); model.ReKey2 = ds.Tables[0].Rows[0]["ReKey2"].ToString(); return(model); } else { return(model); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(MemberAmountDetailModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CORE.dbo.MemberAmountDetail ("); strSql.Append("Memo,MemberAmountChangeTypeId,OldAmount,NewAmount,MemberId,UserId,ChangeAmount,CreateTime,ReKey,ReKey2"); strSql.Append(") values ("); strSql.Append("@Memo,@MemberAmountChangeTypeId,@OldAmount,@NewAmount,@MemberId,@UserId,@ChangeAmount,@CreateTime,@ReKey,@ReKey2"); strSql.Append(") "); strSql.Append(";"); SqlParameter[] parameters = { new SqlParameter("@Memo", SqlDbType.VarChar, 500), new SqlParameter("@MemberAmountChangeTypeId", SqlDbType.Int, 4), new SqlParameter("@OldAmount", SqlDbType.Decimal, 9), new SqlParameter("@NewAmount", SqlDbType.Decimal, 9), new SqlParameter("@MemberId", SqlDbType.Decimal, 9), new SqlParameter("@UserId", SqlDbType.VarChar, 50), new SqlParameter("@ChangeAmount", SqlDbType.Decimal, 9), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@ReKey", SqlDbType.VarChar, 50), new SqlParameter("@ReKey2", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Memo; parameters[1].Value = model.MemberAmountChangeTypeId; parameters[2].Value = model.OldAmount; parameters[3].Value = model.NewAmount; parameters[4].Value = model.MemberId; parameters[5].Value = model.UserId; parameters[6].Value = model.ChangeAmount; parameters[7].Value = model.CreateTime; parameters[8].Value = model.ReKey; parameters[9].Value = model.ReKey2; bool result = false; try { model.MemberAmountDetailId = decimal.Parse(helper.ExecuteNonQueryBackId(strSql.ToString(), "MemberAmountDetailId", parameters)); result = true; } catch (Exception ex) { this.helper.Close(); throw ex; } finally { } return(result); }