public static void BindCombox(ComboBox cb) { StudentSystemConfig config = StaticCacheManager.GetConfig <StudentSystemConfig>(); string[] array = subjects2; if (config.SubjectIs4) { array = subjects1; } foreach (string str in array) { cb.Items.Add(str); } }
public InitButtonPanel() { InitializeComponent(); StudentSystemConfig config = StaticCacheManager.GetConfig <StudentSystemConfig>(); if (config.SubjectIs4) { this.btnSubject2.Visible = false; this.btnSubject20.Visible = true; this.btnSubject21.Visible = true; this.btnSubject20.Click += new EventHandler(StudentHelper.subject20_Click); this.btnSubject21.Click += new EventHandler(StudentHelper.subject21_Click); } else { this.btnSubject2.Visible = true; this.btnSubject2.Click += new EventHandler(StudentHelper.subject2_Click); this.btnSubject20.Visible = false; this.btnSubject21.Visible = false; } this.btnSubject1.Click += new EventHandler(StudentHelper.subject1_Click); this.btnSubject3.Click += new EventHandler(StudentHelper.subject3_Click); this.btnChangePwd.Click += new EventHandler(btnChangePwd_Click); this.btnExitSystem.Click += new EventHandler(btnExitSystem_Click); this.btnLockSystem.Click += new EventHandler(btnLockSystem_Click); this.btnReg.Click += new EventHandler(btnReg_Click); this.btnPhoto.Click += new EventHandler(btnPhoto_Click); this.btnUpdate.Click += new EventHandler(btnUpdate_Click); this.btnFee.Click += new EventHandler(btnFee_Click); this.btnApplyF6.Click += new EventHandler(StudentHelper.F6_Click); this.btnApplyF7.Click += new EventHandler(StudentHelper.F7_Click); this.btnExamHint.Click += new EventHandler(btnExamHint_Click); this.btnPrintF2.Click += new EventHandler(StudentHelper.F2_Click); this.btnPrintF3.Click += new EventHandler(StudentHelper.F3_Click); this.btnPrintF4.Click += new EventHandler(StudentHelper.F4_Click); this.btnPrintF5.Click += new EventHandler(StudentHelper.F5_Click); }
private void cbSubject_TextChanged(object sender, EventArgs e) { string subject = this.cbSubject.Text.Trim(); if (subject.Length > 0) { StudentSystemConfig config = StaticCacheManager.GetConfig <StudentSystemConfig>(); string sqlformat = "SELECT a.c_hmhp, b.c_name, b.c_sex, b.c_idcard, b.c_examid,b.c_state,b.date_lastexam FROM table_students AS b LEFT JOIN table_coach AS a ON b.i_coachid=a.id WHERE b.c_state = '{0}' And {1}"; string sql = string.Empty; IDataAccess access = FT.DAL.DataAccessFactory.GetDataAccess(); string tmp1 = string.Empty; string tmp2 = string.Empty; string tmp3 = string.Empty; string tmp4 = string.Empty; string tmp = string.Empty; if (subject.StartsWith("科目一")) { tmp1 = "初始报名"; tmp2 = access.LowerEqualDateString("b.date_baoming", System.DateTime.Now.AddDays(0 - config.RegToSubject1)); tmp3 = "科目一不合格"; tmp4 = access.LowerEqualDateString("b.date_lastexam", System.DateTime.Now.AddDays(0 - config.Subject1ReExam)); } else if (subject.StartsWith("科目二")) { if (!config.SubjectIs4) { tmp1 = "科目一合格"; tmp2 = access.LowerEqualDateString("b.date_lastexam", System.DateTime.Now.AddDays(0 - config.Subject1To20Days)); tmp3 = "科目二不合格"; tmp4 = access.LowerEqualDateString("b.date_lastexam", System.DateTime.Now.AddDays(0 - config.Subject20ReExam)); } else if (subject.IndexOf("桩") != -1) { tmp1 = "科目一合格"; tmp2 = access.LowerEqualDateString("b.date_lastexam", System.DateTime.Now.AddDays(0 - config.Subject1To20Days)); tmp3 = "科目二(桩)不合格"; tmp4 = access.LowerEqualDateString("b.date_lastexam", System.DateTime.Now.AddDays(0 - config.Subject20ReExam)); } else//场内 { tmp1 = "科目二(桩)合格"; tmp2 = access.LowerEqualDateString("b.date_lastexam", System.DateTime.Now.AddDays(0 - config.Subject20To21Days)); tmp3 = "科目二(场地)不合格"; tmp4 = access.LowerEqualDateString("b.date_lastexam", System.DateTime.Now.AddDays(0 - config.Subject21ReExam)); } } else { if (!config.SubjectIs4) { tmp = "科目二"; } else { tmp = "科目二(场地)"; } tmp1 = tmp + "合格"; tmp2 = access.LowerEqualDateString("b.date_lastexam", System.DateTime.Now.AddDays(0 - config.Subject21To3Days)); tmp3 = "科目三不合格"; tmp4 = access.LowerEqualDateString("b.date_lastexam", System.DateTime.Now.AddDays(0 - config.Subject3ReExam)); } sql = string.Format(sqlformat, new string[] { tmp1, tmp2 }); Console.WriteLine(sql); DataTable dt = access.SelectDataTable(sql, "test"); sql = string.Format(sqlformat, new string[] { tmp3, tmp4 }); Console.WriteLine(sql); DataTable dt2 = access.SelectDataTable(sql, "test"); if (dt != null && dt2 != null) { dt.Merge(dt2); } if (dt != null && dt.Rows.Count > 0) { this.dataGridView1.Rows.Clear(); foreach (DataRow dr in dt.Rows) { this.dataGridView1.Rows.Add(new object[] { dr[0], dr[1], dr[2], dr[3], dr[4], dr[5], dr[6] }); } this.lbCount.Text = "共" + dt.Rows.Count + "条记录"; } else { this.dataGridView1.Rows.Clear(); this.lbCount.Text = "共0条记录"; } } }
public override void EmmitMenu() { ToolStripMenuItem top = this.AddToMenu("驾驶人预录入(&S)"); ToolStripMenuItem tmp = this.BuildSubMenu("初始报名", typeof(StudentBrowser)); top.DropDownItems.Add(tmp); tmp = this.BuildSubMenu("照片采集", typeof(DriverPicCapture)); top.DropDownItems.Add(tmp); tmp = this.BuildSubMenu("学员缴费", typeof(StudentFeeBrowser)); top.DropDownItems.Add(tmp); tmp = this.BuildSubMenu("学员修改", typeof(UpdateForm)); top.DropDownItems.Add(tmp); tmp = this.BuildSubMenu("学员列表", typeof(StudentSearch)); top.DropDownItems.Add(tmp); this.AddSeparatorToMenu(top); tmp = this.BuildTopMenu("直接打机动车驾驶证申请表"); tmp.Click += new EventHandler(StudentHelper.F7_Click); top.DropDownItems.Add(tmp); tmp = this.BuildTopMenu("套打-机动车驾驶证申请表"); tmp.Click += new EventHandler(StudentHelper.F6_Click); top.DropDownItems.Add(tmp); tmp = this.BuildTopMenu("套打-机动车驾驶培训记录"); tmp.Click += new EventHandler(StudentHelper.F2_Click); top.DropDownItems.Add(tmp); tmp = this.BuildTopMenu("套打-机动车驾驶人身体条件证明"); tmp.Click += new EventHandler(StudentHelper.F3_Click); top.DropDownItems.Add(tmp); tmp = this.BuildTopMenu("套打-机动车驾驶员培训学员登记表"); tmp.Click += new EventHandler(StudentHelper.F4_Click); top.DropDownItems.Add(tmp); tmp = this.BuildTopMenu("套打-科目三考试成绩表"); tmp.Click += new EventHandler(StudentHelper.F5_Click); top.DropDownItems.Add(tmp); this.AddSeparatorToMenu(top); tmp = this.BuildTopMenu("科目一成绩录入"); tmp.Click += new EventHandler(StudentHelper.subject1_Click); top.DropDownItems.Add(tmp); StudentSystemConfig config = StaticCacheManager.GetConfig <StudentSystemConfig>(); if (config.SubjectIs4) { tmp = this.BuildTopMenu("科目二(桩)成绩录入"); tmp.Click += new EventHandler(StudentHelper.subject20_Click); top.DropDownItems.Add(tmp); tmp = this.BuildTopMenu("科目二(场地)成绩录入"); tmp.Click += new EventHandler(StudentHelper.subject21_Click); top.DropDownItems.Add(tmp); } else { tmp = this.BuildTopMenu("科目二成绩录入"); tmp.Click += new EventHandler(StudentHelper.subject2_Click); top.DropDownItems.Add(tmp); } tmp = this.BuildTopMenu("科目三成绩录入"); tmp.Click += new EventHandler(StudentHelper.subject3_Click); top.DropDownItems.Add(tmp); this.AddSeparatorToMenu(top); tmp = this.BuildSubMenu("退学", typeof(QuitForm)); top.DropDownItems.Add(tmp); this.AddSeparatorToMenu(top); tmp = this.BuildSubMenu("照片采集配置", typeof(CapturePhotoSetting)); top.DropDownItems.Add(tmp); tmp = this.BuildSubMenu("操作快捷界面", typeof(InitButtonPanel)); top.DropDownItems.Add(tmp); }