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