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
    {

    }
}