// Escribe los valores en la clase salidasmat
private static salidasmat Loadsalidasmat(IDataReader reader)
{
salidasmat item = new salidasmat();
item.nsis = Convert.ToString(reader["nsis"]);
item.nrec = Convert.ToString(reader["nrec"]);
item.fech = Convert.ToDateTime(reader["fech"]);
item.prov = Convert.ToString(reader["prov"]);//contratista
item.mat = Convert.ToString(reader["mat"]);
item.opcd = Convert.ToInt32(reader["occo"]);
item.ccos = Convert.ToString(reader["ccos"]);
item.lug = Convert.ToString(reader["lug"]);
item.tven = Convert.ToString(reader["tpven"]);
item.equ = Convert.ToString(reader["equ"]);
item.ope = Convert.ToString(reader["ope"]);
item.cosm = Convert.ToDecimal(reader["cosm"]);
item.flem = Convert.ToDecimal(reader["flem"]);
item.tifkm = Convert.ToDecimal(reader["tifkm"]);
item.timat = Convert.ToDecimal(reader["timat"]);
item.anul = Convert.ToInt32(reader["anul"]);
item.matfle = Convert.ToDecimal(reader["matfle"]);
item.ttra = Convert.ToString(reader["ttra"]);
item.cant = Convert.ToDecimal(reader["cant"]);
item.timatt = Convert.ToDecimal(reader["timatt"]);
item.hfin = Convert.ToString(reader["hsal"]);
item.opcdt = Convert.ToInt32(reader["occot"]);
item.ccost = Convert.ToString(reader["ccost"]);
item.cont = Convert.ToString(reader["cont"]);
item.flemt = Convert.ToDecimal(reader["flemt"]);
item.tifkmt = Convert.ToDecimal(reader["tifkmt"]);
item.matflet = Convert.ToDecimal(reader["matflet"]);
item.rkm = Convert.ToDecimal(reader["rkm"]);
return(item);
}
// devuleve un registro en particular
public static salidasmat GellIdsalidasmat(string c, int i)
{
salidasmat list = null;
using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["default"].ToString()))
{
conn.Open();
MySqlCommand command;
if (i == 1)
{
command = new MySqlCommand("SELECT * FROM salidasmat WHERE nrec like @cod", conn);
}
else if (i == 2)
{
command = new MySqlCommand("SELECT * FROM salidasmat WHERE nrec like @cod", conn);
}
else
{
command = new MySqlCommand("SELECT * FROM salidasmat WHERE mat like @cod", conn);
}
command.Parameters.AddWithValue("@cod", c);
MySqlDataReader reader = command.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
list = Loadsalidasmat(reader);
}
}
}
return(list);
}
private static salidasmat Loadresumen3(IDataReader reader)
{
decimal s;
salidasmat item = new salidasmat();
item.ttra = Convert.ToString(reader["nom"]);
s = reader["total"] == DBNull.Value ? 0 : Convert.ToDecimal(reader["total"]);
item.matfle = s;
return(item);
}
private static salidasmat Loadresumen2(IDataReader reader)
{
decimal s;
salidasmat item = new salidasmat();
item.rkm = Convert.ToInt32(reader["viajes"]);
item.equ = Convert.ToString(reader["equ"]);
s = reader["total"] == DBNull.Value ? 0 : Convert.ToDecimal(reader["total"]);
item.matfle = s;
return(item);
}
// hace las operaciones correspondiente al procedimiento almacenado.
public static int accion(salidasmat item, int op)
{
int rowsAffected = 0;
try
{
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["default"].ToString()))
{
con.Open();
MySqlCommand command = new MySqlCommand("SP_salidasmat", con);
command.CommandType = CommandType.StoredProcedure;
MySqlParameter paramId = new MySqlParameter("msj", MySqlDbType.Int32);
paramId.Direction = ParameterDirection.Output;
command.Parameters.Add(paramId);
command.Parameters.AddWithValue("nsis1", item.nsis);
command.Parameters.AddWithValue("nrec1", item.nrec);
command.Parameters.AddWithValue("fech1", item.fech);
command.Parameters.AddWithValue("cont1", item.cont);
command.Parameters.AddWithValue("mat1", item.mat);
command.Parameters.AddWithValue("occo1", item.opcd);
command.Parameters.AddWithValue("ccos1", item.ccos);
command.Parameters.AddWithValue("lug1", item.lug);
command.Parameters.AddWithValue("tpven1", item.tven);
command.Parameters.AddWithValue("cant1", item.cant);
command.Parameters.AddWithValue("equ1", item.equ);
command.Parameters.AddWithValue("ope1", item.ope);
command.Parameters.AddWithValue("rkm1", item.rkm);
command.Parameters.AddWithValue("volm1", item.volm);
command.Parameters.AddWithValue("cosm1", item.cosm);
command.Parameters.AddWithValue("flem1", item.flem);
command.Parameters.AddWithValue("tifkm1", item.tifkm);
command.Parameters.AddWithValue("timat1", item.timat);
command.Parameters.AddWithValue("anul1", item.anul);
command.Parameters.AddWithValue("matfle1", item.matfle);
command.Parameters.AddWithValue("ttra1", item.ttra);
command.Parameters.AddWithValue("ccost1", item.ccost);
command.Parameters.AddWithValue("occot1", item.opcdt);
command.Parameters.AddWithValue("prov1", item.prov);
command.Parameters.AddWithValue("hsal1", item.hfin);
command.Parameters.AddWithValue("flemt1", item.flemt);
command.Parameters.AddWithValue("tifkmt1", item.tifkmt);
command.Parameters.AddWithValue("timatt1", item.timatt);
command.Parameters.AddWithValue("usu", item.usu);
command.Parameters.AddWithValue("matflet1", item.matflet);
command.Parameters.AddWithValue("opc", op);
command.ExecuteNonQuery();
rowsAffected = int.Parse(command.Parameters["msj"].Value.ToString());
}
}
catch (MySqlException ex)
{
MessageBox.Show("Error de acceso a datos: " + ex.Message.ToString(), Application.ProductName.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex1)
{
MessageBox.Show("Error: " + ex1.Message.ToString(), Application.ProductName.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(rowsAffected);
}
