feiyongmingxi.cs

来自「.net 开发的基础框架」· CS 代码 · 共 60 行

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


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

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

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

        #region 属性
        #endregion

        #region 方法

        /// <summary>
        /// 根据dateseq查找数据
        /// </summary>
        /// <param name="sDataseq"></param>
        public void SetDataByDataseq(string sDataseq)
        {
            this.ResetSql();
            string SqlString = this.GetSqlSelect();
            SqlString = SPRF.ModifySqlString(SqlString, "  dataseq = '" + sDataseq + "'"); 
            this.SetSqlSelect(SqlString);
        }

        /// <summary>
        /// 根据发票号查数据
        /// </summary>
        /// <param name="sInvoiceCode"></param>
        public void SetDataByInvoiceCode(string sInvoiceCode)
        {
            this.ResetSql();
            string SqlString = this.GetSqlSelect();
            SqlString = SPRF.ModifySqlString(SqlString, "  invoice_code = '" + sInvoiceCode + "'");
            this.SetSqlSelect(SqlString);
        }

        #endregion
    }
}