实现挂号管理窗体功能代码分析（三）

最新推荐文章于 2020-02-29 09:28:31 发布

GX_LiShiTing

最新推荐文章于 2020-02-29 09:28:31 发布

阅读量1.5k

点赞数 1

分类专栏： .NET 文章标签： C# SQL

本文链接：https://blog.csdn.net/GX_LiShiTing/article/details/46277005

版权

本文详细分析了使用C#和SQL实现挂号管理窗体的代码，包括绑定下拉框、自动生成最大单据号、保存病人信息及挂号操作的数据库存储过程、逻辑层和界面层代码实现。

摘要由CSDN通过智能技术生成

第三步：实现挂号管理窗体功能代码分析（三）

1、绑定所有下拉框代码

（1）、数据库存储过程：

--查询会员类型
IF(@Type='FRM_GuaHaoGuanLi_Load_ChaXunHuiYuanLeiXing')
	BEGIN
		SELECTLTRIM(RTRIM(MemberCategoryID))ASMemberCategoryID,
		LTRIM(RTRIM(MemberCategoryName))ASMemberCategoryName
		FROMBT_MemberCategoryTable
	END
--查询婚姻情况
IF(@Type='FRM_GuaHaoGuanLi_Load_ChaXunHunYinQingKuang')
	BEGIN
		SELECTLTRIM(RTRIM(AttributeDetailsID))ASAttributeDetailsID,
		LTRIM(RTRIM(AttributeDetailsName))ASAttributeDetailsName
		FROMBT_AttributeDetailsTable
		WHEREBT_AttributeDetailsTable.AttributeSetID=20
	END
--查询参保类型
IF(@Type='FRM_GuaHaoGuanLi_Load_ChaXunCanBaoLeiXing')
	BEGIN
	SELECTLTRIM(RTRIM(AttributeDetailsID))ASAttributeDetailsID,
	LTRIM(RTRIM(AttributeDetailsName))ASAttributeDetailsName
		FROMBT_AttributeDetailsTable
		WHEREBT_AttributeDetailsTable.AttributeSetID=21
	END
--查询性别
IF(@Type='FRM_GuaHaoGuanLi_Load_ChaXunXingBie')
	BEGIN
		SELECTLTRIM(RTRIM(AttributeDetailsID))ASAttributeDetailsID,
		LTRIM(RTRIM(AttributeDetailsName))ASAttributeDetailsName
		FROMBT_AttributeDetailsTable
		WHEREBT_AttributeDetailsTable.AttributeSetID=2
	END
--查询病人类别
IF(@Type='FRM_GuaHaoGuanLi_Load_ChaXunBingRenLeiBie')
	BEGIN
		SELECTLTRIM(RTRIM(PatientCategoryID))ASPatientCategoryID,
		LTRIM(RTRIM(CategoryName))ASCategoryName
		FROMBT_PatientCategoryTable
	END
--查询收费方式
IF(@Type='FRM_GuaHaoGuanLi_Load_ChaXunShouFeiFangShi')
	BEGIN
		SELECTLTRIM(RTRIM(AttributeDetailsID))ASAttributeDetailsID,
		LTRIM(RTRIM(AttributeDetailsName))ASAttributeDetailsName
		FROMBT_AttributeDetailsTable
		WHEREBT_AttributeDetailsTable.AttributeSetID=17
	END
--查询撰写医生
IF(@Type='FRM_GuaHaoGuanLi_Load_ChaXunZhuanXieYiSheng')
	BEGIN
		SELECTLTRIM(RTRIM(StaffID))ASStaffID,
		LTRIM(RTRIM(StaffName))ASStaffName
		FROMBT_StaffTable
		WHEREBT_StaffTable.AS_StaffPositionID=21
	END
--查询撰写科室	
IF(@Type='FRM_GuaHaoGuanLi_Load_ChaXunKeShi')
	BEGIN
		SELECTLTRIM(RTRIM(TechnicalOfficesID))ASTechnicalOfficesID,
		LTRIM(RTRIM(TechnicalOfficesName))ASTechnicalOfficesName
		FROMBT_TechnicalOfficesTable
	END
--查询挂号类型
IF(@Type='FRM_GuaHaoGuanLi_Load_ChaXunGuaHaoLeiXing')
	BEGIN
		SELECTLTRIM(RTRIM(RegisterCategoryID))ASRegisterCategoryID,
		LTRIM(RTRIM(RegisterCategoryName))ASRegisterCategoryName
		FROMBT_RegisterCategoryTable
	END
