private static int AddScriptResult(JObject job)
{
ScriptExecuteResut serModel = new ScriptExecuteResut();
serModel.ter_id = (int)job["terID"];
serModel.ScriptName = job["ScriptName"].ToString();
serModel.SatrtDate = DateTime.Now.ToString();
serModel.EndDate = DateTime.Now.ToString();
serModel.AccomPlishNum = 1;
serModel.ExecuteTrimLenght = 0;
int currentScript_id = add(job, serModel);
return(currentScript_id);
}
private static int add(JObject job, ScriptExecuteResut model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ScriptExecuteResut(");
strSql.Append("AccomPlishNum,succeed,fail,SatrtDate,EndDate,ter_id,ScriptName,LogFilePath,ExecuteTrimLenght,isDel)");
strSql.Append(" values (");
strSql.Append("@AccomPlishNum,@succeed,@fail,@SatrtDate,@EndDate,@ter_id,@ScriptName,@LogFilePath,@ExecuteTrimLenght,@isDel)");
strSql.Append(";select LAST_INSERT_ROWID()");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@AccomPlishNum", DbType.Int32, 8),
new SQLiteParameter("@succeed", DbType.Int32, 8),
new SQLiteParameter("@fail", DbType.Int32, 8),
new SQLiteParameter("@SatrtDate", DbType.String),
new SQLiteParameter("@EndDate", DbType.String),
new SQLiteParameter("@ter_id", DbType.Int32, 8),
new SQLiteParameter("@ScriptName", DbType.String),
new SQLiteParameter("@LogFilePath", DbType.String),
new SQLiteParameter("@ExecuteTrimLenght", DbType.Int32, 8),
new SQLiteParameter("@isDel", DbType.Int32, 4)
};
parameters[0].Value = model.AccomPlishNum;
parameters[1].Value = model.succeed;
parameters[2].Value = model.fail;
parameters[3].Value = model.SatrtDate;
parameters[4].Value = model.EndDate;
parameters[5].Value = model.ter_id;
parameters[6].Value = model.ScriptName;
parameters[7].Value = model.LogFilePath;
parameters[8].Value = model.ExecuteTrimLenght;
parameters[9].Value = model.IsDel;
object obj = SqliteHelpDao.ExecuteScalar(ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
