/// <summary>
/// 保存账号
/// </summary>
/// <param name="objadmins"></param>
/// <returns></returns>
public int AddAdmins(admins objadmins)
{
int flag = 0;
string sql = " insert into admins (login_user,login_pwd,explain_detail,addtime)";
sql += " VALUES (@login_user,@login_pwd,@explain_detail,@addtime)";
MySqlParameter[] param = new MySqlParameter[]
{
new MySqlParameter("@login_user", objadmins.login_user),
new MySqlParameter("@login_pwd", objadmins.login_pwd),
new MySqlParameter("@explain_detail", objadmins.explain_detail),
new MySqlParameter("@addtime", objadmins.addtime)
};
try
{
flag = MySqlHelpers.Update(sql, param);
}
catch (Exception ex)
{
LogUtils.Error($"{ex}");
System.Diagnostics.EventLog.WriteEntry(" ", ex.ToString(), System.Diagnostics.EventLogEntryType.Error);
}
return(flag);
}
/// <summary>
/// 添加配置
/// </summary>
/// <param name="objSimulators"></param>
/// <returns></returns>
public int Add(SystemConfig objSystemConfig)
{
string sql = "insert into systemconfig (uid,state)";
sql += " VALUES (@uid,@state)";
MySqlParameter[] param = new MySqlParameter[]
{
new MySqlParameter("@uid", objSystemConfig.uid),
new MySqlParameter("@state", objSystemConfig.state)
};
return(MySqlHelpers.Update(sql.ToString(), param));
}
/// <summary>
/// 新增模拟器号码
/// </summary>
/// <param name="objSimulators"></param>
/// <returns></returns>
public int UpdateSimulators(Simulators objSimulators)
{
//string sql = "Update simulators set phonenum=@phonenum,imei=@imei,";
//sql += "androidid=@androidid,created=@created where id=@Id";
// StringBuilder sqlBuilder = new StringBuilder();
string sql = "insert into simulators (id,phonenum,imei,androidid,created)";
sql += " VALUES (@id,@phonenum,@imei,@androidid,@created)";
MySqlParameter[] param = new MySqlParameter[]
{
new MySqlParameter("@Id", objSimulators.id),
new MySqlParameter("@phonenum", objSimulators.phonenum),
new MySqlParameter("@imei", objSimulators.imei),
new MySqlParameter("@androidid", objSimulators.androidid),
new MySqlParameter("@created", objSimulators.created)
};
return(MySqlHelpers.Update(sql.ToString(), param));
}
/// <summary>
/// 修改配置
/// </summary>
/// <param name="objSystemConfig"></param>
/// <returns></returns>
public int UpdateSystemConfig(SystemConfig objSystemConfig)
{
int flag = 0;
string sql = "update systemconfig set state=@state where id=@id";
MySqlParameter[] param = new MySqlParameter[]
{
new MySqlParameter("@state", objSystemConfig.state),
new MySqlParameter("@id", objSystemConfig.id)
};
try
{
flag = MySqlHelpers.Update(sql, param);
}
catch (Exception ex)
{
LogUtils.Error($"{ex}");
System.Diagnostics.EventLog.WriteEntry(" ", ex.ToString(), System.Diagnostics.EventLogEntryType.Error);
}
return(flag);
}
