//METODO BUSCAR public DataTable Buscar(DacfMATt_Material acfMATt_Material) { DataTable DtResultado = new DataTable("acfMATt_Material"); SqlConnection SqlCon = new SqlConnection(); try { SqlCon.ConnectionString = DConexion.CnBDActivo; SqlCommand SqlCmd = new SqlCommand(); SqlCmd.Connection = SqlCon; SqlCmd.CommandText = "usp_B_acfMATt_Material"; SqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter ParMATmaterial = new SqlParameter(); ParMATmaterial.ParameterName = "@sMATmaterial"; ParMATmaterial.SqlDbType = SqlDbType.VarChar; ParMATmaterial.Size = 50; ParMATmaterial.Value = acfMATt_Material.MATmaterial; SqlCmd.Parameters.Add(ParMATmaterial); SqlDataAdapter SqlDat = new SqlDataAdapter(SqlCmd); SqlDat.Fill(DtResultado); } catch (Exception ex) { DtResultado = null; } return(DtResultado); }
//METODO EDITAR public string Editar(DacfMATt_Material acfMATt_Material) { string rpta = ""; SqlConnection SqlCon = new SqlConnection(); try { //Código SqlCon.ConnectionString = DConexion.CnBDActivo; SqlCon.Open(); //Establecer el Comando SqlCommand SqlCmd = new SqlCommand(); SqlCmd.Connection = SqlCon; SqlCmd.CommandText = "usp_U_acfMATt_Material"; SqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter ParMATid = new SqlParameter(); ParMATid.ParameterName = "@iMATid"; ParMATid.SqlDbType = SqlDbType.Int; ParMATid.Value = acfMATt_Material.MATid; SqlCmd.Parameters.Add(ParMATid); // SqlParameter ParMATmaterial = new SqlParameter(); ParMATmaterial.ParameterName = "@sMATmaterial"; ParMATmaterial.SqlDbType = SqlDbType.VarChar; ParMATmaterial.Value = acfMATt_Material.MATmaterial; SqlCmd.Parameters.Add(ParMATmaterial); // SqlParameter ParMATabreviado = new SqlParameter(); ParMATabreviado.ParameterName = "@sMATabreviado"; ParMATabreviado.SqlDbType = SqlDbType.Char; ParMATabreviado.Value = acfMATt_Material.MATabreviado; SqlCmd.Parameters.Add(ParMATabreviado); // //Ejecutamos nuestro comando rpta = SqlCmd.ExecuteNonQuery() != 0 ? "OK" : "NO se Actualizo el Registro"; } catch (Exception ex) { rpta = ex.Message; } finally { if (SqlCon.State == ConnectionState.Open) { SqlCon.Close(); } } return(rpta); }