Exemplo n.º 1
0
        public override void SPL_View_Lot_List(SPL_View_Lot_List_In_Tag View_Lot_List_In, ref SPL_View_Lot_List_Out_Tag View_Lot_List_Out)
        {
            DataTable adoDataTable = null;

            DB_Common      DBC        = new DB_Common();
            DBC_MWIPLOTSTS MWIPLOTSTS = new DBC_MWIPLOTSTS(ref DBC);

            try
            {
                DBC.gDBConnectionString = StdGlobalVariable.ROXml.GetValue("//appSettings//add[@key='MESConnectionString']");
                //DBC.gDBConnectionString = "Provider=OraOLEDB.Oracle.1;Password=mesmgr_v42;Persist Security Info=True;User ID=mesmgr_v42;Data Source=ORAMES";

                if (DBC.OpenDB() != true)
                {
                    View_Lot_List_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                    return;
                }

                DBC.DB_BeginTransaction();

                MWIPLOTSTS.Init();
                MWIPLOTSTS.LOT_ID = "TESTLOT01";
                if (MWIPLOTSTS.SelectData(1, ref adoDataTable) == false)
                {
                    View_Lot_List_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                    View_Lot_List_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                    DBC.DB_Rollback();
                    return;
                }

                if (MWIPLOTSTS.InsertData() == false)
                {
                    View_Lot_List_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                    View_Lot_List_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                    DBC.DB_Rollback();
                    return;
                }
                View_Lot_List_Out.next_lot_id = "의심하면죽어";
                DBC.DB_Rollback();

                return;
            }
            catch (Exception ex)
            {
                View_Lot_List_Out.h_field_msg = ex.Message;
                return;
            }
            finally
            {
                DBC.DB_Close();
            }

            return;
        }
Exemplo n.º 2
0
        public override void FMB_Resource_Priority(FMB_Resource_Priority_In_Tag Resource_Priority_In, ref FMB_Cmn_Out_Tag Cmn_Out)
        {
            DataTable adoDataTable = null;
            DB_Common DBC          = new DB_Common();

            DBC_MFMBRESLOC MFMBRESLOC = new DBC_MFMBRESLOC(ref DBC);

            try
            {
                DBC.gDBConnectionString = StdGlobalVariable.ROXml.GetValue("//appSettings//add[@key='MESConnectionString']");

                if (DBC.OpenDB() != true)
                {
                    Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                    return;
                }

                DBC.DB_BeginTransaction();

                Cmn_Out.h_status_value = StdGlobalConstant.MP_FAIL;

                MFMBRESLOC.Init();

                MFMBRESLOC.FACTORY   = Resource_Priority_In._C.h_factory;
                MFMBRESLOC.RES_ID    = Resource_Priority_In._C.res_id;
                MFMBRESLOC.RES_TYPE  = Resource_Priority_In._C.res_type.ToString();
                MFMBRESLOC.LAYOUT_ID = Resource_Priority_In._C.layout_id;

                if (MFMBRESLOC.SelectData(1, ref adoDataTable) == false)
                {
                    if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                    {
                        Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                        return;
                    }
                    Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                    Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                    DBC.DB_Rollback();
                    return;
                }

                /*Bring to Front*/
                if (Resource_Priority_In._C.h_proc_step == '1')
                {
                    if (MFMBRESLOC.UpdateData(5) == false)
                    {
                        if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                        {
                            Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                            return;
                        }
                        Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                        Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                        DBC.DB_Rollback();
                        return;
                    }

                    if (MFMBRESLOC.SelectData(3, ref adoDataTable) == false)
                    {
                        if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                        {
                            Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                            return;
                        }
                        Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                        Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                        DBC.DB_Rollback();
                        return;
                    }

                    MFMBRESLOC.SEQ = MFMBRESLOC.SEQ + 1;

                    if (MFMBRESLOC.UpdateData(1) == false)
                    {
                        if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                        {
                            Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                            return;
                        }
                        Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                        Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                        DBC.DB_Rollback();
                        return;
                    }
                }
                /*Send to Back*/
                else if (Resource_Priority_In._C.h_proc_step == '2')
                {
                    if (MFMBRESLOC.UpdateData(6) == false)
                    {
                        if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                        {
                            Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                            return;
                        }
                        Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                        Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                        DBC.DB_Rollback();
                        return;
                    }

                    MFMBRESLOC.SEQ = 1;
                    if (MFMBRESLOC.UpdateData(1) == false)
                    {
                        if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                        {
                            Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                            return;
                        }
                        Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                        Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                        DBC.DB_Rollback();
                        return;
                    }
                }

                Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
            }
            catch (Exception ex)
            {
                Cmn_Out.h_field_msg = ex.Message;
                return;
            }
            finally
            {
                DBC.DB_Close();
            }
        }
Exemplo n.º 3
0
        public override void FMB_View_UDR_Group(FMB_View_UDR_Group_In_Tag View_UDR_Group_In, ref FMB_View_UDR_Group_Out_Tag View_UDR_Group_Out)
        {
            DataTable adoFacTable   = null;
            DataTable adoGroupTable = null;
            DB_Common DBC           = new DB_Common();

            DBC_MWIPFACDEF MWIPFACDEF = new DBC_MWIPFACDEF(ref DBC);
            DBC_MFMBUDRDEF MFMBUDRDEF = new DBC_MFMBUDRDEF(ref DBC);

            try
            {
                DBC.gDBConnectionString = StdGlobalVariable.ROXml.GetValue("//appSettings//add[@key='MESConnectionString']");

                if (DBC.OpenDB() != true)
                {
                    View_UDR_Group_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                    return;
                }

                DBC.DB_BeginTransaction();

                View_UDR_Group_Out.h_status_value = StdGlobalConstant.MP_FAIL;

                MWIPFACDEF.Init();
                MWIPFACDEF.FACTORY = View_UDR_Group_In.h_factory;

                if (MWIPFACDEF.SelectData(1, ref adoFacTable) == false)
                {
                    if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                    {
                        View_UDR_Group_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                        return;
                    }
                    View_UDR_Group_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                    View_UDR_Group_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                    DBC.DB_Rollback();
                    return;
                }

                MFMBUDRDEF.Init();
                MFMBUDRDEF.FACTORY  = View_UDR_Group_In.h_factory;
                MFMBUDRDEF.GROUP_ID = View_UDR_Group_In.group_id;

                if (MFMBUDRDEF.SelectData(1, ref adoGroupTable) == false)
                {
                    if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                    {
                        View_UDR_Group_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                        return;
                    }
                    View_UDR_Group_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                    View_UDR_Group_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                    DBC.DB_Rollback();
                    return;
                }

                View_UDR_Group_Out.group_id    = MFMBUDRDEF.GROUP_ID;
                View_UDR_Group_Out.group_desc  = MFMBUDRDEF.GROUP_DESC;
                View_UDR_Group_Out.create_time = MFMBUDRDEF.CREATE_TIME;
                View_UDR_Group_Out.update_time = MFMBUDRDEF.UPDATE_TIME;
                View_UDR_Group_Out.width       = MFMBUDRDEF.WIDTH;
                View_UDR_Group_Out.height      = MFMBUDRDEF.HEIGHT;

                View_UDR_Group_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
            }
            catch (Exception ex)
            {
                View_UDR_Group_Out.h_field_msg = ex.Message;
                return;
            }
            finally
            {
                DBC.DB_Close();
            }
        }
