prech.cs

.net 开发的基础框架

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

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

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

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

        #region 属性
        /// <summary>
        /// 发票号
        /// </summary>
        public string Invoice_Code
        {
            get
            {
                try
                {
                    return this.GetItemString(this.CurrentRow, "invoice_code");
                }
                catch
                {
                    return "";
                }
            }
        }
        #endregion

        #region 方法
        /// <summary>
        /// 查找交易记录
        /// </summary>
        /// <param name="dateseq">医院交易流水号</param>
        /// <param name="date">交易日期，格式ＹＹＹＹＭＭＤＤ</param>
        /// <param name="flag">在全部数据中找否</param>
        public void SetDataByCondition(string dateseq,string date)
        {
            this.ResetSql();
            string SqlString = this.GetSqlSelect();
            if (date.Length == 6)
            {//根据月份查询
                SqlString = SPRF.ModifySqlString(SqlString, "  dateseq = '" + dateseq + "' and to_char(trans_date,'yyyymm') = '" + date + "'");
                this.SetSqlSelect(SqlString);
                return;
            }
            if (date.Length == 8)
            {//根据日期查询
                SqlString = SPRF.ModifySqlString(SqlString, "  dateseq = '" + dateseq + "' and to_char(trans_date,'yyyymmdd') = '" + date + "'");
                this.SetSqlSelect(SqlString);
                return;
            }
            SPRF.ErrText = "-1";
            return;
        }

        #endregion
    }
}