/// <summary>
/// 增加一条数据 －－购买
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(Tz888.Model.ConsumeInfos model)
{
SqlParameter[] parameters =
{
new SqlParameter("@InfoID", SqlDbType.BigInt, 8),
new SqlParameter("@PublishUserName", SqlDbType.VarChar, 30),
new SqlParameter("@ExpendMoney", SqlDbType.Float, 8),
new SqlParameter("@GainMoney", SqlDbType.Float, 8),
new SqlParameter("@ExpendUserName", SqlDbType.VarChar, 30),
new SqlParameter("@CreateDate", SqlDbType.DateTime, 8),
new SqlParameter("@status", SqlDbType.Int, 4),
new SqlParameter("@flag", SqlDbType.VarChar, 30),
};
parameters[0].Value = model.InfoID;
parameters[1].Value = model.PublishUserName;
parameters[2].Value = model.ExpendMoney;
parameters[3].Value = model.GainMoney;
parameters[4].Value = model.ExpendUserName;
parameters[5].Value = model.CreateDate;
parameters[6].Value = model.Status;
parameters[7].Value = "Insert";
bool b = DbHelperSQL.RunProcLob("SP_ConsumeInfo", parameters);
return(b);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="UserName"></param>
/// <param name="PassWord"></param>
/// <returns></returns>
public bool Update(Tz888.Model.ConsumeInfos model)
{
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.BigInt, 8),
new SqlParameter("@status", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.Text),
new SqlParameter("@flag ", SqlDbType.VarChar, 30)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.Status;
parameters[2].Value = model.Remark;
parameters[3].Value = "Update";
bool b = DbHelperSQL.RunProcLob("SP_ConsumeRec", parameters);
return(b);
}
