//获取前台传来的文件

HttpFileCollection files = HttpContext.Current.Request.Files;

Stream st = files[0].InputStream;

byte[] bytes = new byte[st.Length];

st.Read(bytes, 0, bytes.Length);

st.Close();

string sql = "insert into jhac_tb_product_fj (JID,PDC_CODE,PDC_FJ) values (:JID,:PDC_CODE,:PDC_FJ)";

OracleParameter[] parameters = {

new OracleParameter(":JID", OracleType.VarChar,400),

new OracleParameter(":PDC_CODE", OracleType.VarChar,400),

new OracleParameter(":PDC_FJ", OracleType.Blob)

};

parameters[0].Value = "111";

parameters[1].Value = "222";

parameters[2].Value = blob;

DbHelperOra.ExecuteSql(sql, parameters);