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