/* последовательная версия*/ public void UpdateProtocol(CProtocol protocol, DateTime date) { conn.Open(); NpgsqlTransaction t = conn.BeginTransaction(); NpgsqlCommand comm = new NpgsqlCommand("\"UpdateProtocol\"", conn); NpgsqlParameter pid = new NpgsqlParameter("pid", NpgsqlTypes.NpgsqlDbType.Integer); NpgsqlParameter dat = new NpgsqlParameter("dat", NpgsqlTypes.NpgsqlDbType.Date); NpgsqlParameter text = new NpgsqlParameter("text", NpgsqlTypes.NpgsqlDbType.Varchar); pid.Direction = ParameterDirection.Input; dat.Direction = ParameterDirection.Input; text.Direction = ParameterDirection.Input; comm.Parameters.Add(pid); comm.Parameters.Add(dat); comm.Parameters.Add(text); comm.Parameters[0].Value = protocol.sid; comm.Parameters[1].Value = date.Date; comm.Parameters[2].Value = protocol.text; comm.CommandType = CommandType.StoredProcedure; try { var result = comm.ExecuteScalar(); //protocol.text = (string)result; } finally { t.Commit(); conn.Close(); } return; // ??? }
public void FillProtocol(CProtocol protocol) { conn.Open(); NpgsqlTransaction t = conn.BeginTransaction(); NpgsqlCommand comm = new NpgsqlCommand("\"FillProtocol\"", conn); NpgsqlParameter prid = new NpgsqlParameter("prid", NpgsqlTypes.NpgsqlDbType.Integer); NpgsqlParameter sid = new NpgsqlParameter("sid", NpgsqlTypes.NpgsqlDbType.Integer); // NpgsqlParameter txt = new NpgsqlParameter("txt", NpgsqlTypes.NpgsqlDbType.Text); prid.Direction = ParameterDirection.Input; sid.Direction = ParameterDirection.Input; //txt.Direction = ParameterDirection.Input; comm.Parameters.Add(prid); comm.Parameters.Add(sid); // comm.Parameters.Add(txt); comm.Parameters[0].Value = protocol.prid; comm.Parameters[1].Value = protocol.sid; comm.CommandType = CommandType.StoredProcedure; try { var result = comm.ExecuteScalar(); protocol.prid = (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(); }