public SMSPhoneNumChoose() { // // Required for Windows Form Designer support // InitializeComponent(); // // TODO: Add any constructor code after InitializeComponent call // DataSet TeaDept = new RolesSystem().GetRolesDuty(Convert.ToInt32(Thread.CurrentPrincipal.Identity.Name)); PhoneNum = new SMSInfoSystem().GetAllStuPhoneNum();//学生卡 PhoneNumView = PhoneNum.Tables[0].DefaultView; string rowFilter = string.Empty; if(Thread.CurrentPrincipal.Identity.Name.ToLower()=="admin") return; if(!Thread.CurrentPrincipal.IsInRole("园长") &&!Thread.CurrentPrincipal.IsInRole("保健")) { rowFilter = rowFilter + "stu_grade = '" +TeaDept.Tables[0].Rows[0][0].ToString()+"'"; rowFilter = rowFilter + " and stu_class = '" +TeaDept.Tables[0].Rows[0][1].ToString()+"'"; } PhoneNumView.RowFilter = rowFilter; gridControl2.DataSource = PhoneNumView; }
public PhoneNum() { // This call is required by the Windows.Forms Form Designer. InitializeComponent(); // TODO: Add any initialization after the InitForm call getStuInfoByCondition = new GetStuInfoByCondition(); StuList = new CardInfoSystem().GetStuCardInfoList();//学生卡 if(Thread.CurrentPrincipal.Identity.Name.ToLower()=="admin") return; DataSet TeaDept = new RolesSystem().GetRolesDuty(Convert.ToInt32(Thread.CurrentPrincipal.Identity.Name)); string rowFilter = string.Empty; if(!Thread.CurrentPrincipal.IsInRole("园长") &&!Thread.CurrentPrincipal.IsInRole("保健")) { rowFilter = rowFilter + "info_gradeName = '" +TeaDept.Tables[0].Rows[0][0].ToString()+"'"; rowFilter = rowFilter + " and info_className = '" +TeaDept.Tables[0].Rows[0][1].ToString()+"'"; } StuView = StuList.Tables[0].DefaultView; StuView.RowFilter = rowFilter; gridControl1.DataSource = StuView; comboBoxEdit_Send_StuGrade.Properties.Items.Clear(); comboBoxEdit_Send_StuGrade.Properties.Items.AddRange(new object[]{"全部"}); comboBoxEdit_Send_StuGrade.SelectedItem = "全部"; foreach(DataRow getGradeList in getStuInfoByCondition.getGradeInfo("","").Tables[0].Rows) { comboBoxEdit_Send_StuGrade.Properties.Items.AddRange( new object[]{getGradeList[1].ToString()}); } }
public RealtimeInfo() { // This call is required by the Windows.Forms Form Designer. InitializeComponent(); // TODO: Add any initialization after the InitForm call getStuInfoByCondition = new GetStuInfoByCondition(); realTimeSumInfo = new RealtimeSumInfo(); realTimeInfoPrintSystem = new RealtimeInfoPrintSystem(); rolesSystem = new RolesSystem(); #region 帮助 helpProvider_RealtimeInfo_Student.HelpNamespace = System.IO.Path.GetDirectoryName(Application.ExecutablePath) + CPTT.SystemFramework.Util.HELP_FILE_NAME; this.helpProvider_RealtimeInfo_Student.SetHelpKeyword(this.xtraTabPage1,"学生图形统计"); this.helpProvider_RealtimeInfo_Student.SetHelpNavigator(this.xtraTabPage1, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_RealtimeInfo_Student.SetHelpString(this.xtraTabPage1, ""); this.helpProvider_RealtimeInfo_Student.SetShowHelp(this.xtraTabPage1, true); this.helpProvider_RealtimeInfo_Student.SetHelpKeyword(this.xtraTabPage2,"学生数据统计"); this.helpProvider_RealtimeInfo_Student.SetHelpNavigator(this.xtraTabPage2, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_RealtimeInfo_Student.SetHelpString(this.xtraTabPage2, ""); this.helpProvider_RealtimeInfo_Student.SetShowHelp(this.xtraTabPage2, true); #endregion }
public NutritionManagement() { // This call is required by the Windows.Forms Form Designer. InitializeComponent(); // TODO: Add any initialization after the InitForm call foodManagementSystem = new FoodManagementSystem(); foodManagementPrintSystem = new FoodManagementPrintSystem(); getStuInfoByCondition = new GetStuInfoByCondition(); healthManagementSystem = new HealthManagementSystem(); healthMgmt = new HealthMgmt(); healthManagementPrintSystem = new HealthManagementPrintSystem(); rolesSystem = new RolesSystem(); useVersion = CPTT.SystemFramework.Util.UseVersion; #region 帮助 helpProvider_NutritionInfo.HelpNamespace = System.IO.Path.GetDirectoryName(Application.ExecutablePath) + CPTT.SystemFramework.Util.HELP_FILE_NAME; this.helpProvider_NutritionInfo.SetHelpKeyword(this.xtraTabPage1,"食物库存管理"); this.helpProvider_NutritionInfo.SetHelpNavigator(this.xtraTabPage1, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_NutritionInfo.SetHelpString(this.xtraTabPage1, ""); this.helpProvider_NutritionInfo.SetShowHelp(this.xtraTabPage1, true); this.helpProvider_NutritionInfo.SetHelpKeyword(this.xtraTabPage2,"每日食谱安排"); this.helpProvider_NutritionInfo.SetHelpNavigator(this.xtraTabPage2, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_NutritionInfo.SetHelpString(this.xtraTabPage2, ""); this.helpProvider_NutritionInfo.SetShowHelp(this.xtraTabPage2, true); this.helpProvider_NutritionInfo.SetHelpKeyword(this.xtraTabPage3,"集体膳食安排"); this.helpProvider_NutritionInfo.SetHelpNavigator(this.xtraTabPage3, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_NutritionInfo.SetHelpString(this.xtraTabPage3, ""); this.helpProvider_NutritionInfo.SetShowHelp(this.xtraTabPage3, true); this.helpProvider_NutritionInfo.SetHelpKeyword(this.xtraTabPage4,"膳食营养综合统计表"); this.helpProvider_NutritionInfo.SetHelpNavigator(this.xtraTabPage4, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_NutritionInfo.SetHelpString(this.xtraTabPage4, ""); this.helpProvider_NutritionInfo.SetShowHelp(this.xtraTabPage4, true); this.helpProvider_NutritionInfo.SetHelpKeyword(this.xtraTabPage5,"幼儿身体评测登记"); this.helpProvider_NutritionInfo.SetHelpNavigator(this.xtraTabPage5, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_NutritionInfo.SetHelpString(this.xtraTabPage5, ""); this.helpProvider_NutritionInfo.SetShowHelp(this.xtraTabPage5, true); this.helpProvider_NutritionInfo.SetHelpKeyword(this.xtraTabPage6,"幼儿评测结果浏览及打印"); this.helpProvider_NutritionInfo.SetHelpNavigator(this.xtraTabPage6, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_NutritionInfo.SetHelpString(this.xtraTabPage6, ""); this.helpProvider_NutritionInfo.SetShowHelp(this.xtraTabPage6, true); this.helpProvider_NutritionInfo.SetHelpKeyword(this.xtraTabPage7,"晨检及全日观察"); this.helpProvider_NutritionInfo.SetHelpNavigator(this.xtraTabPage7, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_NutritionInfo.SetHelpString(this.xtraTabPage7, ""); this.helpProvider_NutritionInfo.SetShowHelp(this.xtraTabPage7, true); this.helpProvider_NutritionInfo.SetHelpKeyword(this.xtraTabPage8,"服药登记"); this.helpProvider_NutritionInfo.SetHelpNavigator(this.xtraTabPage8, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_NutritionInfo.SetHelpString(this.xtraTabPage8, ""); this.helpProvider_NutritionInfo.SetShowHelp(this.xtraTabPage8, true); this.helpProvider_NutritionInfo.SetHelpKeyword(this.xtraTabPage9,"服药记录"); this.helpProvider_NutritionInfo.SetHelpNavigator(this.xtraTabPage9, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_NutritionInfo.SetHelpString(this.xtraTabPage9, ""); this.helpProvider_NutritionInfo.SetShowHelp(this.xtraTabPage9, true); #endregion }
public TeacherBaseInfo() { // This call is required by the Windows.Forms Form Designer. InitializeComponent(); // TODO: Add any initialization after the InitForm call helpProvider_Help.HelpNamespace = Path.GetDirectoryName(Application.ExecutablePath) + CPTT.SystemFramework.Util.HELP_FILE_NAME; teaBaseInfoPrintSystem = new TeaBaseInfoPrintSystem(); rolesSystem = new RolesSystem(); }
public TeacherOnDutyInfo() { // This call is required by the Windows.Forms Form Designer. InitializeComponent(); // TODO: Add any initialization after the InitForm call getStuInfoByCondition = new GetStuInfoByCondition(); rolesSystem = new RolesSystem(); dateEdit_TeaDutyDetailsSearByStartTime.EditValue = DateTime.Now; dateEdit_TeaDutyDetailsSearByEndTime.EditValue = DateTime.Now; dateEdit1.EditValue = DateTime.Now; dateEdit2.EditValue = DateTime.Now; dateEdit_DutyHistory.EditValue = DateTime.Now; LoadGradeClassInfo(); DutyInfo = new DutySystem().GetDutyInfoList(); BindDutyData(); dataNavigator_DutyDetails.DataSource = DutyInfo.Tables[0]; if(!Thread.CurrentPrincipal.IsInRole("园长") && Thread.CurrentPrincipal.Identity.Name.ToLower() != "admin" ) { DataSet dsRolesDuty = rolesSystem.GetRolesDuty(Convert.ToInt32(Thread.CurrentPrincipal.Identity.Name)); string gradeName = dsRolesDuty.Tables[0].Rows[0][0].ToString(); string className = dsRolesDuty.Tables[0].Rows[0][1].ToString(); comboBoxEdit_TeaDutyDetailsSearByGrade.Properties.Items.Clear(); comboBoxEdit_TeaDutyDetailsSearByGrade.Properties.Items.AddRange(new object[]{gradeName}); comboBoxEdit_TeaDutyDetailsSearByGrade.SelectedItem = gradeName; comboBoxEdit_TeaDutyDetailsSearByClass.Properties.Items.Clear(); comboBoxEdit_TeaDutyDetailsSearByClass.Properties.Items.AddRange(new object[]{className}); comboBoxEdit_TeaDutyDetailsSearByClass.SelectedItem = className; textEdit_TeaDutyDetailsSearByName.Text = new HealthManagementSystem().GetTeaName(Thread.CurrentPrincipal.Identity.Name); textEdit_TeaDutyDetailsSearByName.Properties.ReadOnly = true; textEdit_TeaDutyDetailsSearByID.Text = Thread.CurrentPrincipal.Identity.Name; textEdit_TeaDutyDetailsSearByID.Properties.ReadOnly = true; simpleButton_SaveDutyAsign.Enabled = false; dataNavigator_DutyDetails.Buttons.Append.Visible = false; dataNavigator_DutyDetails.Buttons.Remove.Visible = false; dataNavigator_DutyDetails.Buttons.EndEdit.Visible = false; xtraTabPage_TeaOnDutyReports.PageVisible = false; this.gridColumn4.OptionsColumn.AllowEdit = false; this.gridColumn5.OptionsColumn.AllowEdit = false; this.gridColumn6.OptionsColumn.AllowEdit = false; this.gridColumn7.OptionsColumn.AllowEdit = false; this.gridColumn8.OptionsColumn.AllowEdit = false; this.gridColumn9.OptionsColumn.AllowEdit = false; this.gridColumn10.OptionsColumn.AllowEdit = false; } if ( Thread.CurrentPrincipal.Identity.Name.ToLower() == "admin" ) { simpleButton_SearTeaDutyDetails.Enabled = false; simpleButton3.Enabled = false; simpleButton_LoadHisDuty.Enabled = false; simpleButton_TeaDutySave.Enabled = false; } simpleButton3.Enabled = false; LoadSelectTeaDutyInfo(); simpleButton1_Click(null,null); #region 帮助 helpProvider_DutyInfo.HelpNamespace = System.IO.Path.GetDirectoryName(Application.ExecutablePath) + CPTT.SystemFramework.Util.HELP_FILE_NAME; this.helpProvider_DutyInfo.SetHelpKeyword(this.xtraTabPage_TeaDutyDetails,"班次管理"); this.helpProvider_DutyInfo.SetHelpNavigator(this.xtraTabPage_TeaDutyDetails, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_DutyInfo.SetHelpString(this.xtraTabPage_TeaDutyDetails, ""); this.helpProvider_DutyInfo.SetShowHelp(this.xtraTabPage_TeaDutyDetails, true); this.helpProvider_DutyInfo.SetHelpKeyword(this.xtraTabPage_TeaOnDutyInfo,"出勤信息"); this.helpProvider_DutyInfo.SetHelpNavigator(this.xtraTabPage_TeaOnDutyInfo, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_DutyInfo.SetHelpString(this.xtraTabPage_TeaOnDutyInfo, ""); this.helpProvider_DutyInfo.SetShowHelp(this.xtraTabPage_TeaOnDutyInfo, true); this.helpProvider_DutyInfo.SetHelpKeyword(this.xtraTabPage_TeaOnDutyReports,"出勤信息分析"); this.helpProvider_DutyInfo.SetHelpNavigator(this.xtraTabPage_TeaOnDutyReports, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_DutyInfo.SetHelpString(this.xtraTabPage_TeaOnDutyReports, ""); this.helpProvider_DutyInfo.SetShowHelp(this.xtraTabPage_TeaOnDutyReports, true); #endregion }
public StudentBaseInfo() { // This call is required by the Windows.Forms Form Designer. InitializeComponent(); // TODO: Add any initialization after the InitForm call getStuInfoByCondition = new GetStuInfoByCondition(); stuValidationCheck = new StuValidationCheck(); students = new Students(); stuBaseInfoPrintSystem = new StuBaseInfoPrintSystem(); rolesSystem = new RolesSystem(); #region 帮助 this.helpProvider_StuBaseInfo.HelpNamespace = System.IO.Path.GetDirectoryName(Application.ExecutablePath) + CPTT.SystemFramework.Util.HELP_FILE_NAME; this.helpProvider_StuBaseInfo.SetHelpKeyword(this.xtraTabControl_StuBaseInfo,"学生基本信息管理"); this.helpProvider_StuBaseInfo.SetHelpNavigator(this.xtraTabControl_StuBaseInfo, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_StuBaseInfo.SetHelpString(this.xtraTabControl_StuBaseInfo, ""); this.helpProvider_StuBaseInfo.SetShowHelp(this.xtraTabControl_StuBaseInfo, true); #endregion }
//过滤DataView private void SelectStuCardInfo(string name,string id,string grade,string className) { string rowFilter = string.Empty; DataSet TeaDept = new RolesSystem().GetRolesDuty(Convert.ToInt32(Thread.CurrentPrincipal.Identity.Name)); if(!Thread.CurrentPrincipal.IsInRole("园长") &&!Thread.CurrentPrincipal.IsInRole("保健")) { rowFilter = "info_stuName like '%"+name+"%'"; rowFilter = rowFilter + " and info_gradeName = '" +TeaDept.Tables[0].Rows[0][0].ToString()+"'"; rowFilter = rowFilter + " and info_className = '" +TeaDept.Tables[0].Rows[0][1].ToString()+"'"; if(id.Length==4) { rowFilter += " and info_stuNumber="+id; } } else { rowFilter = "info_stuName like '%"+name+"%'"; if(grade.Equals("全部")) { rowFilter = rowFilter + " and info_gradeName like '%'"; } else { rowFilter = rowFilter + " and info_gradeName like '%"+ grade+"%'"; } if(className.Equals("全部")) { rowFilter = rowFilter + " and info_className like '%'"; } else { rowFilter = rowFilter + " and info_className like '%"+className+"%'"; } if(id.Length==4) { rowFilter += " and info_stuNumber="+id; } } StuView.RowFilter = rowFilter; gridControl1.DataSource = StuView; if(gridView1.RowCount==0) return; string selectedStuID = (gridView1.GetDataRow(gridView1.GetSelectedRows()[0])["info_stuID"]).ToString(); DisplayStuPhoneNum(selectedStuID); }
public StudentMorningCheckInfo() { // 该调用是 Windows.Forms 窗体设计器所必需的。 InitializeComponent(); // TODO: 在 InitializeComponent 调用后添加任何初始化 getStuInfoByCondition = new GetStuInfoByCondition(); stuAttendCalc = new StuAttendCalc(); stuCheckInfo = new StudentCheckInfo(); stuMorningCheckInfoPrintSystem = new StuMorningCheckInfoPrintSystem(); rolesSystem = new RolesSystem(); #region 帮助 helpProvider_StuMorningCheckInfo.HelpNamespace = System.IO.Path.GetDirectoryName(Application.ExecutablePath) + CPTT.SystemFramework.Util.HELP_FILE_NAME; this.helpProvider_StuMorningCheckInfo.SetHelpKeyword(this.xtraTabPage_MorningCheck,"幼儿晨检信息查询"); this.helpProvider_StuMorningCheckInfo.SetHelpNavigator(this.xtraTabPage_MorningCheck, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_StuMorningCheckInfo.SetHelpString(this.xtraTabPage_MorningCheck, ""); this.helpProvider_StuMorningCheckInfo.SetShowHelp(this.xtraTabPage_MorningCheck, true); this.helpProvider_StuMorningCheckInfo.SetHelpKeyword(this.xtraTabPage_BackHomeCheck,"幼儿晚接信息查询"); this.helpProvider_StuMorningCheckInfo.SetHelpNavigator(this.xtraTabPage_BackHomeCheck, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_StuMorningCheckInfo.SetHelpString(this.xtraTabPage_BackHomeCheck, ""); this.helpProvider_StuMorningCheckInfo.SetShowHelp(this.xtraTabPage_BackHomeCheck, true); this.helpProvider_StuMorningCheckInfo.SetHelpKeyword(this.xtraTabPage_FreeDefinition,"幼儿自定义信息查询"); this.helpProvider_StuMorningCheckInfo.SetHelpNavigator(this.xtraTabPage_FreeDefinition, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_StuMorningCheckInfo.SetHelpString(this.xtraTabPage_FreeDefinition, ""); this.helpProvider_StuMorningCheckInfo.SetShowHelp(this.xtraTabPage_FreeDefinition, true); this.helpProvider_StuMorningCheckInfo.SetHelpKeyword(this.xtraTabPage_MoreReport,"晨检信息综合统计报表"); this.helpProvider_StuMorningCheckInfo.SetHelpNavigator(this.xtraTabPage_MoreReport, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_StuMorningCheckInfo.SetHelpString(this.xtraTabPage_MoreReport, ""); this.helpProvider_StuMorningCheckInfo.SetShowHelp(this.xtraTabPage_MoreReport, true); #endregion }
private void SelectPhoneInfo(string name,string id,string grade,string className) { DataSet TeaDept = new RolesSystem().GetRolesDuty(Convert.ToInt32(Thread.CurrentPrincipal.Identity.Name)); string rowFilter = string.Empty; if(!Thread.CurrentPrincipal.IsInRole("园长") &&!Thread.CurrentPrincipal.IsInRole("保健")) { rowFilter = "info_stuName like '%"+name+"%'"; rowFilter = rowFilter + " and stu_grade = '" +TeaDept.Tables[0].Rows[0][0].ToString()+"'"; rowFilter = rowFilter + " and stu_class = '" +TeaDept.Tables[0].Rows[0][1].ToString()+"'"; if(id.Length==4) { rowFilter += " and info_stuNumber="+id; } } else { rowFilter = "info_stuName like '%"+name+"%'"; if(grade.Equals("全部")) { rowFilter = rowFilter + " and stu_grade like '%'"; } else { rowFilter = rowFilter + " and stu_grade like '%"+ grade+"%'"; } if(className.Equals("全部")) { rowFilter = rowFilter + " and stu_class like '%'"; } else { rowFilter = rowFilter + " and stu_class like '%"+className+"%'"; } if(id.Length==4) { rowFilter += " and info_stuNumber="+id; } } PhoneNumView.RowFilter = rowFilter; gridControl2.DataSource = PhoneNumView; if(gridView2.RowCount==0) return; }
public StudentVisitInfo() { // This call is required by the Windows.Forms Form Designer. InitializeComponent(); // TODO: Add any initialization after the InitForm call getStuInfoByCondition = new GetStuInfoByCondition(); stuVisitInfoSystem = new StuVisitInfoSystem(); stuVisitInfoPrintSystem = new StuVisitInfoPrintSystem(); healthManagementSystem = new HealthManagementSystem(); rolesSystem = new RolesSystem(); #region 帮助 helpProvider_StuVisitInfo.HelpNamespace = System.IO.Path.GetDirectoryName(Application.ExecutablePath) + CPTT.SystemFramework.Util.HELP_FILE_NAME; this.helpProvider_StuVisitInfo.SetHelpKeyword(this.xtraTabPage_InfoMgmt,"幼儿家访信息管理"); this.helpProvider_StuVisitInfo.SetHelpNavigator(this.xtraTabPage_InfoMgmt, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_StuVisitInfo.SetHelpString(this.xtraTabPage_InfoMgmt, ""); this.helpProvider_StuVisitInfo.SetShowHelp(this.xtraTabPage_InfoMgmt, true); this.helpProvider_StuVisitInfo.SetHelpKeyword(this.xtraTabPage_InfoQuery,"幼儿家访信息检索"); this.helpProvider_StuVisitInfo.SetHelpNavigator(this.xtraTabPage_InfoQuery, System.Windows.Forms.HelpNavigator.KeywordIndex); this.helpProvider_StuVisitInfo.SetHelpString(this.xtraTabPage_InfoQuery, ""); this.helpProvider_StuVisitInfo.SetShowHelp(this.xtraTabPage_InfoQuery, true); #endregion }