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