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)); } }