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