Exemple #1
0
    /// <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);
    }
Exemple #2
0
    /// <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;
    }
Exemple #3
0
    /// <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;
    }
Exemple #4
0
 /// <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;
 }