68 lines
3.2 KiB
C#
68 lines
3.2 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Configuration;
|
|
using System.Web;
|
|
using System.Web.Security;
|
|
using System.Web.UI;
|
|
using System.Web.UI.WebControls;
|
|
using System.Web.UI.WebControls.WebParts;
|
|
using System.Web.UI.HtmlControls;
|
|
using GThinking.N_MODEL.Page;
|
|
using GThinking.N_MISPRO.Data;
|
|
|
|
namespace GThinking.N_XLXSBJ
|
|
{
|
|
[TableMap(DB = "DBERP", DbTableName = "XLXSJGBYZZ7", Umid = 100860065, IsWorkFlow = false, UseWhr = false,
|
|
DeleteSql = " delete from XLXSJGBYZZ7 where XLXSJGBYZZ7_JGBID=:XLXSJGBYZZ7_JGBID and XLXSJGBYZZ7_BJCLID=:XLXSJGBYZZ7_BJCLID ")]
|
|
|
|
public class TZYZJJ7Entity : EntityManager
|
|
{
|
|
|
|
}
|
|
|
|
[EntityType(Db = "DBERP", Table = "XLXSJGBYZZ7", IsWf = false, IsWhr = false, WhrPrefix = "", IsAttach = false)]
|
|
public class TZYZJJ7 : EntityObject
|
|
{
|
|
public string sJGBID = "";
|
|
public string PXFS = "0";
|
|
|
|
public override TSQL SetQuerySql()
|
|
{
|
|
TSQL SQL = base.SetQuerySql();
|
|
SQL.Add("select XLXSBJCL_BJCLID,XLXSBJCL_BJCLMC,");
|
|
SQL.Add("isnull(TZYZ_JZ01,0) as TZYZ_JZ01,isnull(TZYZ_JZ02,0) as TZYZ_JZ02,isnull(TZYZ_JZ03,0) as TZYZ_JZ03,");
|
|
SQL.Add("isnull(TZYZ_JZ04,0) as TZYZ_JZ04,isnull(TZYZ_JZ05,0) as TZYZ_JZ05,isnull(TZYZ_JZ06,0) as TZYZ_JZ06,");
|
|
SQL.Add("isnull(TZYZ_JZ07,0) as TZYZ_JZ07,isnull(TZYZ_JZ08,0) as TZYZ_JZ08,isnull(TZYZ_JZ09,0) as TZYZ_JZ09,");
|
|
SQL.Add("isnull(TZYZ_JZ10,0) as TZYZ_JZ10 ");
|
|
SQL.Add(" from XLXSBJCL");
|
|
SQL.Add(" left join");
|
|
SQL.Add(" (");
|
|
SQL.Add(" select XLXSJGBYZZ7_BJCLID,");
|
|
SQL.Add(" sum(case XLXSJGBYZZ7_YZID when 'JZ01' then XLXSJGBYZZ7_YZZ else 0 end) as TZYZ_JZ01,");
|
|
SQL.Add(" sum(case XLXSJGBYZZ7_YZID when 'JZ02' then XLXSJGBYZZ7_YZZ else 0 end) as TZYZ_JZ02,");
|
|
SQL.Add(" sum(case XLXSJGBYZZ7_YZID when 'JZ03' then XLXSJGBYZZ7_YZZ else 0 end) as TZYZ_JZ03,");
|
|
SQL.Add(" sum(case XLXSJGBYZZ7_YZID when 'JZ04' then XLXSJGBYZZ7_YZZ else 0 end) as TZYZ_JZ04,");
|
|
SQL.Add(" sum(case XLXSJGBYZZ7_YZID when 'JZ05' then XLXSJGBYZZ7_YZZ else 0 end) as TZYZ_JZ05,");
|
|
SQL.Add(" sum(case XLXSJGBYZZ7_YZID when 'JZ06' then XLXSJGBYZZ7_YZZ else 0 end) as TZYZ_JZ06,");
|
|
SQL.Add(" sum(case XLXSJGBYZZ7_YZID when 'JZ07' then XLXSJGBYZZ7_YZZ else 0 end) as TZYZ_JZ07,");
|
|
SQL.Add(" sum(case XLXSJGBYZZ7_YZID when 'JZ08' then XLXSJGBYZZ7_YZZ else 0 end) as TZYZ_JZ08,");
|
|
SQL.Add(" sum(case XLXSJGBYZZ7_YZID when 'JZ09' then XLXSJGBYZZ7_YZZ else 0 end) as TZYZ_JZ09,");
|
|
SQL.Add(" sum(case XLXSJGBYZZ7_YZID when 'JZ10' then XLXSJGBYZZ7_YZZ else 0 end) as TZYZ_JZ10 ");
|
|
SQL.Add(" from XLXSJGBYZZ7");
|
|
SQL.Add(" where XLXSJGBYZZ7_JGBID=:pJGBID ");
|
|
SQL.Add(" group by XLXSJGBYZZ7_BJCLID");
|
|
SQL.Add(" ) a on a.XLXSJGBYZZ7_BJCLID=XLXSBJCL_BJCLID");
|
|
|
|
SQL.Add(" where 1=1 and isnull(XLXSBJCL_TYBZ,'N') <> 'Y' ");
|
|
if (PXFS.Equals("0"))
|
|
{
|
|
SQL.Add("order by XLXSBJCL_BJCLID");
|
|
}
|
|
else
|
|
SQL.Add("order by XLXSBJCL_BJCLMC");
|
|
SQL.ParamByName("pJGBID").Value = sJGBID;
|
|
return SQL;
|
|
}
|
|
}
|
|
}
|