Exemplo n.º 4
0
        public override void FMB_View_LayOut_List(FMB_View_LayOut_List_In_Tag View_LayOut_List_In, ref FMB_View_LayOut_List_Out_Tag View_LayOut_List_Out)
        {
            int       i            = 0;
            DataTable adoDataTable = null;

            DB_Common      DBC        = new DB_Common();
            DBC_MFMBFACLYT MFMBFACLYT = new DBC_MFMBFACLYT(ref DBC);

            try
            {
                DBC.gDBConnectionString = StdGlobalVariable.ROXml.GetValue("//appSettings//add[@key='MESConnectionString']");

                if (DBC.OpenDB() != true)
                {
                    View_LayOut_List_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                    return;
                }

                DBC.DB_BeginTransaction();

                View_LayOut_List_Out.h_status_value    = StdGlobalConstant.MP_FAIL;
                View_LayOut_List_Out._size_layout_list = 0;
                View_LayOut_List_Out.count             = 0;

                MFMBFACLYT.Init();
                MFMBFACLYT.FACTORY   = View_LayOut_List_In.h_factory;
                MFMBFACLYT.LAYOUT_ID = View_LayOut_List_In.next_layout_id;


                if (MFMBFACLYT.FillData(1, ref adoDataTable) == false)
                {
                    if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                    {
                        View_LayOut_List_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                        return;
                    }
                    View_LayOut_List_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                    View_LayOut_List_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                    DBC.DB_Rollback();
                    return;
                }

                if (adoDataTable.Rows.Count > 0)
                {
                    View_LayOut_List_Out.layout_list = new  FMB_View_LayOut_List_Out_Tag_layout_list[adoDataTable.Rows.Count];
                    for (i = 0; i < adoDataTable.Rows.Count; i++)
                    {
                        if (i == MAX_LAYOUT_LIST)
                        {
                            View_LayOut_List_Out.next_layout_id = adoDataTable.Rows[i]["LAYOUT_ID"].ToString();
                            break;
                        }
                        View_LayOut_List_Out.layout_list[i]             = new FMB_View_LayOut_List_Out_Tag_layout_list();
                        View_LayOut_List_Out.layout_list[i].layout_id   = adoDataTable.Rows[i]["LAYOUT_ID"].ToString();
                        View_LayOut_List_Out.layout_list[i].layout_desc = adoDataTable.Rows[i]["LAYOUT_DESC"].ToString();
                        View_LayOut_List_Out.layout_list[i].width       = Convert.ToInt32(adoDataTable.Rows[i]["WIDTH"]);
                        View_LayOut_List_Out.layout_list[i].height      = Convert.ToInt32(adoDataTable.Rows[i]["HEIGHT"]);
                    }
                }

                View_LayOut_List_Out.count             = i;
                View_LayOut_List_Out._size_layout_list = i;
                View_LayOut_List_Out.h_status_value    = StdGlobalConstant.MP_SUCCESS;
            }
            catch (Exception ex)
            {
                View_LayOut_List_Out.h_field_msg = ex.Message;
                return;
            }
            finally
            {
                DBC.DB_Close();
            }
        }
Exemplo n.º 5
0
        public override void FMB_View_FMB_Group_List(FMB_View_FMB_Group_List_In_Tag View_FMB_Group_List_In, ref FMB_View_FMB_Group_List_Out_Tag View_FMB_Group_List_Out)
        {
            int       i_case, i = 0;
            DataTable adoDataTable = null;

            DB_Common      DBC        = new DB_Common();
            DBC_MFMBGRPUSR MFMBGRPUSR = new DBC_MFMBGRPUSR(ref DBC);
            DBC_MFMBUDRDEF MFMBUDRDEF = new DBC_MFMBUDRDEF(ref DBC);
            DBC_MSECUSRDEF MSECUSRDEF = new DBC_MSECUSRDEF(ref DBC);

            try
            {
                DBC.gDBConnectionString = StdGlobalVariable.ROXml.GetValue("//appSettings//add[@key='MESConnectionString']");

                if (DBC.OpenDB() != true)
                {
                    View_FMB_Group_List_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                    return;
                }

                DBC.DB_BeginTransaction();

                View_FMB_Group_List_Out.h_status_value       = StdGlobalConstant.MP_FAIL;
                View_FMB_Group_List_Out._size_udr_group_list = 0;
                View_FMB_Group_List_Out.count = 0;

                i_case = 0;
                if (View_FMB_Group_List_In.h_proc_step == '1')
                {
                    i_case = 1;
                }
                else if (View_FMB_Group_List_In.h_proc_step == '2')
                {
                    i_case = 2;
                }

                MFMBGRPUSR.Init();
                MFMBGRPUSR.FACTORY  = View_FMB_Group_List_In.h_factory;
                MFMBGRPUSR.GROUP_ID = View_FMB_Group_List_In.next_group;
                MFMBGRPUSR.USER_ID  = View_FMB_Group_List_In.next_user;

                if (MFMBGRPUSR.FillData(i_case, ref adoDataTable) == false)
                {
                    if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                    {
                        View_FMB_Group_List_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                        return;
                    }

                    View_FMB_Group_List_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                    View_FMB_Group_List_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                    DBC.DB_Rollback();
                    return;
                }

                if (adoDataTable.Rows.Count > 0)
                {
                    View_FMB_Group_List_Out.udr_group_list = new  FMB_View_FMB_Group_List_Out_Tag_udr_group_list[adoDataTable.Rows.Count];
                    for (i = 0; i < adoDataTable.Rows.Count; i++)
                    {
                        if (i == MAX_FMB_GROUP_COUNT)
                        {
                            View_FMB_Group_List_Out.next_group = adoDataTable.Rows[i]["GROUP_ID"].ToString();
                            View_FMB_Group_List_Out.next_user  = adoDataTable.Rows[i]["USER_ID"].ToString();
                            break;
                        }

                        View_FMB_Group_List_Out.udr_group_list[i] = new  FMB_View_FMB_Group_List_Out_Tag_udr_group_list();
                        if (View_FMB_Group_List_In.h_proc_step == '1')
                        {
                            View_FMB_Group_List_Out.udr_group_list[i].user = adoDataTable.Rows[i]["USER_ID"].ToString();

                            MSECUSRDEF.Init();
                            MSECUSRDEF.FACTORY = View_FMB_Group_List_In.h_factory;
                            MSECUSRDEF.USER_ID = adoDataTable.Rows[i]["USER_ID"].ToString();
                            MSECUSRDEF.SelectData(i_case, ref adoDataTable);
                            View_FMB_Group_List_Out.udr_group_list[i].user_desc = MSECUSRDEF.USER_DESC;
                        }
                        else if (View_FMB_Group_List_In.h_proc_step == '2')
                        {
                            View_FMB_Group_List_Out.udr_group_list[i].group = adoDataTable.Rows[i]["USER_ID"].ToString();

                            MFMBUDRDEF.Init();
                            MFMBUDRDEF.FACTORY  = View_FMB_Group_List_In.h_factory;
                            MFMBUDRDEF.GROUP_ID = adoDataTable.Rows[i]["USER_ID"].ToString();
                            MFMBUDRDEF.SelectData(i_case, ref adoDataTable);

                            View_FMB_Group_List_Out.udr_group_list[i].group_desc = MFMBUDRDEF.GROUP_DESC;
                        }
                    }
                    i++;
                }

                View_FMB_Group_List_Out.count = i;
                View_FMB_Group_List_Out._size_udr_group_list = i;
                View_FMB_Group_List_Out.h_status_value       = StdGlobalConstant.MP_SUCCESS;
            }
            catch (Exception ex)
            {
                View_FMB_Group_List_Out.h_field_msg = ex.Message;
                return;
            }
            finally
            {
                DBC.DB_Close();
            }
        }
