hform.cs

.net 开发的基础框架

using System;
using System.Collections.Generic;
using System.Text;

using Sybase.DataWindow;
using SPRFrame;

using System.Windows.Forms;

namespace HPIResource.HisForm
{
    // 申请单
    public class HForm
    {
        public DataStore _FormView;             // 申请单显示视图
        public Form_List _FormInfo;             // 申请单头
        public FormFeiyong_List _FormF;         // 申请单费用
        public FormItem_List _FormItems;        // 申请单上的项目
        public FormItem_f_List _ItemF;          // 项目费用
        
        string tableSyntax = "";                
        string viewSyntax = "";

        public DataStore FormView;

        public HForm()
        {
            _FormView = new DataStore();
            _FormInfo = new Form_List();
            _FormItems = new FormItem_List();
            _FormF = new FormFeiyong_List();
            _ItemF = new FormItem_f_List();
        }

        #region 属性
        // 申请单编号
        public int ID
        {
            get { return _FormInfo.ID; }
            set { _FormInfo.ID = value; }
        }
        // 申请单类型
        //（6位字符串,具体类型见HPIR_Form_Catalog表的设定）
        // 特别规定：000001 - 挂号　000002 - 收费单
        public string TYPE
        {
            get { return _FormInfo.TYPE; }
            set { _FormInfo.TYPE = value; }
        }
        //申请单的来源(M - 门诊，Z - 住院，J - 急诊)
        public string SOURCE
        {
            get { return _FormInfo.SOURCE; }
            set { _FormInfo.SOURCE = value; }
        }
        public string Model_STS
        {
            get { return _FormInfo.MODEL_STS; }
            set { _FormInfo.MODEL_STS = value; }
        }
        public int Model_ID
        {
            get { return _FormInfo.MODEL_ID; }
            set { _FormInfo.MODEL_ID = value; }
        }

        //---------------------------------------------------------
        // 病人编号
        public string PatinetID
        {
            get { return _FormInfo.PatientID; }
            set { _FormInfo.PatientID = value; }
        }
        // 床位
        public int BedID
        {
            get { return _FormInfo.BedID; }
            set { _FormInfo.BedID = value; }
        }
        // 病区
        public int BedDept
        {
            get { return _FormInfo.BedDept; }
            set { _FormInfo.BedDept = value; }
        }
        //---------------------------------------------------------
        // 结算标志 T - 结算 F - 未结算
        public string STS_JS
        {
            get { return _FormInfo.STS_JS; }
            set { _FormInfo.STS_JS = value; }
        }
        // 执行标志 T - 执行 F - 未执行
        public string STS_ZX
        {
            get { return _FormInfo.STS_ZX; }
            set { _FormInfo.STS_ZX = value; }
        }
        // 作废标志 T - 作废 F - 未作废
        public string STS_ZF
        {
            get { return _FormInfo.STS_ZF; }
            set { _FormInfo.STS_ZF = value; }
        }
        //结算编号
        public int AccID
        {
            get { return _FormInfo.AccID; }
            set { _FormInfo.AccID = value; }
        }
        //---------------------------------------------------------
        // 开单人
        public int KDMan
        {
            get { return _FormInfo.KDMan; }
            set { _FormInfo.KDMan = value; }
        }
        // 开单部门
        public int KDDept
        {
            get { return _FormInfo.KDDept; }
            set { _FormInfo.KDDept = value; }
        }
        // 开单日期
        public int KDDate
        {
            get { return _FormInfo.KDDate; }
            set { _FormInfo.KDDate = value; }
        }
        // 开单时间
        public int KDTime
        {
            get { return _FormInfo.KDTime; }
            set { _FormInfo.KDTime = value; }
        }
        //---------------------------------------------------------
        // 执行人
        public int ZXMan
        {
            get { return _FormInfo.ZXMan; }
            set { _FormInfo.ZXMan = value; }
        }
        // 执行部门
        public int ZXDept
        {
            get { return _FormInfo.ZXDept; }
            set { _FormInfo.ZXDept = value; }
        }
        // 执行日期
        public int ZXDate
        {
            get { return _FormInfo.ZXDate; }
            set { _FormInfo.ZXDate = value; }
        }
        // 执行时间
        public int ZXTime
        {
            get { return _FormInfo.ZXTime; }
            set { _FormInfo.ZXTime = value; }
        }
        // 操作版本号
        public int VERSION
        {
            get { return _FormInfo.Version; }
            set { _FormInfo.Version = value; }
        }
        // 看诊序号
        public int Reg_No
        {
            get { return _FormInfo.Reg_No; }
            set { _FormInfo.Reg_No = value; }
        }
        // 总金额
        public double SUM
        {
            get { return _FormInfo.SUM; }
            set { _FormInfo.SUM= value; }
        }
        // 贴数
        public int TS
        {
            get { return _FormInfo.TS; }
            set { _FormInfo.TS = value; }
        }

