/// <summary> /// 写入登录日志的方法 /// </summary> /// <param name="userid">用户ID</param> /// <param name="username">用户名称</param> /// <param name="roleid">权限ID</param> /// <param name="rolename">权限名称</param> /// <param name="logintdate">登录时间</param> public void SaveLog(int userid, string username, int roleid, string rolename, string clientip, string createuser, string type) { var values = XmlHelper.ReadXml("SqlQuery", "insertloginlog"); string sql = string.Format(values.First().Value, userid, username, roleid, rolename, createuser, clientip, DateTime.Now, DateTime.Now, type); MySqlHelpers.ExecuteNonQuery(sql); }
public int InsertRecord(RecordStage record) { int flag = 0; MySqlParameter[] par = new MySqlParameter[3]; par[0] = new MySqlParameter("@phonenum", MySqlDbType.Int32); par[0].Value = record.PhoneNum; par[1] = new MySqlParameter("@typeid", MySqlDbType.Int32); par[1].Value = record.TypeId; par[2] = new MySqlParameter("@lastnums", MySqlDbType.Int32); par[2].Value = record.LastNums; try { flag = MySqlHelpers.ExecuteNonQuery(MySqlHelpers.ConnectionString, CommandType.Text , strSql_insert_record, par); } catch (Exception ex) { LogUtils.Error($"{ex}"); System.Diagnostics.EventLog.WriteEntry("Facebook", ex.ToString(), System.Diagnostics.EventLogEntryType.Error); } return(flag); }
public int InsertPhoneNum(Phonenum phonenum) { int nflag = 1; MySqlParameter[] par = new MySqlParameter[3]; par[0] = new MySqlParameter("@simulator_id", MySqlDbType.Int32); par[0].Value = phonenum.SimulatorId; par[1] = new MySqlParameter("@phonenum", MySqlDbType.Text); par[1].Value = phonenum.PhoneNum; par[2] = new MySqlParameter("@status", MySqlDbType.Int32); par[2].Value = phonenum.Status; try { nflag = MySqlHelpers.ExecuteNonQuery(MySqlHelpers.ConnectionString, CommandType.Text , strSql_insert_phonenum, par); } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry("WhatsApp", ex.ToString(), System.Diagnostics.EventLogEntryType.Error); } return(nflag); }
/// <summary> /// 删除分类任务 /// </summary> /// <returns></returns> public int DeleteTypeTasks(int typeid) { int flag = 0; string strSql = ""; if (typeid == 1) //定时任务 { strSql = strSql_delete_timedtasks; } else if (typeid == 2) { strSql = strSql_delete_globaltasks; } if (strSql != "") { try { flag = MySqlHelpers.ExecuteNonQuery(MySqlHelpers.ConnectionString, CommandType.Text, strSql, null); } catch (Exception ex) { LogUtils.Error(string.Format("删除任务出错:{0}", ex.ToString())); } } return(flag); }
/// <summary> /// 变更任务状态 /// </summary> /// <param name="id"></param> /// <param name="status"></param> /// <returns></returns> public int UpdateTaskStatus(int id, int status) { int nflag = 0; string statusval = ""; switch (status) { case 1: statusval = "submit "; break; case -1: statusval = "fail"; break; case 0: statusval = "waiting"; break; default: statusval = "fail"; break; } MySqlParameter[] par = new MySqlParameter[2]; par[0] = new MySqlParameter("@id", MySqlDbType.Int32); par[0].Value = id; par[1] = new MySqlParameter("@status", MySqlDbType.Text); par[1].Value = statusval; nflag = MySqlHelpers.ExecuteNonQuery(MySqlHelpers.ConnectionString, CommandType.Text, strSql_update_updatetaskstatus, par); return(nflag); }
/// <summary> /// INSERT/UPDATE/DELETE公共方法 /// </summary> /// <param name="param">参数</param> /// <returns>影响记录数</returns> public int InsUpdDelDataTableToParam(Dictionary <string, List <Object> > param) { Dictionary <string, Dimention> report = GetReport(); string sql = string.Empty; int count = 0; List <string> repSql = new List <string>(); try { if (param != null) { foreach (var d in param) { Dimention dimention = report[d.Key]; sql = dimention.SqlAll; int i = 0; foreach (Object value in d.Value) { ////替换后的sql语句 sql = sql.Replace("{" + i + "}", value.ToString()); i = i + 1; } } } count = MySqlHelpers.ExecuteNonQuery(sql); } catch (Exception ex) { FileLog.WriteLog(ex.ToString()); } return(count); }
/// <summary> /// 保存配置参数 /// </summary> /// <param name="lang"></param> /// <param name="groupnums"></param> /// <param name="rownums"></param> /// <returns></returns> public int InsertConfigs(int lang, int groupnums, int rownums) { int nflag = 0; MySqlParameter[] par = new MySqlParameter[4]; par[0] = new MySqlParameter("@lang", MySqlDbType.Int32); par[0].Value = lang; par[1] = new MySqlParameter("@rownums", MySqlDbType.Int32); par[1].Value = rownums; par[2] = new MySqlParameter("@groupnums", MySqlDbType.Int32); par[2].Value = groupnums; par[3] = new MySqlParameter("@id", MySqlDbType.Int32); par[3].Value = 1; try { nflag = MySqlHelpers.ExecuteNonQuery(MySqlHelpers.ConnectionString, CommandType.Text , strSql_update_createconfigs, par); } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry("WhatsApp", ex.ToString(), System.Diagnostics.EventLogEntryType.Error); } return(nflag); }
public static int UpdateTaskTrace(TaskTrace taskTrace) { int updateResult = 0; MySqlParameter[] parameters = new MySqlParameter[3]; parameters[0] = new MySqlParameter("@mobileindex", MySqlDbType.Int32); parameters[0].Value = taskTrace.MobileIndex; parameters[1] = new MySqlParameter("@typeid", MySqlDbType.Int32); parameters[1].Value = taskTrace.TypeId; parameters[2] = new MySqlParameter("@position", MySqlDbType.Int32); parameters[2].Value = taskTrace.Position; try { updateResult = MySqlHelpers.ExecuteNonQuery(MySqlHelpers.ConnectionString, CommandType.Text, update_trace_sql, parameters); } catch (Exception ex) { Console.WriteLine("UpdateTaskTrace EXCEPTION"); LogUtils.Error($"{ex}"); } return(updateResult); }
/// <summary> /// 插入任务 /// </summary> /// <param name="tasks"></param> /// <returns></returns> public int InsertTask(TaskSch tasks) { int flag = 0; MySqlParameter[] par = new MySqlParameter[14]; par[0] = new MySqlParameter("@typeid", MySqlDbType.Int32); par[0].Value = tasks.TypeId; par[1] = new MySqlParameter("@remotes", MySqlDbType.Text); par[1].Value = tasks.Remotes; par[2] = new MySqlParameter("@mobileindex", MySqlDbType.Int32); par[2].Value = tasks.MobileIndex; par[3] = new MySqlParameter("@bodys", MySqlDbType.Text); par[3].Value = tasks.Bodys; par[4] = new MySqlParameter("@status", MySqlDbType.Text); par[4].Value = tasks.Status; par[5] = new MySqlParameter("@slidenums", MySqlDbType.Int32); par[5].Value = tasks.SlideNums; par[6] = new MySqlParameter("@repeatnums", MySqlDbType.Int32); par[6].Value = tasks.RepeatNums; par[7] = new MySqlParameter("@friendnums", MySqlDbType.Int32); par[7].Value = tasks.FriendNums; par[8] = new MySqlParameter("@randommins", MySqlDbType.Int32); par[8].Value = tasks.RandomMins; par[9] = new MySqlParameter("@randommaxs", MySqlDbType.Int32); par[9].Value = tasks.RandomMaxs; par[10] = new MySqlParameter("@resultval", MySqlDbType.Text); par[10].Value = tasks.ResultVal; par[11] = new MySqlParameter("@isstep", MySqlDbType.Int32); par[11].Value = tasks.IsStep; par[12] = new MySqlParameter("@iswhole", MySqlDbType.Int32); par[12].Value = tasks.IsWhole; par[13] = new MySqlParameter("@inputname", MySqlDbType.Text); par[13].Value = tasks.InputName; try { flag = MySqlHelpers.ExecuteNonQuery(MySqlHelpers.ConnectionString, CommandType.Text , strSql_insert_tasksign, par); } catch (Exception ex) { LogUtils.Error($"{ex}"); System.Diagnostics.EventLog.WriteEntry("WhatsApp", ex.ToString(), System.Diagnostics.EventLogEntryType.Error); } return(flag); }
public int UpdateTimedTaskExecuteTime(int id) { int nflag = 0; MySqlParameter[] par = new MySqlParameter[2]; par[0] = new MySqlParameter("@id", MySqlDbType.Int32); par[0].Value = id; par[1] = new MySqlParameter("@lastexecutetime", MySqlDbType.Date); par[1].Value = DateTime.Now.Date; nflag = MySqlHelpers.ExecuteNonQuery(MySqlHelpers.ConnectionString, CommandType.Text, strSql_update_updatetimedtask_executetime, par); return(nflag); }
/// <summary> /// 根据uif进行用户的注册 /// </summary> /// <param name="uif"></param> /// <returns>是否注册成功</returns> public int register(userinfo uif) { if (isHaveThisUserName(uif.username) == null) { MySqlParameter[] mySqlParameter = { new MySqlParameter("@username", uif.username), new MySqlParameter("@pwd", uif.pwd), new MySqlParameter("@nicheng", uif.nicheng), new MySqlParameter("@touxiangurl", uif.touxiangurl) }; string sql = @"insert into boke.userinfo values(@username,@pwd,null,@nicheng,now(),now(),@touxiangurl,0)"; int Count = MySqlHelpers.ExecuteNonQuery(sql, mySqlParameter); return(Count); } else { return(0); } }
/// <summary> /// 更新任务的执行结果 /// </summary> /// <param name="id"></param> /// <param name="status"></param> /// <returns></returns> public int UpdateTaskResult(int id, string status) { int nflag = 0; MySqlParameter[] par = new MySqlParameter[2]; par[0] = new MySqlParameter("@id", MySqlDbType.Int32); par[0].Value = id; par[1] = new MySqlParameter("@resultval", MySqlDbType.Text); par[1].Value = status; nflag = MySqlHelpers.ExecuteNonQuery(MySqlHelpers.ConnectionString, CommandType.Text, strSql_update_updatetaskres, par); return(nflag); }
/// <summary> /// 删除任务 /// </summary> /// <param name="id"></param> /// <returns></returns> public int DeleteTasks(int id) { int flag = 0; MySqlParameter[] par = new MySqlParameter[1]; par[0] = new MySqlParameter("@id", MySqlDbType.Int32); par[0].Value = id; try { flag = MySqlHelpers.ExecuteNonQuery(MySqlHelpers.ConnectionString, CommandType.Text, strSql_delete_tasks, par); } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry("WhatsApp", ex.ToString(), System.Diagnostics.EventLogEntryType.Error); } return(flag); }
public int UpdatePhoneStatus(int phone, int respone) { int nflag = 1; MySqlParameter[] par = new MySqlParameter[2]; par[0] = new MySqlParameter("@statusval", MySqlDbType.Int32); par[0].Value = respone; par[1] = new MySqlParameter("@phonenum", MySqlDbType.Int32); par[1].Value = phone; try { nflag = MySqlHelpers.ExecuteNonQuery(MySqlHelpers.ConnectionString, CommandType.Text , strSql_update_phonestatus, par); } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry("WhatsApp", ex.ToString(), System.Diagnostics.EventLogEntryType.Error); } return(nflag); }
//增加操作日志 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> /// <param name="sql"></param> /// <param name="mySqlParameters"></param> /// <returns></returns> public int dataUapdatOrInsert(string sql, MySqlParameter[] mySqlParameters) { return(MySqlHelpers.ExecuteNonQuery(sql, mySqlParameters)); }
public int RunSQL(string list) { return(MySqlHelpers.ExecuteNonQuery(list)); }
public string Delete(string sql) { int result = MySqlHelpers.ExecuteNonQuery(sql); return("{\"del\":" + result + "}"); }
public string Create(string sql) { int result = MySqlHelpers.ExecuteNonQuery(sql); return("{\"ins\":" + result + "}"); }
public string MulteBatch(List <string> sqlArray) { int result = MySqlHelpers.ExecuteNonQuery(sqlArray); return("\"ins\":" + result + ""); }