/// <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 + "");
}
