/*Заполняет таблицу исследований для пришедшего пациента*/ public void FillStudy(CStudy study) { conn.Open(); NpgsqlTransaction t = conn.BeginTransaction(); NpgsqlCommand comm = new NpgsqlCommand("\"FillStudy2\"", conn); NpgsqlParameter pid = new NpgsqlParameter("pid", NpgsqlTypes.NpgsqlDbType.Integer); NpgsqlParameter sid = new NpgsqlParameter("sid", NpgsqlTypes.NpgsqlDbType.Integer); NpgsqlParameter mod = new NpgsqlParameter("mod", NpgsqlTypes.NpgsqlDbType.Varchar); NpgsqlParameter is_hosp = new NpgsqlParameter("is_hosp", NpgsqlTypes.NpgsqlDbType.Varchar); NpgsqlParameter dep = new NpgsqlParameter("dep", NpgsqlTypes.NpgsqlDbType.Varchar); NpgsqlParameter body = new NpgsqlParameter("body", NpgsqlTypes.NpgsqlDbType.Varchar); NpgsqlParameter role = new NpgsqlParameter("role", NpgsqlTypes.NpgsqlDbType.Integer); NpgsqlParameter date = new NpgsqlParameter("date", NpgsqlTypes.NpgsqlDbType.Date); pid.Direction = ParameterDirection.Input; sid.Direction = ParameterDirection.Input; mod.Direction = ParameterDirection.Input; is_hosp.Direction = ParameterDirection.Input; dep.Direction = ParameterDirection.Input; body.Direction = ParameterDirection.Input; role.Direction = ParameterDirection.Input; date.Direction = ParameterDirection.Input; comm.Parameters.Add(pid); comm.Parameters.Add(sid); comm.Parameters.Add(mod); comm.Parameters.Add(is_hosp); comm.Parameters.Add(dep); comm.Parameters.Add(body); comm.Parameters.Add(role); comm.Parameters.Add(date); comm.Parameters[0].Value = study.pid; // first of all it must be in patient comm.Parameters[1].Value = study.sid; comm.Parameters[2].Value = study.modality; comm.Parameters[3].Value = study.is_hospital; comm.Parameters[4].Value = study.department; comm.Parameters[5].Value = study.body; comm.Parameters[6].Value = study.role_id; comm.Parameters[7].Value = study.study_date; comm.CommandType = CommandType.StoredProcedure; try { var result = comm.ExecuteScalar(); study.sid = (int)result; } finally { t.Commit(); conn.Close(); } }
public CStartForm() { InitializeComponent(); // system function tabed_window.SelectedTab = tabPage2; user = new User(); shadow = new CShadowService(); patient = new CPatient(); study = new CStudy(); protocol = new CProtocol(); patient.initials = new CInitials(); patient.birth_date = new CBirthDate(); shadow.win = new MakeaWindowPrm(); shadow.sql = new SQLDaemon(FileReader(path)); shadow.box = new CStateBox(); shadow.box.locker = new object(); }