public IList <RecordStage> GetRecordstages(int mobileindex, int typeid)
{
List <RecordStage> list = new List <RecordStage>();
MySqlParameter[] par = new MySqlParameter[2];
par[0] = new MySqlParameter("@phonenum", MySqlDbType.Int32);
par[0].Value = mobileindex;
par[1] = new MySqlParameter("@typeid", MySqlDbType.Int32);
par[1].Value = typeid;
using (MySqlDataReader dr = MySqlHelpers.ExecuteReader(MySqlHelpers.ConnectionString, CommandType.Text, strSql_select_recordbymobile, par))
{
while (dr.Read())
{
RecordStage record = new RecordStage();
record.Id = Int32.Parse(dr["id"].ToString());
record.PhoneNum = Int32.Parse(dr["phonenum"].ToString());
record.TypeId = Int32.Parse(dr["typeid"].ToString());
record.LastNums = Int32.Parse(dr["lastnums"].ToString());
list.Add(record);
}
}
return(list);
}
public IList <TaskSch> GetTimedTasks()
{
List <TaskSch> list = new List <TaskSch>();
using (MySqlDataReader dr = MySqlHelpers.ExecuteReader(MySqlHelpers.ConnectionString, CommandType.Text, strSql_select_timedtasks))
{
while (dr.Read())
{
TaskSch task = new TaskSch();
task.Id = Int32.Parse(dr["id"].ToString());
task.TypeId = Int32.Parse(dr["typeid"].ToString());
task.Remotes = dr["remotes"].ToString();
task.MobileIndex = Int32.Parse(dr["mobileindex"].ToString());
task.Bodys = dr["bodys"].ToString();
task.Status = dr["status"].ToString();
task.ResultVal = dr["resultval"].ToString();
task.SlideNums = Int32.Parse(dr["slidenums"].ToString());
task.FriendNums = Int32.Parse(dr["friendnums"].ToString());
task.RepeatNums = Int32.Parse(dr["repeatnums"].ToString());
task.RandomMins = Int32.Parse(dr["randommins"].ToString());
task.RandomMaxs = Int32.Parse(dr["randommaxs"].ToString());
task.IsStep = Int32.Parse(dr["isstep"].ToString());
task.IsWhole = Int32.Parse(dr["iswhole"].ToString());
task.InputName = dr["inputname"].ToString();
task.StartTime = DateTime.Parse(dr["starttime"].ToString());
list.Add(task);
}
}
return(list);
}
/// <summary>
/// 获取任务列表
/// </summary>
/// <param name="limit"></param>
/// <returns></returns>
public IList <TaskSch> GetTasksForSend(string status, int orders, int limit = 100)
{
List <TaskSch> list = new List <TaskSch>();
string sql_select = strSql_select_tasks_asc;
if (orders == 2)
{
sql_select = strSql_select_tasks_desc;
}
MySqlParameter[] par = new MySqlParameter[2];
par[0] = new MySqlParameter("@status", MySqlDbType.Text);
par[0].Value = status;
par[1] = new MySqlParameter("@limit", MySqlDbType.Int32);
par[1].Value = limit;
using (MySqlDataReader dr = MySqlHelpers.ExecuteReader(MySqlHelpers.ConnectionString, CommandType.Text, sql_select, par))
{
while (dr.Read())
{
TaskSch task = new TaskSch();
task.Id = Int32.Parse(dr["id"].ToString());
task.TypeId = Int32.Parse(dr["typeid"].ToString());
task.Remotes = dr["remotes"].ToString();
task.MobileIndex = Int32.Parse(dr["mobileindex"].ToString());
task.Bodys = dr["bodys"].ToString();
task.Status = dr["status"].ToString();
task.ResultVal = dr["resultval"].ToString();
task.SlideNums = Int32.Parse(dr["slidenums"].ToString());
task.FriendNums = Int32.Parse(dr["friendnums"].ToString());
task.RepeatNums = Int32.Parse(dr["repeatnums"].ToString());
task.RandomMins = Int32.Parse(dr["randommins"].ToString());
task.RandomMaxs = Int32.Parse(dr["randommaxs"].ToString());
task.IsStep = Int32.Parse(dr["isstep"].ToString());
task.IsWhole = Int32.Parse(dr["iswhole"].ToString());
task.InputName = dr["inputname"].ToString();
task.StartTime2 = dr["starttime"].ToString();
task.LastExecuteTime = dr["lastexecutetime"].ToString();
list.Add(task);
}
}
return(list);
}
public Configs GetConfigs()
{
Configs config = new Configs();
List <Configs> list = new List <Configs>();
using (MySqlDataReader dr = MySqlHelpers.ExecuteReader(MySqlHelpers.ConnectionString, CommandType.Text, strSql_select_allconfigs, null))
{
if (dr.Read())
{
config.Id = Int32.Parse(dr["id"].ToString());
config.Lang = Int32.Parse(dr["lang"].ToString());
config.Rownums = Int32.Parse(dr["rownums"].ToString());
config.Groupnums = Int32.Parse(dr["groupnums"].ToString());
}
}
return(config);
}
/// <summary>
/// 统计任务数
/// </summary>
/// <returns></returns>
public int CountByStatus(string status = "waiting")
{
int resnum = 0;
MySqlParameter[] par = new MySqlParameter[1];
par[0] = new MySqlParameter("@status", MySqlDbType.Text);
par[0].Value = status;
using (MySqlDataReader dr = MySqlHelpers.ExecuteReader(MySqlHelpers.ConnectionString, CommandType.Text, strSql_count_tasknums, par))
{
if (dr.Read())
{
resnum = Int32.Parse(dr["countnums"].ToString());
}
}
return(resnum);
}
public List <Phonenum> SelectPhoneNumber()
{
List <Phonenum> list = new List <Phonenum>();
using (MySqlDataReader dr = MySqlHelpers.ExecuteReader(MySqlHelpers.ConnectionString, CommandType.Text, strSql_select_phoneNumber, null))
{
while (dr.Read())
{
Phonenum phonenum = new Phonenum();
phonenum.Id = Int32.Parse(dr["id"].ToString());
phonenum.PhoneNum = dr["phonenum"].ToString();
phonenum.SimulatorId = Int32.Parse(dr["simulator_id"].ToString());
phonenum.Status = Int32.Parse(dr["status"].ToString());
phonenum.Created = dr["created"].ToString();
list.Add(phonenum);
}
}
return(list);
}
/// <summary>
/// 查询每个模拟器待处理任务数
/// </summary>
/// <param name="status"></param>
/// <returns></returns>
public IList <TaskSch> GetTasksForSendGroup(string status)
{
List <TaskSch> list = new List <TaskSch>();
MySqlParameter[] par = new MySqlParameter[1];
par[0] = new MySqlParameter("@status", MySqlDbType.Text);
par[0].Value = status;
using (MySqlDataReader dr = MySqlHelpers.ExecuteReader(MySqlHelpers.ConnectionString, CommandType.Text, strSql_select_mobileindex_grouptasks, par))
{
while (dr.Read())
{
TaskSch task = new TaskSch();
task.MobileIndex = Int32.Parse(dr["mobileindex"].ToString());
task.Created = Int32.Parse(dr["nums"].ToString());
list.Add(task);
}
}
return(list);
}
/// <summary>
/// 统计每个模拟器的任务数
/// </summary>
/// <param name="status"></param>
/// <param name="mobileIndex"></param>
/// <returns></returns>
public int CountByStatus(string status, int mobileIndex, int iswhole)
{
int resnum = 0;
MySqlParameter[] par = new MySqlParameter[3];
par[0] = new MySqlParameter("@status", MySqlDbType.Text);
par[0].Value = status;
par[1] = new MySqlParameter("@mobileindex", MySqlDbType.Int32);
par[1].Value = mobileIndex;
par[2] = new MySqlParameter("@iswhole", MySqlDbType.Int32);
par[2].Value = iswhole;
using (MySqlDataReader dr = MySqlHelpers.ExecuteReader(MySqlHelpers.ConnectionString, CommandType.Text, strSql_count_tasknums_mobileindex, par))
{
if (dr.Read())
{
resnum = Int32.Parse(dr["countnums"].ToString());
}
}
return(resnum);
}
