protected override void BeforeGetData() { JoinConditions.Clear(); JoinConditions.Add(new JoinCondition { JoinType = EmJoinType.LeftJoin, Table = "tmo_docinfo", OnCol = "doc_id" }); if (bindDev.EditValue != null) { JoinConditions.Add(new JoinCondition { JoinType = EmJoinType.RightJoin, Table = $"(select dev_userid from tmo_monitor_devicebind where dev_type={bindDev.EditValue} GROUP BY dev_userid)", TableAsName = "b", OnCol = "dev_userid", MainTable = "tmo_userinfo", MainCol = "user_id" }); } else { JoinConditions.Add(new JoinCondition { JoinType = EmJoinType.LeftJoin, Table = "(select dev_userid from tmo_monitor_devicebind GROUP BY dev_userid)", TableAsName = "b", OnCol = "dev_userid", MainTable = "tmo_userinfo", MainCol = "user_id" }); } FixWhere = $"(tmo_userinfo.doc_id in ({TmoComm.login_docInfo.children_docid}) or tmo_userinfo.doc_id is null)"; }
/// <summary> /// This method is used to load the exam data in the table. /// </summary> private void LoadData() { var conditions = new JoinConditions { LogicalOperator = LogicalOperators.AND, Conditions = new List <Condition> { new Condition { BaseTable = DatabaseTable.Subject, JoinTable = DatabaseTable.Topic, JoinTableColumnName = TableColumns.TOPIC_PARENT_SUBJECT } } }; var data = viewModelDataService.GetRecords(DatabaseTable.Topic, conditions); // Convert datatable data to a list, sort it by name. List <TopicSubjectViewModel> modelData = (from DataRow row in data.Rows select new TopicSubjectViewModel { Id = Convert.ToInt32(row[TableColumns.COMMON_ID]), SubjectName = row[TableColumns.SUBJECT_SUBJECT_NAME].ToString(), TopicName = row[TableColumns.TOPIC_TOPIC_NAME].ToString() }) .ToList(); modelData = modelData.OrderBy(x => x.SubjectName).ThenBy(x => x.TopicName).ToList(); dgvTopicDetails.AutoGenerateColumns = false; dgvTopicDetails.DataSource = modelData; }
/// <summary> /// This method is used to create condition object for joining. /// </summary> /// <param name="defaultLoad">Grid loading state.</param> /// <returns>Returns Join Condition object.</returns> private JoinConditions CreateCondition(bool defaultLoad) { var conditions = new JoinConditions { LogicalOperator = LogicalOperators.AND, Conditions = new List <Condition> { new Condition { BaseTable = DatabaseTable.Exam, JoinTable = DatabaseTable.Relationship, JoinTableColumnName = TableColumns.EXAM_RELATION_EXAM_ID }, new Condition { BaseTable = DatabaseTable.Topic, JoinTable = DatabaseTable.Relationship, JoinTableColumnName = TableColumns.EXAM_RELATION_TOPIC_ID }, new Condition { BaseTable = DatabaseTable.Subject, JoinTable = DatabaseTable.Topic, JoinTableColumnName = TableColumns.TOPIC_PARENT_SUBJECT } } }; // Check if a search condition is specified. if (!defaultLoad) { conditions.Search = new List <SearchCondition>(); if (cbExamList.SelectedIndex > 0) { conditions.Search.Add(new SearchCondition { BaseTable = DatabaseTable.Exam, Column = TableColumns.COMMON_ID, Value = Convert.ToInt32(cbExamList.SelectedValue) }); } if (cbSubjectList.SelectedIndex > 0) { conditions.Search.Add(new SearchCondition { BaseTable = DatabaseTable.Subject, Column = TableColumns.COMMON_ID, Value = Convert.ToInt32(cbSubjectList.SelectedValue) }); } } return(conditions); }
public UCQuestionSave() { Title = "指标分析"; InitializeComponent(); BrowseMode = true; TableName = "tmo_question_save"; Columns = new[] { "tmo_question_save.*", "u.gender", "u.age", "u.name" }; JoinConditions.Add(new JoinCondition() { JoinType = EmJoinType.LeftJoin, MainCol = "user_id", OnCol = "user_id", Table = "tmo_userinfo", TableAsName = "u" }); OrderByConditons.Add(new OrderByCondition("tmo_question_save.questionnaire_time", true)); btnSelcet.Click += btnSelcet_Click; btnClear.Click += btnClear_Click; }
public UCActionPlanInfo() { Title = "健康行动计划"; InitializeComponent(); TableName = "tmo_userstatus"; Columns = new[] { "tmo_userstatus.user_id", "tmo_userstatus.usertimes as user_times", "tmo_userstatus.questionnare_status", "'' as actionplan", "tmo_userinfo.name", "tmo_userinfo.gender", "tmo_userinfo.age", "tmo_userinfo.birthday", "tmo_userinfo.input_time", "tmo_docinfo.doc_name", "tmo_extend_service.pay_money", "tmo_extend_service.pay_time", "tmo_actionplan.apid", "tmo_actionplan.apstartdate", "tmo_actionplan.apenddate", "'' as acstate", "tmo_actionplanlib.aclb_title" }; FixWhere = "tmo_userstatus.questionnare_status>=3 and tmo_userinfo.is_del!=1 and (tmo_userinfo.doc_id is null or tmo_userinfo.doc_id in (" + TmoComm.login_docInfo.children_docid + "))"; JoinConditions.Add(new JoinCondition() { JoinType = EmJoinType.LeftJoin, MainCol = "user_id", MainTable = "tmo_userstatus", OnCol = "user_id", Table = "tmo_userinfo" }); JoinConditions.Add(new JoinCondition() { JoinType = EmJoinType.LeftJoin, MainCol = "doc_id", MainTable = "tmo_userinfo", OnCol = "doc_id", Table = "tmo_docinfo" }); JoinConditions.Add(new JoinCondition() { JoinType = EmJoinType.LeftJoin, MainCol = "id", MainTable = "tmo_userstatus", OnCol = "id", Table = "tmo_extend_service" }); JoinConditions.Add(new JoinCondition() { JoinType = EmJoinType.LeftJoin, MainCol = "user_id and tmo_actionplan.usertimes=tmo_userstatus.usertimes", MainTable = "tmo_userstatus", OnCol = "userid", Table = "tmo_actionplan" }); JoinConditions.Add(new JoinCondition() { JoinType = EmJoinType.LeftJoin, MainCol = "aplib", MainTable = "tmo_actionplan", OnCol = "aclb_id", Table = "tmo_actionplanlib" }); OrderByConditons.Add(new OrderByCondition() { Col = "tmo_extend_service.pay_time", IsDesc = true }); HasEdit = false; HasDel = false; btnSelcet.Click += btnSelcet_Click; btnClear.Click += btnClear_Click; acStartTimeMin.Enabled = acStartTimeMax.Enabled = acEndTimeMin.Enabled = acEndTimeMax.Enabled = false; ckStartTime.CheckedChanged += (s, e) => { acStartTimeMin.Enabled = acStartTimeMax.Enabled = ckStartTime.Checked; }; ckEndTime.CheckedChanged += (s, e) => { acEndTimeMin.Enabled = acEndTimeMax.Enabled = ckEndTime.Checked; }; doc_id.Click += doc_id_Click; }
public UCInterveneLibInfo() { Title = "健康干预库"; InitializeComponent(); //ChooseMode = true; btnUse.Click += BtnUse_Click; AllowPagePanel = false; Init("tmo_intervenelib", "intelb_id"); Columns = new string[] { "tmo_intervenelibtype.type_name", "tmo_intervenelib.*" }; JoinConditions.Add(new JoinCondition { JoinType = EmJoinType.LeftJoin, MainCol = "intelb_type", Table = "tmo_intervenelibtype", OnCol = "type_id" }); }
public UCActionPlanLibInfo() { Title = "健康计划库"; InitializeComponent(); btnUse.Click += BtnUse_Click; AllowPagePanel = false; HasEdit = false; Init("tmo_actionplanlib", "aclb_id"); Columns = new string[] { "tmo_actionplanlibtype.type_name", "tmo_actionplanlib.aclb_id", "tmo_actionplanlib.aclb_title", "tmo_actionplanlib.aclb_content", "tmo_actionplanlib.aclb_base64Ext" }; JoinConditions.Add(new JoinCondition { JoinType = EmJoinType.LeftJoin, MainCol = "aclb_type", Table = "tmo_actionplanlibtype", OnCol = "type_id" }); }
public UCIntervene() { Title = "健康干预"; InitializeComponent(); Init("tmo_intervene", "inte_id"); Columns = new[] { "tmo_userinfo.name", "tmo_userinfo.gender", "tmo_userinfo.age", "tmo_docinfo.doc_name", "tmo_intervene.*" }; JoinConditions.Add(new JoinCondition() { JoinType = EmJoinType.LeftJoin, Table = "tmo_userinfo", OnCol = "user_id" }); JoinConditions.Add(new JoinCondition() { JoinType = EmJoinType.LeftJoin, Table = "tmo_docinfo", OnCol = "doc_id", MainTable = "tmo_intervene" }); OrderByConditons.Add(new OrderByCondition("tmo_intervene.input_time", true)); ckInputTime.CheckedChanged += CkInputTime_CheckedChanged; ckPlanTime.CheckedChanged += CkPlanTime_CheckedChanged; btnSelcet.Click += BtnSelcet_Click; btnClear.Click += btnClear_Click; doc_id.Click += doc_id_Click; }