Exemplo n.º 6
0
        public override void FMB_View_Resource_List(FMB_View_Resource_List_In_Tag View_Resource_List_In, ref FMB_View_Resource_List_Out_Tag View_Resource_List_Out)
        {
            int       i, i_case = 0;
            DataTable adoDataTable = null;
            DataTable adoResTable  = null;
            DataTable adoImgTable  = null;

            DB_Common      DBC        = new DB_Common();
            DBC_MRASRESDEF MRASRESDEF = new DBC_MRASRESDEF(ref DBC);
            DBC_MFMBRESIMG MFMBRESIMG = new DBC_MFMBRESIMG(ref DBC);
            DBC_MFMBRESLOC MFMBRESLOC = new DBC_MFMBRESLOC(ref DBC);
            DBC_FMBJOIN    FMBJOIN    = new DBC_FMBJOIN(ref DBC);

            try
            {
                DBC.gDBConnectionString = StdGlobalVariable.ROXml.GetValue("//appSettings//add[@key='MESConnectionString']");

                if (DBC.OpenDB() != true)
                {
                    View_Resource_List_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                    return;
                }

                DBC.DB_BeginTransaction();

                View_Resource_List_Out.h_status_value = StdGlobalConstant.MP_FAIL;
                View_Resource_List_Out._size_res_list = 0;
                View_Resource_List_Out.count          = 0;

                i      = 0;
                i_case = 0;

                if (View_Resource_List_In.h_proc_step == '1')
                {
                    i_case = 1;
                }
                else if (View_Resource_List_In.h_proc_step == '4')
                {
                    i_case = 2;
                }

                if (View_Resource_List_In.h_proc_step == '1' || View_Resource_List_In.h_proc_step == '4')
                {
                    FMBJOIN.Init();
                    FMBJOIN.FACTORY = View_Resource_List_In.h_factory;
                    FMBJOIN.RES_ID  = View_Resource_List_In.next_res_id;


                    if (FMBJOIN.FillResLocList(1, ref adoDataTable) == false)
                    {
                        if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                        {
                            View_Resource_List_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                            return;
                        }
                        View_Resource_List_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                        View_Resource_List_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                        DBC.DB_Rollback();
                        return;
                    }

                    if (adoDataTable.Rows.Count > 0)
                    {
                        View_Resource_List_Out.res_list = new FMB_View_Resource_List_Out_Tag_res_list[adoDataTable.Rows.Count];
                        for (i = 0; i < adoDataTable.Rows.Count; i++)
                        {
                            if (i == MAX_RES_LIST)
                            {
                                View_Resource_List_Out.next_res_id = adoDataTable.Rows[i]["RES_ID"].ToString();
                                break;
                            }

                            MRASRESDEF.Init();
                            MRASRESDEF.FACTORY = View_Resource_List_In.h_factory;
                            MRASRESDEF.RES_ID  = adoDataTable.Rows[i]["RES_ID"].ToString();
                            MRASRESDEF.SelectData(1, ref adoResTable);

                            MFMBRESIMG.Init();
                            MFMBRESIMG.FACTORY = View_Resource_List_In.h_factory;
                            MFMBRESIMG.RES_ID  = adoDataTable.Rows[i]["RES_ID"].ToString();
                            MFMBRESIMG.SelectData(1, ref adoImgTable);

                            View_Resource_List_Out.res_list[i]                  = new FMB_View_Resource_List_Out_Tag_res_list();
                            View_Resource_List_Out.res_list[i].res_id           = adoDataTable.Rows[i]["RES_ID"].ToString();
                            View_Resource_List_Out.res_list[i].res_desc         = adoDataTable.Rows[i]["RES_DESC"].ToString();
                            View_Resource_List_Out.res_list[i].attached_flag    = adoDataTable.Rows[i]["ATTACHED_FLAG"].ToString()[0];
                            View_Resource_List_Out.res_list[i].layout_id        = adoDataTable.Rows[i]["LAYOUT_ID"].ToString();
                            View_Resource_List_Out.res_list[i].res_up_down_flag = adoDataTable.Rows[i]["UP_DOWN_FLAG"].ToString()[0];
                            View_Resource_List_Out.res_list[i].res_type         = MRASRESDEF.RES_TYPE;
                            View_Resource_List_Out.res_list[i].area_id          = MRASRESDEF.AREA_ID;
                            View_Resource_List_Out.res_list[i].sub_area_id      = MRASRESDEF.SUB_AREA_ID;
                            View_Resource_List_Out.res_list[i].res_pri_sts      = MRASRESDEF.RES_PRI_STS;
                            View_Resource_List_Out.res_list[i].res_ctrl_mode    = MRASRESDEF.RES_CTRL_MODE;
                            View_Resource_List_Out.res_list[i].res_proc_mode    = MRASRESDEF.RES_PROC_MODE;
                            View_Resource_List_Out.res_list[i].last_start_time  = MRASRESDEF.LAST_START_TIME;
                            View_Resource_List_Out.res_list[i].last_end_time    = MRASRESDEF.LAST_END_TIME;
                            View_Resource_List_Out.res_list[i].last_down_time   = MRASRESDEF.LAST_DOWN_TIME;
                            View_Resource_List_Out.res_list[i].last_event       = MRASRESDEF.LAST_EVENT_ID;
                            View_Resource_List_Out.res_list[i].last_event_time  = MRASRESDEF.LAST_EVENT_TIME;
                            View_Resource_List_Out.res_list[i].img_idx          = MFMBRESIMG.IMAGE_IDX;
                        }
                    }
                }

                if (View_Resource_List_In.h_proc_step == '2' || View_Resource_List_In.h_proc_step == '3')
                {
                    MRASRESDEF.Init();
                    MRASRESDEF.FACTORY = View_Resource_List_In.h_factory;
                    MRASRESDEF.RES_ID  = View_Resource_List_In.next_res_id;

                    if (MRASRESDEF.FillData(6, ref adoDataTable) == false)
                    {
                        if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                        {
                            View_Resource_List_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                            return;
                        }
                        View_Resource_List_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                        View_Resource_List_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                        DBC.DB_Rollback();
                        return;
                    }

                    if (adoDataTable.Rows.Count > 0)
                    {
                        View_Resource_List_Out.res_list = new FMB_View_Resource_List_Out_Tag_res_list[adoDataTable.Rows.Count];
                        for (i = 0; i < adoDataTable.Rows.Count; i++)
                        {
                            if (i == MAX_RES_LIST)
                            {
                                View_Resource_List_Out.next_res_id = adoDataTable.Rows[i]["RES_ID"].ToString();
                                break;
                            }

                            View_Resource_List_Out.res_list[i]                  = new FMB_View_Resource_List_Out_Tag_res_list();
                            View_Resource_List_Out.res_list[i].res_id           = adoDataTable.Rows[i]["RES_ID"].ToString();
                            View_Resource_List_Out.res_list[i].res_desc         = adoDataTable.Rows[i]["RES_DESC"].ToString();
                            View_Resource_List_Out.res_list[i].res_up_down_flag = adoDataTable.Rows[i]["RES_UP_DOWN_FLAG"].ToString()[0];
                            View_Resource_List_Out.res_list[i].delete_flag      = adoDataTable.Rows[i]["DELETE_FLAG"].ToString()[0];
                        }
                    }
                }

                if (View_Resource_List_In.h_proc_step == '5')
                {
                    MFMBRESLOC.Init();
                    MFMBRESLOC.FACTORY   = View_Resource_List_In.h_factory;
                    MFMBRESLOC.RES_ID    = View_Resource_List_In.next_res_id;
                    MFMBRESLOC.LAYOUT_ID = View_Resource_List_In.layout_id;

                    if (MFMBRESLOC.FillData(2, ref adoDataTable) == false)
                    {
                        if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                        {
                            View_Resource_List_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                            return;
                        }
                        View_Resource_List_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                        View_Resource_List_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                        DBC.DB_Rollback();
                        return;
                    }

                    if (adoDataTable.Rows.Count > 0)
                    {
                        View_Resource_List_Out.res_list = new FMB_View_Resource_List_Out_Tag_res_list[adoDataTable.Rows.Count];
                        for (i = 0; i < adoDataTable.Rows.Count; i++)
                        {
                            if (i == MAX_RES_LIST)
                            {
                                View_Resource_List_Out.next_res_id = adoDataTable.Rows[i]["RES_ID"].ToString();
                                break;
                            }

                            MRASRESDEF.Init();
                            MRASRESDEF.FACTORY = View_Resource_List_In.h_factory;
                            MRASRESDEF.RES_ID  = adoDataTable.Rows[i]["RES_ID"].ToString();
                            MRASRESDEF.SelectData(1, ref adoResTable);

                            View_Resource_List_Out.res_list[i]                  = new FMB_View_Resource_List_Out_Tag_res_list();
                            View_Resource_List_Out.res_list[i].res_id           = adoDataTable.Rows[i]["RES_ID"].ToString();
                            View_Resource_List_Out.res_list[i].res_desc         = adoDataTable.Rows[i]["RES_DESC"].ToString();
                            View_Resource_List_Out.res_list[i].res_up_down_flag = adoDataTable.Rows[i]["RES_UP_DOWN_FLAG"].ToString()[0];
                        }
                    }
                }

                View_Resource_List_Out.count          = i;
                View_Resource_List_Out._size_res_list = i;
                View_Resource_List_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
            }
            catch (Exception ex)
            {
                View_Resource_List_Out.h_field_msg = ex.Message;
                return;
            }
            finally
            {
                DBC.DB_Close();
            }
        }
