62,046
社区成员
发帖
与我相关
我的任务
分享
public DataTable ReadData_QZ_KP(DateTime st, DateTime et)
{
DataTable dt = new DataTable();
string sql = "select startdate,kp from QZDATA.QZ_KP WHERE startdate>=to_date('" + st.ToString("yyyy-MM-dd") + "','yyyy-MM-dd') and startdate<=to_date('" + et.ToString("yyyy-MM-dd") + "','yyyy-MM-dd')";
using (OracleConnection conn = new OracleConnection(OracleStrConn))
{
conn.Open();
using (OracleCommand cmd = new OracleCommand(sql, conn))
{
OracleDataReader dr = cmd.ExecuteReader();
dt.Load(dr);
}
}
return dt;
}
string sql = "select a.startdate,a.kp from [QZDATA.QZ_KP] as a WHERE startdate>=to_date('" + st.ToString("yyyy-MM-dd") + "','yyyy-MM-dd') and startdate<=to_date('" + et.ToString("yyyy-MM-dd") + "','yyyy-MM-dd')";
CREATE TABLE QZ_KP
(
STARTDATE DATE,
KP VARCHAR2(200 BYTE),
KPSUM VARCHAR2(50 BYTE),
AP3H VARCHAR2(200 BYTE),
APDAY VARCHAR2(50 BYTE)
)