public void purge() { string r = "delete from img_stg where " + "ID = @ID"; sql_code.prms_p prms = new mvc.business.sql_code.prms_p(); prms.enroll("ID", ID, System.Data.SqlDbType.VarChar ); sql_code.run_non_query(r, prms ); }
public static img_stg_p get(string ID ) { string r = "select * from img_stg " + " where " + "ID = @ID"; sql_code.prms_p prms = new mvc.business.sql_code.prms_p(); prms.enroll("ID", ID, System.Data.SqlDbType.VarChar ); SqlConnection conn = null; SqlDataReader SDR = sql_code.run_query(r, prms, ref conn ); img_stg_p ims = null; if (SDR.Read() ) { ims = get(SDR); } SDR.Close(); SDR.Dispose(); conn.Close(); conn.Dispose(); return(ims); }