public DataSet GetRecord(string cmdText, CommandType cmdType, List <Oracle.DataAccess.Client.OracleParameter> parameters = null) { Oracle.DataAccess.Client.OracleCommand com = new Oracle.DataAccess.Client.OracleCommand("CUSTOMERORDER.CgetorderProcedure", con); com.CommandType = CommandType.StoredProcedure; var da = new Oracle.DataAccess.Client.OracleDataAdapter(com); DataSet ds = new DataSet(); da.Fill(ds); return(ds); }
public DataSet gcustomerrecord(int customerCode) { var sql = "Select Initcap(Pur_Nom)Pur_Nom,P13.Crd_Cod,P13.Itm_Cod,P13.srl_num,Itm_Des,Uom_Abr,Qtd_Rte,Qtn_Num,Qty_Prc,Pmt_Flg From Nml.Pgi_00_13 P13, Nml.Crp_00_27 C27 Where P13.Vld_Dte Is Not Null And C27.Pur_Cod = P13.Pur_Cod And P13.Crd_Cod ='" + customerCode + "' Order By P13.Crd_Cod,P13.Itm_Cod"; Oracle.DataAccess.Client.OracleCommand com = new Oracle.DataAccess.Client.OracleCommand(sql, con); com.CommandType = CommandType.Text; var da = new Oracle.DataAccess.Client.OracleDataAdapter(com); DataSet ds = new DataSet(); da.Fill(ds); return(ds); }
public DataSet GetPopUpRecord(int user) { //var sql = "select NVL(PUR_COD,-1) PUR_COD,NVL(SRL_NUM,-1)SRL_NUM,NVL(SRL_NUM,-1)SPR_NUM,NVL(CRD_COD,-1)CRD_COD,NVL(BAS_COD,-1)BAS_COD,NVL(ITM_COD,-1)ITM_COD,NVL(QTD_RTE,-1)QTD_RTE,NVL(QTN_NUM,-1)QTN_NUM,NVL(QTY_PRC,-1) QTY_PRC,NVL(ITM_DES,' ')ITM_DES,NVL(PMT_FLG,-1)PMT_FLG from pgi_00_13" + " where PUR_COD= '" + user + "'"; var sql = "select NVL(UOM_ABR,-1)UOM_ABR,ITM_COD,ITM_DES,CRD_COD,NVL(QTD_RTE,-1)QTD_RTE,NVL(QTN_NUM,-1)QTN_NUM,NVL(QTY_PRC,-1) QTY_PRC,NVL(PMT_FLG,-1)PMT_FLG from pgi_00_13" + " where ITM_COD= '" + user + "'"; Oracle.DataAccess.Client.OracleCommand com = new Oracle.DataAccess.Client.OracleCommand(sql, con); com.CommandType = CommandType.Text; var da = new Oracle.DataAccess.Client.OracleDataAdapter(com); DataSet ds = new DataSet(); da.Fill(ds); return(ds); }
/// <summary> /// 检索返回结果集 /// </summary> /// <param name="sql"></param> /// <param name="pms"></param> /// <returns></returns> public DataTable ExcuteProDataTable_oracle(string sql, params System.Data.SqlClient.SqlParameter[] pms) { //Oracle.DataAccess.Client.OracleDataAdapter using (Oracle.DataAccess.Client.OracleDataAdapter sda = new Oracle.DataAccess.Client.OracleDataAdapter(sql, connString)) { DataTable dt = new DataTable(); sda.SelectCommand.CommandType = CommandType.Text; if (pms != null) { sda.SelectCommand.Parameters.AddRange(pms); } sda.Fill(dt); return(dt); } }
public DataSet DataSet(string cmdText, CommandType cmdType, List <Oracle.DataAccess.Client.OracleParameter> parameters = null) { using (var sCon = new Oracle.DataAccess.Client.OracleConnection(GetConnectionString())) { using (var sCmd = new Oracle.DataAccess.Client.OracleCommand(cmdText, sCon)) { sCmd.CommandTimeout = 300; sCmd.CommandType = cmdType; if (null != parameters) { sCmd.Parameters.AddRange(parameters.ToArray()); } using (var sDAdapter = new Oracle.DataAccess.Client.OracleDataAdapter(sCmd)) { using (var ds = new DataSet()) { sDAdapter.Fill(ds); return(ds); } } } } }