public string GetAnalysesList(GmConnection conn) { StringBuilder sb = new StringBuilder(); GmCommand cmd = conn.CreateCommand( @"select RequestDate, Name from Analyses left join AnalysisTypes on AnalysisTypes.Id=AnalysisTypeId where PatientId=@Id"); cmd.AddInt("Id", id); using (DbDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { int i = 0; DateTime dt = dr.GetDateTime(i++); string name = dr.GetString(i++); if (sb.Length > 0) { sb.Append("; "); } sb.AppendFormat("{0:dd.MM} {1}", dt, name); } } if (sb.Length > 0) { sb.Append("."); } return(sb.ToString()); }
public void Load(Context context) { if (ranges != null) { throw new Exception("Ranges already loaded."); } GmCommand cmd = context.Conn.CreateCommandById("selectCountFromGisRangesWhereTypeId"); cmd.AddInt("TypeId", id); int count = (int)cmd.ExecuteScalar(); ranges = new List <GRange>(count); if (count > 0) { cmd = context.Conn.CreateCommandById("selectAllFromGisRangesWhereTypeId"); cmd.AddInt("TypeId", id); using (IDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { GRange range = new GRange(context, this, dr); } } } }
void LoadLib(Context context) { int[] indexerCode; GmCommand cmd = context.Conn.CreateCommandById("selectAllFromGisLibWhereId"); cmd.AddInt("Id", Constants.currentLib); using (IDataReader dr = cmd.ExecuteReader()) { if (!dr.Read()) { throw new GeoLibException("Lib record not found."); } attr = dr.GetInt32((int)LibField.Attr); name = dr.GetString((int)LibField.Name); // DZ 16.01.09 // context.SetStyle(dr.GetString((int)LibField.Style),ref styleStr,ref style); context.SetStyle(dr.IsDBNull((int)LibField.Style) ? "" : dr.GetString((int)LibField.Style), ref styleStr, ref style); // context.SetStyle(dr.GetString((int)LibField.DefaultStyle),ref defaultStyleStr,ref defaultStyle.style); context.SetStyle(dr.IsDBNull((int)LibField.DefaultStyle) ? "" : dr.GetString((int)LibField.DefaultStyle), ref defaultStyleStr, ref defaultStyle); smin = dr.GetInt32((int)LibField.SMin); smax = dr.GetInt32((int)LibField.SMax); bounds = context.Buf.GetRect(dr, (int)LibField.Code); indexerCode = context.Buf.GetIntArray(dr, (int)LibField.IndexerCode); scales.Values = context.Buf.GetIntArray(dr, (int)LibField.Scales); } if (scales.Count == 0) { scales.InitScales(); } id = Constants.currentLib; indexer = new Indexer(indexerCode); }
public static string GetTreatment(GmConnection conn, int patientId) { /* string cmdText = @"select Medicaments.Name from Prescriptions * left join StoreProducts on StoreProducts.Id=StoreProductId * left join Products on Products.Id=ProductId * left join Medicaments on Medicaments.Id=MedicamentId * where PatientId=@PatientId";*/ string cmdText = @"select MedicamentGroups.Name from Prescriptions left join StoreProducts on StoreProducts.Id=StoreProductId left join Products on Products.Id=ProductId left join MedicamentGroupTies on MedicamentGroupTies.MedicamentId=Products.MedicamentId left join MedicamentGroups on MedicamentGroups.Id=MedicamentGroupId where PatientId=@PatientId"; GmCommand cmd = conn.CreateCommand(cmdText); cmd.AddInt("PatientId", patientId); List <string> list = new List <string>(); using (DbDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { string s = dr.GetString(0); if (!list.Contains(s)) { list.Add(s); } } } list.Sort(); return(Geomethod.CollectionUtils.GetCommaSeparatedList <string>(list)); }
public void Load(Context context) { if (objects != null) { return; } lock (this) { if (objects != null) { return; } GmCommand cmd = context.Conn.CreateCommandById("selectCountFromGisObjectsWhereRangeId"); cmd.AddInt("RangeId", id); int count = (int)cmd.ExecuteScalar(); objects = new List <GObject>(count); if (count > 0) { cmd = context.Conn.CreateCommandById("selectAllFromGisObjectsWhereRangeId"); cmd.AddInt("RangeId", id); using (IDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { GObject.Create(context, this, dr, true); } } } } }
protected void Page_Load(object sender, EventArgs e) { log = MainMasterPage.InitPage(this); int forumTopicId = RequestUtils.GetForumTopicId(this); this.SqlDataSource1.SelectParameters["ForumTopicId"].DefaultValue = forumTopicId.ToString(); try { string cmdText = "SELECT Forums.Id AS ForumId, Forums.Name AS ForumName, ForumTopics.Name AS ForumTopicName FROM Forums INNER JOIN ForumTopics ON Forums.Id = ForumTopics.ForumId WHERE (ForumTopics.Id = @ForumTopicId)"; using (GmConnection conn = Global.CreateConnection()) { GmCommand cmd = conn.CreateCommand(cmdText); cmd.AddInt("ForumTopicId", forumTopicId); using (GmDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { forumId = dr.GetInt(); forumName = dr.GetString(); forumTopicName = dr.GetString(); } else { return; } } } } catch (Exception ex) { log.Exception(ex); } }
public bool IsMultyLoginDenied() { bool denied = false; if (UserId != 0) { using (GmConnection conn = App.ConnectionFactory.CreateConnection()) { GmCommand cmd = conn.CreateCommand("select MultiLoginFlag, lastupdate, GETDATE() from [User] where UserCode=@UserCode"); cmd.AddInt("UserCode", UserId); using (IDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { int i = 0; bool multiLoginFlag = dr.GetBoolean(i++); if (multiLoginFlag) { DateTime lastUpdate = dr.GetDateTime(i++); DateTime curTime = dr.GetDateTime(i++); TimeSpan ts = curTime - lastUpdate; denied = ts.TotalMilliseconds < this.config.PollTime * 2; //+config.CommandTimeout*1000 } } } } } return(denied); }
public static List <Analysis> GetAnalyses(GmConnection conn, int patientId) { List <Analysis> list = new List <Analysis>(); GmCommand cmd = conn.CreateCommand("select * from Analyses where PatientId=@PatientId"); cmd.AddInt("PatientId", patientId); using (DbDataReader dr = cmd.ExecuteReader()) { list.Add(new Analysis(dr)); } return(list); }
public static void GetPrescriptionTypes(GmConnection conn, List <PrescriptionType> list) { GmCommand cmd = conn.CreateCommand("select * from PrescriptionTypes"); using (DbDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { list.Add(new PrescriptionType(dr)); } } }
public static void GetRoles(GmConnection conn, Dictionary <int, Role> roles) { GmCommand cmd = conn.CreateCommand("select * from Roles"); using (DbDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { Role role = new Role(dr); roles.Add(role.id, role); } } }
public static ConfigRecord GetLastConfigRecord(GmConnection conn) { GmCommand cmd = conn.CreateCommand("select top 1 * from ConfigRecords order by Id desc"); using (DbDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { return(new ConfigRecord(dr)); } } return(null); }
public static void GetUsers(GmConnection conn, Dictionary <int, User> users) { GmCommand cmd = conn.CreateCommand("select * from Users"); using (DbDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { User user = new User(dr); users.Add(user.Id, user); } } }
public string GetInsuranceCompanyName(GmConnection conn) { GmCommand cmd = conn.CreateCommand("select Name from InsuranceCompanies where Id=@Id"); cmd.AddInt("Id", insuranceCompanyId); using (DbDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { return(dr.GetString(0)); } } return(""); }
public static User GetUser(GmConnection conn, string login) { GmCommand cmd = conn.CreateCommand("select * from Users where Login=@Login"); cmd.AddString("Login", login); using (DbDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { return(new User(dr)); } } return(null); }
public static Article GetArticle(GmConnection conn, string tag) { GmCommand cmd = conn.CreateCommand("select * from Articles where Tag=@Tag"); cmd.AddString("Tag", tag); using (GmDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { return(new Article(dr)); } } return(null); }
public static Watching GetLastTakingWatching(GmConnection conn, int userId) { GmCommand cmd = conn.CreateCommand("select top 1 * from Watching where UserId=@UserId and EndTime is null"); cmd.AddInt("UserId", userId); using (DbDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { return(new Watching(dr)); } } return(null); }
public static Employee GetEmployee(GmConnection conn, int id) { GmCommand cmd = conn.CreateCommand("select * from Employees where Id=@Id"); cmd.AddInt("Id", id); using (DbDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { return(new Employee(dr)); } } return(null); }
public static void GetArticleParams(GmConnection conn, int articleId, System.Collections.Specialized.StringDictionary sd) { GmCommand cmd = conn.CreateCommand("select [Key], [Value] from ArticleParams where ArticleId=@ArticleId"); cmd.AddInt("ArticleId", articleId); using (GmDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { var key = dr.GetString(); var val = dr.GetString(); sd[key] = val; } } }
public static Employee GetEmployee(GmConnection conn, string login, string password) { GmCommand cmd = conn.CreateCommand("select * from Employees where Login=@Login and Password=@Password"); cmd.AddString("Login", login); cmd.AddString("Password", password); using (DbDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { return(new Employee(dr)); } } return(null); }
public static int GetDiagnoses(GmConnection conn, Dictionary <int, Diagnosis> diagnoses) { GmCommand cmd = conn.CreateCommand("select * from Diagnoses"); // cmd.AddInt("Id", id); using (DbDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { Diagnosis diagnosis = new Diagnosis(dr); diagnoses.Add(diagnosis.Id, diagnosis); } } return(diagnoses.Count); }
public static int GetMedicaments(GmConnection conn, List <Medicament> medicaments) { GmCommand cmd = conn.CreateCommand("select * from Medicaments"); int count = 0; using (DbDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { Medicament med = new Medicament(dr); medicaments.Add(med); count++; } } return(count); }
public static PrescriptionType GetPrescriptionType(GmConnection conn, int id) { if (id == 0) { return(null); } GmCommand cmd = conn.CreateCommand("select * from PrescriptionTypes where Id=@Id"); cmd.AddInt("Id", id); using (DbDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { return(new PrescriptionType(dr)); } } return(null); }
public static LinkExchangePage GetLinkExchangePage(GmConnection conn, int id) { if (id == 0) { return(null); } GmCommand cmd = conn.CreateCommand("select * from LinkExchange where Id=@Id"); cmd.AddInt("Id", id); using (DbDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { return(new LinkExchangePage(dr)); } } return(null); }
public static Medicament GetMedicament(GmConnection conn, int id) { if (id == 0) { return(null); } GmCommand cmd = conn.CreateCommand("select * from Medicaments where Id=@Id"); cmd.AddInt("Id", id); using (DbDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { return(new Medicament(dr)); } } return(null); }
public static Candidate GetCandidate(GmConnection conn, int id) { if (id == 0) { return(null); } GmCommand cmd = conn.CreateCommand("select * from Candidates where Id=@Id"); cmd.AddInt("Id", id); using (GmDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { return(new Candidate(dr)); } } return(null); }
public static ExpertBoard GetExpertBoard(GmConnection conn, int id) { if (id == 0) { return(null); } GmCommand cmd = conn.CreateCommand("select * from ExpertBoards where Id=@Id"); cmd.AddInt("Id", id); using (DbDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { return(new ExpertBoard(dr)); } } return(null); }
public static Gallery GetGallery(GmConnection conn, int id) { if (id == 0) { return(null); } GmCommand cmd = conn.CreateCommand("select * from Galleries where Id=@Id"); cmd.AddInt("Id", id); using (DbDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { return(new Gallery(dr)); } } return(null); }
public static UserInfo GetUserInfo(GmConnection conn, int id) { if (id == 0) { return(null); } GmCommand cmd = conn.CreateCommand("select * from UserInfo where Id=@Id"); cmd.AddInt("Id", id); using (DbDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { return(new UserInfo(dr)); } } return(null); }
// public int Age { get { return birthday != DateTime.MinValue ? DateTimeUtils.Age(birthday) : -1; } } #region Construction public static PatientIdentification GetPatientIdentification(GmConnection conn, int id) { if (id == 0) { return(null); } GmCommand cmd = conn.CreateCommand("select * from PatientIdentifications where Id=@Id"); cmd.AddInt("Id", id); using (DbDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { return(new PatientIdentification(dr)); } } return(null); }
public static ArticleParam GetArticleParam(GmConnection conn, int id) { if (id == 0) { return(null); } GmCommand cmd = conn.CreateCommand("select * from ArticleParams where Id=@Id"); cmd.AddInt("Id", id); using (GmDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { return(new ArticleParam(dr)); } } return(null); }