public static SqlDataReader run_query(string query, sql_code.prms_p prms, ref SqlConnection conn ) { conn = get_conn(); SqlCommand cnt = new SqlCommand(); cnt.Connection = conn; cnt.CommandText = query; foreach (prm_p prm in prms.curs ) { cnt.Parameters.Add("@" + prm.pseudo, prm.type ); cnt.Parameters["@" + prm.pseudo].Value = prm.content; } SqlDataReader SDR = cnt.ExecuteReader(); return(SDR); }
public static component_p get(string name ) { string r = "select * from component where name = @name"; sql_code.prms_p prms = new sql_code.prms_p(); prms.enroll("name", name, System.Data.SqlDbType.VarChar ); SqlConnection conn = null; SqlDataReader SDR = sql_code.run_query(r, prms, ref conn ); component_p comp = null; if (SDR.Read() ) { comp = get(SDR); } SDR.Close(); conn.Close(); conn.Dispose(); return(comp); }
get(string cli, string pcode ) { cli = cli.ToUpper(); string r = "select * from cli " + " where " + "not (cli <> @cli or " + "pcode <> @pcode" + ")"; sql_code.prms_p prms = new sql_code.prms_p(); prms.enroll("cli", cli, System.Data.SqlDbType.VarChar ); prms.enroll("pcode", pcode, System.Data.SqlDbType.VarChar ); SqlConnection conn = null; SqlDataReader SDR = sql_code.run_query(r, prms, ref conn ); cli_p c = null; if (SDR.Read() ) { c = get(SDR); } SDR.Close(); SDR.Dispose(); conn.Close(); conn.Dispose(); return(c); }