/// <summary> /// 增加一条数据(以参数传值) /// </summary> public static int Add(OracleConnection conn,SMT_TEST model) { string insSql = "INSERT INTO SMT_TEST (TESTID,USERID,PASSWORD,AGE,BIRTHDAY,REMARK) VALUES (:TESTID,:USERID,:PASSWORD,:AGE,:BIRTHDAY,:REMARK)"; OracleParameter[] pageparm = { new OracleParameter(":TESTID",OracleType.NVarChar), new OracleParameter(":USERID",OracleType.NVarChar), new OracleParameter(":PASSWORD",OracleType.NVarChar), new OracleParameter(":AGE",OracleType.Int32), new OracleParameter(":BIRTHDAY",OracleType.DateTime), new OracleParameter(":REMARK",OracleType.Clob) }; pageparm[0].Value = model.TESTID;//主键ID pageparm[1].Value = model.USERID;//用户名 pageparm[2].Value = model.PASSWORD;//密码 pageparm[3].Value = model.AGE;//年龄 pageparm[4].Value = model.BIRTHDAY;//生日 pageparm[5].Value = model.REMARK;//备注 return MsOracle.ExecuteSQLByTransaction(conn,insSql, pageparm); }
private static void TestAdo() { OracleConnection conn= ADOHelper.GetOracleConnection(); SMT_TEST entity = new SMT_TEST(); entity.TESTID =Guid.NewGuid().ToString().Replace("-","");//主键ID entity.USERID ="中国人";//用户名 entity.PASSWORD = "******";//密码 entity.AGE =32;//年龄 entity.BIRTHDAY =DateTime.Now;//生日 entity.REMARK = "就是备注";//备注 MsOracle.BeginTransaction(conn); // Add(conn,entity); Add(conn, entity); entity.TESTID = Guid.NewGuid().ToString().Replace("-", "");//主键ID entity.AGE = 23;//年龄 Add(conn, entity); MsOracle.CommitTransaction(conn); }