public List <SqlParameter> SetParametersAddOrdenDetails(Roll_Details datos)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@p1", SqlDbType = SqlDbType.NVarChar, Value = datos.Numero_Orden
},
new SqlParameter()
{
ParameterName = "@p2", SqlDbType = SqlDbType.NVarChar, Value = datos.Product_id
},
new SqlParameter()
{
ParameterName = "@p3", SqlDbType = SqlDbType.NVarChar, Value = datos.Product_name
},
new SqlParameter()
{
ParameterName = "@p4", SqlDbType = SqlDbType.NVarChar, Value = datos.Roll_number
},
new SqlParameter()
{
ParameterName = "@p5", SqlDbType = SqlDbType.NVarChar, Value = datos.Unique_code
},
new SqlParameter()
{
ParameterName = "@p6", SqlDbType = SqlDbType.Int, Value = datos.Splice
},
new SqlParameter()
{
ParameterName = "@p7", SqlDbType = SqlDbType.Decimal, Value = datos.Width
},
new SqlParameter()
{
ParameterName = "@p8", SqlDbType = SqlDbType.Decimal, Value = datos.Large
},
new SqlParameter()
{
ParameterName = "@p9", SqlDbType = SqlDbType.Decimal, Value = datos.Msi
},
new SqlParameter()
{
ParameterName = "@p10", SqlDbType = SqlDbType.NVarChar, Value = datos.Roll_id
},
new SqlParameter()
{
ParameterName = "@p11", SqlDbType = SqlDbType.NVarChar, Value = datos.Code_Person
},
new SqlParameter()
{
ParameterName = "@p12", SqlDbType = SqlDbType.NVarChar, Value = datos.Status
},
new SqlParameter()
{
ParameterName = "@p13", SqlDbType = SqlDbType.Bit, Value = datos.Disponible
}
};
return(sp);
}
public List <Roll_Details> GetDataUniqueCode(string conduce)
{
List <Roll_Details> lista = new List <Roll_Details>();
try
{
Micomm.Conectar(R.SQL.DATABASE.NAME);
SqlCommand comando = new SqlCommand
{
Connection = Micomm.cnn,
CommandType = CommandType.Text,
CommandText = R.SQL.QUERY_SQL.DESPACHOS.SQL_SELECT_UNIQUECODE_DETAILS_DESPACHO
};
SqlParameter p1 = new SqlParameter("@p1", conduce);
comando.Parameters.Add(p1);
SqlDataReader reader = comando.ExecuteReader();
while (reader.Read())
{
Roll_Details rollo = new Roll_Details
{
Product_id = reader.GetString(0),
Product_name = reader.GetString(1),
Roll_number = reader.GetInt32(2).ToString(),
Width = reader.GetDecimal(3),
Large = reader.GetDecimal(4),
Msi = reader.GetDecimal(5),
Splice = reader.GetInt32(6),
Roll_id = reader.GetString(7),
Code_Person = "",
Status = "",
Unique_code = reader.GetString(8)
};
lista.Add(rollo);
}
comando.Dispose();
Micomm.Desconectar();
return(lista);
}
catch (SqlException ex)
{
MessageBox.Show("error al tratar de leer los RC en el detalle del conduce (DESPACHO)..." + ex);
return(lista);
}
}
public List <SqlParameter> SetParametersAddRCDespacho(Roll_Details datos, string numero)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@p1", SqlDbType = SqlDbType.NVarChar, Value = numero
},
new SqlParameter()
{
ParameterName = "@p2", SqlDbType = SqlDbType.NVarChar, Value = datos.Unique_code
},
new SqlParameter()
{
ParameterName = "@p3", SqlDbType = SqlDbType.NVarChar, Value = datos.Product_id
},
new SqlParameter()
{
ParameterName = "@p4", SqlDbType = SqlDbType.Decimal, Value = datos.Width
},
new SqlParameter()
{
ParameterName = "@p5", SqlDbType = SqlDbType.Decimal, Value = datos.Large
},
new SqlParameter()
{
ParameterName = "@p6", SqlDbType = SqlDbType.Decimal, Value = datos.Msi
},
new SqlParameter()
{
ParameterName = "@p7", SqlDbType = SqlDbType.NVarChar, Value = datos.Roll_number
},
new SqlParameter()
{
ParameterName = "@p8", SqlDbType = SqlDbType.NVarChar, Value = datos.Roll_id
},
new SqlParameter()
{
ParameterName = "@p9", SqlDbType = SqlDbType.Int, Value = datos.Splice
}
};
return(sp);
}
public Roll_Details GetDataUniqueCode(string rc)
{
Roll_Details rollo = new Roll_Details();
try
{
Micomm.Conectar(R.SQL.DATABASE.NAME);
SqlCommand comando = new SqlCommand
{
Connection = Micomm.cnn,
CommandType = CommandType.Text,
CommandText = R.SQL.QUERY_SQL.PRODUCCION.SQL_QUERY_SELECT_GETDATA_UNIQUE_CODE
};
SqlParameter p1 = new SqlParameter("@p1", rc);
comando.Parameters.Add(p1);
SqlDataReader reader = comando.ExecuteReader();
while (reader.Read())
{
rollo.Product_id = reader.GetString(1);
rollo.Product_name = reader.GetString(2);
rollo.Roll_number = reader.GetInt32(3).ToString();
rollo.Width = reader.GetDecimal(4);
rollo.Large = reader.GetDecimal(5);
rollo.Msi = reader.GetDecimal(6);
rollo.Splice = reader.GetInt32(7);
rollo.Roll_id = reader.GetString(8);
rollo.Code_Person = reader.GetString(9);
rollo.Status = reader.GetString(10);
rollo.Unique_code = reader.GetString(11);
rollo.Tipo_mov = reader.GetString(12);
}
comando.Dispose();
Micomm.Desconectar();
return(rollo);
}
catch (SqlException ex)
{
MessageBox.Show("error al tratar de leer la data de un codigo unico..." + ex);
return(rollo);
}
}
