Add, delete, modify, and delete oracle three-layer parameters

Add, delete, modify, and create an instance with parameters in the three layers of oracle

// Add using System. Runtime. Serialization; namespace WZ. EMR. Model {/// <summary> // The object class DATA_SET. (Attribute description: automatically extract the description of the Database field) // </summary> [DataContract] public class ModelDemo {public ModelDemo () {}# region Model /// <summary> /// version /// </summary> [DataMember] public string ID {set; get ;} /// <summary> /// dataset identifier /// </summary> [DataMember] public string NAME {set; get ;} # endregion Model} public int Add_TEM_MACRO (TEM_MACRO model) {StringBuilder strSql = new StringBuilder (); strSql. append ("insert into EMR. TEM_MACRO ("); strSql. append ("MACRO_ID, MACRO_NAME, TABLE_NAME, COLUMN_NAME, STR_WHERE, TYPE_FLAG)"); strSql. append ("values ("); strSql. append (": MACRO_ID,: MACRO_NAME,: TABLE_NAME,: COLUMN_NAME,: STR_WHERE,: TYPE_FLAG)"); Database db = CreateDataBase (); DbCommand dbCommand = db. getSqlStringCommand (strSql. toString (); db. addInParameter (dbCommand, "MACRO_ID", DbType. int32, model. MACRO_ID); db. addInParameter (dbCommand, "MACRO_NAME", DbType. string, model. MACRO_NAME); db. addInParameter (dbCommand, "TABLE_NAME", DbType. string, model. TABLE_NAME); db. addInParameter (dbCommand, "COLUMN_NAME", DbType. string, model. COLUMN_NAME); db. addInParameter (dbCommand, "STR_WHERE", DbType. string, model. STR_WHERE); db. addInParameter (dbCommand, "TYPE_FLAG", DbType. int32, model. TYPE_FLAG); return db. executeNonQuery (dbCommand );}