public bool Edit(Model.Integral.MemberIntegralGift model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update MemberIntegralGift set "); strSql.Append("name=@name,detail=@detail,Integral=@Integral,Number=@Number,Member_Class=@Member_Class,State=@State"); strSql.Append(" where id=@id"); var dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "name", DbType.String, model.name); db.AddInParameter(dbCommand, "detail", DbType.String, model.detail); db.AddInParameter(dbCommand, "Integral", DbType.Decimal, model.Integral); db.AddInParameter(dbCommand, "Number", DbType.Decimal, model.Number); db.AddInParameter(dbCommand, "Member_Class", DbType.String, model.Member_Class); db.AddInParameter(dbCommand, "State", DbType.Int32, model.State); db.AddInParameter(dbCommand, "id", DbType.Int32, model.id); return 0 < db.ExecuteNonQuery(dbCommand); }
public Model.Integral.MemberIntegralGift GetModel(int id) { Model.Integral.MemberIntegralGift model = null; DataTable dt = GetList("and id=" + id); if (dt.Rows.Count > 0) { model = new Model.Integral.MemberIntegralGift() { id = (int)dt.Rows[0]["id"], name = (string)dt.Rows[0]["name"], detail = (string)dt.Rows[0]["detail"], Integral = (decimal)dt.Rows[0]["Integral"], Number = (decimal)dt.Rows[0]["Number"], Member_Class = (string)dt.Rows[0]["Member_Class"], State = (int)dt.Rows[0]["State"] }; } return model; }
public int Add(Model.Integral.MemberIntegralGift model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MemberIntegralGift("); strSql.Append("name,detail,Integral,Number,Member_Class,State)"); strSql.Append(" values ("); strSql.Append("@name,@detail,@Integral,@Number,@Member_Class,@State)"); strSql.Append(";select @@IDENTITY"); var dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "name", DbType.String, model.name); db.AddInParameter(dbCommand, "detail", DbType.String, model.detail); db.AddInParameter(dbCommand, "Integral", DbType.Decimal, model.Integral); db.AddInParameter(dbCommand, "Number", DbType.Decimal, model.Number); db.AddInParameter(dbCommand, "Member_Class", DbType.String, model.Member_Class); db.AddInParameter(dbCommand, "State", DbType.Int32, model.State); int result; object obj = db.ExecuteScalar(dbCommand); if (obj == null || !int.TryParse(obj.ToString(), out result)) { return 0; } return result; }