47 lines
2.1 KiB
C#
47 lines
2.1 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
|
||
{
|
||
[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
|
||
}
|
||
}
|