根据钢区读取静态表获取连铸机号

在钢区下拉框下拉时做处理，调用事件，取得机组代码调用后台查询

      private void efcc_no_QueryPopUp(object sender, CancelEventArgs e)
        {

            string unit_code = "";

            if (efdiv_st.EditValue.ToString() == "2")
            {
                unit_code = "LG3";
            }
            else if (efdiv_st.EditValue.ToString() == "3")
            {
                unit_code = "LG2";
            }
            else if (efdiv_st.EditValue.ToString() == "4")
            {
                unit_code = "S009";
            }

            EI.EIInfo inInfo = new EI.EIInfo();
            inInfo.Tables[0].Columns.Add("UNIT_CODE", typeof(string));

            inInfo.Tables[0].Rows.Add();
            inInfo.Tables[0].Rows[0]["UNIT_CODE"] = unit_code;

            EI.EIInfo outBlock = EI.EIManager.Instance.CallService("MA1RM", "pssmma04cc_i", inInfo);

            if (outBlock.sys_info.flag == 0)
            {
                if (outBlock.Tables[0] != null)
                {
                    DataTable dt_unit = outBlock.Tables[0];
                    Common.Utility.SetLookUpEditProperty_code(efcc_no, dt_unit, "CC_DESC", "CC_MACH_NO", true);
                }
            }

            if (efdiv_st.EditValue.ToString() == "1")
            {
                DataTable dt_unit1 = new DataTable();
                DataTable dt_unit2 = new DataTable();

                EI.EIInfo inInfo1 = new EI.EIInfo();
                inInfo1.Tables[0].Columns.Add("UNIT_CODE", typeof(string));

                inInfo1.Tables[0].Rows.Add();
                inInfo1.Tables[0].Rows[0]["UNIT_CODE"] = "S001";

                EI.EIInfo outBlock1 = EI.EIManager.Instance.CallService("MA1RM", "pssmma04cc_i", inInfo1);

                if (outBlock1.sys_info.flag == 0)
                {
                    dt_unit1 = outBlock1.Tables[0];
                }

                EI.EIInfo inInfo2 = new EI.EIInfo();
                inInfo2.Tables[0].Columns.Add("UNIT_CODE", typeof(string));

                inInfo2.Tables[0].Rows.Add();
                inInfo2.Tables[0].Rows[0]["UNIT_CODE"] = "LG1";

                EI.EIInfo outBlock2 = EI.EIManager.Instance.CallService("MA1RM", "pssmma04cc_i", inInfo2);

                if (outBlock2.sys_info.flag == 0)
                {
                    dt_unit2 = outBlock2.Tables[0];
                }

                for (int i = 0; i < dt_unit2.Rows.Count; i++)
                {
                    DataRow dr = dt_unit2.Rows[i];
                    dt_unit1.ImportRow(dr);
                }

                Common.Utility.SetLookUpEditProperty_code(efcc_no, dt_unit1, "CC_DESC", "CC_MACH_NO", true);
            }
        }

后台代码pmomma4cc_i

try
    {
        //获取传入参数
        v_unit_code = bcls_rec->Tables[0].Rows[0]["UNIT_CODE"].ToString().Trim();
        Log::Trace("", __FUNCTION__, "v_unit_code = [{0}]", v_unit_code);
        //设置返回列
        bcls_ret->Tables[0].Columns.Add(DT_STRING, "CC_MACH_NO");            //连铸机号
        bcls_ret->Tables[0].Columns.Add(DT_STRING, "CC_DESC");                //连铸机描述
        bcls_ret->Tables[0].Columns.Add(DT_STRING, "UNIT_CODE");    //机组代码

        sqlstr = "SELECT  CC_MACH_NO,CC_DESC, UNIT_CODE  FROM  PSSMMA.TPSSMMA31  ";
        /*拼接条件语句*/
        if (v_unit_code != "")
        {
            sqlstr += "  WHERE  UNIT_CODE = @unit_code ";
        }

        sqlstr += " GROUP BY CC_MACH_NO,CC_DESC,UNIT_CODE ORDER BY UNIT_CODE ASC,CC_MACH_NO ASC ";

        Log::Trace("", __FUNCTION__, "sqlstr = [{0}]", sqlstr);
        /*给查询SQL赋条件值*/
        CDbCommand cmd_sql(sqlstr, conn);
        cmd_sql.Parameters.Set("unit_code", v_unit_code);
        cmd_sql.ExecuteQuery(bcls_ret->Tables[0]);
        bcls_ret->Tables[0].set_TableName("TPSSMMA31");
    }