yewusr.cs

.net 开发的基础框架

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

using Sybase.DataWindow;

using SPRFrame;
using HPIResource;

namespace HPIResource.HisForm
{
    // 业务收入统计
    public class YewuSR:DataStore
    {
        string strSql = "";
        public YewuSR()
        {
            this.LibraryList = HPIR.PbdFile;
            this.DataWindowObject = "dw_yewushouru";
            this.SetTransaction(SPRF.GetDB());
            strSql = this.GetSqlSelect();
        }
        public YewuSR(string sType)
        {
            this.LibraryList = HPIR.PbdFile;
            this.DataWindowObject = "dw_yewushouru_"+sType;
            this.SetTransaction(SPRF.GetDB());
            strSql = this.GetSqlSelect();
        }

        public void ResetSQL()
        {
            this.SetSqlSelect(strSql);
        }

        public void SetDataByDate(int sDate,int eDate)
        {
            this.ResetSQL();
            string s = this.GetSqlSelect().ToUpper();
            int i = s.IndexOf("WHERE");
            string s1 = s.Substring(0, i + 5);
            string s2 = s.Substring(i + 6, s.Length - i - 6);
            s = s1+" ( HPIR_FORMACCOUNT.ACCDATE >=" + sDate.ToString() + " and HPIR_FORMACCOUNT.ACCDATE <=" + eDate.ToString() + ") and " + s2;
            this.SetSqlSelect(s);
        }
    }
}