116 lines
4.5 KiB
C#
116 lines
4.5 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;
|
|
using GThinking.N_MISPRO;
|
|
using GThinking.N_MISPRO.Utility;
|
|
|
|
namespace GThinking.N_XLXSBJ
|
|
{
|
|
[EntityType(Db = "DBERP", Table = "CLYLJSJG", IsWf = false, IsWhr = false, IsAttach = false)]
|
|
|
|
public class CLYL_DRYL : EntityObject
|
|
{
|
|
public string sGCID = "";
|
|
public string sCPPIID = "";
|
|
public string sCPWLID = "";
|
|
public string sCPWLMC = "";
|
|
public string sCPWLGG = "";
|
|
public string sWLID = "";
|
|
public string sWLMC = "";
|
|
public string sWLGG = "";
|
|
public string sFromPage = "";
|
|
|
|
public override TSQL SetQuerySql()
|
|
{
|
|
TSQL SQL = base.SetQuerySql();
|
|
SQL.Add("select CLYLJSJG_GCID,CLYLJSJG_CPWLID,");
|
|
SQL.Add("rtrim(rtrim(rtrim(rtrim(isnull(a.WL_MC,' '))||' '||rtrim(isnull(a.WL_GG,' ')))||' '||rtrim(isnull(a.WL_TZ,' ')))||' '||rtrim(isnull(a.WL_CL,' ')))||'|'||rtrim(isnull(a.WL_JLDW,' ')) as CPWLXX, ");
|
|
SQL.Add(" CLYLJSJG_WLID,");
|
|
SQL.Add("rtrim(rtrim(rtrim(rtrim(isnull(b.WL_MC,' '))||' '||rtrim(isnull(b.WL_GG,' ')))||' '||rtrim(isnull(b.WL_TZ,' ')))||' '||rtrim(isnull(b.WL_CL,' ')))||'|'||rtrim(isnull(b.WL_JLDW,' ')) as WLXX,");
|
|
SQL.Add(" CLYLJSJG_SL as SL, ");
|
|
SQL.Add(" case when isnull(XLXSBJCLWL_BJCLID,' ')=' ' then ' ' else rtrim(XLXSBJCLWL_BJCLID)||'|'||XLXSBJCL_BJCLMC end as BJCL ");
|
|
SQL.Add(" from CLYLJSJG ");
|
|
SQL.Add("left join WL a on a.WL_WLID=CLYLJSJG_CPWLID ");
|
|
SQL.Add("left join WL b on b.WL_WLID=CLYLJSJG_WLID ");
|
|
SQL.Add("left join XLXSBJCLWL on XLXSBJCLWL_WLID=CLYLJSJG_WLID ");
|
|
SQL.Add("left join XLXSBJCL on XLXSBJCL_BJCLID=XLXSBJCLWL_BJCLID ");
|
|
SQL.Add(" where CLYLJSJG_GCID=:pGCID and isnull(XLXSBJCLWL_WLID,' ')<>' ' ");
|
|
SQL.Add(" and isnull(XLXSBJCLWL_BJCLID,' ')<>' ' ");
|
|
if (!sCPPIID.Equals(""))
|
|
{
|
|
SQL.Add(" and " + CMISproDataBase.GetWhereLead("a.WL_PIID", sCPPIID));
|
|
}
|
|
if (sFromPage.Equals("CLYL_CLYLList") || sFromPage.Equals("CLYLList"))
|
|
{
|
|
if (!sCPWLID.Equals(""))
|
|
{
|
|
SQL.Add(" and CLYLJSJG_CPWLID = :pCPWLID ");
|
|
SQL.ParamByName("pCPWLID").Value = sCPWLID;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
if (!sCPWLID.Equals(""))
|
|
{
|
|
SQL.Add(" and CLYLJSJG_CPWLID like :pCPWLID ");
|
|
SQL.ParamByName("pCPWLID").Value = "%" + sCPWLID + "%";
|
|
}
|
|
}
|
|
if (!sCPWLMC.Equals(""))
|
|
{
|
|
SQL.Add(" and a.WL_MC like :pCPWLMC ");
|
|
SQL.ParamByName("pCPWLMC").Value = "%" + sCPWLMC + "%";
|
|
}
|
|
if (!sCPWLGG.Equals(""))
|
|
{
|
|
SQL.Add(" and a.WL_GG like :pCPWLGG ");
|
|
SQL.ParamByName("pCPWLGG").Value = "%" + sCPWLGG + "%";
|
|
}
|
|
if (!sWLID.Equals(""))
|
|
{
|
|
SQL.Add(" and CLYLJSJG_WLID like :pWLID ");
|
|
SQL.ParamByName("pWLID").Value = "%" + sWLID + "%";
|
|
}
|
|
if (!sWLMC.Equals(""))
|
|
{
|
|
SQL.Add(" and b.WL_MC like :pWLMC ");
|
|
SQL.ParamByName("pWLMC").Value = "%" + sWLMC + "%";
|
|
}
|
|
if (!sWLGG.Equals(""))
|
|
{
|
|
SQL.Add(" and b.WL_GG like :pWLGG ");
|
|
SQL.ParamByName("pWLGG").Value = "%" + sWLGG + "%";
|
|
}
|
|
if (sFromPage.Equals("CLYL_CLYLList") || sFromPage.Equals("CLYLList"))
|
|
{
|
|
SQL.Add(" order by CLYLJSJG_GCID,CLYLJSJG_CPWLID,XLXSBJCLWL_BJCLID,CLYLJSJG_WLID ");
|
|
}
|
|
else
|
|
SQL.Add(" order by CLYLJSJG_GCID,CLYLJSJG_CPWLID,CLYLJSJG_WLID ");
|
|
SQL.ParamByName("pGCID").Value = sGCID;
|
|
return SQL;
|
|
}
|
|
|
|
public override bool Querying(TSQL sql)
|
|
{
|
|
Entites.Columns.Clear();
|
|
Entites.Clear();
|
|
return base.Querying(sql);
|
|
}
|
|
}
|
|
|
|
[TableMap(DB = "DBERP", DbTableName = "XLXSCLWLYL", Umid = 100860014, IsWorkFlow = false)]
|
|
public class CLYL_DRYL2 : EntityManager
|
|
{
|
|
|
|
}
|
|
}
|