/// <summary> /// 根据工序ID获取工序名称 /// </summary> /// <param name="strGxID">工序ID</param> public string GetGxName(string strGxID) { string strGxName; GZ_GXDZB valGxdzb = new GZ_GXDZB(); GZ_GXDZB conGxdzb = new GZ_GXDZB(); conGxdzb.MESGXID = strGxID; conn = "connMES"; valGxdzb = BLLTable <GZ_GXDZB> .Factory(conn).GetRowData(conGxdzb); strGxName = valGxdzb.MESGXMC; return(strGxName); }
/// <summary> /// 根据权限获取可以查询的工序 /// </summary> /// <returns></returns> private void GetGx(string strcj) { string where = "SELECT DISTINCT MESGXMC,MESGXID FROM GZ_GXDZB WHERE 1=1"; if (!string.IsNullOrEmpty(strcj)) { where = string.Format(" {0} and chejian = '{1}'", where, strcj); } GZ_GXDZB valRgzmx = new GZ_GXDZB(); GZ_GXDZB condRgzmx = new GZ_GXDZB(); conn = "connMEStest"; DataTable dtbGX = BLLTable <GZ_GXDZB> .Factory(conn).qDataTable(where); this.cbGX.DataSource = dtbGX; cbGX.TextField = "MESGXMC"; cbGX.ValueField = "MESGXID"; cbGX.DataBind(); ViewState["gx"] = dtbGX;//dtbRGZMX; }
/// <summary> /// 根据权限获取可以查询的工序 /// </summary> /// <returns></returns> private void GetGx(string strcj) { string where = "SELECT DISTINCT MESGXMC,MESGXID FROM GZ_GXDZB WHERE 1=1"; if (!string.IsNullOrEmpty(strcj)) { where = string.Format(" {0} and chejian = '{1}'", where, strcj); } GZ_GXDZB valRgzmx = new GZ_GXDZB(); GZ_GXDZB condRgzmx = new GZ_GXDZB(); conn = "connMEStest"; DataTable dtbGX = BLLTable<GZ_GXDZB>.Factory(conn).qDataTable(where); this.cbGX.DataSource = dtbGX; cbGX.TextField = "MESGXMC"; cbGX.ValueField = "MESGXID"; cbGX.DataBind(); ViewState["gx"] = dtbGX;//dtbRGZMX; }
/// <summary> /// 根据工序ID获取工序名称 /// </summary> /// <param name="strGxID">工序ID</param> public string GetGxName(string strGxID) { string strGxName; GZ_GXDZB valGxdzb = new GZ_GXDZB(); GZ_GXDZB conGxdzb = new GZ_GXDZB(); conGxdzb.MESGXID = strGxID; conn = "connMES"; valGxdzb = BLLTable<GZ_GXDZB>.Factory(conn).GetRowData(conGxdzb); strGxName = valGxdzb.MESGXMC; return strGxName; }