代码如下: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...但是参数化我不知道怎么做。。请各位帮我弄下。。付上代码。
{
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...但是参数化我不知道怎么做。。请各位帮我弄下。。付上代码。
我觉得你这样写可读性不高——个人意见:-D利用参数化SQL语
句,向Oracle数据库插入DateTime类型数据时该如何设置???
你纠结什么啊???要那么多人过来干嘛???问题解决不就好了么???不会是你上面的还没有看懂吧???不是给你说了么,数据库字段为datetime类型的对应字段的值用Convert.Todatetime()就可以了么!!!