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);
}
}
}
}
}
