/// <summary>
/// 修改数量
/// </summary>
public void ChangeCount()
{
if (this.NewCount == "")
{
this.NewCount = "0";
}
else
{
double count = 0;
if (!double.TryParse(NewCount, out count))
{
this.NewCount = "0";
}
if (count > 9999)
{
count = 9999;
this.NewCount = "9999";
}
if (!NewCount.EndsWith("."))
{
this.NewCount = Math.Round(count, 3).ToString("0.###");
}
}
}
public string SacarTodaslasClaves()
{
con = new MySqlConnection();
con.ConnectionString = "Server=127.0.0.1;Database=downtoledo; Uid=toor;Pwd=toor;SslMode=none";
try
{
con.Open();
MySqlCommand com = new MySqlCommand("call allcodes()", con);
MySqlDataReader reader = com.ExecuteReader();
List <NewCount> listacodigos = new List <NewCount>();
while (reader.Read())
{
NewCount ncuenta = new NewCount();
ncuenta.clave = (String)reader.GetValue(0);
ncuenta.rol = (string)reader.GetValue(1);
listacodigos.Add(ncuenta);
}
Respuesta r = new Respuesta();
r.codigos = listacodigos;
r.correcto = 0;
return(JsonConvert.SerializeObject(r));
}catch (MySqlException e)
{
Respuesta r = new Respuesta();
r.codigos = new List <NewCount>();
r.correcto = 1;
return(JsonConvert.SerializeObject(r));
}
}
public void Add(int v)
{
_buffer[_writeIndex++] = v;
if (_writeIndex >= WindowSize)
{
LastAverage = _buffer.Average();
_writeIndex = 0;
NewCount?.Invoke(this, EventArgs.Empty);
}
}
public override int GetHashCode()
{
var hash = 1;
if (Result != 0)
{
hash ^= Result.GetHashCode();
}
if (NewCount != 0)
{
hash ^= NewCount.GetHashCode();
}
return(hash);
}
public string CrearCodigo(string rol)
{
con = new MySqlConnection();
con.ConnectionString = "Server=127.0.0.1;Database=downtoledo; Uid=toor;Pwd=toor;SslMode=none";
try
{
con.Open();
String clave = "";
Random random = new Random();
for (int i = 0; i < 10; i++)
{
Boolean numerocorrecto = false;
int numero = 0;
while (!numerocorrecto)
{
numero = random.Next(48, 122);
if ((numero > 57 && numero < 65) || (numero > 90 && numero < 97))
{
numerocorrecto = false;
}
else
{
numerocorrecto = true;
}
}
Char character = Convert.ToChar(numero);
clave += character;
}
MySqlCommand com = new MySqlCommand("call createcode('" + clave + "'," + rol + ")", con);
com.ExecuteNonQuery();
con.Close();
NewCount nueva = new NewCount();
com = new MySqlCommand("call namerol(" + rol + ")", con);
con.Open();
MySqlDataReader reader = com.ExecuteReader();
reader.Read();
nueva.rol = (string)reader.GetValue(0);
nueva.clave = clave;
con.Close();
String respuesta = JsonConvert.SerializeObject(nueva);
return(respuesta);
}
catch (MySqlException)
{
return("error");
}
}
private async Task <NewCount> NewUser(string rol)
{
string r = "";
url = new Uri("http://localhost:61177/NuevaCuenta.asmx/Saberidrol");
formulario = new List <KeyValuePair <string, string> >();
formulario.Add(new KeyValuePair <string, string>("rol", rol));
content = new FormUrlEncodedContent(formulario);
var response = await cliente.PostAsync(url, content);
if (response.IsSuccessStatusCode)
{
var contenido = response.Content.ReadAsStringAsync().Result;
xml = new XmlDocument();
xml.LoadXml(contenido);
r = (xml.DocumentElement.InnerText);
}
url = new Uri("http://localhost:61177/NuevaCuenta.asmx/CrearCodigo");
formulario = new List <KeyValuePair <string, string> >();
formulario.Add(new KeyValuePair <string, string>("rol", r));
content = new FormUrlEncodedContent(formulario);
response = await cliente.PostAsync(url, content);
if (response.IsSuccessStatusCode)
{
var contenido = response.Content.ReadAsStringAsync().Result;
xml = new XmlDocument();
xml.LoadXml(contenido);
var nuevaRespuesta = new NewCount();
nuevaRespuesta = JsonConvert.DeserializeObject <NewCount>(xml.DocumentElement.InnerText);
return(nuevaRespuesta);
}
else
{
return(null);
}
}