--查询操作员
IF(@Type='FRM_GuaHaoGuanLi_Load_ChaXunCaoZuoYuan')
	BEGIN
	SELECTLTRIM(RTRIM(StaffID))ASStaffID,
		LTRIM(RTRIM(StaffName))ASStaffName
		FROMBT_StaffTable
		WHEREBT_StaffTable.AS_StaffPositionID=24
	END
--查询班次
IF(@Type='FRM_GuaHaoGuanLi_Load_ChaXunBanCi')
	BEGIN
		SELECTLTRIM(RTRIM(ClassesID))ASClassesID,
		LTRIM(RTRIM(ClassesName))ASClassesName
		FROMBT_ClassesTable
	END

（2）、逻辑层代码：

DALPublic.DALMethod myDALMethod = new DALPublic.DALMethod();
        [OperationContract]
        #region 查询会员类型
publicDataSet FRM_GuaHaoGuanLi_Load_ChaXunHuiYuanLeiXing()
        {
SqlParameter[] SQLCMDpas ={
newSqlParameter ("@Type",SqlDbType.Char),
                                              };
            SQLCMDpas[0].Value = "FRM_GuaHaoGuanLi_Load_ChaXunHuiYuanLeiXing";
DataTable myDataTable = myDALMethod.QueryDataTable("GuaHaoShouFei_FRM_GuaHaoGuanLi", SQLCMDpas);
DataSet myDataSet = newDataSet();
            myDataSet.Tables.Add(myDataTable);
return myDataSet;
        }
        #endregion
        [OperationContract]
        #region 查询婚姻情况?
publicDataSet FRM_GuaHaoGuanLi_Load_ChaXunHunYinQingKuang()
        {
SqlParameter[] SQLCMDpas ={
newSqlParameter ("@Type",SqlDbType.Char),
                                              };
            SQLCMDpas[0].Value = "FRM_GuaHaoGuanLi_Load_ChaXunHunYinQingKuang";
DataTable myDataTable = myDALMethod.QueryDataTable("GuaHaoShouFei_FRM_GuaHaoGuanLi", SQLCMDpas);
DataSet myDataSet = newDataSet();
            myDataSet.Tables.Add(myDataTable);
return myDataSet;
        }
        #endregion
        [OperationContract]
        #region 查询参保类型
publicDataSet FRM_GuaHaoGuanLi_Load_ChaXunCanBaoLeiXing()
        {
SqlParameter[] SQLCMDpas ={
newSqlParameter ("@Type",SqlDbType.Char),
                                              };
            SQLCMDpas[0].Value = "FRM_GuaHaoGuanLi_Load_ChaXunCanBaoLeiXing";
DataTable myDataTable = myDALMethod.QueryDataTable("GuaHaoShouFei_FRM_GuaHaoGuanLi", SQLCMDpas);
DataSet myDataSet = newDataSet();
            myDataSet.Tables.Add(myDataTable);
return myDataSet;
        }
        #endregion
        [OperationContract]
        #region 查询性别
publicDataSet FRM_GuaHaoGuanLi_Load_ChaXunXingBie()
        {
SqlParameter[] SQLCMDpas ={
newSqlParameter ("@Type",SqlDbType.Char),
                                              };
            SQLCMDpas[0].Value = "FRM_GuaHaoGuanLi_Load_ChaXunXingBie";
DataTable myDataTable = myDALMethod.QueryDataTable("GuaHaoShouFei_FRM_GuaHaoGuanLi", SQLCMDpas);
DataSet myDataSet = newDataSet();
            myDataSet.Tables.Add(myDataTable);
return myDataSet;
        }
        #endregion
        [OperationContract]
        #region 查询病人类别
publicDataSet FRM_GuaHaoGuanLi_Load_ChaXunBingRenLeiBie()
        {
SqlParameter[] SQLCMDpas ={
newSqlParameter ("@Type",SqlDbType.Char),
                                              };
            SQLCMDpas[0].Value = "FRM_GuaHaoGuanLi_Load_ChaXunBingRenLeiBie";
DataTable myDataTable = myDALMethod.QueryDataTable("GuaHaoShouFei_FRM_GuaHaoGuanLi", SQLCMDp