        #endregion

        /// <summary>
        /// 初始化申请单
        /// </summary>
        /// <param name="iId"></param>
        /// <param name="iModelId"></param>
        public void init(int iId, int iModelId)
        {
            if (iId == 0)
            {
                // 新申请单,按照iModelId取项目
                _FormInfo.InsertRow(0);
                _FormInfo.SetRow(1);
            }
            else
            {
                // 旧申请单
                _FormInfo.ResetSQL();
                _FormInfo.SetDataById(iId);
                _FormInfo.Retrieve();
                // 按照iId取项目和数据
                _FormItems.ResetSQL();
                _FormItems.SetDataByFormId(iId);
                _FormItems.Retrieve();
                // 取得申请单的费用
                _FormF.Retrieve(iId);
            }
        }

        /// <summary>
        /// 产生申请单号
        /// </summary>
        /// <returns></returns>
        public int CreateFormID()
        {
            int id = this.ID;
            if (this.ID == 0)
            {
                // 产生申请单最大值
                id = SPRF.MaxId("HPIR_FORM");
                if (id <= 0)
                {
                    SPRF.ErrText = "不能产生申请单的编号";
                    return -1;
                }
                this.ID = id;
            }
            return id;
        }
        /// <summary>
        /// 保存申请单
        /// </summary>
        /// <returns></returns>
        public int Save()
        {
            if (this.ID == 0)
            {
                if (CreateFormID() <= 0)
                {
                    return -1;
                }
            }

            if (this.KDMan < 0)
            {
                SPRF.ErrText = "没有开单人";
                return -1;
            }

            // 保存申请单费用
            for (int i = _FormF.RowCount; i >= 1; i--)
            {
                _FormF.SetRow(i);
                if (_FormF.ITEM_ID == 0) _FormF.DeleteRow(i);
            }
            double s = 0;
            for (int i = 1; i <= _FormF.RowCount; i++)
            {
                _FormF.SetRow(i);
                s += _FormF.ITEM_PRICE * _FormF.NUM * _FormF.DAYS;
                if (_FormF.FORM_ID == 0) _FormF.FORM_ID = this.ID;
            }

            try
            {
                _FormF.UpdateData();
            }
            catch (DbErrorException e)
            {
                SPRF.ErrText = _FormF.DataWindowObject + e.SqlErrorText;
                return -1;
            }

            // 保存申请单头部信息
            this.SUM = s;
            this.VERSION = this.VERSION + 1;
            this.KDDate = DateTime.Now.Year * 10000 + DateTime.Now.Month * 100 + DateTime.Now.Day;
            this.KDTime = DateTime.Now.Hour * 10000 + DateTime.Now.Minute * 100 + DateTime.Now.Second;
            try
            {
                _FormInfo.UpdateData();
            }
            catch (DbErrorException e)
            {
                SPRF.ErrText = _FormInfo.DataWindowObject + e.SqlErrorText;
                return -1;
            }
            return 0;
        }