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"));
}