大家帮帮忙阿!Oracle怎么参数化查询时间段..????
代码如下:
protected void btnSubmit_Click(object sender, EventArgs e)
{
int status = ddlLVStatus.SelectedIndex;
string ientifyTime = txtIdentifyTime.Text.Trim();//起始时间
string ientifyEndTime = txtEndIdentifyTime.Text.Trim();//结束时间
try
{
DBConn db = new DBConn();
OracleConnection conn = new OracleConnection(db.connString);
StringBuilder buffer = new StringBuilder();
buffer.Append("select VerifiedManually,PlateNo,EquipmentCode,Ctime,IdentifyTime,SiteCode from T_CP_PLATEINFO");
buffer.Append(" where VerifiedManually=:VerifiedManually and PlateNo=:PlateNo and EquipmentCode=:EquipmentCode and");
buffer.Append(" Ctime=:Ctime and IdentifyTime=:IdentifyTime and SiteCode=:SiteCode");
OracleCommand comm = new OracleCommand(buffer.ToString(), conn);
comm.Parameters.Add(":VerifiedManually", OracleType.Int32, 10).Value = status;
comm.Parameters.Add(":Ctime", OracleType.DateTime, 20).Value = ientifyTime;
comm.Parameters.Add(":IdentifyTime", OracleType.DateTime, 20).Value = ientifyEndTime;
DataTable data = new DataTable();
OracleDataAdapter adapter = new OracleDataAdapter(comm);
adapter.Fill(data);
sbHTML = GetData(data);
Config.WriteFileLog(WebConfig.path, buffer.ToString());//写入日志
}
catch (Exception ee)
{
Config.AlertAtStartup(this, ee.Message);
}
GetData是我自己写的一个构造table的方法,在前台引用。
我现在要求起始时间和结束时间的时间段。我知道要用Between...and...但是参数化我不知道怎么做。。请各位帮我弄下。。付上代码。