Exemplo n.º 7
0
        public override void FMB_Update_Resource_Location(FMB_Update_ResLoc_In_Tag Update_ResLoc_In, ref FMB_Cmn_Out_Tag Cmn_Out)
        {
            string sSysTime = String.Empty;

            DataTable adoDataTable = null;
            DB_Common DBC          = new DB_Common();

            DBC_MFMBRESLOC MFMBRESLOC = new DBC_MFMBRESLOC(ref DBC);

            try
            {
                DBC.gDBConnectionString = StdGlobalVariable.ROXml.GetValue("//appSettings//add[@key='MESConnectionString']");

                if (DBC.OpenDB() != true)
                {
                    Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                    return;
                }

                DBC.DB_BeginTransaction();

                Cmn_Out.h_status_value = StdGlobalConstant.MP_FAIL;

                DBC.DB_GetSysTime(ref sSysTime);

                if (Update_ResLoc_In._C.res_type == 'R')
                {
                    MFMBRESLOC.Init();

                    MFMBRESLOC.FACTORY  = Update_ResLoc_In._C.h_factory;
                    MFMBRESLOC.RES_ID   = Update_ResLoc_In._C.res_id;
                    MFMBRESLOC.RES_TYPE = Update_ResLoc_In._C.res_type.ToString();

                    if (MFMBRESLOC.SelectDataForUpdate(2, ref adoDataTable) == false)
                    {
                        if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                        {
                            Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                            return;
                        }
                        Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                        Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                        DBC.DB_Rollback();
                        return;
                    }

                    if (Update_ResLoc_In._C.h_proc_step == StdGlobalConstant.MP_STEP_CREATE)
                    {
                        MFMBRESLOC.Init();

                        MFMBRESLOC.FACTORY   = Update_ResLoc_In._C.h_factory;
                        MFMBRESLOC.LAYOUT_ID = Update_ResLoc_In._C.layout_id;

                        if (MFMBRESLOC.SelectData(3, ref adoDataTable) == false)
                        {
                            if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                            {
                                Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                                return;
                            }
                            Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                            Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                            DBC.DB_Rollback();
                            return;
                        }

                        if (MFMBRESLOC.SEQ == 0)
                        {
                            MFMBRESLOC.SEQ = 1;
                        }
                        else
                        {
                            MFMBRESLOC.SEQ = MFMBRESLOC.SEQ + 1;
                        }
                    }

                    MFMBRESLOC.FACTORY        = Update_ResLoc_In._C.h_factory;
                    MFMBRESLOC.RES_ID         = Update_ResLoc_In._C.res_id;
                    MFMBRESLOC.RES_TYPE       = Update_ResLoc_In._C.res_type.ToString();
                    MFMBRESLOC.LAYOUT_ID      = Update_ResLoc_In._C.layout_id;
                    MFMBRESLOC.LOC_X          = Update_ResLoc_In._C.loc_x;
                    MFMBRESLOC.LOC_Y          = Update_ResLoc_In._C.loc_y;
                    MFMBRESLOC.LOC_WIDTH      = Update_ResLoc_In._C.loc_width;
                    MFMBRESLOC.LOC_HEIGHT     = Update_ResLoc_In._C.loc_height;
                    MFMBRESLOC.TEXT           = Update_ResLoc_In._C.text;
                    MFMBRESLOC.TEXT_SIZE      = Update_ResLoc_In._C.text_size;
                    MFMBRESLOC.TEXT_COLOR     = Update_ResLoc_In._C.text_color;
                    MFMBRESLOC.TEXT_STYLE     = Update_ResLoc_In._C.text_style.ToString();
                    MFMBRESLOC.TAG_TYPE       = Update_ResLoc_In._C.tag_type;
                    MFMBRESLOC.BACK_COLOR     = Update_ResLoc_In._C.back_color;
                    MFMBRESLOC.NO_MOUSE_EVENT = Update_ResLoc_In._C.no_mouse_event.ToString();
                    MFMBRESLOC.SIGNAL_FLAG    = Update_ResLoc_In._C.signal_flag.ToString();

                    if (Update_ResLoc_In._C.h_proc_step == StdGlobalConstant.MP_STEP_CREATE)
                    {
                        MFMBRESLOC.CREATE_USER_ID = Update_ResLoc_In._C.h_user_id;
                        MFMBRESLOC.CREATE_TIME    = sSysTime;

                        if (MFMBRESLOC.InsertData() == false)
                        {
                            if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                            {
                                Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                                return;
                            }
                            Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                            Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                            DBC.DB_Rollback();
                            return;
                        }
                    }
                    else if (Update_ResLoc_In._C.h_proc_step == StdGlobalConstant.MP_STEP_UPDATE)
                    {
                        MFMBRESLOC.UPDATE_USER_ID = Update_ResLoc_In._C.h_user_id;
                        MFMBRESLOC.UPDATE_TIME    = sSysTime;

                        if (MFMBRESLOC.UpdateData(2) == false)
                        {
                            if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                            {
                                Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                                return;
                            }
                            Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                            Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                            DBC.DB_Rollback();
                            return;
                        }
                    }
                    else if (Update_ResLoc_In._C.h_proc_step == StdGlobalConstant.MP_STEP_DELETE)
                    {
                        if (MFMBRESLOC.DeleteData(3) == false)
                        {
                            if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                            {
                                Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                                return;
                            }
                            Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                            Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                            DBC.DB_Rollback();
                            return;
                        }

                        if (MFMBRESLOC.UpdateData(5) == false)
                        {
                            if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                            {
                                Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                                return;
                            }
                            Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                            Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                            DBC.DB_Rollback();
                            return;
                        }
                    }
                }
                else if (Update_ResLoc_In._C.res_type == 'T')
                {
                    MFMBRESLOC.Init();

                    MFMBRESLOC.FACTORY   = Update_ResLoc_In._C.h_factory;
                    MFMBRESLOC.RES_ID    = Update_ResLoc_In._C.res_id;
                    MFMBRESLOC.RES_TYPE  = Update_ResLoc_In._C.res_type.ToString();
                    MFMBRESLOC.LAYOUT_ID = Update_ResLoc_In._C.layout_id;

                    if (MFMBRESLOC.SelectDataForUpdate(1, ref adoDataTable) == false)
                    {
                        if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                        {
                            Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                            return;
                        }
                        Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                        Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                        DBC.DB_Rollback();
                        return;
                    }

                    if (Update_ResLoc_In._C.h_proc_step == StdGlobalConstant.MP_STEP_CREATE)
                    {
                        MFMBRESLOC.Init();

                        MFMBRESLOC.FACTORY   = Update_ResLoc_In._C.h_factory;
                        MFMBRESLOC.LAYOUT_ID = Update_ResLoc_In._C.layout_id;

                        if (MFMBRESLOC.SelectData(3, ref adoDataTable) == false)
                        {
                            if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                            {
                                Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                                return;
                            }
                            Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                            Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                            DBC.DB_Rollback();
                            return;
                        }

                        if (MFMBRESLOC.SEQ == 0)
                        {
                            MFMBRESLOC.SEQ = 1;
                        }
                        else
                        {
                            MFMBRESLOC.SEQ = MFMBRESLOC.SEQ + 1;
                        }
                    }

                    MFMBRESLOC.FACTORY        = Update_ResLoc_In._C.h_factory;
                    MFMBRESLOC.RES_ID         = Update_ResLoc_In._C.res_id;
                    MFMBRESLOC.RES_TYPE       = Update_ResLoc_In._C.res_type.ToString();
                    MFMBRESLOC.LAYOUT_ID      = Update_ResLoc_In._C.layout_id;
                    MFMBRESLOC.LOC_X          = Update_ResLoc_In._C.loc_x;
                    MFMBRESLOC.LOC_Y          = Update_ResLoc_In._C.loc_y;
                    MFMBRESLOC.LOC_WIDTH      = Update_ResLoc_In._C.loc_width;
                    MFMBRESLOC.LOC_HEIGHT     = Update_ResLoc_In._C.loc_height;
                    MFMBRESLOC.TEXT           = Update_ResLoc_In._C.text;
                    MFMBRESLOC.TEXT_SIZE      = Update_ResLoc_In._C.text_size;
                    MFMBRESLOC.TEXT_COLOR     = Update_ResLoc_In._C.text_color;
                    MFMBRESLOC.TEXT_STYLE     = Update_ResLoc_In._C.text_style.ToString();
                    MFMBRESLOC.TAG_TYPE       = Update_ResLoc_In._C.tag_type;
                    MFMBRESLOC.BACK_COLOR     = Update_ResLoc_In._C.back_color;
                    MFMBRESLOC.NO_MOUSE_EVENT = Update_ResLoc_In._C.no_mouse_event.ToString();
                    MFMBRESLOC.SIGNAL_FLAG    = Update_ResLoc_In._C.signal_flag.ToString();

                    if (Update_ResLoc_In._C.h_proc_step == StdGlobalConstant.MP_STEP_CREATE)
                    {
                        MFMBRESLOC.CREATE_USER_ID = Update_ResLoc_In._C.h_user_id;
                        MFMBRESLOC.CREATE_TIME    = sSysTime;

                        if (MFMBRESLOC.InsertData() == false)
                        {
                            if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                            {
                                Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                                return;
                            }
                            Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                            Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                            DBC.DB_Rollback();
                            return;
                        }
                    }
                    else if (Update_ResLoc_In._C.h_proc_step == StdGlobalConstant.MP_STEP_UPDATE)
                    {
                        MFMBRESLOC.UPDATE_USER_ID = Update_ResLoc_In._C.h_user_id;
                        MFMBRESLOC.UPDATE_TIME    = sSysTime;

                        if (MFMBRESLOC.UpdateData(1) == false)
                        {
                            if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                            {
                                Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                                return;
                            }
                            Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                            Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                            DBC.DB_Rollback();
                            return;
                        }
                    }
                    else if (Update_ResLoc_In._C.h_proc_step == StdGlobalConstant.MP_STEP_DELETE)
                    {
                        if (MFMBRESLOC.DeleteData(1) == false)
                        {
                            if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                            {
                                Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                                return;
                            }
                            Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                            Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                            DBC.DB_Rollback();
                            return;
                        }

                        if (MFMBRESLOC.UpdateData(5) == false)
                        {
                            if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                            {
                                Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                                return;
                            }
                            Cmn_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                            Cmn_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                            DBC.DB_Rollback();
                            return;
                        }
                    }
                }


                Cmn_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
            }
            catch (Exception ex)
            {
                Cmn_Out.h_field_msg = ex.Message;
                return;
            }
            finally
            {
                DBC.DB_Close();
            }
        }
