public static int CountTaskTrace(TaskTrace taskTrace)
{
int countResult = 0;
MySqlParameter[] parameters = new MySqlParameter[2];
parameters[0] = new MySqlParameter("@mobileindex", MySqlDbType.Int32);
parameters[0].Value = taskTrace.MobileIndex;
parameters[1] = new MySqlParameter("@typeid", MySqlDbType.Int32);
parameters[1].Value = taskTrace.TypeId;
try
{
countResult = int.Parse(MySqlHelpers.ExecuteScalar(MySqlHelpers.ConnectionString, CommandType.Text, count_trace_sql, parameters).ToString());
}
catch (Exception ex)
{
Console.WriteLine("CountTaskTrace EXCEPTION");
LogUtils.Error($"{ex}");
}
return(countResult);
}
public static int GetTaskTracePosition(TaskTrace taskTrace)
{
int position = 0;
MySqlParameter[] parameters = new MySqlParameter[2];
parameters[0] = new MySqlParameter("@mobileindex", MySqlDbType.Int32);
parameters[0].Value = taskTrace.MobileIndex;
parameters[1] = new MySqlParameter("@typeid", MySqlDbType.Int32);
parameters[1].Value = taskTrace.TypeId;
try
{
position = (int)MySqlHelpers.ExecuteScalar(MySqlHelpers.ConnectionString, CommandType.Text, get_trace_position_sql, parameters);
}
catch (Exception ex)
{
Console.WriteLine("GetTaskTracePosition EXCEPTION");
LogUtils.Error($"{ex}");
}
return(position);
}
//增加操作日志
public HttpResponseMessage Post_Log([FromBody] string value)
{
string userid = UtilFunction.GetCookie("uid");
string username = UtilFunction.GetCookie("uname");
string roleid = UtilFunction.GetCookie("roleid");
string rolename = Convert.ToString(MySqlHelpers.ExecuteScalar("select rolename from angel_sys_role where id = '" + roleid + "'"));
string logposition = value.Split('"')[5];
string operationtype = value.Split('"')[9];
try
{
int count = Convert.ToInt32(MySqlHelpers.ExecuteScalar("SELECT COUNT(*) FROM angel_sys_operationlog"));
int ID = 0;
if (count == 0)
{
ID = 1;
}
else
{
ID = Convert.ToInt32(MySqlHelpers.ExecuteScalar("SELECT MAX(ID) FROM angel_sys_operationlog")) + 1;
}
string sql = "INSERT INTO angel_sys_operationlog VALUES (" + ID + ", '" + userid + "', '" + username + "', '" + roleid + "','" + rolename + "','" + logposition + "','" + operationtype + "','" + value.ToString() + "','" + username + "','" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')";
MySqlHelpers.ExecuteNonQuery(sql);
StringBuilder result = new StringBuilder();
result.Append("{");
string code = "\"code\":{{\"id\":{0},\"msg\":\"{1}\"}}";
code = string.Format(code, 1, "成功");
result.Append(code);
result.Append("}");
return(GetJSONMessage(result.ToString()));
}
catch (Exception er)
{
return(GetJSONMessage(""));
}
}
/// <summary>
/// 获取总条数
/// </summary>
public object counttotal()
{
string sql = " select count(*) from angel_sys_loginlog";
return(MySqlHelpers.ExecuteScalar(sql));
}
public object ExecuteScalar(string sql)
{
return(MySqlHelpers.ExecuteScalar(sql));
}
/// <summary>
/// 获取总条数
/// </summary>
public object counttotal()
{
string sql = " select count(*) from angel_SYS_LOGINLOG";
return(MySqlHelpers.ExecuteScalar(sql));
}
