/// <summary>
/// 增加一条HASH纪录的日志文件
/// </summary>
public static int AddNewHashLOG(HASHITEM thehash, int thedetailID)
{
try
{
StringBuilder strSql = new StringBuilder();
{
////添加工作计划
//string tempstr = string.Format("insert into H31_DHT_TYPE{0} (", thedetailID);
//strSql.Append(tempstr);
//strSql.Append("hashKey,recvTime,updateTime,keyContent,KeyWords,keyType,recvTimes,fileCnt,filetotalSize,Detail)");
//strSql.Append(" values (");
//strSql.Append("@hashKey,@recvTime,@updateTime,@keyContent,@KeyWords,@keyType,@recvTimes,@fileCnt,@filetotalSize,@Detail)");
//DbParameter[] cmdParms = {
//dbsql.CreateInDbParameter("@hashKey",DbType.String,40,thehash.hashKey),
//dbsql.CreateInDbParameter("@recvTime", DbType.DateTime,thehash.recvTime),
//dbsql.CreateInDbParameter("@updateTime", DbType.DateTime,thehash.recvTime),
//dbsql.CreateInDbParameter("@keyContent", DbType.String,thehash.keyContent),
//dbsql.CreateInDbParameter("@KeyWords", DbType.String,thehash.keyWords),
//dbsql.CreateInDbParameter("@keyType", DbType.Int32,thehash.keyType),
//dbsql.CreateInDbParameter("@recvTimes", DbType.Int32,thehash.recvTimes),
//dbsql.CreateInDbParameter("@fileCnt", DbType.Int32,thehash.fileCnt),
//dbsql.CreateInDbParameter("@filetotalSize", DbType.Int32,thehash.filetotalSize),
//dbsql.CreateInDbParameter("@Detail", DbType.Int32,thedetailID)
//};
//return dbsql.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms);
}
}
catch (System.Exception ex)
{
H31Debug.PrintLn(ex.StackTrace);
}
return(-1);
}
/// <summary>
/// 更新HASH纪录次
/// </summary>
public static int UpdateHashCount(int thetype, HASHITEM thehash, int thedetailID, int isHanzhi)
{
try
{
StringBuilder strSql = new StringBuilder();
string tempstr = string.Format("update H31_DHT_TYPE_{0}_{1} set recvTimes=recvTimes+1 where hashKey='{2}'", thetype * 100 + 1, isHanzhi, thehash.hashKey);
strSql.Append(tempstr);
return(dbsql.ExecuteNonQuery(CommandType.Text, strSql.ToString(), null));
}
catch (System.Exception ex)
{
H31Debug.PrintLn(ex.StackTrace);
}
return(-1);
}
/// <summary>
/// 增加一条HASH纪录
/// </summary>
public static int AddNewHash(HASHTYPE thetype, HASHITEM thehash, int thedetailID, int isHanzhi)
{
try
{
StringBuilder strSql = new StringBuilder();
{
//添加工作计划
string tempstr = string.Format("insert into H31_DHT_TYPE_{0}_{1} (", (int)thetype * 100 + 1, isHanzhi);
strSql.Append(tempstr);
strSql.Append("hashKey,recvTime,updateTime,keyContent,KeyWords,keyType,recvTimes,fileCnt,filetotalSize,Detail)");
strSql.Append(" values (");
strSql.Append("@hashKey,@recvTime,@updateTime,@keyContent,@KeyWords,@keyType,@recvTimes,@fileCnt,@filetotalSize,@Detail)");
DbParameter[] cmdParms =
{
dbsql.CreateInDbParameter("@hashKey", DbType.String, 40, thehash.hashKey),
dbsql.CreateInDbParameter("@recvTime", DbType.DateTime, thehash.recvTime),
dbsql.CreateInDbParameter("@updateTime", DbType.DateTime, thehash.recvTime),
dbsql.CreateInDbParameter("@keyContent", DbType.String, thehash.keyContent),
dbsql.CreateInDbParameter("@KeyWords", DbType.String, thehash.keyWords),
dbsql.CreateInDbParameter("@keyType", DbType.Int32, thehash.keyType),
dbsql.CreateInDbParameter("@recvTimes", DbType.Int32, thehash.recvTimes),
dbsql.CreateInDbParameter("@fileCnt", DbType.Int32, thehash.fileCnt),
dbsql.CreateInDbParameter("@filetotalSize", DbType.Double, Convert.ToDouble(thehash.filetotalSize)),
dbsql.CreateInDbParameter("@Detail", DbType.Int32, thedetailID)
};
int res = dbsql.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms);
if (res == 1)
{
string tempstr2 = string.Format("select top 1 id from H31_DHT_TYPE_{0}_{1} where hashKey='{2}' order by id desc", (int)thetype * 100 + 1, isHanzhi, thehash.hashKey);
object countid = dbsql.ExecuteScalar(CommandType.Text, tempstr2.ToString(), null);
if (countid == null)
{
return(0);
}
return((int)countid);
}
}
}
catch (System.Exception ex)
{
H31Debug.PrintLn(ex.StackTrace);
}
return(-1);
}
