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.Utility;
namespace GThinking.N_XLXSBJ
{
#region 数据表级映射
[TableMap(DB = "DBERP", DbTableName = "XLXSCLHQ", Umid = 100860003, IsWorkFlow = false, IsAttach = false, UseWhr = true,
QuerySelSql = "select XLXSBJCL_BJCLID as XLXSCLHQ_BJCLID, XLXSBJCL_BJCLMC, isnull(XLXSCLHQ_WSJG,0.0) as XLXSCLHQ_WSJG,isnull(XLXSCLHQ_HSJG,0.0) as XLXSCLHQ_HSJG, XLXSCLHQ_YXQS," + "\r\n"
+ " XLXSCLHQ_YXQZ,isnull(XLXSCLHQ_BZ, ' ') as XLXSCLHQ_BZ,isnull(XLXSCLHQ_WHRID, ' ') as XLXSCLHQ_WHRID, isnull(XLXSCLHQ_WHR, ' ') as XLXSCLHQ_WHR, XLXSCLHQ_WHSJ, " + "\r\n"
+ " isnull(XLXSCLHQ_HSJGF,0.0) as XLXSCLHQ_HSJGF , isnull(XLXSCLHQ_WSJGF,0.0) as XLXSCLHQ_WSJGF, " + "\r\n"
+ " isnull(XLXSCLHQ_HSCGJG,0.0) as XLXSCLHQ_HSCGJG , isnull(XLXSCLHQ_WSCGJG,0.0) as XLXSCLHQ_WSCGJG, " + "\r\n"
+ " isnull(XLXSCLHQ_WSJG1,0.0) as XLXSCLHQ_WSJG1,isnull(XLXSCLHQ_HSJG1,0.0) as XLXSCLHQ_HSJG1, " + "\r\n"
+ " XLXSCLHQ_JGYBJCLID1,isnull(XLXSCLHQ_JGBL1,0.0) as XLXSCLHQ_JGBL1 " + "\r\n"
+ " from XLXSBJCL " + "\r\n"
+ " left join XLXSCLHQ on XLXSCLHQ_BJCLID = XLXSBJCL_BJCLID" + "\r\n"
+ " where 1=1 and XLXSCLHQ_JGBID ='ZZZZZZZZ' ",
EntitySelSql = " select XLXSCLHQ_JGBID, XLXSBJCL_BJCLID as XLXSCLHQ_BJCLID, XLXSCLHQ_BJCLID as OLD_XLXSCLHQ_BJCLID, XLXSBJCL_BJCLMC, isnull(XLXSCLHQ_WSJG,0.0) as XLXSCLHQ_WSJG,isnull(XLXSCLHQ_HSJG,0.0) as XLXSCLHQ_HSJG, XLXSCLHQ_YXQS,XLXSCLHQ_YXQS as OLD_XLXSCLHQ_YXQS, " + "\r\n"
+ " XLXSCLHQ_YXQZ, isnull(XLXSCLHQ_BZ, ' ') as XLXSCLHQ_BZ, isnull(XLXSCLHQ_WHRID, ' ') as XLXSCLHQ_WHRID, isnull(XLXSCLHQ_WHR, ' ') as XLXSCLHQ_WHR, XLXSCLHQ_WHSJ,isnull(XLXSBJCL_TYBZ,'N') as XLXSBJCL_TYBZ, " + "\r\n"
+ " isnull(XLXSCLHQ_HSJGF,0.0) as XLXSCLHQ_HSJGF , isnull(XLXSCLHQ_WSJGF,0.0) as XLXSCLHQ_WSJGF, " + "\r\n"
+ " isnull(XLXSCLHQ_HSCGJG,0.0) as XLXSCLHQ_HSCGJG , isnull(XLXSCLHQ_WSCGJG,0.0) as XLXSCLHQ_WSCGJG, " + "\r\n"
+ " isnull(XLXSCLHQ_WSJG1,0.0) as XLXSCLHQ_WSJG1,isnull(XLXSCLHQ_HSJG1,0.0) as XLXSCLHQ_HSJG1, " + "\r\n"
+ " XLXSCLHQ_JGYBJCLID1,isnull(XLXSCLHQ_JGBL1,0.0) as XLXSCLHQ_JGBL1 " + "\r\n"
+ " from XLXSBJCL " + "\r\n"
+ " left join XLXSCLHQ on XLXSCLHQ_BJCLID = XLXSBJCL_BJCLID and XLXSCLHQ_YXQS =:OLD_XLXSCLHQ_YXQS and XLXSCLHQ_JGBID ='ZZZZZZZZ' " + "\r\n"
+ " where XLXSBJCL_BJCLID =:OLD_XLXSCLHQ_BJCLID ",
UpdateSql = " update XLXSBJCL set XLXSBJCL_BJCLID = :OLD_XLXSCLHQ_BJCLID where XLXSBJCL_BJCLID=:OLD_XLXSCLHQ_BJCLID " + "\r\n",
InsertSql = " insert into XLXSCLHQ( " + "\r\n"
+ " XLXSCLHQ_BJCLID,XLXSCLHQ_JGBID, XLXSCLHQ_WSJG, XLXSCLHQ_HSJG, XLXSCLHQ_YXQS, XLXSCLHQ_YXQZ, " + "\r\n"
+ " XLXSCLHQ_BZ, XLXSCLHQ_WHRID, XLXSCLHQ_WHR, XLXSCLHQ_WHSJ, XLXSCLHQ_HSJGF, XLXSCLHQ_WSJGF,XLXSCLHQ_HSCGJG,XLXSCLHQ_WSCGJG ) " + "\r\n"
+ " values( " + "\r\n"
+ " :XLXSCLHQ_BJCLID,'ZZZZZZZZ', :XLXSCLHQ_WSJG, :XLXSCLHQ_HSJG, :XLXSCLHQ_YXQS, :XLXSCLHQ_YXQZ, " + "\r\n"
+ " :XLXSCLHQ_BZ, :XLXSCLHQ_WHRID, :XLXSCLHQ_WHR, :XLXSCLHQ_WHSJ, :XLXSCLHQ_HSJGF, :XLXSCLHQ_WSJGF,:XLXSCLHQ_HSCGJG,:XLXSCLHQ_WSCGJG ) ",
DeleteSql = " delete from XLXSCLHQ where XLXSCLHQ_BJCLID =:OLD_XLXSCLHQ_BJCLID and XLXSCLHQ_YXQS =:OLD_XLXSCLHQ_YXQS and XLXSCLHQ_JGBID ='ZZZZZZZZ' ")]
#endregion
public class XLXSCLHQ : EntityManager
{
#region 字段级映射
private string _XLXSCLHQ_JGBID;
[ColumnMap(DbField = "XLXSCLHQ_JGBID", CtrlName = "", DbTitle = "价格表", Type = FieldType.HiddenField, DefaultValue = "",
IsAllowNull = true, IsKey = true, Length = 10)]
public string XLXSCLHQ_JGBID
{
get { return _XLXSCLHQ_JGBID; }
set { _XLXSCLHQ_JGBID = value; }
}
private string _XLXSCLHQ_BJCLID;
[ColumnMap(DbField = "XLXSCLHQ_BJCLID", CtrlName = "txtBJCLID", DbTitle = "材料编码", Type = FieldType.C, DefaultValue = "",
IsAllowNull = false, IsKey = true, Length = 20)]
public string XLXSCLHQ_BJCLID
{
get { return _XLXSCLHQ_BJCLID; }
set { _XLXSCLHQ_BJCLID = value; }
}
private string _OLD_XLXSCLHQ_BJCLID;
[ColumnMap(DbField = "OLD_XLXSCLHQ_BJCLID", CtrlName = "txtOLD_BJCLID", DbTitle = "原材料编码", Type = FieldType.HiddenField, DefaultValue = "",
IsAllowNull = false, IsKey = false, Length = 20, PrintVisible = false)]
public string OLD_XLXSCLHQ_BJCLID
{
get { return _OLD_XLXSCLHQ_BJCLID; }
set { _OLD_XLXSCLHQ_BJCLID = value; }
}
private string _XLXSCLHQ_WSJG;
[ColumnMap(DbField = "XLXSCLHQ_WSJG", CtrlName = "txtWSJG", DbTitle = "材料价格（元/Kg）", Type = FieldType.F, DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 0)]
public string XLXSCLHQ_WSJG
{
get { return _XLXSCLHQ_WSJG; }
set { _XLXSCLHQ_WSJG = value; }
}
private string _XLXSCLHQ_HSJG;
[ColumnMap(DbField = "XLXSCLHQ_HSJG", CtrlName = "txtHSJG", DbTitle = "材料价格（元/Kg）", Type = FieldType.F, DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 0)]
public string XLXSCLHQ_HSJG
{
get { return _XLXSCLHQ_HSJG; }
set { _XLXSCLHQ_HSJG = value; }
}
//加工费
private string _XLXSCLHQ_HSJGF;
[ColumnMap(DbField = "XLXSCLHQ_HSJGF", CtrlName = "txtHSJGF", DbTitle = "含税加工费", Type = FieldType.F, DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 0)]
public string XLXSCLHQ_HSJGF
{
get { return _XLXSCLHQ_HSJGF; }
set { _XLXSCLHQ_HSJGF = value; }
}
private string _XLXSCLHQ_WSJGF;
[ColumnMap(DbField = "XLXSCLHQ_WSJGF", CtrlName = "txtWSJGF", DbTitle = "无税加工费", Type = FieldType.F, DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 0)]
public string XLXSCLHQ_WSJGF
{
get { return _XLXSCLHQ_WSJGF; }
set { _XLXSCLHQ_WSJGF = value; }
}
private string _XLXSCLHQ_HSCGJG;
[ColumnMap(DbField = "XLXSCLHQ_HSCGJG", CtrlName = "txtHSCGJG", DbTitle = "含税采购价格", Type = FieldType.F, DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 0)]
public string XLXSCLHQ_HSCGJG
{
get { return _XLXSCLHQ_HSCGJG; }
set { _XLXSCLHQ_HSCGJG = value; }
}
private string _XLXSCLHQ_WSCGJG;
[ColumnMap(DbField = "XLXSCLHQ_WSCGJG", CtrlName = "txtWSCGJG", DbTitle = "无税采购价格", Type = FieldType.F, DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 0)]
public string XLXSCLHQ_WSCGJG
{
get { return _XLXSCLHQ_WSCGJG; }
set { _XLXSCLHQ_WSCGJG = value; }
}
private string _XLXSCLHQ_YXQS;
[ColumnMap(DbField = "XLXSCLHQ_YXQS", CtrlName = "datYXQS", Type = FieldType.D, DbTitle = "有效期始", DefaultValue = "",
IsAllowNull = false, IsKey = true, Length = 100)]
public string XLXSCLHQ_YXQS
{
get { return _XLXSCLHQ_YXQS; }
set { _XLXSCLHQ_YXQS = value; }
}
private string _OLD_XLXSCLHQ_YXQS;
[ColumnMap(DbField = "OLD_XLXSCLHQ_YXQS", CtrlName = "txtOLD_YXQS", Type = FieldType.HiddenField, DbTitle = "原有效期始", DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 100, PrintVisible = false)]
public string OLD_XLXSCLHQ_YXQS
{
get { return _OLD_XLXSCLHQ_YXQS; }
set { _OLD_XLXSCLHQ_YXQS = value; }
}
private string _XLXSCLHQ_YXQZ;
[ColumnMap(DbField = "XLXSCLHQ_YXQZ", CtrlName = "datYXQZ", Type = FieldType.D, DbTitle = "有效期止", DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 100)]
public string XLXSCLHQ_YXQZ
{
get { return _XLXSCLHQ_YXQZ; }
set { _XLXSCLHQ_YXQZ = value; }
}
private string _XLXSBJCL_TYBZ;
[ColumnMap(DbField = "XLXSBJCL_TYBZ", CtrlName = "txtTYBZ", DbTitle = "停用标志", Type = FieldType.HiddenField, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 1)]
public string XLXSBJCL_TYBZ
{
get { return _XLXSBJCL_TYBZ; }
set { _XLXSBJCL_TYBZ = value; }
}
private string _XLXSCLHQ_BZ;
[ColumnMap(DbField = "XLXSCLHQ_BZ", CtrlName = "txtBZ", DbTitle = "备注", Type = FieldType.C, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 250)]
public string XLXSCLHQ_BZ
{
get { return _XLXSCLHQ_BZ; }
set { _XLXSCLHQ_BZ = value; }
}
private string _XLXSCLHQ_WHR;
[ColumnMap(DbField = "XLXSCLHQ_WHR", CtrlName = "txtWHR", DbTitle = "维护人", Type = FieldType.C, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 30)]
public string XLXSCLHQ_WHR
{
get { return _XLXSCLHQ_WHR; }
set { _XLXSCLHQ_WHR = value; }
}
private string _XLXSCLHQ_WHRID;
[ColumnMap(DbField = "XLXSCLHQ_WHRID", CtrlName = "txtWHRID", DbTitle = "维护人工号", Type = FieldType.HiddenField, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 10)]
public string XLXSCLHQ_WHRID
{
get { return _XLXSCLHQ_WHRID; }
set { _XLXSCLHQ_WHRID = value; }
}
private string _XLXSCLHQ_WHSJ;
[ColumnMap(DbField = "XLXSCLHQ_WHSJ", CtrlName = "datWHSJ", DbTitle = "维护时间", Type = FieldType.DT, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 10)]
public string XLXSCLHQ_WHSJ
{
get { return _XLXSCLHQ_WHSJ; }
set { _XLXSCLHQ_WHSJ = value; }
}
private string _XLXSCLHQ_WSJG1;
[ColumnMap(DbField = "XLXSCLHQ_WSJG1", CtrlName = "txtJGYLWSJG1", DbTitle = "加工原料无税价格1", Type = FieldType.HiddenField, DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 10)]
public string XLXSCLHQ_WSJG1
{
get { return _XLXSCLHQ_WSJG1; }
set { _XLXSCLHQ_WSJG1 = value; }
}
private string _XLXSCLHQ_HSJG1;
[ColumnMap(DbField = "XLXSCLHQ_HSJG1", CtrlName = "txtJGYLHSJG1", DbTitle = "加工原料含税价格1", Type = FieldType.HiddenField, DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 10)]
public string XLXSCLHQ_HSJG1
{
get { return _XLXSCLHQ_HSJG1; }
set { _XLXSCLHQ_HSJG1 = value; }
}
private string _XLXSCLHQ_JGBL1;
[ColumnMap(DbField = "XLXSCLHQ_JGBL1", CtrlName = "txtJGBL1", DbTitle = "价格比例1", Type = FieldType.HiddenField, DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 10)]
public string XLXSCLHQ_JGBL1
{
get { return _XLXSCLHQ_JGBL1; }
set { _XLXSCLHQ_JGBL1 = value; }
}
private string _XLXSCLHQ_JGYBJCLID1;
[ColumnMap(DbField = "XLXSCLHQ_JGYBJCLID1", CtrlName = "txtJGYBJCLID1", DbTitle = "加工原报价材料1", Type = FieldType.HiddenField, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 20)]
public string XLXSCLHQ_JGYBJCLID1
{
get { return _XLXSCLHQ_JGYBJCLID1; }
set { _XLXSCLHQ_JGYBJCLID1 = value; }
}
#endregion
#region 公用函数
///
/// 判断质检单位是否被使用
///
///
///
public static bool isJYDWUsed(string sJYDWID)
{
if (string.IsNullOrEmpty(sJYDWID))
return false;
else
return CMISproDataBase.ExistsRecord("DBERP", string.Format("select 1 from RLMZCY where RLMZCY_CYDWID = '{0}'", sJYDWID));
}
#endregion
}
/****************************历史维护界面*****************************************/
#region 数据表级映射
[TableMap(DB = "DBERP", DbTableName = "XLXSCLHQ", Umid = 100860003, IsWorkFlow = false, IsAttach = false, UseWhr = true,
QuerySelSql = "select isnull(XLXSCLHQ_WSJG,0.0) as HIS_WSJG,isnull(XLXSCLHQ_HSJG,0.0) as HIS_HSJG, XLXSCLHQ_YXQS AS HIS_YXQS," + "\r\n"
+ " XLXSCLHQ_YXQZ as HIS_YXQZ,isnull(XLXSCLHQ_BZ, ' ') as HIS_BZ,isnull(XLXSCLHQ_WHRID, ' ') as HIS_WHRID, isnull(XLXSCLHQ_WHR, ' ') as HIS_WHR, XLXSCLHQ_WHSJ as HIS_WHSJ " + "\r\n"
+ " from XLXSBJCL " + "\r\n"
+ " where 1=1 andXLXSBJCL_BJCLID =:XLXSCLHQ_BJCLID and XLXSCLHQ_JGBID ='ZZZZZZZZ' ",
EntitySelSql = " select isnull(XLXSCLHQ_WSJG,0.0) as HIS_WSJG,isnull(XLXSCLHQ_HSJG,0.0) as HIS_HSJG, ,XLXSCLHQ_YXQS as HIS_YXQS, " + "\r\n"
+ " XLXSCLHQ_YXQZ as HIS_YXQZ, isnull(XLXSCLHQ_BZ, ' ') as HIS_BZ, isnull(XLXSCLHQ_WHRID, ' ') as HIS_WHRID, isnull(XLXSCLHQ_WHR, ' ') as HIS_WHR, XLXSCLHQ_WHSJ as HIS_WHSJ " + "\r\n"
+ " from XLXSBJCL " + "\r\n"
+ " where XLXSBJCL_BJCLID =:XLXSCLHQ_BJCLID and XLXSCLHQ_JGBID ='ZZZZZZZZ' ",
UpdateSql = " ",
InsertSql = " ",
DeleteSql = " ")]
#endregion
public class XLXSCLHQ_HIS : EntityManager
{
}
/*********************************************************************************/
}