public bool Insert(MODELreadMeterRecordCancel MODELreadMeterRecordCancel) { StringBuilder str = new StringBuilder(); str.Append("INSERT INTO readMeterRecordCancel(readMeterRecordCancelId,readMeterRecordId,chargeID) "); str.Append("VALUES(@readMeterRecordCancelId,@readMeterRecordId,@chargeID)"); SqlParameter[] para = { new SqlParameter("@readMeterRecordCancelId", SqlDbType.VarChar, 30), new SqlParameter("@readMeterRecordId", SqlDbType.VarChar, 50), new SqlParameter("@chargeID", SqlDbType.VarChar, 50) }; para[0].Value = MODELreadMeterRecordCancel.readMeterRecordCancelId; para[1].Value = MODELreadMeterRecordCancel.readMeterRecordId; para[2].Value = MODELreadMeterRecordCancel.chargeID; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
public bool Update(MODELreadMeterRecordCancel MODELreadMeterRecordCancel) { StringBuilder str = new StringBuilder(); str.Append("UPDATE readMeterRecordCancel SET readMeterRecordId=@readMeterRecordId,chargeID=@chargeID "); str.Append("WHERE readMeterRecordCancelId=@readMeterRecordCancelId"); SqlParameter[] para = { new SqlParameter("@readMeterRecordId", SqlDbType.VarChar, 50), new SqlParameter("@chargeID", SqlDbType.VarChar, 50), new SqlParameter("@readMeterRecordCancelId", SqlDbType.VarChar, 50) }; para[0].Value = MODELreadMeterRecordCancel.readMeterRecordId; para[1].Value = MODELreadMeterRecordCancel.chargeID; para[2].Value = MODELreadMeterRecordCancel.readMeterRecordCancelId; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }