public int GetObjectCountByTime(DateTime timeStart, DateTime timeEnd)
{
StringBuilder strsql = new StringBuilder("select count(Obj_id) from [dbo].[C_Work_Object]");
if (timeStart != DateTime.MinValue || timeEnd != DateTime.MinValue)
{
strsql.Append(" where ");
if (timeStart == DateTime.MinValue)
{
strsql.AppendFormat("Obj_dotime< '{0}'", timeEnd.ToString());
}
else if (timeEnd == DateTime.MinValue)
{
strsql.AppendFormat("Obj_dotime> '{0}'", timeStart.ToString());
}
else
{
strsql.AppendFormat("Obj_dotime between '{0}' and '{1}'", timeStart.ToString(), timeEnd.ToString());
}
}
return this.dbProcessor.ExecuteInsert(strsql); }出现无法从System.text.StringBuilder转换为 "string"怎么改正啊??哪位指点一下啊,谢谢~~
{
StringBuilder strsql = new StringBuilder("select count(Obj_id) from [dbo].[C_Work_Object]");
if (timeStart != DateTime.MinValue || timeEnd != DateTime.MinValue)
{
strsql.Append(" where ");
if (timeStart == DateTime.MinValue)
{
strsql.AppendFormat("Obj_dotime< '{0}'", timeEnd.ToString());
}
else if (timeEnd == DateTime.MinValue)
{
strsql.AppendFormat("Obj_dotime> '{0}'", timeStart.ToString());
}
else
{
strsql.AppendFormat("Obj_dotime between '{0}' and '{1}'", timeStart.ToString(), timeEnd.ToString());
}
}
return this.dbProcessor.ExecuteInsert(strsql); }出现无法从System.text.StringBuilder转换为 "string"怎么改正啊??哪位指点一下啊,谢谢~~
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货