yb_icinfo.cs

.net 开发的基础框架

using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using Sybase.DataWindow;
using SPRFrame;

namespace SISS.YiBaoBan
{
    public class YB_IcInfo : DataStore
    {
        private string sSql;

        public YB_IcInfo()
        {
            this.LibraryList = Path.GetFullPath("his_datawindow.pbd");
            this.DataWindowObject = "xsyb_icinfo";
            this.SetTransaction(SPRF.GetDBMain());
            sSql = this.GetSqlSelect();
        }

        public void ResetSql()
        {
            this.SetSqlSelect(sSql);
        }

        #region 属性
        /// <summary>
        /// 医院交易流水号
        /// </summary>
        public string Dateseq
        {
            get
            {
                try
                {
                    return this.GetItemString(this.CurrentRow, "dateseq");
                }
                catch
                {
                    return "";
                }
            }
        }
        /// <summary>
        /// 中心交易流水号
        /// </summary>
        public string Tradeno
        {
            get 
            {
                try
                {
                    return this.GetItemString(this.CurrentRow, "tradeno");
                }
                catch
                {
                    return "";
                }
            }
        }
        #endregion

        #region  方法
        /// <summary>
        /// 萧山医保信息
        /// </summary>
        /// <param name="dateseq">医院流水号</param>
        /// <param name="tradeno">医保交易流水号</param>
        /// <param name="name">病人姓名</param>
        /// <param name="bxbh">保险编号</param>
        public void SetDataByConditon(string dateseq, string tradeno, string name, string bxbh,string date)
        {
            this.ResetSql();
            string SqlString = this.GetSqlSelect();
            if (dateseq != "")
            {
                SqlString = SPRF.ModifySqlString(SqlString, "  yb_result.dateseq = '" + dateseq + "'");
            }
            if (tradeno != "")
            {
                SqlString = SPRF.ModifySqlString(SqlString, "  yb_result.tradeno = '" + tradeno + "'");
            }
            if (name != "")
            {
                SqlString = SPRF.ModifySqlString(SqlString, "  yb_icinfo.xm like '%" + name + "%'");
            }
            if (bxbh != "")
            {
                SqlString = SPRF.ModifySqlString(SqlString, "  yb_icinfo.JBYLBXGRZH like '%" + bxbh + "'");
            }
            if (date != "" && date.Length == 6)
            {
                SqlString = SPRF.ModifySqlString(SqlString, " to_char(yb_result.cre_date,'yyyymm') = '" + date + "'");
            }
            if (date != "" && date.Length == 8)
            {
                SqlString = SPRF.ModifySqlString(SqlString, " to_char(yb_result.cre_date,'yyyymmdd') = '" + date + "'");
            }
            this.SetSqlSelect(SqlString);
        }

        #endregion 
    }
}