41 lines
1.3 KiB
C#
41 lines
1.3 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Text;
|
|
using GThinking.N_MISPROAS.Caching;
|
|
using System.Data;
|
|
using GThinking.N_MISPRO.Data;
|
|
|
|
namespace GThinking.N_XLXSBJ
|
|
{
|
|
internal class KZXXCache : DbDataCacheBase
|
|
{
|
|
public DataSet dsXLXSBJKZXXSZ;
|
|
|
|
public KZXXCache()
|
|
: base("DBERP", "N_XLXSBJ_XLXSBJKZXXSZ", "XLXSBJKZXXSZ")
|
|
{
|
|
}
|
|
|
|
protected override void FillData(string subKey)
|
|
{
|
|
|
|
TDatabase db = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(db);
|
|
SQL.Clear();
|
|
SQL.Add("select XLXSBJKZXXSZ_MC, XLXSBJKZXXSZ_SJLX, XLXSBJKZXXSZ_DYZD, isnull(XLXSBJKZXXSZ_BT,'N') as BT, XLXSBJKZXXSZ_SRFS, ");
|
|
SQL.Add("XLXSBJKZXXSZ_MJLB,XLXSBJKZXXSZ_MJSQL,XLXSBJKZXXSZ_WIDTH, XLXSBJKZXXSZ_ROWS, XLXSBJKZXXSZ_JLDW,XLXSBJKZXXSZ_QSZ, ");
|
|
SQL.Add("XLXSBJKZXXSZ_WHBZ,XLXSBJKZXXSZ_XSBZ,XLXSBJKZXXSZ_SYBJFLID,XLXSBJKZXXSZ_ZWCXTJ ");
|
|
SQL.Add("from XLXSBJKZXXSZ ");
|
|
SQL.Add("where 1=1 ");
|
|
SQL.Add("order by XLXSBJKZXXSZ_BJSX, XLXSBJKZXXSZ_BH ");
|
|
SQL.ClassId = "N_XLXSBJ.KZXXCache";
|
|
SQL.SqlId = "FillData_1";
|
|
DataSet ds = db.OpenDataSet(SQL);
|
|
if (ds.Tables.Count > 0)
|
|
{
|
|
dsXLXSBJKZXXSZ = ds;
|
|
}
|
|
}
|
|
}
|
|
}
|