Exemplo n.º 8
0
        public override void WIP_View_Factory_List(WIP_View_Factory_List_In_Tag View_Factory_List_In, ref WIP_View_Factory_List_Out_Tag View_Factory_List_Out)
        {
            int       i            = 0;
            DataTable adoDataTable = null;

            DB_Common      DBC        = new DB_Common();
            DBC_MWIPFACDEF MWIPFACDEF = new DBC_MWIPFACDEF(ref DBC);

            try
            {
                DBC.gDBConnectionString = StdGlobalVariable.ROXml.GetValue("//appSettings//add[@key='MESConnectionString']");

                if (DBC.OpenDB() != true)
                {
                    View_Factory_List_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                    return;
                }

                DBC.DB_BeginTransaction();

                View_Factory_List_Out.h_status_value     = StdGlobalConstant.MP_FAIL;
                View_Factory_List_Out._size_factory_list = 0;
                View_Factory_List_Out.count = 0;

                MWIPFACDEF.Init();

                if (MWIPFACDEF.FillData(1, ref adoDataTable) == false)
                {
                    if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                    {
                        View_Factory_List_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                        return;
                    }
                    View_Factory_List_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                    View_Factory_List_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                    DBC.DB_Rollback();
                    return;
                }

                if (adoDataTable.Rows.Count > 0)
                {
                    View_Factory_List_Out.factory_list = new WIP_View_Factory_List_Out_Tag_factory_list[adoDataTable.Rows.Count];
                    for (i = 0; i < adoDataTable.Rows.Count; i++)
                    {
                        View_Factory_List_Out.factory_list[i]          = new WIP_View_Factory_List_Out_Tag_factory_list();
                        View_Factory_List_Out.factory_list[i].factory  = adoDataTable.Rows[i]["FACTORY"].ToString();
                        View_Factory_List_Out.factory_list[i].fac_desc = adoDataTable.Rows[i]["FAC_DESC"].ToString();
                    }
                }

                View_Factory_List_Out.count = i;
                View_Factory_List_Out._size_factory_list = i;
                View_Factory_List_Out.h_status_value     = StdGlobalConstant.MP_SUCCESS;
            }
            catch (Exception ex)
            {
                View_Factory_List_Out.h_field_msg = ex.Message;
                return;
            }
            finally
            {
                DBC.DB_Close();
            }
        }
        //public const int MAX_RES_LIST = 1000;

        public override void FMB_View_Resource_List_Detail(FMB_View_Resource_List_In_Tag View_Resource_List_In, ref FMB_View_Resource_List_Out_Detail_Tag View_Resource_List_Out)
        {
            int       i            = 0;
            DataTable adoDataTable = null;
            DataTable adoImgTable  = null;

            DB_Common      DBC        = new DB_Common();
            DBC_FMBJOIN    FMBJOIN    = new DBC_FMBJOIN(ref DBC);
            DBC_MFMBRESLOC MFMBRESLOC = new DBC_MFMBRESLOC(ref DBC);
            DBC_MFMBRESIMG MFMBRESIMG = new DBC_MFMBRESIMG(ref DBC);

            try
            {
                DBC.gDBConnectionString = StdGlobalVariable.ROXml.GetValue("//appSettings//add[@key='MESConnectionString']");

                if (DBC.OpenDB() != true)
                {
                    View_Resource_List_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                    return;
                }

                DBC.DB_BeginTransaction();

                View_Resource_List_Out.h_status_value = StdGlobalConstant.MP_FAIL;
                View_Resource_List_Out._size_res_list = 0;
                View_Resource_List_Out.count          = 0;
                View_Resource_List_Out.next_res_id    = String.Empty;
                View_Resource_List_Out.next_seq       = 0;

                /*Type 별 List*/
                if (View_Resource_List_In.h_proc_step == '1')
                {
                    if (View_Resource_List_In.res_type == 'R')
                    {
                        FMBJOIN.Init();
                        FMBJOIN.FACTORY   = View_Resource_List_In.h_factory;
                        FMBJOIN.LAYOUT_ID = View_Resource_List_In.layout_id;
                        FMBJOIN.SEQ       = View_Resource_List_In.next_seq;
                        if (FMBJOIN.FillResDetail(1, ref adoDataTable) == false)
                        {
                            if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                            {
                                View_Resource_List_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                                return;
                            }
                            View_Resource_List_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                            View_Resource_List_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                            DBC.DB_Rollback();
                            return;
                        }
                        if (adoDataTable.Rows.Count > 0)
                        {
                            View_Resource_List_Out.res_list = new FMB_View_Resource_List_Out_Detail_Tag_res_list[adoDataTable.Rows.Count];
                            for (i = 0; i < adoDataTable.Rows.Count; i++)
                            {
                                if (i == MAX_UDR_LIST)
                                {
                                    View_Resource_List_Out.next_seq = Convert.ToInt32(adoDataTable.Rows[i]["SEQ"]);
                                    break;
                                }

                                MFMBRESIMG.Init();
                                MFMBRESIMG.FACTORY = View_Resource_List_In.h_factory;
                                MFMBRESIMG.RES_ID  = adoDataTable.Rows[i]["RES_ID"].ToString();
                                MFMBRESIMG.SelectData(1, ref adoImgTable);

                                View_Resource_List_Out.res_list[i]                      = new FMB_View_Resource_List_Out_Detail_Tag_res_list();
                                View_Resource_List_Out.res_list[i].res_id               = adoDataTable.Rows[i]["RES_ID"].ToString();
                                View_Resource_List_Out.res_list[i].res_tag_flag         = adoDataTable.Rows[i]["RES_TAG_FLAG"].ToString()[0];
                                View_Resource_List_Out.res_list[i].layout_id            = adoDataTable.Rows[i]["LAYOUT_ID"].ToString();
                                View_Resource_List_Out.res_list[i].seq                  = Convert.ToInt32(adoDataTable.Rows[i]["SEQ"]);
                                View_Resource_List_Out.res_list[i].loc_x                = Convert.ToInt32(adoDataTable.Rows[i]["LOC_X"]);
                                View_Resource_List_Out.res_list[i].loc_y                = Convert.ToInt32(adoDataTable.Rows[i]["LOC_Y"]);
                                View_Resource_List_Out.res_list[i].loc_width            = Convert.ToInt32(adoDataTable.Rows[i]["LOC_WIDTH"]);
                                View_Resource_List_Out.res_list[i].loc_height           = Convert.ToInt32(adoDataTable.Rows[i]["LOC_HEIGHT"]);
                                View_Resource_List_Out.res_list[i].text                 = adoDataTable.Rows[i]["TEXT"].ToString();
                                View_Resource_List_Out.res_list[i].text_size            = Convert.ToInt32(adoDataTable.Rows[i]["TEXT_SIZE"]);
                                View_Resource_List_Out.res_list[i].text_color           = Convert.ToInt32(adoDataTable.Rows[i]["TEXT_COLOR"]);
                                View_Resource_List_Out.res_list[i].text_style           = adoDataTable.Rows[i]["TEXT_STYLE"].ToString()[0];
                                View_Resource_List_Out.res_list[i].tag_type             = Convert.ToInt32(adoDataTable.Rows[i]["TAG_TYPE"]);
                                View_Resource_List_Out.res_list[i].back_color           = Convert.ToInt32(adoDataTable.Rows[i]["BACK_COLOR"]);
                                View_Resource_List_Out.res_list[i].create_time          = adoDataTable.Rows[i]["CREATE_TIME"].ToString();
                                View_Resource_List_Out.res_list[i].update_time          = adoDataTable.Rows[i]["UPDATE_TIME"].ToString();
                                View_Resource_List_Out.res_list[i].no_mouse_event       = adoDataTable.Rows[i]["NO_MOUSE_EVENT"].ToString()[0];
                                View_Resource_List_Out.res_list[i].signal_flag          = adoDataTable.Rows[i]["SIGNAL_FLAG"].ToString()[0];
                                View_Resource_List_Out.res_list[i].seq                  = Convert.ToInt32(adoDataTable.Rows[i]["SEQ"]);
                                View_Resource_List_Out.res_list[i].res_desc             = adoDataTable.Rows[i]["RES_DESC"].ToString();
                                View_Resource_List_Out.res_list[i].res_type             = adoDataTable.Rows[i]["RES_TYPE"].ToString();
                                View_Resource_List_Out.res_list[i].area_id              = adoDataTable.Rows[i]["AREA_ID"].ToString();
                                View_Resource_List_Out.res_list[i].sub_area_id          = adoDataTable.Rows[i]["SUB_AREA_ID"].ToString();
                                View_Resource_List_Out.res_list[i].res_location         = adoDataTable.Rows[i]["RES_LOCATION"].ToString();
                                View_Resource_List_Out.res_list[i].proc_rule            = adoDataTable.Rows[i]["PROC_RULE"].ToString()[0];
                                View_Resource_List_Out.res_list[i].max_proc_count       = Convert.ToInt32(adoDataTable.Rows[i]["MAX_PROC_COUNT"]);
                                View_Resource_List_Out.res_list[i].res_up_down_flag     = adoDataTable.Rows[i]["RES_UP_DOWN_FLAG"].ToString()[0];
                                View_Resource_List_Out.res_list[i].res_pri_sts          = adoDataTable.Rows[i]["RES_PRI_STS"].ToString();
                                View_Resource_List_Out.res_list[i].res_ctrl_mode        = adoDataTable.Rows[i]["RES_CTRL_MODE"].ToString();
                                View_Resource_List_Out.res_list[i].res_proc_mode        = adoDataTable.Rows[i]["RES_PROC_MODE"].ToString();
                                View_Resource_List_Out.res_list[i].last_recipe_id       = adoDataTable.Rows[i]["LAST_RECIPE_ID"].ToString();
                                View_Resource_List_Out.res_list[i].proc_count           = Convert.ToInt32(adoDataTable.Rows[i]["PROC_COUNT"]);
                                View_Resource_List_Out.res_list[i].last_start_time      = adoDataTable.Rows[i]["LAST_START_TIME"].ToString();
                                View_Resource_List_Out.res_list[i].last_end_time        = adoDataTable.Rows[i]["LAST_END_TIME"].ToString();
                                View_Resource_List_Out.res_list[i].last_down_time       = adoDataTable.Rows[i]["LAST_DOWN_TIME"].ToString();
                                View_Resource_List_Out.res_list[i].last_down_hist_seq   = Convert.ToInt32(adoDataTable.Rows[i]["LAST_DOWN_HIST_SEQ"]);
                                View_Resource_List_Out.res_list[i].last_event           = adoDataTable.Rows[i]["LAST_EVENT_ID"].ToString();
                                View_Resource_List_Out.res_list[i].last_event_time      = adoDataTable.Rows[i]["LAST_EVENT_TIME"].ToString();
                                View_Resource_List_Out.res_list[i].last_active_hist_seq = Convert.ToInt32(adoDataTable.Rows[i]["LAST_ACTIVE_HIST_SEQ"]);
                                View_Resource_List_Out.res_list[i].last_hist_seq        = Convert.ToInt32(adoDataTable.Rows[i]["LAST_HIST_SEQ"]);
                                View_Resource_List_Out.res_list[i].img_idx              = MFMBRESIMG.IMAGE_IDX;
                                View_Resource_List_Out.res_list[i].lot_id               = adoDataTable.Rows[i]["LOT_ID"].ToString();
                            }
                        }
                    }
                    else if (View_Resource_List_In.res_type == 'T')
                    {
                        MFMBRESLOC.Init();
                        MFMBRESLOC.FACTORY   = View_Resource_List_In.h_factory;
                        MFMBRESLOC.LAYOUT_ID = View_Resource_List_In.layout_id;
                        MFMBRESLOC.SEQ       = View_Resource_List_In.next_seq;
                        if (MFMBRESLOC.FillData(1, ref adoDataTable) == false)
                        {
                            if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                            {
                                View_Resource_List_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                                return;
                            }
                            View_Resource_List_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                            View_Resource_List_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                            DBC.DB_Rollback();
                            return;
                        }

                        for (i = 0; i < adoDataTable.Rows.Count; i++)
                        {
                            if (i == MAX_UDR_LIST)
                            {
                                View_Resource_List_Out.next_seq = Convert.ToInt32(adoDataTable.Rows[i]["SEQ"]);
                                break;
                            }
                            View_Resource_List_Out.res_list[i].seq            = Convert.ToInt32(adoDataTable.Rows[i]["SEQ"]);
                            View_Resource_List_Out.res_list[i].res_id         = adoDataTable.Rows[i]["RES_ID"].ToString();
                            View_Resource_List_Out.res_list[i].res_tag_flag   = adoDataTable.Rows[i]["RES_TYPE"].ToString()[0];
                            View_Resource_List_Out.res_list[i].loc_x          = Convert.ToInt32(adoDataTable.Rows[i]["LOC_X"]);
                            View_Resource_List_Out.res_list[i].loc_y          = Convert.ToInt32(adoDataTable.Rows[i]["LOC_Y"]);
                            View_Resource_List_Out.res_list[i].loc_width      = Convert.ToInt32(adoDataTable.Rows[i]["LOC_WIDTH"]);
                            View_Resource_List_Out.res_list[i].loc_height     = Convert.ToInt32(adoDataTable.Rows[i]["LOC_HEIGHT"]);
                            View_Resource_List_Out.res_list[i].text           = adoDataTable.Rows[i]["TEXT"].ToString();
                            View_Resource_List_Out.res_list[i].text_size      = Convert.ToInt32(adoDataTable.Rows[i]["TEXT_SIZE"]);
                            View_Resource_List_Out.res_list[i].text_color     = Convert.ToInt32(adoDataTable.Rows[i]["TEXT_COLOR"]);
                            View_Resource_List_Out.res_list[i].text_size      = Convert.ToInt32(adoDataTable.Rows[i]["TEXT_SIZE"]);
                            View_Resource_List_Out.res_list[i].text_style     = adoDataTable.Rows[i]["TEXT_STYLE"].ToString()[0];
                            View_Resource_List_Out.res_list[i].tag_type       = Convert.ToInt32(adoDataTable.Rows[i]["TAG_TYPE"]);
                            View_Resource_List_Out.res_list[i].back_color     = Convert.ToInt32(adoDataTable.Rows[i]["BACK_COLOR"]);
                            View_Resource_List_Out.res_list[i].create_time    = adoDataTable.Rows[i]["CREATE_TIME"].ToString();
                            View_Resource_List_Out.res_list[i].update_time    = adoDataTable.Rows[i]["UPDATE_TIME"].ToString();
                            View_Resource_List_Out.res_list[i].no_mouse_event = adoDataTable.Rows[i]["NO_MOUSE_EVENT"].ToString()[0];
                            View_Resource_List_Out.res_list[i].signal_flag    = adoDataTable.Rows[i]["SIGNAL_FLAG"].ToString()[0];
                        }
                    }
                }
                /*Control Sequence 별 List*/
                else if (View_Resource_List_In.h_proc_step == '2')
                {
                    FMBJOIN.Init();
                    FMBJOIN.FACTORY   = View_Resource_List_In.h_factory;
                    FMBJOIN.LAYOUT_ID = View_Resource_List_In.layout_id;
                    FMBJOIN.SEQ       = View_Resource_List_In.next_seq;
                    if (FMBJOIN.FillUdrDetail(2, ref adoDataTable) == false)
                    {
                        if (DBC.gErrors.SqlCode == SQL_CODE.SQL_NOT_FOUND)
                        {
                            View_Resource_List_Out.h_status_value = StdGlobalConstant.MP_SUCCESS;
                            return;
                        }
                        View_Resource_List_Out.h_msg        = DBC.gErrors.SqlCode.ToString();
                        View_Resource_List_Out.h_db_err_msg = DBC.gErrors.ErrMsg;
                        DBC.DB_Rollback();
                        return;
                    }

                    if (adoDataTable.Rows.Count > 0)
                    {
                        View_Resource_List_Out.res_list = new FMB_View_Resource_List_Out_Detail_Tag_res_list[adoDataTable.Rows.Count];
                        for (i = 0; i < adoDataTable.Rows.Count; i++)
                        {
                            if (i == MAX_UDR_LIST)
                            {
                                View_Resource_List_Out.next_seq = Convert.ToInt32(adoDataTable.Rows[i]["SEQ"]);
                                break;
                            }

                            MFMBRESIMG.Init();
                            MFMBRESIMG.FACTORY = View_Resource_List_In.h_factory;
                            MFMBRESIMG.RES_ID  = adoDataTable.Rows[i]["RES_ID"].ToString();
                            MFMBRESIMG.SelectData(1, ref adoImgTable);

                            View_Resource_List_Out.res_list[i].res_id               = adoDataTable.Rows[i]["RES_ID"].ToString();
                            View_Resource_List_Out.res_list[i].res_tag_flag         = adoDataTable.Rows[i]["RES_TAG_FLAG"].ToString()[0];
                            View_Resource_List_Out.res_list[i].loc_x                = Convert.ToInt32(adoDataTable.Rows[i]["LOC_X"]);
                            View_Resource_List_Out.res_list[i].loc_y                = Convert.ToInt32(adoDataTable.Rows[i]["LOC_Y"]);
                            View_Resource_List_Out.res_list[i].loc_width            = Convert.ToInt32(adoDataTable.Rows[i]["LOC_WIDTH"]);
                            View_Resource_List_Out.res_list[i].loc_height           = Convert.ToInt32(adoDataTable.Rows[i]["LOC_HEIGHT"]);
                            View_Resource_List_Out.res_list[i].text                 = adoDataTable.Rows[i]["TEXT"].ToString();
                            View_Resource_List_Out.res_list[i].text_size            = Convert.ToInt32(adoDataTable.Rows[i]["TEXT_SIZE"]);
                            View_Resource_List_Out.res_list[i].text_color           = Convert.ToInt32(adoDataTable.Rows[i]["TEXT_COLOR"]);
                            View_Resource_List_Out.res_list[i].text_size            = Convert.ToInt32(adoDataTable.Rows[i]["TEXT_SIZE"]);
                            View_Resource_List_Out.res_list[i].text_style           = adoDataTable.Rows[i]["TEXT_STYLE"].ToString()[0];
                            View_Resource_List_Out.res_list[i].tag_type             = Convert.ToInt32(adoDataTable.Rows[i]["TAG_TYPE"]);
                            View_Resource_List_Out.res_list[i].back_color           = Convert.ToInt32(adoDataTable.Rows[i]["BACK_COLOR"]);
                            View_Resource_List_Out.res_list[i].create_time          = adoDataTable.Rows[i]["CREATE_TIME"].ToString();
                            View_Resource_List_Out.res_list[i].update_time          = adoDataTable.Rows[i]["UPDATE_TIME"].ToString();
                            View_Resource_List_Out.res_list[i].no_mouse_event       = adoDataTable.Rows[i]["NO_MOUSE_EVENT"].ToString()[0];
                            View_Resource_List_Out.res_list[i].signal_flag          = adoDataTable.Rows[i]["SIGNAL_FLAG"].ToString()[0];
                            View_Resource_List_Out.res_list[i].seq                  = Convert.ToInt32(adoDataTable.Rows[i]["SEQ"]);
                            View_Resource_List_Out.res_list[i].res_desc             = adoDataTable.Rows[i]["RES_DESC"].ToString();
                            View_Resource_List_Out.res_list[i].res_type             = adoDataTable.Rows[i]["RES_TYPE"].ToString();
                            View_Resource_List_Out.res_list[i].area_id              = adoDataTable.Rows[i]["AREA_ID"].ToString();
                            View_Resource_List_Out.res_list[i].sub_area_id          = adoDataTable.Rows[i]["SUB_AREA_ID"].ToString();
                            View_Resource_List_Out.res_list[i].res_location         = adoDataTable.Rows[i]["RES_LOCATION"].ToString();
                            View_Resource_List_Out.res_list[i].proc_rule            = adoDataTable.Rows[i]["PROC_RULE"].ToString()[0];
                            View_Resource_List_Out.res_list[i].max_proc_count       = Convert.ToInt32(adoDataTable.Rows[i]["MAX_PROC_COUNT"]);
                            View_Resource_List_Out.res_list[i].res_up_down_flag     = adoDataTable.Rows[i]["RES_UP_DOWN_FLAG"].ToString()[0];
                            View_Resource_List_Out.res_list[i].res_pri_sts          = adoDataTable.Rows[i]["RES_PRI_STS"].ToString();
                            View_Resource_List_Out.res_list[i].res_ctrl_mode        = adoDataTable.Rows[i]["RES_CTRL_MODE"].ToString();
                            View_Resource_List_Out.res_list[i].res_proc_mode        = adoDataTable.Rows[i]["RES_PROC_MODE"].ToString();
                            View_Resource_List_Out.res_list[i].last_recipe_id       = adoDataTable.Rows[i]["LAST_RECIPE_ID"].ToString();
                            View_Resource_List_Out.res_list[i].proc_count           = Convert.ToInt32(adoDataTable.Rows[i]["PROC_COUNT"]);
                            View_Resource_List_Out.res_list[i].last_start_time      = adoDataTable.Rows[i]["LAST_START_TIME"].ToString();
                            View_Resource_List_Out.res_list[i].last_end_time        = adoDataTable.Rows[i]["LAST_END_TIME"].ToString();
                            View_Resource_List_Out.res_list[i].last_down_time       = adoDataTable.Rows[i]["LAST_DOWN_TIME"].ToString();
                            View_Resource_List_Out.res_list[i].last_down_hist_seq   = Convert.ToInt32(adoDataTable.Rows[i]["LAST_DOWN_HIST_SEQ"]);
                            View_Resource_List_Out.res_list[i].last_event           = adoDataTable.Rows[i]["LAST_EVENT_ID"].ToString();
                            View_Resource_List_Out.res_list[i].last_event_time      = adoDataTable.Rows[i]["LAST_EVENT_TIME"].ToString();
                            View_Resource_List_Out.res_list[i].last_active_hist_seq = Convert.ToInt32(adoDataTable.Rows[i]["LAST_ACTIVE_HIST_SEQ"]);
                            View_Resource_List_Out.res_list[i].last_hist_seq        = Convert.ToInt32(adoDataTable.Rows[i]["LAST_HIST_SEQ"]);
                            View_Resource_List_Out.res_list[i].img_idx              = Convert.ToInt32(adoDataTable.Rows[i]["IMAGE_IDX"]);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                View_Resource_List_Out.h_field_msg = ex.Message;
                return;
            }
            finally
            {
                DBC.DB_Close();
            }
        }