public string getcode(string kehuid, string kehuleibie, string riqi, string bianm)
    {
        OracleConnection con = new OracleConnection("Data Source=aa;User ID=test;Password=test");
        string sql = "select * from vw_jiage1 where (客户编码='" + kehuid + "' or 客户类别 like '%" + kehuleibie + "%') and 开始日期 < '" + riqi + "' and '" + riqi + "' < 结束日期 and 物料ID like '" + bianm + "'";
        OracleCommand com = new OracleCommand(sql,con);
        con.Open();
        OracleDataReader dr = com.ExecuteReader();
        string aa = "0";
        while (dr.Read())
        {
            aa = dr["整件单价"].ToString();
        }
        dr.Close();
        con.Close();
        return aa;
    }