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;
using System.Collections.Generic;

namespace GThinking.N_XLXSBJ
{
    [EntityType(Db = "DBERP", Table = "XLXSBJDCLCB", IsWf = false, IsWhr = false, IsAttach = false)]

    public class XLBJD_CLYLBL : EntityObject
    {
        public string sBJDID = "";
        public string sXH = "";
        public Dictionary<string, string> DicCLYL = new Dictionary<string, string>();

        public override TSQL SetQuerySql()
        {
            TSQL SQL = base.SetQuerySql();
            SQL.Add("select XLXSBJCL_BJCLID,XLXSBJCL_BJCLMC ");
            if (DicCLYL.Count > 0)
            {
                SQL.Add(" ,case ");
                foreach (string sKey in DicCLYL.Keys)
                {
                    string sYLBL = DicCLYL[sKey].Split('|')[0];
                    SQL.Add(" when XLXSBJCL_BJCLID = '" + sKey + "' then " + sYLBL + " ");
                }
                SQL.Add(" else 0 end as CLYLBL ");
                SQL.Add(" ,case ");
                foreach (string sKey in DicCLYL.Keys)
                {
                    string sCLYL = DicCLYL[sKey].Split('|')[1];
                    SQL.Add(" when XLXSBJCL_BJCLID = '" + sKey + "' then " + sCLYL + " ");
                }
                SQL.Add(" else 0 end as CLYL ");
                SQL.Add(" ,case ");
                foreach (string sKey in DicCLYL.Keys)
                {
                    string sCLJG = DicCLYL[sKey].Split('|')[2];
                    SQL.Add(" when XLXSBJCL_BJCLID = '" + sKey + "' then " + sCLJG + " ");
                }
                SQL.Add(" else 0 end as CLJG ");
            }
            SQL.Add(" from XLXSBJCL ");
            SQL.Add(" where isnull(XLXSBJCL_BJCLMC,' ')<>' ' and ( 1<> 1 ");
            if (DicCLYL.Count > 0)
            {
                foreach (string sKey in DicCLYL.Keys)
                {
                    SQL.Add(" or XLXSBJCL_BJCLID = '" + sKey + "'");
                }
            }
            SQL.Add(" ) order by XLXSBJCL_BJCLID ");
            SQL.ParamByName("pBJDID").Value = sBJDID;
            SQL.ParamByName("pXH").Value = CMISproConvert.StrToFloat(sXH);
            return SQL;
        }

        public override bool Querying(TSQL sql)
        {
            Entites.Columns.Clear();
            Entites.Clear();
            return base.Querying(sql);
        }
    }

    [TableMap(DB = "DBERP", DbTableName = "XLXSBJDCLCB", Umid = 100860010, IsWorkFlow = false, UseWhr = false, IsAttach = false,

    QuerySelSql = "",

    EntitySelSql = "",

    UpdateSql = "",

    InsertSql = " ")]

    public class PLSZ : EntityManager
    {
    }
}