367 lines
16 KiB
C#
367 lines
16 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 System.Collections.Generic;
|
|
using GThinking.N_MISPRO.Data;
|
|
|
|
namespace GThinking.N_XLJC
|
|
{
|
|
[TableMap(DB = "DBERP", DbTableName = "XLDZBZ", Umid = 101421011, IsWorkFlow = false,
|
|
|
|
QuerySelSql = "select XLDZBZ_XH, XLDZBZ_XLCPZLID, XLDZBZ_DZSCXM, XLDZBZ_DZSCYQ, XLDZBZ_WHR, XLDZBZ_WHRID, XLDZBZ_WHSJ "
|
|
+ " from XLDZBZ"
|
|
+ " where XLDZBZ_XLBZID=:XLDZBZ_XLBZID"
|
|
+ " order by XLDZBZ_XH ",
|
|
|
|
EntitySelSql = " select XLDZBZ_XLBZID,XLDZBZ_XH, XLDZBZ_XLCPZLID, XLDZBZ_DZSCXM, XLDZBZ_DZSCYQ, XLDZBZ_WHR, XLDZBZ_WHRID, XLDZBZ_WHSJ "
|
|
+ " from XLDZBZ"
|
|
+ " where XLDZBZ_XLBZID=:XLDZBZ_XLBZID and XLDZBZ_XH=:XLDZBZ_XH ",
|
|
|
|
|
|
UpdateSql = " update XLDZBZ set "
|
|
+ " XLDZBZ_XH = :XLDZBZ_XH, "
|
|
+ " XLDZBZ_XLBZID = :XLDZBZ_XLBZID, "
|
|
+ " XLDZBZ_XLCPZLID = :XLDZBZ_XLCPZLID, "
|
|
+ " XLDZBZ_DZSCXM = :XLDZBZ_DZSCXM, "
|
|
+ " XLDZBZ_DZSCYQ = :XLDZBZ_DZSCYQ, "
|
|
+ " XLDZBZ_WHR = :XLDZBZ_WHR,"
|
|
+ " XLDZBZ_WHRID = :XLDZBZ_WHRID, "
|
|
+ " XLDZBZ_WHSJ = :XLDZBZ_WHSJ "
|
|
+ " where XLDZBZ_XH = :XLDZBZ_OLDXH and XLDZBZ_XLBZID = :XLDZBZ_XLBZID",
|
|
|
|
InsertSql = " insert into XLDZBZ(XLDZBZ_XH, XLDZBZ_XLBZID,XLDZBZ_XLCPZLID, XLDZBZ_DZSCXM, XLDZBZ_DZSCYQ, XLDZBZ_WHR, XLDZBZ_WHRID, XLDZBZ_WHSJ) "
|
|
+ " values( :XLDZBZ_XH, :XLDZBZ_XLBZID, :XLDZBZ_XLCPZLID, :XLDZBZ_DZSCXM, :XLDZBZ_DZSCYQ, :XLDZBZ_WHR, :XLDZBZ_WHRID, :XLDZBZ_WHSJ) ",
|
|
|
|
DeleteSql = " delete from XLDZBZ where XLDZBZ_XH=:XLDZBZ_XH and XLDZBZ_XLBZID = :XLDZBZ_XLBZID")]
|
|
|
|
public class XLDZBZYQ : EntityManager
|
|
{
|
|
private string _XLDZBZ_XH;
|
|
[ColumnMap(DbField = "XLDZBZ_XH", CtrlName = "txtXH", Type = FieldType.F,
|
|
DbTitle = "序号", DefaultValue = "",
|
|
IsAllowNull = false, IsKey = true, Length = 10)]
|
|
public string XLDZBZ_XH
|
|
{
|
|
get { return _XLDZBZ_XH; }
|
|
set { _XLDZBZ_XH = value; }
|
|
}
|
|
|
|
private string _XLDZBZ_XLCPZLID;
|
|
[ColumnMap(DbField = "XLDZBZ_XLCPZLID", CtrlName = "cbxXLCPZLID", Type = FieldType.CBX,
|
|
DbTitle = "线缆产品种类", DefaultValue = "",
|
|
IsAllowNull = false, IsKey = false, Length = 10)]
|
|
public string XLDZBZ_XLCPZLID
|
|
{
|
|
get { return _XLDZBZ_XLCPZLID; }
|
|
set { _XLDZBZ_XLCPZLID = value; }
|
|
}
|
|
|
|
|
|
private string _XLDZBZ_DZSCXM;
|
|
[ColumnMap(DbField = "XLDZBZ_DZSCXM", CtrlName = "cbxDZSCXM", Type = FieldType.CBX,
|
|
DbTitle = "定制生产项目", DefaultValue = "",
|
|
IsAllowNull = false, IsKey = false, Length = 40)]
|
|
public string XLDZBZ_DZSCXM
|
|
{
|
|
get { return _XLDZBZ_DZSCXM; }
|
|
set { _XLDZBZ_DZSCXM = value; }
|
|
}
|
|
|
|
private string _XLDZBZ_DZSCYQ;
|
|
[ColumnMap(DbField = "XLDZBZ_DZSCYQ", CtrlName = "cbxDZSCYQ", Type = FieldType.CBX,
|
|
DbTitle = "定制生产要求", DefaultValue = "",
|
|
IsAllowNull = false, IsKey = false, Length = 250)]
|
|
public string XLDZBZ_DZSCYQ
|
|
{
|
|
get { return _XLDZBZ_DZSCYQ; }
|
|
set { _XLDZBZ_DZSCYQ = value; }
|
|
}
|
|
|
|
// 私有变量维护人
|
|
private string _XLDZBZ_WHR;
|
|
[ColumnMap(DbField = "XLDZBZ_WHR", CtrlName = "txtWHR", Type = FieldType.C,
|
|
DbTitle = "维护人", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string XLDZBZ_WHR
|
|
{
|
|
get { return _XLDZBZ_WHR; }
|
|
set { _XLDZBZ_WHR = value; }
|
|
}
|
|
// 私有变量维护人ID
|
|
private string _XLDZBZ_WHRID;
|
|
[ColumnMap(DbField = "XLDZBZ_WHRID", CtrlName = "txtWHRID", Type = FieldType.HiddenField,
|
|
DbTitle = "维护人工号", DefaultValue = "", PrintVisible = false,
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLDZBZ_WHRID
|
|
{
|
|
get { return _XLDZBZ_WHRID; }
|
|
set { _XLDZBZ_WHRID = value; }
|
|
}
|
|
// 私有变量维护时间
|
|
private string _XLDZBZ_WHSJ;
|
|
[ColumnMap(DbField = "XLDZBZ_WHSJ", CtrlName = "datWHSJ", Type = FieldType.DT,
|
|
DbTitle = "维护时间", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 0)]
|
|
public string XLDZBZ_WHSJ
|
|
{
|
|
get { return _XLDZBZ_WHSJ; }
|
|
set { _XLDZBZ_WHSJ = value; }
|
|
}
|
|
|
|
private string _XLDZBZ_XLBZID;
|
|
[ColumnMap(DbField = "XLDZBZ_XLBZID", CtrlName = "txtXLBZID", Type = FieldType.HiddenField, DbTitle = "定制标准编码", DefaultValue = "",
|
|
IsAllowNull = false, IsKey = true, Length = 10, PrintVisible = false)]
|
|
public string XLDZBZ_XLBZID
|
|
{
|
|
get { return _XLDZBZ_XLBZID; }
|
|
set { _XLDZBZ_XLBZID = value; }
|
|
}
|
|
|
|
private string _XLDZBZ_OLDXH;
|
|
[ColumnMap(DbField = "XLDZBZ_OLDXH", CtrlName = "txtXH_OLD", Type = FieldType.HiddenField, DbTitle = "原序号", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10, PrintVisible = false)]
|
|
public string XLDZBZ_OLDXH
|
|
{
|
|
get { return _XLDZBZ_OLDXH; }
|
|
set { _XLDZBZ_OLDXH = value; }
|
|
}
|
|
|
|
|
|
|
|
public static void GetXLCPZLID(ref Dictionary<string, string> dicXLCPZLID)
|
|
{
|
|
dicXLCPZLID.Clear();
|
|
dicXLCPZLID.Add("DTCP", "导体产品");
|
|
dicXLCPZLID.Add("XXCP", "线芯产品");
|
|
dicXLCPZLID.Add("LXCP", "缆芯产品");
|
|
dicXLCPZLID.Add("XLCP", "线缆产品");
|
|
}
|
|
|
|
public static void GetDZSCXM(ref Dictionary<string, string> dicDZSCXM, string sXLCPZLID)
|
|
{
|
|
dicDZSCXM.Clear();
|
|
if (sXLCPZLID.Equals("DTCP"))
|
|
{
|
|
dicDZSCXM.Add("导体材料", "导体材料");
|
|
dicDZSCXM.Add("导体电阻", "导体电阻");
|
|
dicDZSCXM.Add("导体屏蔽加厚", "导体屏蔽加厚");
|
|
dicDZSCXM.Add("导体形状", "导体形状");
|
|
dicDZSCXM.Add("导体截面", "导体截面");
|
|
}
|
|
else if (sXLCPZLID.Equals("XXCP"))
|
|
{
|
|
dicDZSCXM.Add("挤出方式", "挤出方式");
|
|
dicDZSCXM.Add("绝缘加厚", "绝缘加厚");
|
|
dicDZSCXM.Add("绝缘屏蔽加厚", "绝缘屏蔽加厚");
|
|
}
|
|
else if (sXLCPZLID.Equals("LXCP"))
|
|
{
|
|
dicDZSCXM.Add("编织屏蔽密度", "编织屏蔽密度");
|
|
dicDZSCXM.Add("编织丝大小", "编织丝大小");
|
|
dicDZSCXM.Add("成缆绕包包带", "成缆绕包包带");
|
|
dicDZSCXM.Add("防水要求", "防水要求");
|
|
dicDZSCXM.Add("复合屏蔽", "复合屏蔽");
|
|
dicDZSCXM.Add("绞合方式", "绞合方式");
|
|
dicDZSCXM.Add("铠装材料", "铠装材料");
|
|
dicDZSCXM.Add("铠装钢带厚度", "铠装钢带厚度");
|
|
dicDZSCXM.Add("内护套材料", "内护套材料");
|
|
dicDZSCXM.Add("内护套厚度", "内护套厚度");
|
|
}
|
|
else if (sXLCPZLID.Equals("XLCP"))
|
|
{
|
|
dicDZSCXM.Add("护套厚度", "护套厚度");
|
|
dicDZSCXM.Add("护套要求", "护套要求");
|
|
dicDZSCXM.Add("零线加大", "零线加大");
|
|
dicDZSCXM.Add("零线减小", "零线减小");
|
|
}
|
|
}
|
|
|
|
public static void GetDZSCYQ(ref Dictionary<string, string> dicDZSCYQ, string sXLCPZLID, string DZSCXM)
|
|
{
|
|
dicDZSCYQ.Clear();
|
|
if (sXLCPZLID.Equals("DTCP"))
|
|
{
|
|
if (DZSCXM.Equals("导体材料"))
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL sql = new TSQL(dberp);
|
|
sql.Clear();
|
|
sql.Add("select distinct XLDTCLB_DTCLID,XLDTCLB_WLMC from XLDTCLB where XLDTCLB_WLID=' ' and isnull(XLDTCLB_TYBZ,' ')<>'Y' order by XLDTCLB_DTCLID,XLDTCLB_WLMC ");
|
|
DataSet ds = dberp.OpenDataSet(sql);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
dicDZSCYQ.Add(ds.Tables[0].Rows[i]["XLDTCLB_DTCLID"].ToString().Trim(), ds.Tables[0].Rows[i]["XLDTCLB_WLMC"].ToString().Trim());
|
|
}
|
|
}
|
|
}
|
|
if (DZSCXM.Equals("导体电阻"))
|
|
{
|
|
dicDZSCYQ.Add("优于5%", "优于5%");
|
|
}
|
|
else if (DZSCXM.Equals("导体屏蔽加厚"))
|
|
{
|
|
dicDZSCYQ.Add("0.1", "0.1");
|
|
dicDZSCYQ.Add("0.2", "0.2");
|
|
dicDZSCYQ.Add("0.3", "0.3");
|
|
}
|
|
else if (DZSCXM.Equals("导体形状"))
|
|
{
|
|
dicDZSCYQ.Add("紧压圆形", "紧压圆形");
|
|
dicDZSCYQ.Add("型线", "型线");
|
|
dicDZSCYQ.Add("型线绞合成圆形", "型线绞合成圆形");
|
|
}
|
|
else if (DZSCXM.Equals("导体截面"))
|
|
{
|
|
dicDZSCYQ.Add("±1", "±1");
|
|
}
|
|
|
|
}
|
|
else if (sXLCPZLID.Equals("XXCP"))
|
|
{
|
|
if (DZSCXM.Equals("挤出方式"))
|
|
{
|
|
dicDZSCYQ.Add("挤管式", "挤管式");
|
|
dicDZSCYQ.Add("挤压式", "挤压式");
|
|
dicDZSCYQ.Add("半挤管式", "半挤管式");
|
|
}
|
|
else if (DZSCXM.Equals("绝缘加厚"))
|
|
{
|
|
dicDZSCYQ.Add("0.5", "0.5");
|
|
dicDZSCYQ.Add("1", "1");
|
|
dicDZSCYQ.Add("1.5", "1.5");
|
|
dicDZSCYQ.Add("2", "2");
|
|
}
|
|
else if (DZSCXM.Equals("绝缘屏蔽加厚"))
|
|
{
|
|
dicDZSCYQ.Add("0.1", "0.1");
|
|
dicDZSCYQ.Add("0.2", "0.2");
|
|
dicDZSCYQ.Add("0.3", "0.3");
|
|
}
|
|
|
|
}
|
|
else if (sXLCPZLID.Equals("LXCP"))
|
|
{
|
|
if (DZSCXM.Equals("编织屏蔽密度"))
|
|
{
|
|
dicDZSCYQ.Add("80%", "80%");
|
|
dicDZSCYQ.Add("90%", "90%");
|
|
dicDZSCYQ.Add("70%", "70%");
|
|
dicDZSCYQ.Add("60%", "60%");
|
|
}
|
|
else if (DZSCXM.Equals("编织丝大小"))
|
|
{
|
|
dicDZSCYQ.Add("0.1", "0.1");
|
|
dicDZSCYQ.Add("0.15", "0.15");
|
|
dicDZSCYQ.Add("0.2", "0.2");
|
|
dicDZSCYQ.Add("0.25", "0.25");
|
|
dicDZSCYQ.Add("0.3", "0.3");
|
|
}
|
|
else if (DZSCXM.Equals("成缆绕包包带"))
|
|
{
|
|
dicDZSCYQ.Add("PP带", "PP带");
|
|
dicDZSCYQ.Add("阻燃玻纤带", "阻燃玻纤带");
|
|
dicDZSCYQ.Add("无纺布", "无纺布");
|
|
dicDZSCYQ.Add("聚酯带", "聚酯带");
|
|
}
|
|
else if (DZSCXM.Equals("防水要求"))
|
|
{
|
|
dicDZSCYQ.Add("阻水带", "阻水带");
|
|
dicDZSCYQ.Add("阻水带+铝塑复合带", "阻水带+铝塑复合带");
|
|
}
|
|
else if (DZSCXM.Equals("复合屏蔽"))
|
|
{
|
|
dicDZSCYQ.Add("编织屏蔽+铜(铝)/塑复合带", "编织屏蔽+铜(铝)/塑复合带");
|
|
}
|
|
else if (DZSCXM.Equals("绞合方式"))
|
|
{
|
|
dicDZSCYQ.Add("双绞（对绞）", "双绞（对绞）");
|
|
dicDZSCYQ.Add("要求有分成缆", "要求有分成缆");
|
|
}
|
|
else if (DZSCXM.Equals("铠装材料"))
|
|
{
|
|
dicDZSCYQ.Add("钢带铠装", "钢带铠装");
|
|
dicDZSCYQ.Add("铝带铠装", "铝带铠装");
|
|
dicDZSCYQ.Add("铝合金带铠装", "铝合金带铠装");
|
|
dicDZSCYQ.Add("不锈钢带铠装", "不锈钢带铠装");
|
|
}
|
|
else if (DZSCXM.Equals("铠装钢带厚度"))
|
|
{
|
|
dicDZSCYQ.Add("0.2", "0.2");
|
|
dicDZSCYQ.Add("0.5", "0.5");
|
|
dicDZSCYQ.Add("0.8", "0.8");
|
|
}
|
|
else if (DZSCXM.Equals("内护套材料"))
|
|
{
|
|
dicDZSCYQ.Add("聚乙烯", "聚乙烯");
|
|
dicDZSCYQ.Add("PVC", "PVC");
|
|
dicDZSCYQ.Add("低烟无卤聚烯烃", "低烟无卤聚烯烃");
|
|
}
|
|
else if (DZSCXM.Equals("内护套厚度"))
|
|
{
|
|
dicDZSCYQ.Add("有特殊要求的根据客户特殊要求，无特殊要求的执行国家标准", "有特殊要求的根据客户特殊要求，无特殊要求的执行国家标准");
|
|
}
|
|
}
|
|
else if (sXLCPZLID.Equals("XLCP"))
|
|
{
|
|
if (DZSCXM.Equals("护套厚度"))
|
|
{
|
|
dicDZSCYQ.Add("有特殊要求的根据客户特殊要求，无特殊要求的执行国家标准", "有特殊要求的根据客户特殊要求，无特殊要求的执行国家标准");
|
|
}
|
|
else if (DZSCXM.Equals("护套要求"))
|
|
{
|
|
dicDZSCYQ.Add("阻燃", "阻燃");
|
|
dicDZSCYQ.Add("耐火", "耐火");
|
|
dicDZSCYQ.Add("防鼠", "防鼠");
|
|
dicDZSCYQ.Add("防蚁", "防蚁");
|
|
dicDZSCYQ.Add("耐寒", "耐寒");
|
|
}
|
|
else if (DZSCXM.Equals("零线加大"))
|
|
{
|
|
dicDZSCYQ.Add("16㎜2加大规格至25㎜2", "16㎜2加大规格至25㎜2");
|
|
dicDZSCYQ.Add("25㎜2加大规格至35㎜2", "25㎜2加大规格至35㎜2");
|
|
dicDZSCYQ.Add("35㎜2加大规格至50㎜2", "35㎜2加大规格至50㎜2");
|
|
dicDZSCYQ.Add("50㎜2加大规格至70㎜2", "50㎜2加大规格至70㎜2");
|
|
dicDZSCYQ.Add("70㎜2加大规格至95㎜2", "70㎜2加大规格至95㎜2");
|
|
dicDZSCYQ.Add("70㎜2加大规格至120㎜2", "70㎜2加大规格至120㎜2");
|
|
dicDZSCYQ.Add("95㎜2加大规格至120㎜2", "95㎜2加大规格至120㎜2");
|
|
dicDZSCYQ.Add("95㎜2加大规格至150㎜2", "95㎜2加大规格至150㎜2");
|
|
dicDZSCYQ.Add("120㎜2加大规格150㎜2", "120㎜2加大规格至150㎜2");
|
|
dicDZSCYQ.Add("120㎜2加大规格185㎜2", "120㎜2加大规格至185㎜2");
|
|
dicDZSCYQ.Add("150㎜2加大规格185㎜2", "150㎜2加大规格至185㎜2");
|
|
dicDZSCYQ.Add("150㎜2加大规格240㎜2", "150㎜2加大规格至240㎜2");
|
|
dicDZSCYQ.Add("185㎜2加大规格240㎜2", "185㎜2加大规格至240㎜2");
|
|
dicDZSCYQ.Add("185㎜2加大规格300㎜2", "185㎜2加大规格至300㎜2");
|
|
}
|
|
else if (DZSCXM.Equals("零线减小"))
|
|
{
|
|
dicDZSCYQ.Add("400㎜2减小规格至300㎜2", "400㎜2减小规格至300㎜2");
|
|
dicDZSCYQ.Add("300㎜2减小规格至240㎜2", "300㎜2减小规格至240㎜2");
|
|
dicDZSCYQ.Add("240㎜2减小规格至185㎜2", "240㎜2减小规格至185㎜2");
|
|
dicDZSCYQ.Add("185㎜2减小规格至150㎜2", "185㎜2减小规格至150㎜2");
|
|
dicDZSCYQ.Add("150㎜2减小规格至120㎜2", "150㎜2减小规格至120㎜2");
|
|
dicDZSCYQ.Add("120㎜2减小规格至95㎜2", "120㎜2减小规格至95㎜2");
|
|
dicDZSCYQ.Add("95㎜2减小规格至70㎜2", "95㎜2减小规格至70㎜2");
|
|
dicDZSCYQ.Add("70㎜2减小规格至50㎜2", "70㎜2减小规格至50㎜2");
|
|
dicDZSCYQ.Add("50㎜2减小规格至35㎜2", "50㎜2减小规格至35㎜2");
|
|
dicDZSCYQ.Add("35㎜2减小规格至25㎜2", "35㎜2减小规格至25㎜2");
|
|
dicDZSCYQ.Add("25㎜2减小规格至16㎜2", "25㎜2减小规格至16㎜2");
|
|
dicDZSCYQ.Add("16㎜2减小规格至10㎜2", "16㎜2减小规格至10㎜2");
|
|
dicDZSCYQ.Add("10㎜2减小规格至6㎜2", "10㎜2减小规格至6㎜2");
|
|
dicDZSCYQ.Add("6㎜2减小规格至4㎜2", "6㎜2减小规格至4㎜2");
|
|
dicDZSCYQ.Add("4㎜2减小规格至2.5㎜2", "4㎜2减小规格至2.5㎜2");
|
|
}
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|