934 lines
40 KiB
C#
934 lines
40 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.Utility;
|
|
using GThinking.N_WORKFLOW;
|
|
using GThinking.N_MISPRO;
|
|
using System.Web.Script.Serialization;
|
|
using System.Collections.Generic;
|
|
|
|
namespace GThinking.N_XLXSBJ
|
|
{
|
|
[TableMap(DB = "DBERP", DbTableName = "XLXSCLQD", Umid = 100860034, IsWorkFlow = false, IsAttach = false)]
|
|
|
|
public class CLCB : EntityManager
|
|
{
|
|
}
|
|
|
|
[EntityType(Db = "DBERP", Table = "XLXSCLQD", IsWf = false, IsWhr = false, WhrPrefix = "XLXSCLQD", IsAttach = false)]
|
|
public class CLCB_BDOBill : EntityObject
|
|
{
|
|
#region 属性字段
|
|
|
|
private string _XLXHID;
|
|
[ScriptIgnore]
|
|
public string XLXHID
|
|
{
|
|
get { return _XLXHID; }
|
|
set
|
|
{
|
|
_XLXHID = value;
|
|
_CLCBMX_BDOBill.XLXHID = value;
|
|
}
|
|
}
|
|
|
|
private string _XLGGID;
|
|
[ScriptIgnore]
|
|
public string XLGGID
|
|
{
|
|
get { return _XLGGID; }
|
|
set
|
|
{
|
|
_XLGGID = value;
|
|
_CLCBMX_BDOBill.XLGGID = value;
|
|
}
|
|
}
|
|
|
|
private string _ST;
|
|
[ScriptIgnore]
|
|
public string ST
|
|
{
|
|
get { return _ST; }
|
|
set
|
|
{
|
|
_ST = value;
|
|
_CLCBMX_BDOBill.ST = value;
|
|
}
|
|
}
|
|
|
|
private string _DYDJ;
|
|
[ScriptIgnore]
|
|
public string DYDJ
|
|
{
|
|
get { return _DYDJ; }
|
|
set
|
|
{
|
|
_DYDJ = value;
|
|
_CLCBMX_BDOBill.DYDJ = value;
|
|
}
|
|
}
|
|
|
|
private string _OLD_XLXHID;
|
|
[ScriptIgnore]
|
|
public string OLD_XLXHID
|
|
{
|
|
get { return _OLD_XLXHID; }
|
|
set
|
|
{
|
|
_OLD_XLXHID = value;
|
|
}
|
|
}
|
|
|
|
private string _OLD_XLGGID;
|
|
[ScriptIgnore]
|
|
public string OLD_XLGGID
|
|
{
|
|
get { return _OLD_XLGGID; }
|
|
set
|
|
{
|
|
_OLD_XLGGID = value;
|
|
}
|
|
}
|
|
|
|
private string _OLD_ST;
|
|
[ScriptIgnore]
|
|
public string OLD_ST
|
|
{
|
|
get { return _OLD_ST; }
|
|
set
|
|
{
|
|
_OLD_ST = value;
|
|
}
|
|
}
|
|
|
|
private string _OLD_DYDJ;
|
|
[ScriptIgnore]
|
|
public string OLD_DYDJ
|
|
{
|
|
get { return _OLD_DYDJ; }
|
|
set
|
|
{
|
|
_OLD_DYDJ = value;
|
|
}
|
|
}
|
|
|
|
private bool _isKeyChange;
|
|
public bool isKeyChange
|
|
{
|
|
set
|
|
{
|
|
_isKeyChange = value;
|
|
}
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 控件
|
|
|
|
[DataMember(DbField = "XLXSCLQD_XLXHID", DbTitle = "型号", IsKey = true, DbType = TGtdbType.VarChar,
|
|
Len = 40, IsNullable = false, DefValue = "", CtlName = "cbxXLXHID",
|
|
CtlType = FieldType.CBX)]
|
|
public string XLXSCLQD_XLXHID
|
|
{
|
|
get { return GetField("XLXSCLQD_XLXHID").ToString().Trim(); }
|
|
set { SetField("XLXSCLQD_XLXHID", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLXSCLQD_XLGGID", DbTitle = "规格", IsKey = true, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = false, DefValue = "", CtlName = "txtXLGGID",
|
|
CtlType = FieldType.C)]
|
|
public string XLXSCLQD_XLGGID
|
|
{
|
|
get { return GetField("XLXSCLQD_XLGGID").ToString().Trim(); }
|
|
set { SetField("XLXSCLQD_XLGGID", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLXSCLQD_XLBZID", DbTitle = "标准", IsKey = true, DbType = TGtdbType.VarChar,
|
|
Len = 10, IsNullable = false, DefValue = "", CtlName = "cbxST",
|
|
CtlType = FieldType.CBX)]
|
|
public string XLXSCLQD_XLBZID
|
|
{
|
|
get { return GetField("XLXSCLQD_XLBZID").ToString().Trim(); }
|
|
set { SetField("XLXSCLQD_XLBZID", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLXSCLQD_DYDJID", DbTitle = "电压等级", IsKey = true, DbType = TGtdbType.VarChar,
|
|
Len = 20, IsNullable = true, DefValue = " ", CtlName = "cbxDYDJID",
|
|
CtlType = FieldType.CBX)]
|
|
public string XLXSCLQD_DYDJID
|
|
{
|
|
get { return GetField("XLXSCLQD_DYDJID").ToString().Trim(); }
|
|
set { SetField("XLXSCLQD_DYDJID", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLXSCLQD_XH", DbTitle = "显示顺序", IsKey = false, DbType = TGtdbType.Float,
|
|
Len = 0, IsNullable = true, DefValue = "0", CtlName = "txtXH",
|
|
CtlType = FieldType.F)]
|
|
public string XLXSCLQD_XH
|
|
{
|
|
get { return GetField("XLXSCLQD_XH").ToString().Trim(); }
|
|
set { SetField("XLXSCLQD_XH", value); }
|
|
}
|
|
|
|
//XLXSCLQD_CLCB
|
|
[DataMember(DbField = "XLXSCLQD_CLZL", DbTitle = "材料重量", IsKey = false, DbType = TGtdbType.Float,
|
|
Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtCLZL",
|
|
CtlType = FieldType.F)]
|
|
public string XLXSCLQD_CLZL
|
|
{
|
|
get { return GetField("XLXSCLQD_CLZL").ToString().Trim(); }
|
|
set { SetField("XLXSCLQD_CLZL", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLXSCLQD_JGCZBID", DbTitle = "结构尺重表号", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 10, IsNullable = false, DefValue = "", CtlName = "txtJGCZBID",
|
|
CtlType = FieldType.HiddenField)]
|
|
public string XLXSCLQD_JGCZBID
|
|
{
|
|
get { return GetField("XLXSCLQD_JGCZBID").ToString().Trim(); }
|
|
set { SetField("XLXSCLQD_JGCZBID", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLXSCLQD_JGCZBBBID", DbTitle = "结构尺重表版本号", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 10, IsNullable = false, DefValue = "", CtlName = "txtJGCZBBBID",
|
|
CtlType = FieldType.HiddenField)]
|
|
public string XLXSCLQD_JGCZBBBID
|
|
{
|
|
get { return GetField("XLXSCLQD_JGCZBBBID").ToString().Trim(); }
|
|
set { SetField("XLXSCLQD_JGCZBBBID", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLXSCLQD_BZ", DbTitle = "备注", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtBZ",
|
|
CtlType = FieldType.C)]
|
|
public string XLXSCLQD_BZ
|
|
{
|
|
get { return GetField("XLXSCLQD_BZ").ToString().Trim(); }
|
|
set { SetField("XLXSCLQD_BZ", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLXSCLQD_WHR", DbTitle = "维护人", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 30, IsNullable = true, DefValue = "", CtlName = "txtWHR",
|
|
CtlType = FieldType.C)]
|
|
public string XLXSCLQD_WHR
|
|
{
|
|
get { return GetField("XLXSCLQD_WHR").ToString().Trim(); }
|
|
set { SetField("XLXSCLQD_WHR", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLXSCLQD_WHRID", DbTitle = "维护人工号", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 10, IsNullable = true, DefValue = "", CtlName = "txtWHRID",
|
|
CtlType = FieldType.HiddenField)]
|
|
public string XLXSCLQD_WHRID
|
|
{
|
|
get { return GetField("XLXSCLQD_WHRID").ToString().Trim(); }
|
|
set { SetField("XLXSCLQD_WHRID", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLXSCLQD_WHSJ", DbTitle = "维护时间", IsKey = false, DbType = TGtdbType.DateTime,
|
|
Len = 8, IsNullable = true, DefValue = "", CtlName = "datWHSJ",
|
|
CtlType = FieldType.DT)]
|
|
public string XLXSCLQD_WHSJ
|
|
{
|
|
get { return GetField("XLXSCLQD_WHSJ").ToString().Trim(); }
|
|
set { SetField("XLXSCLQD_WHSJ", value); }
|
|
}
|
|
#endregion
|
|
|
|
#region 继承事件
|
|
|
|
public override TSQL SetDeleteSql()
|
|
{
|
|
TSQL SQL = base.SetDeleteSql();
|
|
SQL.Add("delete from XLXSCLQD where XLXSCLQD_XLXHID = :XLXSCLQD_XLXHID and XLXSCLQD_XLGGID = :XLXSCLQD_XLGGID and XLXSCLQD_XLBZID = :XLXSCLQD_XLBZID and XLXSCLQD_DYDJID=:XLXSCLQD_DYDJID");
|
|
SQL.AddParam("XLXSCLQD_XLXHID", TGtdbType.VarChar, 40, XLXSCLQD_XLXHID);
|
|
SQL.AddParam("XLXSCLQD_XLGGID", TGtdbType.VarChar, 60, XLXSCLQD_XLGGID);
|
|
SQL.AddParam("XLXSCLQD_XLBZID", TGtdbType.VarChar, 10, XLXSCLQD_XLBZID);
|
|
SQL.AddParam("XLXSCLQD_DYDJID", TGtdbType.VarChar, 20, XLXSCLQD_DYDJID);
|
|
return SQL;
|
|
}
|
|
|
|
public override TSQL SetInsertSql()
|
|
{
|
|
TSQL SQL = base.SetInsertSql();
|
|
SQL.Add("insert into XLXSCLQD( ");
|
|
SQL.Add("XLXSCLQD_XLXHID,");
|
|
SQL.Add("XLXSCLQD_XLGGID,");
|
|
SQL.Add("XLXSCLQD_XLBZID,");
|
|
SQL.Add("XLXSCLQD_DYDJID,");
|
|
SQL.Add("XLXSCLQD_CLZL,");
|
|
SQL.Add("XLXSCLQD_CLJGBL01,XLXSCLQD_CLJGBL02,XLXSCLQD_CLJGBL03,XLXSCLQD_CLJGBL04,");
|
|
SQL.Add("XLXSCLQD_CLJGBL05,XLXSCLQD_CLJGBL06,XLXSCLQD_CLJGBL07,XLXSCLQD_CLJGBL08,");
|
|
SQL.Add("XLXSCLQD_CLJGBL09,XLXSCLQD_CLJGBL10,XLXSCLQD_CLJGBL11,XLXSCLQD_CLJGBL12,");
|
|
SQL.Add("XLXSCLQD_CLJGBL13,XLXSCLQD_CLJGBL14,XLXSCLQD_CLJGBL15,XLXSCLQD_CLJGBL16,");
|
|
SQL.Add("XLXSCLQD_CLJGBL17,XLXSCLQD_CLJGBL18,XLXSCLQD_CLJGBL19,XLXSCLQD_CLJGBL20,");
|
|
SQL.Add("XLXSCLQD_CLJGBL21,XLXSCLQD_CLJGBL22,XLXSCLQD_CLJGBL23,XLXSCLQD_CLJGBL24,");
|
|
SQL.Add("XLXSCLQD_CLJGBL25,XLXSCLQD_CLJGBL26,XLXSCLQD_CLJGBL27,XLXSCLQD_CLJGBL28,");
|
|
SQL.Add("XLXSCLQD_CLJGBL29,XLXSCLQD_CLJGBL30,XLXSCLQD_CLJGBL31,XLXSCLQD_CLJGBL32,");
|
|
SQL.Add("XLXSCLQD_CLJGBL33,XLXSCLQD_CLJGBL34,XLXSCLQD_CLJGBL35,XLXSCLQD_CLJGBL36,");
|
|
SQL.Add("XLXSCLQD_CLJGBL37,XLXSCLQD_CLJGBL38,XLXSCLQD_CLJGBL39,XLXSCLQD_CLJGBL40,");
|
|
SQL.Add("XLXSCLQD_CLJGBL41,XLXSCLQD_CLJGBL42,XLXSCLQD_CLJGBL43,XLXSCLQD_CLJGBL44,");
|
|
SQL.Add("XLXSCLQD_CLJGBL45,XLXSCLQD_CLJGBL46,XLXSCLQD_CLJGBL47,XLXSCLQD_CLJGBL48,");
|
|
SQL.Add("XLXSCLQD_CLJGBL49,XLXSCLQD_CLJGBL50,XLXSCLQD_CLJGBL51,XLXSCLQD_CLJGBL52,");
|
|
SQL.Add("XLXSCLQD_CLJGBL53,XLXSCLQD_CLJGBL54,XLXSCLQD_CLJGBL55,XLXSCLQD_CLJGBL56,");
|
|
SQL.Add("XLXSCLQD_CLJGBL57,XLXSCLQD_CLJGBL58,XLXSCLQD_CLJGBL59,XLXSCLQD_CLJGBL60,");
|
|
SQL.Add("XLXSCLQD_CLJGBL61,XLXSCLQD_CLJGBL62,XLXSCLQD_CLJGBL63,XLXSCLQD_CLJGBL64,");
|
|
SQL.Add("XLXSCLQD_CLJGBL65,XLXSCLQD_CLJGBL66,XLXSCLQD_CLJGBL67,XLXSCLQD_CLJGBL68,");
|
|
SQL.Add("XLXSCLQD_CLJGBL69,XLXSCLQD_CLJGBL70,XLXSCLQD_CLJGBL71,XLXSCLQD_CLJGBL72,");
|
|
SQL.Add("XLXSCLQD_CLJGBL73,XLXSCLQD_CLJGBL74,XLXSCLQD_CLJGBL75,XLXSCLQD_CLJGBL76,");
|
|
SQL.Add("XLXSCLQD_CLJGBL77,XLXSCLQD_CLJGBL78,XLXSCLQD_CLJGBL79,XLXSCLQD_CLJGBL80,");
|
|
SQL.Add("XLXSCLQD_BZ,");
|
|
SQL.Add("XLXSCLQD_WHRID,");
|
|
SQL.Add("XLXSCLQD_WHR,");
|
|
SQL.Add("XLXSCLQD_WHSJ,XLXSCLQD_XH,XLXSCLQD_JGCZBID,XLXSCLQD_JGCZBBBID)");
|
|
SQL.Add(" values(");
|
|
SQL.Add(":XLXSCLQD_XLXHID,");
|
|
SQL.Add(":XLXSCLQD_XLGGID,");
|
|
SQL.Add(":XLXSCLQD_XLBZID,");
|
|
SQL.Add(":XLXSCLQD_DYDJID,");
|
|
SQL.Add(":XLXSCLQD_CLZL,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add("1,1,1,1,");
|
|
SQL.Add(":XLXSCLQD_BZ,");
|
|
SQL.Add(":XLXSCLQD_WHRID,");
|
|
SQL.Add(":XLXSCLQD_WHR,");
|
|
SQL.Add(":XLXSCLQD_WHSJ,:XLXSCLQD_XH,:XLXSCLQD_JGCZBID,:XLXSCLQD_JGCZBBBID)");
|
|
return SQL;
|
|
}
|
|
|
|
public override TSQL SetUpdateSql()
|
|
{
|
|
TSQL SQL = base.SetUpdateSql();
|
|
SQL.Add("update XLXSCLQD set ");
|
|
SQL.Add(" XLXSCLQD_XLXHID=:XLXSCLQD_XLXHID,");
|
|
SQL.Add(" XLXSCLQD_XLGGID=:XLXSCLQD_XLGGID,");
|
|
SQL.Add(" XLXSCLQD_XLBZID=:XLXSCLQD_XLBZID,");
|
|
SQL.Add(" XLXSCLQD_DYDJID=:XLXSCLQD_DYDJID,");
|
|
SQL.Add(" XLXSCLQD_CLZL=:XLXSCLQD_CLZL,");
|
|
SQL.Add(" XLXSCLQD_BZ=:XLXSCLQD_BZ, ");
|
|
SQL.Add(" XLXSCLQD_WHR=:XLXSCLQD_WHR, ");
|
|
SQL.Add(" XLXSCLQD_WHRID=:XLXSCLQD_WHRID, ");
|
|
SQL.Add(" XLXSCLQD_WHSJ=:XLXSCLQD_WHSJ,XLXSCLQD_XH=:XLXSCLQD_XH,XLXSCLQD_JGCZBID=:XLXSCLQD_JGCZBID,XLXSCLQD_JGCZBBBID=:XLXSCLQD_JGCZBBBID ");
|
|
SQL.Add(" where XLXSCLQD_XLXHID = :OLD_XLXSCLQD_XLXHID and XLXSCLQD_XLGGID = :OLD_XLXSCLQD_XLGGID and XLXSCLQD_XLBZID=:OLD_XLXSCLQD_XLBZID and XLXSCLQD_DYDJID=:OLD_XLXSCLQD_DYDJID ");
|
|
SQL.AddParam("XLXSCLQD_XLXHID", TGtdbType.VarChar, 40, XLXHID);
|
|
SQL.AddParam("XLXSCLQD_XLGGID", TGtdbType.VarChar, 60, XLGGID);
|
|
SQL.AddParam("XLXSCLQD_XLBZID", TGtdbType.VarChar, 10, ST);
|
|
SQL.AddParam("XLXSCLQD_DYDJID", TGtdbType.VarChar, 20, DYDJ);
|
|
SQL.AddParam("OLD_XLXSCLQD_XLXHID", TGtdbType.VarChar, 40, OLD_XLXHID);
|
|
SQL.AddParam("OLD_XLXSCLQD_XLGGID", TGtdbType.VarChar, 60, OLD_XLGGID);
|
|
SQL.AddParam("OLD_XLXSCLQD_XLBZID", TGtdbType.VarChar, 10, OLD_ST);
|
|
SQL.AddParam("OLD_XLXSCLQD_DYDJID", TGtdbType.VarChar, 20, OLD_DYDJ);
|
|
|
|
return SQL;
|
|
}
|
|
|
|
public override TSQL SetQuerySql()
|
|
{
|
|
TSQL SQL = base.SetQuerySql();
|
|
SQL.Add(" select XLXSCLQD_XLXHID, XLXSCLQD_XLGGID, XLXSCLQD_XLBZID, XLXSCLQD_DYDJID, XLXSCLQD_CLZL, ");
|
|
SQL.Add(" XLXSCLQD_BZ, XLXSCLQD_WHR, XLXSCLQD_WHRID, XLXSCLQD_WHSJ,XLXSCLQD_XH,XLXSCLQD_JGCZBID,XLXSCLQD_JGCZBBBID ");
|
|
SQL.Add(" from XLXSCLQD ");
|
|
SQL.Add(" where 1 = 1 ");
|
|
//增加where条件以及参数的赋值
|
|
return SQL;
|
|
}
|
|
|
|
public override TSQL SetQuerySqlByKey()
|
|
{
|
|
TSQL SQL = base.SetQuerySqlByKey();
|
|
SQL.Add(" select XLXSCLQD_XLXHID, XLXSCLQD_XLGGID, XLXSCLQD_XLBZID, XLXSCLQD_DYDJID, XLXSCLQD_CLZL, ");
|
|
SQL.Add(" XLXSCLQD_BZ, XLXSCLQD_WHR, XLXSCLQD_WHRID, XLXSCLQD_WHSJ,XLXSCLQD_XH,XLXSCLQD_JGCZBID,XLXSCLQD_JGCZBBBID ");
|
|
SQL.Add(" from XLXSCLQD ");
|
|
SQL.Add(" where XLXSCLQD_XLXHID = :XLXSCLQD_XLXHID and XLXSCLQD_XLGGID = :XLXSCLQD_XLGGID and XLXSCLQD_XLBZID=:XLXSCLQD_XLBZID and XLXSCLQD_DYDJID=:XLXSCLQD_DYDJID ");
|
|
SQL.AddParam("XLXSCLQD_XLXHID", TGtdbType.VarChar, 40, _XLXHID);
|
|
SQL.AddParam("XLXSCLQD_XLGGID", TGtdbType.VarChar, 60, _XLGGID);
|
|
SQL.AddParam("XLXSCLQD_XLBZID", TGtdbType.VarChar, 10, _ST);
|
|
SQL.AddParam("XLXSCLQD_DYDJID", TGtdbType.VarChar, 20, _DYDJ);
|
|
return SQL;
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 子实体
|
|
|
|
private CLCBMX_BDOBill _CLCBMX_BDOBill = new CLCBMX_BDOBill();
|
|
|
|
[Association(Name = "XLXSCLQD", DeleteOnNull = true, Storage = "_CLCBMX_BDOBill", OtherKey = "XLXSCLQD_XLXHID", ThisKey = "XLXSCLQD_XLXHID")]
|
|
public CLCBMX_BDOBill CLCBMX
|
|
{
|
|
get { return _CLCBMX_BDOBill; }
|
|
set { _CLCBMX_BDOBill = value; }
|
|
}
|
|
|
|
#endregion
|
|
}
|
|
|
|
[EntityType(Db = "DBERP", Table = "XLXSCLQDMX", IsWf = false, IsWhr = false, WhrPrefix = "XLXSCLQD", IsAttach = false)]
|
|
public class CLCBMX_BDOBill : EntityObject
|
|
{
|
|
#region 属性变量
|
|
|
|
private string _XLXHID;
|
|
|
|
[ScriptIgnore]
|
|
public string XLXHID
|
|
{
|
|
get { return _XLXHID; }
|
|
set { _XLXHID = value; }
|
|
}
|
|
|
|
private string _XLGGID;
|
|
|
|
[ScriptIgnore]
|
|
public string XLGGID
|
|
{
|
|
get { return _XLGGID; }
|
|
set { _XLGGID = value; }
|
|
}
|
|
|
|
private string _ST;
|
|
|
|
[ScriptIgnore]
|
|
public string ST
|
|
{
|
|
get { return _ST; }
|
|
set { _ST = value; }
|
|
}
|
|
|
|
private string _DYDJ;
|
|
|
|
[ScriptIgnore]
|
|
public string DYDJ
|
|
{
|
|
get { return _DYDJ; }
|
|
set { _DYDJ = value; }
|
|
}
|
|
|
|
private string _NewRecord;
|
|
|
|
[ScriptIgnore]
|
|
public string NewRecord
|
|
{
|
|
get { return _NewRecord; }
|
|
set { _NewRecord = value; }
|
|
}
|
|
|
|
private string _sHSJGBZ;
|
|
|
|
[ScriptIgnore]
|
|
public string sHSJGBZ
|
|
{
|
|
get { return _sHSJGBZ; }
|
|
set { _sHSJGBZ = value; }
|
|
}
|
|
#endregion
|
|
|
|
#region 字段属性
|
|
|
|
[DataMember(DbField = "XLXSCLQD_XLXHID", DbTitle = "型号", IsKey = true, DbType = TGtdbType.VarChar,
|
|
Len = 40, IsNullable = false, DefValue = "", CtlName = "txtXLXSCLQD_XLXHID",
|
|
CtlType = FieldType.C)]
|
|
public string XLXSCLQD_XLXHID
|
|
{
|
|
get { return GetField("XLXSCLQD_XLXHID").ToString().Trim(); }
|
|
set { SetField("XLXSCLQD_XLXHID", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLXSCLQD_XLGGID", DbTitle = "规格", IsKey = true, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = false, DefValue = "", CtlName = "txtXLXSCLQD_XLGGID",
|
|
CtlType = FieldType.C)]
|
|
public string XLXSCLQD_XLGGID
|
|
{
|
|
get { return GetField("XLXSCLQD_XLGGID").ToString().Trim(); }
|
|
set { SetField("XLXSCLQD_XLGGID", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLXSCLQD_XLBZID", DbTitle = "标准", IsKey = true, DbType = TGtdbType.VarChar,
|
|
Len = 10, IsNullable = false, DefValue = "", CtlName = "txtXLXSCLQD_XLBZID",
|
|
CtlType = FieldType.C)]
|
|
public string XLXSCLQD_XLBZID
|
|
{
|
|
get { return GetField("XLXSCLQD_XLBZID").ToString().Trim(); }
|
|
set { SetField("XLXSCLQD_XLBZID", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "BJCLID", DbTitle = "材料名称", IsKey = true, DbType = TGtdbType.VarChar,
|
|
Len = 500, IsNullable = false, DefValue = "", CtlName = "txtBJCLID",
|
|
CtlType = FieldType.C)]
|
|
public string BJCLID
|
|
{
|
|
get { return GetField("BJCLID").ToString().Trim(); }
|
|
set { SetField("BJCLID", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "WLXX", DbTitle = "物料信息", IsKey = true, DbType = TGtdbType.VarChar,
|
|
Len = 30, IsNullable = false, DefValue = "", CtlName = "txtWLXX",
|
|
CtlType = FieldType.C)]
|
|
public string WLXX
|
|
{
|
|
get { return GetField("WLXX").ToString().Trim(); }
|
|
set { SetField("WLXX", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "CLJGBL", DbTitle = "材料用量比例", IsKey = false, DbType = TGtdbType.Float,
|
|
IsNullable = true, DefValue = "0", CtlName = "txtCLJGBL",
|
|
CtlType = FieldType.F)]
|
|
public string CLJGBL
|
|
{
|
|
get { return GetField("CLJGBL").ToString().Trim(); }
|
|
set { SetField("CLJGBL", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "CLSL", DbTitle = "材料用量(Kg)", IsKey = false, DbType = TGtdbType.Float,
|
|
Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtCLSL",
|
|
CtlType = FieldType.F)]
|
|
public string CLSL
|
|
{
|
|
get { return GetField("CLSL").ToString().Trim(); }
|
|
set { SetField("CLSL", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "SHL", DbTitle = "材料损耗率(%)", IsKey = false, DbType = TGtdbType.Float,
|
|
Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtSHL",
|
|
CtlType = FieldType.F)]
|
|
public string SHL
|
|
{
|
|
get { return GetField("SHL").ToString().Trim(); }
|
|
set { SetField("SHL", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "CLJG", DbTitle = "材料价格", IsKey = false, DbType = TGtdbType.Float,
|
|
Len = 0, IsNullable = true, DefValue = "0", CtlName = "txtCLJG",
|
|
CtlType = FieldType.F)]
|
|
public string CLJG
|
|
{
|
|
get { return GetField("CLJG").ToString().Trim(); }
|
|
set { SetField("CLJG", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "CLJE", DbTitle = "材料金额", IsKey = false, DbType = TGtdbType.Float,
|
|
Len = 0, IsNullable = true, DefValue = "0", CtlName = "txtCLJE",
|
|
CtlType = FieldType.F)]
|
|
public string CLJE
|
|
{
|
|
get { return GetField("CLJE").ToString().Trim(); }
|
|
set { SetField("CLJE", value); }
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 重载新建，更新，删除,查询sql语句。
|
|
|
|
public override TSQL SetQuerySqlByKey()
|
|
{
|
|
TSQL SQL = base.SetQuerySqlByKey();
|
|
|
|
return SQL;
|
|
}
|
|
|
|
public override TSQL SetQuerySql()
|
|
{
|
|
TSQL SQL = base.SetQuerySql();
|
|
SQL.Clear();
|
|
SQL.Add("select '' as XLXSCLQD_XLXHID,'' as XLXSCLQD_XLGGID,'' as XLXSCLQD_XLBZID,'' as XLXSCLQD_DYDJ,CLQDL,BJCLID ,CLMC,WLXX, CLJGBL, CLSL, SHL, CLJG,CLJE,px ");
|
|
SQL.Add("from( ");
|
|
SetQuerySQLString(SQL);
|
|
SQL.Add(" ) XX ");
|
|
SQL.Add(" order by px,CLQDL ");
|
|
SQL.ParamByName("pRQ").Value = DateTime.Now.ToShortDateString();
|
|
SQL.ParamByName("pXLXHID").Value = XLXHID;
|
|
SQL.ParamByName("pXLGGID").Value = XLGGID;
|
|
SQL.ParamByName("pST").Value = ST;
|
|
SQL.ParamByName("pDYDJ").Value = DYDJ;
|
|
return SQL;
|
|
}
|
|
|
|
private void SetQuerySQLString(TSQL SQL)
|
|
{
|
|
int i;
|
|
if (!string.IsNullOrEmpty(NewRecord) && NewRecord.Equals("Y"))
|
|
{
|
|
|
|
}
|
|
else
|
|
{
|
|
Dictionary<string, string> dicCLHQ = new Dictionary<string, string>();
|
|
Dictionary<string, string> dicWLHQ = new Dictionary<string, string>();
|
|
DataSet dsWLHQ = null;
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL tSql = new TSQL(dberp);
|
|
tSql.Clear();
|
|
tSql.Add("select XLJGCZBLM_CLQDL,XLJGCZBLM_BJCLID,XLXSBJCL_BJHQ");
|
|
tSql.Add(" from XLJGCZBLM");
|
|
tSql.Add(" left join XLXSCLQD on XLXSCLQD_JGCZBID=XLJGCZBLM_JGCZBID and XLXSCLQD_JGCZBBBID = XLJGCZBLM_JGCZBBBID ");
|
|
tSql.Add(" left join XLXSBJCL on XLXSBJCL_BJCLID=XLJGCZBLM_BJCLID");
|
|
tSql.Add(" where XLXSCLQD_XLXHID=:pXLXHID and XLXSCLQD_XLGGID=:pXLGGID and XLXSCLQD_XLBZID=:pXLBZID and XLXSCLQD_DYDJID=:pDYDJID");
|
|
tSql.Add(" and XLXSCLQD_WPID='ZZZZ'");
|
|
tSql.Add(" and isnull(XLJGCZBLM_CLQDL,' ')<>' ' ");
|
|
tSql.Add(" order by XLJGCZBLM_CLQDL");
|
|
tSql.ParamByName("pXLXHID").Value = XLXHID;
|
|
tSql.ParamByName("pXLGGID").Value = XLGGID;
|
|
tSql.ParamByName("pXLBZID").Value = ST;
|
|
tSql.ParamByName("pDYDJID").Value = DYDJ;
|
|
DataSet dsCZB = dberp.OpenDataSet(tSql);
|
|
for (i = 0; i < dsCZB.Tables[0].Rows.Count; i++)
|
|
{
|
|
if (dsCZB.Tables[0].Rows[i]["XLXSBJCL_BJHQ"].ToString().Trim().Equals("1"))//1|材料行情
|
|
dicCLHQ.Add(dsCZB.Tables[0].Rows[i]["XLJGCZBLM_CLQDL"].ToString().Trim(), dsCZB.Tables[0].Rows[i]["XLJGCZBLM_BJCLID"].ToString().Trim());
|
|
else if (dsCZB.Tables[0].Rows[i]["XLXSBJCL_BJHQ"].ToString().Trim().Equals("2"))//2|物料行情
|
|
dicWLHQ.Add(dsCZB.Tables[0].Rows[i]["XLJGCZBLM_CLQDL"].ToString().Trim(), dsCZB.Tables[0].Rows[i]["XLJGCZBLM_BJCLID"].ToString().Trim());
|
|
}
|
|
//存在物料行情材料
|
|
if (dicWLHQ.Keys.Count > 0)
|
|
{
|
|
tSql.Clear();
|
|
tSql.Add("select XLXSCLQD_JGCZBID,XLXSCLQD_JGCZBBBID,XLXSCLQD_JGCZBXH,XLXSCLQD_DRHH");
|
|
tSql.Add(" from XLXSCLQD ");
|
|
tSql.Add(" where XLXSCLQD_XLXHID=:pXLXHID and XLXSCLQD_XLGGID=:pXLGGID and XLXSCLQD_XLBZID=:pXLBZID and XLXSCLQD_DYDJID=:pDYDJID");
|
|
tSql.ParamByName("pXLXHID").Value = XLXHID;
|
|
tSql.ParamByName("pXLGGID").Value = XLGGID;
|
|
tSql.ParamByName("pXLBZID").Value = ST;
|
|
tSql.ParamByName("pDYDJID").Value = DYDJ;
|
|
DataSet dsCZBXL = dberp.OpenDataSet(tSql);
|
|
if (dsCZBXL.Tables[0].Rows.Count > 0)
|
|
{
|
|
string sJGCZBID = dsCZBXL.Tables[0].Rows[0]["XLXSCLQD_JGCZBID"].ToString().Trim();
|
|
string sJGCZBBBID = dsCZBXL.Tables[0].Rows[0]["XLXSCLQD_JGCZBBBID"].ToString().Trim();
|
|
string sJGCZBXH = dsCZBXL.Tables[0].Rows[0]["XLXSCLQD_JGCZBXH"].ToString().Trim();
|
|
string sDRHH = dsCZBXL.Tables[0].Rows[0]["XLXSCLQD_DRHH"].ToString().Trim();
|
|
|
|
tSql.Clear();
|
|
tSql.Add("select ");
|
|
bool bFirst = true;
|
|
foreach (string sCLQDL in dicWLHQ.Keys)
|
|
{
|
|
if (bFirst)
|
|
{
|
|
tSql.Add(string.Format("XLXSCLQDWL_WLID{0},", sCLQDL.Replace("第", "").Replace("列", "")));
|
|
tSql.Add(string.Format(" isnull(c{0}.XLXSWLHQ_WSJG,0) as WSJG{0},", sCLQDL.Replace("第", "").Replace("列", "")));
|
|
tSql.Add(string.Format(" isnull(c{0}.XLXSWLHQ_HSJG,0) as HSJG{0}", sCLQDL.Replace("第", "").Replace("列", "")));
|
|
}
|
|
else
|
|
{
|
|
tSql.Add(string.Format(",XLXSCLQDWL_WLID{0},", sCLQDL.Replace("第", "").Replace("列", "")));
|
|
tSql.Add(string.Format(" isnull(c{0}.XLXSWLHQ_WSJG,0) as WSJG{0},", sCLQDL.Replace("第", "").Replace("列", "")));
|
|
tSql.Add(string.Format(" isnull(c{0}.XLXSWLHQ_HSJG,0) as HSJG{0}", sCLQDL.Replace("第", "").Replace("列", "")));
|
|
}
|
|
bFirst = false;
|
|
}
|
|
tSql.Add(" from XLXSCLQDWL");
|
|
foreach (string sCLQDL in dicWLHQ.Keys)//关联XLXSWLHQ，获取物料行情
|
|
{
|
|
tSql.Add(" left join");
|
|
tSql.Add(" (");
|
|
tSql.Add(" select XLXSWLHQ_WLID,XLXSWLHQ_WSJG,XLXSWLHQ_HSJG");
|
|
tSql.Add(" from XLXSWLHQ,");
|
|
tSql.Add(" (");
|
|
tSql.Add(" select XLXSWLHQ_WLID as WLID,max(XLXSWLHQ_YXQS)as maxYXQS");
|
|
tSql.Add(" from XLXSWLHQ");
|
|
tSql.Add(" where XLXSWLHQ_JGBID=' '");
|
|
tSql.Add(" and XLXSWLHQ_YXQS<=:pRQ and (XLXSWLHQ_YXQZ>=:pRQ or XLXSWLHQ_YXQZ is null)");
|
|
tSql.Add(" group by XLXSWLHQ_WLID");
|
|
tSql.Add(string.Format(") a{0} ", sCLQDL.Replace("第", "").Replace("列", "")));
|
|
tSql.Add(" where XLXSWLHQ_JGBID=' ' and XLXSWLHQ_WLID=WLID and XLXSWLHQ_YXQS=maxYXQS");
|
|
tSql.Add(string.Format(") c{0} on c{0}.XLXSWLHQ_WLID=XLXSCLQDWL_WLID{0} ", sCLQDL.Replace("第", "").Replace("列", "")));
|
|
}
|
|
tSql.Add(" where XLXSCLQDWL_JGCZBID=:pJGCZBID and XLXSCLQDWL_JGCZBBBID=:pJGCZBBBID and XLXSCLQDWL_JGCZBXH =:pJGCZBXH and XLXSCLQDWL_DRHH=:pDRHH");
|
|
tSql.ParamByName("pRQ").Value = DateTime.Now.ToShortDateString().Trim();
|
|
tSql.ParamByName("pJGCZBID").Value = sJGCZBID;
|
|
tSql.ParamByName("pJGCZBBBID").Value = sJGCZBBBID;
|
|
tSql.ParamByName("pJGCZBXH").Value = sJGCZBXH;
|
|
tSql.ParamByName("pDRHH").Value = sDRHH;
|
|
dsWLHQ = dberp.OpenDataSet(tSql);
|
|
}
|
|
}
|
|
|
|
SQL.Add("select substring(XLJGCZBLM_CLQDL,2,2) as CLQDL,XLJGCZBLM_BJCLID as BJCLID,XLXSBJCL_BJCLMC as CLMC, ");
|
|
|
|
//物料信息
|
|
if (dicCLHQ.Count != 0 || dicWLHQ.Count != 0)
|
|
{
|
|
SQL.Add(" case ");
|
|
foreach (string sCLQDL in dicCLHQ.Keys)
|
|
{
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then ' ' ", sCLQDL));
|
|
}
|
|
foreach (string sCLQDL in dicWLHQ.Keys)
|
|
{
|
|
if (dsWLHQ != null && dsWLHQ.Tables[0].Rows.Count > 0)
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then '{1}' ", sCLQDL, GetWLXX(dsWLHQ.Tables[0].Rows[0]["XLXSCLQDWL_WLID" + sCLQDL.Replace("第", "").Replace("列", "")].ToString().Trim())));
|
|
else
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then ' ' ", sCLQDL));
|
|
}
|
|
SQL.Add(" end as WLXX, ");
|
|
}
|
|
else
|
|
{
|
|
SQL.Add(" ' ' as WLXX, ");
|
|
}
|
|
|
|
//材料价格
|
|
if (dicCLHQ.Count != 0 || dicWLHQ.Count != 0)
|
|
{
|
|
SQL.Add(" case ");
|
|
foreach (string sCLQDL in dicCLHQ.Keys)
|
|
{
|
|
if (sHSJGBZ.Equals("Y"))
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then isnull(XLXSCLHQ_HSJG,0.0) ", sCLQDL));
|
|
else
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then isnull(XLXSCLHQ_WSJG,0.0) ", sCLQDL));
|
|
}
|
|
foreach (string sCLQDL in dicWLHQ.Keys)
|
|
{
|
|
if (dsWLHQ != null && dsWLHQ.Tables[0].Rows.Count > 0)
|
|
{
|
|
if (sHSJGBZ.Equals("Y"))
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then {1} ", sCLQDL, dsWLHQ.Tables[0].Rows[0]["HSJG" + sCLQDL.Replace("第", "").Replace("列", "")].ToString().Trim()));
|
|
else
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then {1} ", sCLQDL, dsWLHQ.Tables[0].Rows[0]["WSJG" + sCLQDL.Replace("第", "").Replace("列", "")].ToString().Trim()));
|
|
}
|
|
else
|
|
{
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then 0.0 ", sCLQDL));
|
|
}
|
|
}
|
|
SQL.Add(" end as CLJG, ");
|
|
}
|
|
else
|
|
{
|
|
SQL.Add(" 0 as CLJG, ");
|
|
}
|
|
|
|
//材料数量
|
|
if (dicCLHQ.Count != 0 || dicWLHQ.Count != 0)
|
|
{
|
|
SQL.Add(" case ");
|
|
foreach (string sCLQDL in dicCLHQ.Keys)
|
|
{
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then XLXSCLQD_SL{1} ", sCLQDL, sCLQDL.Replace("第", "").Replace("列", "")));
|
|
}
|
|
foreach (string sCLQDL in dicWLHQ.Keys)
|
|
{
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then XLXSCLQD_SL{1} ", sCLQDL, sCLQDL.Replace("第", "").Replace("列", "")));
|
|
}
|
|
SQL.Add(" end as CLSL, ");
|
|
}
|
|
else
|
|
{
|
|
SQL.Add(" 0 as CLSL, ");
|
|
}
|
|
|
|
//损耗率
|
|
if (dicCLHQ.Count != 0 || dicWLHQ.Count != 0)
|
|
{
|
|
SQL.Add(" case ");
|
|
foreach (string sCLQDL in dicCLHQ.Keys)
|
|
{
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then XLXSCLQD_SHL{1} ", sCLQDL, sCLQDL.Replace("第", "").Replace("列", "")));
|
|
}
|
|
foreach (string sCLQDL in dicWLHQ.Keys)
|
|
{
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then XLXSCLQD_SHL{1} ", sCLQDL, sCLQDL.Replace("第", "").Replace("列", "")));
|
|
}
|
|
SQL.Add(" end as SHL, ");
|
|
}
|
|
else
|
|
{
|
|
SQL.Add(" 0 as SHL, ");
|
|
}
|
|
|
|
//材料用量比例
|
|
if (dicCLHQ.Count != 0 || dicWLHQ.Count != 0)
|
|
{
|
|
SQL.Add(" case ");
|
|
foreach (string sCLQDL in dicCLHQ.Keys)
|
|
{
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then XLXSCLQD_CLJGBL{1} ", sCLQDL, sCLQDL.Replace("第", "").Replace("列", "")));
|
|
}
|
|
foreach (string sCLQDL in dicWLHQ.Keys)
|
|
{
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then XLXSCLQD_CLJGBL{1} ", sCLQDL, sCLQDL.Replace("第", "").Replace("列", "")));
|
|
}
|
|
SQL.Add(" end as CLJGBL, ");
|
|
}
|
|
else
|
|
{
|
|
SQL.Add(" 0 as CLJGBL, ");
|
|
}
|
|
|
|
//材料成本
|
|
if (dicCLHQ.Count != 0 || dicWLHQ.Count != 0)
|
|
{
|
|
SQL.Add(" case ");
|
|
foreach (string sCLQDL in dicCLHQ.Keys)
|
|
{
|
|
if (sHSJGBZ.Equals("Y"))
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then isnull(XLXSCLHQ_HSJG,0.0)*XLXSCLQD_SL{1}*(1+XLXSCLQD_SHL{1}/100)*XLXSCLQD_CLJGBL{1} ", sCLQDL, sCLQDL.Replace("第", "").Replace("列", "")));
|
|
else
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then isnull(XLXSCLHQ_WSJG,0.0)*XLXSCLQD_SL{1}*(1+XLXSCLQD_SHL{1}/100)*XLXSCLQD_CLJGBL{1} ", sCLQDL, sCLQDL.Replace("第", "").Replace("列", "")));
|
|
}
|
|
foreach (string sCLQDL in dicWLHQ.Keys)
|
|
{
|
|
if (dsWLHQ != null && dsWLHQ.Tables[0].Rows.Count > 0)
|
|
{
|
|
if (sHSJGBZ.Equals("Y"))
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then {2}*XLXSCLQD_SL{1}*(1+XLXSCLQD_SHL{1}/100)*XLXSCLQD_CLJGBL{1} ", sCLQDL, sCLQDL.Replace("第", "").Replace("列", ""),
|
|
dsWLHQ.Tables[0].Rows[0]["HSJG" + sCLQDL.Replace("第", "").Replace("列", "")].ToString().Trim()));
|
|
else
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then {2}*XLXSCLQD_SL{1}*(1+XLXSCLQD_SHL{1}/100)*XLXSCLQD_CLJGBL{1} ", sCLQDL, sCLQDL.Replace("第", "").Replace("列", ""),
|
|
dsWLHQ.Tables[0].Rows[0]["WSJG" + sCLQDL.Replace("第", "").Replace("列", "")].ToString().Trim()));
|
|
}
|
|
else
|
|
{
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then 0.0 ", sCLQDL));
|
|
}
|
|
}
|
|
SQL.Add(" end as CLJE, ");
|
|
}
|
|
else
|
|
{
|
|
SQL.Add(" 0 as CLJE, ");
|
|
}
|
|
|
|
//排序
|
|
if (dicCLHQ.Count != 0 || dicWLHQ.Count != 0)
|
|
{
|
|
SQL.Add(" case ");
|
|
foreach (string sCLQDL in dicCLHQ.Keys)
|
|
{
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then ( case when XLXSCLQD_SL{1} = 0 then 0 else 1 end) ", sCLQDL, sCLQDL.Replace("第", "").Replace("列", "")));
|
|
}
|
|
foreach (string sCLQDL in dicWLHQ.Keys)
|
|
{
|
|
SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then ( case when XLXSCLQD_SL{1} = 0 then 0 else 1 end) ", sCLQDL, sCLQDL.Replace("第", "").Replace("列", "")));
|
|
}
|
|
SQL.Add(" end as px ");
|
|
}
|
|
else
|
|
{
|
|
SQL.Add(" 0 as px ");
|
|
}
|
|
|
|
//if (sHSJGBZ.Equals("Y"))
|
|
//{
|
|
// SQL.Add(" isnull(XLXSCLHQ_HSJG,0.0) as CLJG,");
|
|
//}
|
|
//else
|
|
//{
|
|
// SQL.Add(" isnull(XLXSCLHQ_WSJG,0.0) as CLJG,");
|
|
//}
|
|
//for (i = 1; i <= 80; i++)
|
|
//{
|
|
// string sCLQDL = "第" + i.ToString().PadLeft(2, '0') + "列";
|
|
// if (i.ToString().Equals("1"))
|
|
// {
|
|
// SQL.Add(" case ");
|
|
// }
|
|
// SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then XLXSCLQD_SL{1} ", sCLQDL, i.ToString().PadLeft(2, '0')));
|
|
// if (i.ToString().Equals("80"))
|
|
// {
|
|
// SQL.Add(" end as CLSL, ");
|
|
// }
|
|
//}
|
|
//for (i = 1; i <= 80; i++)
|
|
//{
|
|
// string sCLQDL = "第" + i.ToString().PadLeft(2, '0') + "列";
|
|
// if (i.ToString().Equals("1"))
|
|
// {
|
|
// SQL.Add(" case ");
|
|
// }
|
|
// SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then XLXSCLQD_SHL{1} ", sCLQDL, i.ToString().PadLeft(2, '0')));
|
|
// if (i.ToString().Equals("80"))
|
|
// {
|
|
// SQL.Add(" end as SHL, ");
|
|
// }
|
|
//}
|
|
//for (i = 1; i <= 80; i++)
|
|
//{
|
|
// string sCLQDL = "第" + i.ToString().PadLeft(2, '0') + "列";
|
|
// if (i.ToString().Equals("1"))
|
|
// {
|
|
// SQL.Add(" case ");
|
|
// }
|
|
// SQL.Add(string.Format(" when XLJGCZBLM_CLQDL='{0}' then XLXSCLQD_CLJGBL{1} ", sCLQDL, i.ToString().PadLeft(2, '0')));
|
|
// if (i.ToString().Equals("80"))
|
|
// {
|
|
// SQL.Add(" end as CLJGBL ");
|
|
// }
|
|
//}
|
|
SQL.Add(" from XLXSCLQD,XLJGCZBLM ");
|
|
SQL.Add(" left join XLXSBJCL on XLXSBJCL_BJCLID=XLJGCZBLM_BJCLID");
|
|
//SQL.Add(" left join XLJGCZBML on XLJGCZBML_JGCZBID = XLJGCZBLM_JGCZBID");
|
|
SQL.Add(" left join ");
|
|
SQL.Add(" ( ");
|
|
SQL.Add(" select XLXSCLHQ_BJCLID, ");
|
|
if (sHSJGBZ.Equals("Y"))
|
|
{
|
|
SQL.Add(" XLXSCLHQ_HSJG ");
|
|
}
|
|
else
|
|
{
|
|
SQL.Add(" XLXSCLHQ_WSJG ");
|
|
}
|
|
SQL.Add(" from XLXSCLHQ, ");
|
|
SQL.Add(" ( ");
|
|
SQL.Add(" select XLXSCLHQ_BJCLID as BJCLID,max(XLXSCLHQ_YXQS) as maxYXQS ");
|
|
SQL.Add(" from XLXSCLHQ ");
|
|
SQL.Add(" where XLXSCLHQ_JGBID='ZZZZZZZZ' ");
|
|
SQL.Add(" and XLXSCLHQ_YXQS<=:pRQ ");
|
|
SQL.Add(" and (XLXSCLHQ_YXQZ is null or XLXSCLHQ_YXQZ>=:pRQ) ");
|
|
SQL.Add(" group by XLXSCLHQ_BJCLID ");
|
|
SQL.Add(" ) a ");
|
|
SQL.Add(" where XLXSCLHQ_JGBID='ZZZZZZZZ' ");
|
|
SQL.Add(" and XLXSCLHQ_BJCLID=BJCLID ");
|
|
SQL.Add(" and XLXSCLHQ_YXQS=maxYXQS ");
|
|
SQL.Add(" ) b on XLXSCLHQ_BJCLID=XLXSBJCL_BJCLID ");
|
|
|
|
SQL.Add(" where XLJGCZBLM_JGCZBID=XLXSCLQD_JGCZBID and XLXSCLQD_JGCZBBBID = XLJGCZBLM_JGCZBBBID and isnull(XLJGCZBLM_CLQDL,' ')<>' '");
|
|
SQL.Add(" and XLXSCLQD_XLXHID=:pXLXHID and XLXSCLQD_XLGGID=:pXLGGID and XLXSCLQD_XLBZID=:pST and XLXSCLQD_DYDJID=:pDYDJ ");
|
|
}
|
|
|
|
}
|
|
|
|
private string GetWLXX(string sWLID)
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL sql = new TSQL(dberp);
|
|
sql.Add("select WL_MC,WL_GG from WL where WL_WLID=:pWLID");
|
|
sql.ParamByName("pWLID").Value = sWLID.Trim();
|
|
DataSet ds = dberp.OpenDataSet(sql);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
return sWLID.Trim() + "|" + ds.Tables[0].Rows[0]["WL_MC"].ToString().Trim() + "|" + ds.Tables[0].Rows[0]["WL_GG"].ToString().Trim();
|
|
else
|
|
return sWLID.Trim();
|
|
}
|
|
#endregion
|
|
}
|
|
}
|