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