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