public UCUserInfo()
{
InitializeComponent();
Title = "客户管理";
Init("tmo_userinfo", "user_id");
btnSelcet.Click += btnSelcet_Click;
btnClear.Click += btnClear_Click;
ckBirthday.CheckedChanged += ckBirthday_CheckedChanged;
ckInputTime.CheckedChanged += ckInputTime_CheckedChanged;
btnQues.Click += btnQues_Click;
Columns = new[]
{
"tmo_userinfo.vip_type",
"tmo_userinfo.name",
"tmo_userinfo.user_id",
"tmo_userinfo.gender",
"tmo_userinfo.age",
"tmo_userinfo.identity",
"tmo_userinfo.birthday",
"tmo_userinfo.address",
"tmo_userinfo.phone",
"tmo_userinfo.tel",
"tmo_userinfo.retire",
"tmo_userinfo.source",
"tmo_userinfo.input_time",
"tmo_userinfo.doc_id",
"tmo_docinfo.doc_name"
}; //TODO 明确列加速查询
OrderByConditons.Add(new OrderByCondition("tmo_userinfo.update_time", true));
btnChangeDoc.Click += btnChangeDoc_Click;
doc_id.Click += doc_id_Click;
btnDevBind.Click += btnDevBind_Click;
btnPHR.Click += btnPHR_Click;
}
public UCFunction()
{
Title = "权限管理";
InitializeComponent();
Init("tmo_function", "func_id");
OrderByConditons.Add(new OrderByCondition("input_time"));
AllowPagePanel = false;
btnAdd.Visible = false;
TSCommon.SetTreeList(treeList1);
}
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 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;
}
