82 lines
4.2 KiB
C#
82 lines
4.2 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;
|
|
|
|
namespace GThinking.N_XLXSBJ
|
|
{
|
|
[TableMap(DB = "DBERP", DbTableName = "XLXSCLQD", Umid = 100860002, IsWorkFlow = false, IsAttach = false, UseWhr = true,
|
|
QuerySelSql = "",
|
|
DefaultFilter = " ",
|
|
EntitySelSql = "select XLXSCLQD_XLXHID, XLXSCLQD_XLGGID, XLXSCLQD_XLBZID, XLXSCLQD_DYDJID, XLXSCLQD_CLZL,\r\n"
|
|
//+ " CLQD_SL01, CLQD_SL02, CLQD_SL03, CLQD_SL04, CLQD_SL05, CLQD_SL06, CLQD_SL07, CLQD_SL08, CLQD_SL09, CLQD_SL10, \r\n"
|
|
//+ " CLQD_SL11, CLQD_SL12, CLQD_SL13, CLQD_SL14, CLQD_SL15, CLQD_SL16, CLQD_SL17, CLQD_SL18, CLQD_SL19, CLQD_SL20, \r\n"
|
|
//+ " CLQD_SL21, CLQD_SL22, CLQD_SL23, CLQD_SL24, CLQD_SL25, CLQD_SL26, CLQD_SL27, CLQD_SL28, CLQD_SL29, CLQD_SL30, \r\n"
|
|
+ " XLXSCLQD_BZ, XLXSCLQD_WHR, XLXSCLQD_WHRID, XLXSCLQD_WHSJ\r\n"
|
|
+ " from XLXSCLQD where XLXSCLQD_XLXHID = :XLXSCLQD_XLXHID and XLXSCLQD_XLGGID = :XLXSCLQD_XLGGID and XLXSCLQD_XLBZID=:XLXSCLQD_XLBZID and XLXSCLQD_DYDJID=:XLXSCLQD_DYDJID",
|
|
UpdateSql = "update XLXSCLQD set \r\n"
|
|
+ "XLXSCLQD_XLXHID=:XLXSCLQD_XLXHID,\r\n"
|
|
+ "XLXSCLQD_XLGGID=:XLXSCLQD_XLGGID,\r\n"
|
|
+ "XLXSCLQD_XLBZID=:XLXSCLQD_XLBZID,\r\n"
|
|
+ "XLXSCLQD_DYDJID=:XLXSCLQD_DYDJID,\r\n"
|
|
+ "XLXSCLQD_CLZL=:XLXSCLQD_CLZL,\r\n"
|
|
//+ "CLQD_SL01=:CLQD_SL01,\r\n"
|
|
//+ "CLQD_SL02=:CLQD_SL02,\r\n"
|
|
//+ "CLQD_SL03=:CLQD_SL03,\r\n"
|
|
//+ "CLQD_SL04=:CLQD_SL04,\r\n"
|
|
//+ "CLQD_SL05=:CLQD_SL05,\r\n"
|
|
//+ "CLQD_SL06=:CLQD_SL06,\r\n"
|
|
//+ "CLQD_SL07=:CLQD_SL07,\r\n"
|
|
//+ "CLQD_SL08=:CLQD_SL08,\r\n"
|
|
//+ "CLQD_SL09=:CLQD_SL09,\r\n"
|
|
//+ "CLQD_SL10=:CLQD_SL10,\r\n"
|
|
//+ "CLQD_SL11=:CLQD_SL11,\r\n"
|
|
//+ "CLQD_SL12=:CLQD_SL12,\r\n"
|
|
//+ "CLQD_SL13=:CLQD_SL13,\r\n"
|
|
//+ "CLQD_SL14=:CLQD_SL14,\r\n"
|
|
//+ "CLQD_SL15=:CLQD_SL15,\r\n"
|
|
//+ "CLQD_SL16=:CLQD_SL16,\r\n"
|
|
//+ "CLQD_SL17=:CLQD_SL17,\r\n"
|
|
//+ "CLQD_SL18=:CLQD_SL18,\r\n"
|
|
//+ "CLQD_SL19=:CLQD_SL19,\r\n"
|
|
//+ "CLQD_SL20=:CLQD_SL20,\r\n"
|
|
//+ "CLQD_SL21=:CLQD_SL21,\r\n"
|
|
//+ "CLQD_SL22=:CLQD_SL22,\r\n"
|
|
//+ "CLQD_SL23=:CLQD_SL23,\r\n"
|
|
//+ "CLQD_SL24=:CLQD_SL24,\r\n"
|
|
//+ "CLQD_SL25=:CLQD_SL25,\r\n"
|
|
//+ "CLQD_SL26=:CLQD_SL26,\r\n"
|
|
//+ "CLQD_SL27=:CLQD_SL27,\r\n"
|
|
//+ "CLQD_SL28=:CLQD_SL28,\r\n"
|
|
//+ "CLQD_SL29=:CLQD_SL29,\r\n"
|
|
//+ "CLQD_SL30=:CLQD_SL30,\r\n"
|
|
+ "XLXSCLQD_BZ=:XLXSCLQD_BZ,\r\n"
|
|
+ "XLXSCLQD_WHR=:XLXSCLQD_WHR,\r\n"
|
|
+ "XLXSCLQD_WHRID=:XLXSCLQD_WHRID,\r\n"
|
|
+ "XLXSCLQD_WHSJ=:XLXSCLQD_WHSJ\r\n"
|
|
+ " where XLXSCLQD_XLXHID = :XLXSCLQD_XLXHID and XLXSCLQD_XLGGID = :XLXSCLQD_XLGGID and XLXSCLQD_XLBZID=:XLXSCLQD_XLBZID and XLXSCLQD_DYDJID=:XLXSCLQD_DYDJID ",
|
|
|
|
InsertSql = "insert into XLXSCLQD( XLXSCLQD_XLXHID, XLXSCLQD_XLGGID, XLXSCLQD_XLBZID, XLXSCLQD_DYDJID, XLXSCLQD_CLZL,\r\n"
|
|
//+ "CLQD_SL01, CLQD_SL02, CLQD_SL03, CLQD_SL04, CLQD_SL05, CLQD_SL06, CLQD_SL07, CLQD_SL08, CLQD_SL09, CLQD_SL10,\r\n"
|
|
//+ "CLQD_SL11, CLQD_SL12, CLQD_SL13, CLQD_SL14, CLQD_SL15, CLQD_SL16, CLQD_SL17, CLQD_SL18, CLQD_SL19, CLQD_SL20,\r\n"
|
|
//+ "CLQD_SL21, CLQD_SL22, CLQD_SL23, CLQD_SL24, CLQD_SL25, CLQD_SL26, CLQD_SL27, CLQD_SL28, CLQD_SL29, CLQD_SL30,\r\n"
|
|
+ " XLXSCLQD_BZ, XLXSCLQD_WHR, XLXSCLQD_WHRID, XLXSCLQD_WHSJ)"
|
|
+ " values(:XLXSCLQD_XLXHID, :XLXSCLQD_XLGGID, :XLXSCLQD_XLBZID, :XLXSCLQD_DYDJID, :XLXSCLQD_CLZL,\r\n"
|
|
//+ ":CLQD_SL01, :CLQD_SL02, :CLQD_SL03, :CLQD_SL04, :CLQD_SL05, :CLQD_SL06, :CLQD_SL07, :CLQD_SL08, :CLQD_SL09, :CLQD_SL10,\r\n"
|
|
//+ ":CLQD_SL11, :CLQD_SL12, :CLQD_SL13, :CLQD_SL14, :CLQD_SL15, :CLQD_SL16, :CLQD_SL17, :CLQD_SL18, :CLQD_SL19, :CLQD_SL20,\r\n"
|
|
//+ ":CLQD_SL21, :CLQD_SL22, :CLQD_SL23, :CLQD_SL24, :CLQD_SL25, :CLQD_SL26, :CLQD_SL27, :CLQD_SL28, :CLQD_SL29, :CLQD_SL30,\r\n"
|
|
+ " :XLXSCLQD_BZ, :XLXSCLQD_WHR, :XLXSCLQD_WHRID, :XLXSCLQD_WHSJ)",
|
|
|
|
DeleteSql = "delete from XLXSCLQD where XLXSCLQD_XLXHID = :XLXSCLQD_XLXHID and XLXSCLQD_XLGGID = :XLXSCLQD_XLGGID and XLXSCLQD_XLBZID=:XLXSCLQD_XLBZID and XLXSCLQD_DYDJID=:XLXSCLQD_DYDJID ")]
|
|
public class CLQD : EntityManager
|
|
{
|
|
|
|
}
|
|
}
|