public HealthManagementRules() { // // TODO: 在此处添加构造函数逻辑 // healthMgmt = new HealthMgmt(); }
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 DataSet GetDiagInfo(HealthMgmt healthMgmt) { using ( HealthManagementDataAccess healthManagementDataAccess = new HealthManagementDataAccess() ) { try { return healthManagementDataAccess.GetDiagInfo(healthMgmt); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return null; } } }
private int FillDiagResult(HealthMgmt healthMgmt) { saveDiagResultCommand = "SaveDiagResult"; dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(saveDiagResultCommand); dbCommandWrapper.AddInParameter("@getNumber",DbType.String,healthMgmt.StuNumber); dbCommandWrapper.AddInParameter("@getDiagInfo",DbType.String,healthMgmt.DiagInfo); dbCommandWrapper.AddInParameter("@getUpperSym",DbType.String,healthMgmt.UpperSym); dbCommandWrapper.AddInParameter("@getLungSym",DbType.String,healthMgmt.LungSym); dbCommandWrapper.AddInParameter("@getThroatSym",DbType.String,healthMgmt.ThroatSym); dbCommandWrapper.AddInParameter("@getEnteronSym",DbType.String,healthMgmt.EnteronSym); dbCommandWrapper.AddInParameter("@getAbdomenSym",DbType.String,healthMgmt.AbdomenSym); dbCommandWrapper.AddInParameter("@getSkinSym",DbType.String,healthMgmt.SkinSym); dbCommandWrapper.AddInParameter("@getFacialSym",DbType.String,healthMgmt.FacialSym); dbCommandWrapper.AddInParameter("@getElse",DbType.String,healthMgmt.Else); dbCommandWrapper.AddInParameter("@getMedInfo",DbType.String,healthMgmt.MedInfo); dbCommandWrapper.AddInParameter("@getTeaSign",DbType.String,healthMgmt.TeacherSign); dbCommandWrapper.AddInParameter("@getDate",DbType.DateTime,healthMgmt.RegisterDate); dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,32); dbHealth.ExecuteNonQuery(dbCommandWrapper); return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected")); }
private DataSet FillDiagInfo(HealthMgmt healthMgmt) { getDiagInfoCommand = "GetDaigInfo"; dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(getDiagInfoCommand); dbCommandWrapper.AddInParameter("@getNumber",DbType.String,healthMgmt.StuNumber); dbCommandWrapper.AddInParameter("@getDate",DbType.DateTime,healthMgmt.RegisterDate); dbCommandWrapper.AddInParameter("@getTeaSign",DbType.String,healthMgmt.TeacherSign); return dbHealth.ExecuteDataSet(dbCommandWrapper); }
public DataSet GetDiagInfo(HealthMgmt healthMgmt) { return FillDiagInfo(healthMgmt); }
private DataSet FillHealthOutput(HealthMgmt healthMgmt) { getHealthOutputCommand = "GetHealthOutput"; dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(getHealthOutputCommand); dbCommandWrapper.AddInParameter("@getGrade",DbType.String,healthMgmt.OutGrade); dbCommandWrapper.AddInParameter("@getClass",DbType.String,healthMgmt.OutClass); dbCommandWrapper.AddInParameter("@getName",DbType.String,healthMgmt.OutName); dbCommandWrapper.AddInParameter("@getNumber",DbType.String,healthMgmt.OutNumber); dbCommandWrapper.AddInParameter("@getGender",DbType.String,healthMgmt.OutGender); dbCommandWrapper.AddInParameter("@getAge",DbType.String,healthMgmt.OutAge); dbCommandWrapper.AddInParameter("@getType",DbType.String,healthMgmt.OutType); dbCommandWrapper.AddInParameter("@getResult",DbType.String,healthMgmt.OutResult); dbCommandWrapper.AddInParameter("@getBegDate",DbType.String,healthMgmt.OutBegDate); dbCommandWrapper.AddInParameter("@getEndDate",DbType.String,healthMgmt.OutEndDate); return dbHealth.ExecuteDataSet(dbCommandWrapper); }
public int UpdateMed(HealthMgmt healthMgmt) { updateMedCommand = "UpdateMed"; dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(updateMedCommand); dbCommandWrapper.AddInParameter("@getMedName",DbType.String,healthMgmt.MedName); dbCommandWrapper.AddInParameter("@getMedType",DbType.String,healthMgmt.MedType); dbCommandWrapper.AddInParameter("@getMedTake",DbType.String,healthMgmt.MedTake); dbCommandWrapper.AddInParameter("@getTaketimes",DbType.Int32,healthMgmt.Taketimes); dbCommandWrapper.AddInParameter("@getMedModifyID",DbType.Int32,healthMgmt.MedModifyID); dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,32); dbHealth.ExecuteNonQuery(dbCommandWrapper); return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected")); }
public int SaveDiagResult(HealthMgmt healthMgmt) { return FillDiagResult(healthMgmt); }
public int SaveMorningWatch(HealthMgmt healthMgmt,bool isWatchState ) { saveMorningWatchCommand = "SaveMorningWatch"; dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(saveMorningWatchCommand); dbCommandWrapper.AddInParameter("@getNumber",DbType.String,healthMgmt.WatchNumber); dbCommandWrapper.AddInParameter("@getName",DbType.String,healthMgmt.WatchName); dbCommandWrapper.AddInParameter("@getHeat",DbType.String,healthMgmt.WatchHeat); dbCommandWrapper.AddInParameter("@getSpirit",DbType.String,healthMgmt.WatchSpirit); dbCommandWrapper.AddInParameter("@getMouth",DbType.String,healthMgmt.WatchMouth); dbCommandWrapper.AddInParameter("@getSkin",DbType.String,healthMgmt.WatchSkin); dbCommandWrapper.AddInParameter("@getOState",DbType.String,healthMgmt.WatchOState); dbCommandWrapper.AddInParameter("@getTreat",DbType.String,healthMgmt.WatchTreat); dbCommandWrapper.AddInParameter("@getDate",DbType.String,healthMgmt.WatchDate); dbCommandWrapper.AddInParameter("@getDailyMovement",DbType.String,healthMgmt.DailyMovement); dbCommandWrapper.AddInParameter("@getDailySpirit",DbType.String,healthMgmt.DailySpirit); dbCommandWrapper.AddInParameter("@getDailyAppetite",DbType.String,healthMgmt.DailyAppetite); dbCommandWrapper.AddInParameter("@getDailySleep",DbType.String,healthMgmt.DailySleep); dbCommandWrapper.AddInParameter("@getDailyStool",DbType.String,healthMgmt.DailyStool); dbCommandWrapper.AddInParameter("@getDailyCough",DbType.String,healthMgmt.DailyCough); dbCommandWrapper.AddInParameter("@getDailyElse",DbType.String,healthMgmt.DailyElse); dbCommandWrapper.AddInParameter("@getDailyCtrlAct",DbType.Boolean,healthMgmt.DailyCtrlAct); dbCommandWrapper.AddInParameter("@getDailyLife",DbType.Boolean,healthMgmt.DailyLife); dbCommandWrapper.AddInParameter("@getDailySeafood",DbType.Boolean,healthMgmt.DailySeafood); dbCommandWrapper.AddInParameter("@getDailyHeat",DbType.Boolean,healthMgmt.DailyHeat); dbCommandWrapper.AddInParameter("@getTeacherSign",DbType.String,healthMgmt.TeacherSign); dbCommandWrapper.AddInParameter("@isWatchState",DbType.Boolean,isWatchState); dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,32); dbHealth.ExecuteNonQuery(dbCommandWrapper); return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected")); }
public DataSet GetHealthOutput(HealthMgmt healthMgmt) { return FillHealthOutput(healthMgmt); }
public int DeleteHealthAnaly(HealthMgmt healthMgmt) { deleteHealthAnalyCommand = "DeleteHealthAnaly"; dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(deleteHealthAnalyCommand); dbCommandWrapper.AddInParameter("@getStuID",DbType.String,healthMgmt.StuID); dbCommandWrapper.AddInParameter("@getDate",DbType.String,healthMgmt.Date); dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,16); dbHealth.ExecuteNonQuery(dbCommandWrapper); return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected")); }
public int UpdateHealthAnaly(HealthMgmt healthMgmt) { updateHealthAnalyCommand = "UpdateHealthAnaly"; dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(updateHealthAnalyCommand); dbCommandWrapper.AddInParameter("@getStuID",DbType.String,healthMgmt.StuID); dbCommandWrapper.AddInParameter("@getDate",DbType.String,healthMgmt.Date); dbCommandWrapper.AddInParameter("@getAge",DbType.String,healthMgmt.Age); dbCommandWrapper.AddInParameter("@getHeight",DbType.Double,healthMgmt.Height); dbCommandWrapper.AddInParameter("@getHeightAnaly",DbType.String,healthMgmt.HeightAnaly.Trim()); dbCommandWrapper.AddInParameter("@getWeight",DbType.Double,healthMgmt.Weight); dbCommandWrapper.AddInParameter("@getWeightAnaly",DbType.String,healthMgmt.WeightAnaly.Trim()); dbCommandWrapper.AddInParameter("@getWHO",DbType.String,healthMgmt.WHO.Trim()); dbCommandWrapper.AddInParameter("@getNut",DbType.String,healthMgmt.Nut.Trim()); dbCommandWrapper.AddInParameter("@getRemark",DbType.String,healthMgmt.Remark); dbCommandWrapper.AddInParameter("@getX", DbType.String, healthMgmt.X); dbCommandWrapper.AddInParameter("@getStd",DbType.Boolean,healthMgmt.Std); dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,16); dbHealth.ExecuteNonQuery(dbCommandWrapper); return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected")); }
public int UpdateNchsHealthAnalysis(HealthMgmt healthMgmt) { updateNchsHealthAnalysisCommand = "hm_nchs_updateHealthAnalysis"; dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(updateNchsHealthAnalysisCommand); dbCommandWrapper.AddInParameter("@getStuID",DbType.String,healthMgmt.StuID); dbCommandWrapper.AddInParameter("@getDate",DbType.String,healthMgmt.Date); dbCommandWrapper.AddInParameter("@getAge",DbType.String,healthMgmt.Age); dbCommandWrapper.AddInParameter("@getHeight",DbType.Double,healthMgmt.Height); dbCommandWrapper.AddInParameter("@getNchsHeight",DbType.String,healthMgmt.HeightAnaly.Trim()); dbCommandWrapper.AddInParameter("@getWeight",DbType.Double,healthMgmt.Weight); dbCommandWrapper.AddInParameter("@getNchsWeight",DbType.String,healthMgmt.WeightAnaly.Trim()); dbCommandWrapper.AddInParameter("@getNchsObesity",DbType.String,healthMgmt.WHO.Trim()); dbCommandWrapper.AddInParameter("@getNchsNut",DbType.String,healthMgmt.Nut.Trim()); dbCommandWrapper.AddInParameter("@getNchsUnderWeight",DbType.String,healthMgmt.NchsUnderWeight.Trim()); dbCommandWrapper.AddInParameter("@getNchsStunting",DbType.String,healthMgmt.NchsStunting.Trim()); dbCommandWrapper.AddInParameter("@getNchsWasting",DbType.String,healthMgmt.NchsWasting.Trim()); dbCommandWrapper.AddInParameter("@getRemark",DbType.String,healthMgmt.Remark); dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,16); dbHealth.ExecuteNonQuery(dbCommandWrapper); return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected")); }