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; namespace GThinking.N_XLJC { [TableMap(DB = "DBERP", DbTableName = "XLXHJGCZBML", Umid = 101421008, IsWorkFlow = false, IsAttach = false, UseWhr = false, QuerySelSql = @"select XLXHJGCZBML_JGCZBID,XLXHJGCZBML_JGCZBXH,XLXHJGCZBML_XLXHID,XLXHJGCZBML_DYDJID, XLXHJGCZBML_XLBZID,XLXHJGCZBML_XLBZBH, XLXHJGCZBML_WHRID,XLXHJGCZBML_WHR,XLXHJGCZBML_WHSJ from XLXHJGCZBML where 1 = 1 order by XLXHJGCZBML_JGCZBID", EntitySelSql = @"select XLXHJGCZBML_JGCZBID,XLXHJGCZBML_JGCZBXH,XLXHJGCZBML_XLXHID,XLXHJGCZBML_DYDJID, XLXHJGCZBML_XLBZID,XLXHJGCZBML_XLBZBH, XLXHJGCZBML_WHRID,XLXHJGCZBML_WHR,XLXHJGCZBML_WHSJ from XLXHJGCZBML where XLXHJGCZBML_JGCZBID = :XLXHJGCZBML_JGCZBID and XLXHJGCZBML_JGCZBXH=:XLXHJGCZBML_JGCZBXH", InsertSql = @"insert into XLXHJGCZBML (XLXHJGCZBML_JGCZBID,XLXHJGCZBML_JGCZBXH,XLXHJGCZBML_XLXHID,XLXHJGCZBML_DYDJID, XLXHJGCZBML_XLBZID,XLXHJGCZBML_XLBZBH, XLXHJGCZBML_WHRID,XLXHJGCZBML_WHR,XLXHJGCZBML_WHSJ ) values(:XLXHJGCZBML_JGCZBID,:XLXHJGCZBML_JGCZBXH,:XLXHJGCZBML_XLXHID,:XLXHJGCZBML_DYDJID, :XLXHJGCZBML_XLBZID,:XLXHJGCZBML_XLBZBH, :XLXHJGCZBML_WHRID,:XLXHJGCZBML_WHR,:XLXHJGCZBML_WHSJ )", UpdateSql = @"update XLXHJGCZBML set XLXHJGCZBML_JGCZBID=:XLXHJGCZBML_JGCZBID,XLXHJGCZBML_JGCZBXH=:XLXHJGCZBML_JGCZBXH, XLXHJGCZBML_XLXHID=:XLXHJGCZBML_XLXHID,XLXHJGCZBML_DYDJID=:XLXHJGCZBML_DYDJID, XLXHJGCZBML_XLBZID=:XLXHJGCZBML_XLBZID,XLXHJGCZBML_XLBZBH=:XLXHJGCZBML_XLBZBH, XLXHJGCZBML_WHRID=:XLXHJGCZBML_WHRID,XLXHJGCZBML_WHR=:XLXHJGCZBML_WHR,XLXHJGCZBML_WHSJ=:XLXHJGCZBML_WHSJ where XLXHJGCZBML_JGCZBID = :XLXHJGCZBML_JGCZBID and XLXHJGCZBML_JGCZBXH=:XLXHJGCZBML_JGCZBXH ", DeleteSql = @"delete from XLXHJGCZBML where XLXHJGCZBML_JGCZBID = :XLXHJGCZBML_JGCZBID and XLXHJGCZBML_JGCZBXH=:XLXHJGCZBML_JGCZBXH")] public class XLJGCZB_XHML : EntityManager { private string _XLXHJGCZBML_JGCZBID; [ColumnMap(DbField = "XLXHJGCZBML_JGCZBID", CtrlName = "txtJGCZBID", DbTitle = "表号", Type = FieldType.HiddenField, DefaultValue = "", IsAllowNull = false, IsKey = true, Length = 10)] public string XLXHJGCZBML_JGCZBID { get { return _XLXHJGCZBML_JGCZBID; } set { _XLXHJGCZBML_JGCZBID = value; } } private string _XLXHJGCZBML_JGCZBXH; [ColumnMap(DbField = "XLXHJGCZBML_JGCZBXH", CtrlName = "txtJGCZBXH", DbTitle = "序号", Type = FieldType.F, DefaultValue = "0", IsAllowNull = false, IsKey = false, Length = 0)] public string XLXHJGCZBML_JGCZBXH { get { return _XLXHJGCZBML_JGCZBXH; } set { _XLXHJGCZBML_JGCZBXH = value; } } private string _XLXHJGCZBML_XLXHID; [ColumnMap(DbField = "XLXHJGCZBML_XLXHID", CtrlName = "cbxXLXHID", Type = FieldType.CBX, DbTitle = "线缆型号", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 40)] public string XLXHJGCZBML_XLXHID { get { return _XLXHJGCZBML_XLXHID; } set { _XLXHJGCZBML_XLXHID = value; } } private string _XLXHJGCZBML_DYDJID; [ColumnMap(DbField = "XLXHJGCZBML_DYDJID", CtrlName = "cbxDYDJID", DbTitle = "电压等级", Type = FieldType.CBX, DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 20)] public string XLXHJGCZBML_DYDJID { get { return _XLXHJGCZBML_DYDJID; } set { _XLXHJGCZBML_DYDJID = value; } } private string _XLXHJGCZBML_XLBZID; [ColumnMap(DbField = "XLXHJGCZBML_XLBZID", CtrlName = "cbxXLBZID", DbTitle = "线缆标准", Type = FieldType.CBX, DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 10)] public string XLXHJGCZBML_XLBZID { get { return _XLXHJGCZBML_XLBZID; } set { _XLXHJGCZBML_XLBZID = value; } } private string _XLXHJGCZBML_XLBZBH; [ColumnMap(DbField = "XLXHJGCZBML_XLBZBH", CtrlName = "cbxXLBZBH", DbTitle = "线缆标准编号", Type = FieldType.CBX, DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 60)] public string XLXHJGCZBML_XLBZBH { get { return _XLXHJGCZBML_XLBZBH; } set { _XLXHJGCZBML_XLBZBH = value; } } private string _XLXHJGCZBML_WHR; [ColumnMap(DbField = "XLXHJGCZBML_WHR", CtrlName = "txtWHR", Type = FieldType.C, DbTitle = "维护人", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 30)] public string XLXHJGCZBML_WHR { get { return _XLXHJGCZBML_WHR; } set { _XLXHJGCZBML_WHR = value; } } private string _XLXHJGCZBML_WHRID; [ColumnMap(DbField = "XLXHJGCZBML_WHRID", CtrlName = "txtWHRID", Type = FieldType.HiddenField, DbTitle = "维护人工号", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 10, PrintVisible = false)] public string XLXHJGCZBML_WHRID { get { return _XLXHJGCZBML_WHRID; } set { _XLXHJGCZBML_WHRID = value; } } private string _XLXHJGCZBML_WHSJ; [ColumnMap(DbField = "XLXHJGCZBML_WHSJ", CtrlName = "datWHSJ", Type = FieldType.DT, DbTitle = "维护时间", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 8)] public string XLXHJGCZBML_WHSJ { get { return _XLXHJGCZBML_WHSJ; } set { _XLXHJGCZBML_WHSJ = value; } } public static int getNewXH(string sID) { TDatabase dberp = TContextDatabases.GetDatabase("DBERP"); TSQL SQL = new TSQL(dberp); SQL.Clear(); SQL.Add("select top 1 XLXHJGCZBML_JGCZBXH from XLXHJGCZBML "); SQL.Add(" where XLXHJGCZBML_JGCZBID=:pID and XLXHJGCZBML_JGCZBXH<0 "); SQL.Add(" order by XLXHJGCZBML_JGCZBXH "); SQL.ParamByName("pID").Value = sID; DataSet ds = dberp.OpenDataSet(SQL); if (ds.Tables[0].Rows.Count > 0) { if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0][0].ToString().Trim())) { return CMISproConvert.StrToInt(ds.Tables[0].Rows[0][0].ToString()) - 1; } else { return -1; } } else { return -1; } } //以线缆型号，电压等级，标准，工艺分类，标准编号 五个因素判断重复 ----返回 结构尺重表|结构尺重表名称【序号：XX】 public static string ReJudge(string sXLXHID, string sDYDJID, string sXLBZID, string sGYFLBM, string sXLBZBH, string sJGCZBID) { sGYFLBM = sGYFLBM.Equals("") ? " " : sGYFLBM; TDatabase dberp = TContextDatabases.GetDatabase("DBERP"); TSQL SQL = new TSQL(dberp); SQL.Clear(); string sSQL = string.Format("select XLXHJGCZBML_JGCZBID,XLJGCZBML_JGCZBMC,ABS(XLXHJGCZBML_JGCZBXH) as XLXHJGCZBML_JGCZBXH from XLXHJGCZBML " + " left join XLJGCZBML on XLJGCZBML_JGCZBID = XLXHJGCZBML_JGCZBID WHERE XLXHJGCZBML_JGCZBXH < 0 " + " and XLXHJGCZBML_XLXHID='{0}' and XLXHJGCZBML_DYDJID = '{1}' " + " and XLXHJGCZBML_XLBZID='{2}' and isnull(XLJGCZBML_GYFLBM,' ') = '{3}'" + " and XLXHJGCZBML_XLBZBH='{4}' ", sXLXHID, sDYDJID, sXLBZID, sGYFLBM, sXLBZBH); SQL.Add(sSQL); DataSet dsXLXHJGCZBML = dberp.OpenDataSet(SQL); if (dsXLXHJGCZBML.Tables[0].Rows.Count > 0) { return dsXLXHJGCZBML.Tables[0].Rows[0][0].ToString().Trim() + "|" + dsXLXHJGCZBML.Tables[0].Rows[0][1].ToString().Trim() + "【序号：" + dsXLXHJGCZBML.Tables[0].Rows[0][2].ToString().Trim() + "】"; } else { return ""; } } } }