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
{
    [EntityType(Db = "DBERP", Table = "XLWBBJDMX", IsWf = false, IsWhr = false, WhrPrefix = "", IsAttach = false,
    DocGrpId = "", DocFjs = "")]
    public class BJYF_YJZP : EntityObject
    {
        #region 继承事件

        public string sBJDID = "";
        public string sBJDXH = "";
        public string sXLWJ = "0";
        public string sZXWQBS = "0";
        public string sXZQHID = "";

        public override TSQL SetQuerySql()
        {
            TSQL sql = base.SetQuerySql();
            sql.Add("   select XLXSBJDMXZP_BJDID,XLXSBJDMXZP_BJDXH,'" + sXZQHID + "' as XZQHID," + sXLWJ + " as XLWJ," + sZXWQBS + " as ZXWQBS, XLXSBJDMXZP_ZPXH, XLXSBJDMXZP_DC,XLXSBJDMXZP_DS,  ");
            sql.Add("   case XLXSBJDMXZP_PJCZ  when 'TMP' then 'TMP|铁木盘'  when 'QTP' then 'QTP|全铁盘' when 'QMP' then 'QMP|全木盘'  when 'CKTMP' then 'CKTMP|出口铁木盘' ");
            sql.Add("   when 'JGTMP' then 'JGTMP|加固铁木盘' when 'JGCKTMP' then 'JGCKTMP|加固出口铁木盘' else '' end as XLXSBJDMXZP_PJCZ,");
            sql.Add("   XLXSBJDMXZP_PJWJ,XLXSBJDMXZP_PJNJ,XLXSBJDMXZP_PJKD,");
            sql.Add("   case when XLXSBJDMXZP_PJWJ = 0 then ' ' else rtrim(convert(char,XLXSBJDMXZP_PJWJ))||'×'||rtrim(convert(char,XLXSBJDMXZP_PJNJ))||'×'||rtrim(convert(char,XLXSBJDMXZP_PJKD)) end as PJCC, ");
            sql.Add("   XLXSBJDMXZP_YSFL,XLXSBJDMXZP_WHR,XLXSBJDMXZP_WHSJ ");
            sql.Add("   from XLXSBJDMXZP ");
            sql.Add("   where 1 = 1 ");
            sql.Add("   and XLXSBJDMXZP_BJDID =:XLXSBJDMXZP_BJDID and XLXSBJDMXZP_BJDXH=:XLXSBJDMXZP_BJDXH ");
            sql.ParamByName("XLXSBJDMXZP_BJDID").Value = sBJDID;
            sql.ParamByName("XLXSBJDMXZP_BJDXH").Value = sBJDXH;
            sql.Add("order by XLXSBJDMXZP_ZPXH ");
            return sql;
        }
        #endregion
    }
}