コード例 #1
0
ファイル: Common.cs プロジェクト: aliceshin/origine
        public bool CheckRemoveMessage(DataSet ds, BasePopupFrm page, string item, bool isShowMsg)
        {
            if (DSUtil.GetResultSucceed(ds) == Definition.FAIL)
            {
                page.MsgClose();

                if (isShowMsg && DSUtil.GetResultMsg(ds) != "")
                {
                    MSGHandler.DisplayMessage(MSGType.Warning, "VMS_DELETE_FAIL_USEDATA", new string[] { item }, null);
                }

                return(false);
            }
            else
            {
                page.MsgClose();

                if (isShowMsg)
                {
                    MSGHandler.DisplayMessage(MSGType.Information, "VMS_DELETE_SUCCESS", null, null);
                }

                return(true);
            }
        }
コード例 #2
0
ファイル: InterfaceData.cs プロジェクト: aliceshin/origine
        public DataSet QueryConfigList()
        {
            DataSet ds = new DataSet();

            try
            {
                //LinkedList lklist = new LinkedList();
                //lklist.Add("FRAMEWORK_ID", sFrameworkID);
                //lklist.Add("MEMBER_ID", sMemberID);

                //ds = base.Query(SQL_QUERY_CONFIG_LIST, lklist);

                ds = base.Query(SQL_QUERY_CONFIG_LIST);

                if (DSUtil.GetResultSucceed(ds) == 0)
                {
                    ds = new DataSet();
                }
            }
            catch (Exception ex)
            {
            }

            return(ds);
        }
コード例 #3
0
ファイル: Common.cs プロジェクト: aliceshin/origine
        // TODO : Added by Danny [2009.05.13]
        public bool CheckSaveMessage(DataSet ds, bool isShowMsg)
        {
            if (DSUtil.GetResultSucceed(ds) == Definition.FAIL)
            {
                if (isShowMsg && DSUtil.GetResultMsg(ds) != "")
                {
                    MSGHandler.DisplayMessage(MSGType.Error, DSUtil.GetResultMsg(ds));
                }
                else if (isShowMsg)
                {
                    MSGHandler.DisplayMessage(MSGType.Warning, "GENERAL_SAVE_FAIL", null, null);
                }

                return(false);
            }
            else
            {
                if (isShowMsg)
                {
                    MSGHandler.DisplayMessage(MSGType.Information, "GENERAL_SAVE_SUCCESS", null, null);
                }

                return(true);
            }
        }
コード例 #4
0
ファイル: Common.cs プロジェクト: aliceshin/origine
        public bool CheckSearchMessage(DataSet ds, BasePopupFrm page, bool isShowMsg)
        {
            if (DSUtil.GetResultSucceed(ds) == Definition.FAIL)
            {
                page.MsgClose();

                if (isShowMsg && DSUtil.GetResultMsg(ds) != "")
                {
                    MSGHandler.DisplayMessage(MSGType.Error, DSUtil.GetResultMsg(ds));
                }

                return(false);
            }
            else
            {
                if (ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
                {
                    page.MsgClose();

                    if (isShowMsg)
                    {
                        MSGHandler.DisplayMessage(MSGType.Information, "GENERAL_NO_DATA", null, null);
                    }
                }

                return(true);
            }
        }
コード例 #5
0
        //SPC-629
        public string PasteModel(LinkedList pasteModelList)
        {
            DataSet dsResult = _ws.ATTCopyModelInfo(pasteModelList.GetSerialData());

            if (dsResult == null)
            {
                return(Definition.MSG_KEY_NO_PASTE_ITEM);
            }
            if (DSUtil.GetResultSucceed(dsResult) == 0)
            {
                return("FAIL");
            }

            return("SUCCESS");
        }
コード例 #6
0
ファイル: InterfaceData.cs プロジェクト: aliceshin/origine
        public DataSet QueryFrameWorkList()
        {
            DataSet ds = new DataSet();

            try
            {
                ds = base.Query(SQL_QUERY_FRAMEWORK_LIST);

                if (DSUtil.GetResultSucceed(ds) == 0)
                {
                    ds = new DataSet();
                }
            }
            catch
            {
            }

            return(ds);
        }
コード例 #7
0
ファイル: InterfaceData.cs プロジェクト: aliceshin/origine
        public DataSet QuerySubjectName()
        {
            DataSet ds = new DataSet();

            try
            {
                ds = base.Query(SQL_QUERY_SUBJECT_NAME);

                if (DSUtil.GetResultSucceed(ds) == 0)
                {
                    ds = new DataSet();
                }
            }
            catch (Exception ex)
            {
            }

            return(ds);
        }
コード例 #8
0
ファイル: InterfaceData.cs プロジェクト: aliceshin/origine
        public DataSet QueryViewEQPList(string sViewTableName)
        {
            DataSet ds = new DataSet();

            try
            {
                string sSQL = string.Format(SQL_QUERY_VIEW_EQP_LIST, sViewTableName);

                ds = base.Query(sSQL);

                if (DSUtil.GetResultSucceed(ds) == 0)
                {
                    ds = new DataSet();
                }
            }
            catch (Exception ex)
            {
            }

            return(ds);
        }
コード例 #9
0
ファイル: InterfaceData.cs プロジェクト: aliceshin/origine
        public DataSet QueryViewTableList()
        {
            DataSet ds = new DataSet();

            try
            {
                LinkedList lklist = new LinkedList();
                lklist.Add("PROPERTY_NAME", "TABLE");


                //ds = base.Query(SQL_QUERY_VIEW_TABLE_LIST, lklist);
                ds = base.Query(SQL_QUERY_VIEW_TABLE_LIST, lklist);

                if (DSUtil.GetResultSucceed(ds) == 0)
                {
                    ds = new DataSet();
                }
            }
            catch (Exception ex)
            {
            }

            return(ds);
        }
コード例 #10
0
ファイル: InterfaceData.cs プロジェクト: aliceshin/origine
        public DataSet QueryConfigPropertyList()
        {
            DataSet ds = new DataSet();

            try
            {
                //LinkedList lklist = new LinkedList();
                //lklist.Add("CONFIG_RAWID", CONFIG_RAWID);

                //ds = base.Query(SQL_QUERY_CONFIG_PROPERTY_LIST, lklist);

                ds = base.Query(SQL_QUERY_CONFIG_PROPERTY_LIST);

                if (DSUtil.GetResultSucceed(ds) == 0)
                {
                    ds = new DataSet();
                }
            }
            catch (Exception ex)
            {
            }

            return(ds);
        }
コード例 #11
0
ファイル: SPCModelBusiness.cs プロジェクト: aliceshin/origine
        public DataSet CopyModelInfo(byte[] param)
        {
            DataSet dsReturn = null;

            try
            {
                spcModelData.ParentSQLHandler = this;

                LinkedList llstTotalConfigInfo = new LinkedList();
                LinkedList llstParam           = null;
                llstTotalConfigInfo.SetSerialData(param);

                ArrayList arrMainTargetRawid = new ArrayList();
                ArrayList arrSubTargetRawid  = new ArrayList();

                base.BeginTrans();

                for (int i = 0; i < llstTotalConfigInfo.Count; i++)
                {
                    llstParam = (LinkedList)llstTotalConfigInfo[i];

                    string sUserID = llstParam[Definition.DynamicCondition_Condition_key.USER_ID].ToString();

                    string sourceConfigRawID = llstParam[Definition.COPY_MODEL.SOURCE_MODEL_CONFIG_RAWID].ToString();
                    string targetConfigRawID = llstParam[Definition.COPY_MODEL.TARGET_MODEL_CONFIG_RAWID].ToString();
                    string mainYN            = llstParam[Definition.CONDITION_KEY_MAIN_YN].ToString();

                    if (mainYN == "Y")
                    {
                        arrMainTargetRawid.Add(targetConfigRawID);
                    }
                    else
                    {
                        arrSubTargetRawid.Add(targetConfigRawID);
                    }

                    bool hasSubconfigs = Convert.ToBoolean(llstParam[Definition.CONDITION_KEY_HAS_SUBCONFIG].ToString());

                    dsReturn = spcModelData.CopyModelInfo(llstParam);

                    if (base.ErrorMessage.Length > 0 || DSUtil.GetResultSucceed(dsReturn) == 0)
                    {
                        this.RollBack();
                        return(dsReturn);
                    }
                }

                //modified by enkim Gemini P3-3816
                //string subConfigRawIDs = "";
                //if (mainYN.Equals(Definition.VARIABLE_Y) && hasSubconfigs)
                //{
                //    dsReturn = spcModelData.ModifySPCSubModelForCopy(llstParam, ref subConfigRawIDs);
                //    if (subConfigRawIDs.Length > 0)
                //    {
                //        subConfigRawIDs = subConfigRawIDs.Substring(1);
                //    }
                //}

                //modified end

                this.Commit();

                if (arrMainTargetRawid.Count > 0)
                {
                    LinkedList llstCondition = new LinkedList();
                    llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, arrMainTargetRawid[0].ToString());
                    llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, "Y");
                    llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update");
                    llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[BISTel.eSPC.Common.COLUMN.USER_ID].ToString());

                    //수정했을 경우 Server로 변경에 대한 Inform을 준다.
                    Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.ATT.Interface.MsgInterfaceBusiness();
                    msgBussiness.SetSPCModel(llstCondition.GetSerialData());
                }
                if (arrSubTargetRawid.Count > 0)
                {
                    string subConfigRawIDs = "";

                    for (int i = 0; i < arrSubTargetRawid.Count; i++)
                    {
                        subConfigRawIDs += ";" + arrSubTargetRawid[i].ToString();
                    }

                    if (subConfigRawIDs.Length > 0)
                    {
                        subConfigRawIDs = subConfigRawIDs.Substring(1);
                        LinkedList llstCondition = new LinkedList();
                        llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, subConfigRawIDs);
                        llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, "N");
                        llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update");
                        llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[BISTel.eSPC.Common.COLUMN.USER_ID].ToString());

                        //수정했을 경우 Server로 변경에 대한 Inform을 준다.
                        Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.ATT.Interface.MsgInterfaceBusiness();
                        msgBussiness.SetSPCModel(llstCondition.GetSerialData());
                    }
                }



                //modified by enkim Gemini P3-3816

                //if (mainYN.Equals(Definition.VARIABLE_Y) && hasSubconfigs)
                //{
                //    llstCondition = new LinkedList();
                //    llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, subConfigRawIDs);
                //    llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_N);
                //    llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update");

                //    //수정했을 경우 Server로 변경에 대한 Inform을 준다.
                //    msgBussiness = new BISTel.eSPC.Business.Server.Interface.MsgInterfaceBusiness();
                //    msgBussiness.SetSPCModel(llstCondition.GetSerialData());
                //}

                //modified end
            }
            catch (Exception ex)
            {
                BISTel.PeakPerformance.Client.CommonLibrary.LogHandler.ExceptionLogWrite(Definition.APPLICATION_NAME, ex);
                base.RollBack();
            }
            finally
            {
                this.Close();
            }

            return(dsReturn);
        }
コード例 #12
0
ファイル: SPCModelBusiness.cs プロジェクト: aliceshin/origine
        public DataSet SaveSPCModelData(byte[] param)
        {
            string configRawID = "";

            DataSet dsReturn = new DataSet();

            bool   _isGroup   = false;
            string groupRawid = null; //SPC-1292, KBLEE, GroupRawId 정보 담는 변수

            try
            {
                spcModelData.ParentSQLHandler = this;

                LinkedList llstParam = new LinkedList();
                llstParam.SetSerialData(param);
                bool useComma = false;

                if (llstParam[Definition.VARIABLE_USE_COMMA] is bool)
                {
                    useComma = (bool)llstParam[Definition.VARIABLE_USE_COMMA];
                }

                string sUserID = llstParam[Definition.CONDITION_KEY_USER_ID].ToString();
                BISTel.eSPC.Common.ConfigMode configMode = (BISTel.eSPC.Common.ConfigMode)llstParam[Definition.CONDITION_KEY_CONFIG_MODE];

                DataTable dtModel     = (DataTable)llstParam[BISTel.eSPC.Common.TABLE.MODEL_ATT_MST_SPC];
                DataTable dtConfig    = (DataTable)llstParam[BISTel.eSPC.Common.TABLE.MODEL_CONFIG_ATT_MST_SPC];
                DataTable dtConfigOpt = (DataTable)llstParam[BISTel.eSPC.Common.TABLE.MODEL_CONFIG_OPT_ATT_MST_SPC];
                DataTable dtContext   = (DataTable)llstParam[BISTel.eSPC.Common.TABLE.MODEL_CONTEXT_ATT_MST_SPC];
                DataTable dtRule      = (DataTable)llstParam[BISTel.eSPC.Common.TABLE.MODEL_RULE_ATT_MST_SPC];
                DataTable dtRuleOpt   = (DataTable)llstParam[BISTel.eSPC.Common.TABLE.MODEL_RULE_OPT_ATT_MST_SPC];
                DataTable dtAutoCalc  = (DataTable)llstParam[BISTel.eSPC.Common.TABLE.MODEL_AUTOCALC_ATT_MST_SPC];

                string _sMainYN        = "";
                string sConfigRawid    = "";
                string srefConfigRawid = "";
                bool   bOnlyMain       = false;
                bool   bOnlyMainGroup  = false;

                if (llstParam[Definition.CONDITION_KEY_MAIN_YN] != null)
                {
                    _sMainYN = llstParam[Definition.CONDITION_KEY_MAIN_YN].ToString();
                }

                bool _hasSubconfigs = Convert.ToBoolean(llstParam[Definition.CONDITION_KEY_HAS_SUBCONFIG].ToString());

                if (llstParam.Contains(BISTel.eSPC.Common.COLUMN.GROUP_YN))
                {
                    _isGroup = true;
                }

                if (llstParam.Contains(BISTel.eSPC.Common.COLUMN.GROUP_RAWID))
                {
                    groupRawid = llstParam[BISTel.eSPC.Common.COLUMN.GROUP_RAWID].ToString();
                }

                base.BeginTrans();

                switch (configMode)
                {
                case BISTel.eSPC.Common.ConfigMode.CREATE_MAIN:
                case BISTel.eSPC.Common.ConfigMode.SAVE_AS:
                    dsReturn = spcModelData.CreateSPCModel(configMode, sUserID, dtModel, dtConfig, dtConfigOpt, dtContext, dtRule, dtRuleOpt, dtAutoCalc, ref srefConfigRawid, groupRawid, useComma);
                    break;

                case BISTel.eSPC.Common.ConfigMode.CREATE_SUB:
                    dsReturn = spcModelData.CreateSPCModel(configMode, sUserID, dtModel, dtConfig, dtConfigOpt, dtContext, dtRule, dtRuleOpt, dtAutoCalc, ref srefConfigRawid, groupRawid, useComma);
                    break;

                case BISTel.eSPC.Common.ConfigMode.MODIFY:
                case BISTel.eSPC.Common.ConfigMode.ROLLBACK:
                    List <string> lstChangedMasterColList = (List <string>)llstParam["CHANGED_MASTER_COL_LIST"];
                    dsReturn = spcModelData.ModifySPCModel(sUserID, dtModel, dtConfig, dtConfigOpt, dtContext, dtRule, dtRuleOpt, dtAutoCalc, lstChangedMasterColList, groupRawid, useComma);
                    break;

                case BISTel.eSPC.Common.ConfigMode.DEFAULT:
                    dsReturn = spcModelData.SaveDefaultConfig(sUserID, dtModel, dtConfig, dtConfigOpt, dtContext, dtRule, dtRuleOpt, dtAutoCalc, useComma);
                    break;
                }

                if (base.ErrorMessage.Length > 0 || DSUtil.GetResultSucceed(dsReturn) == 0)
                {
                    this.RollBack();
                    return(dsReturn);
                }

                if (configMode.Equals(BISTel.eSPC.Common.ConfigMode.MODIFY) || configMode.Equals(BISTel.eSPC.Common.ConfigMode.ROLLBACK))
                {
                    configRawID = dtConfig.Rows[0][BISTel.eSPC.Common.COLUMN.RAWID].ToString();
                }

                if ((configMode.Equals(BISTel.eSPC.Common.ConfigMode.MODIFY) || configMode.Equals(BISTel.eSPC.Common.ConfigMode.ROLLBACK)) && _sMainYN.Equals(Definition.VARIABLE_Y) &&
                    _hasSubconfigs)
                {
                    if (llstParam.Contains("ONLY_MAIN"))
                    {
                        if (llstParam["ONLY_MAIN"].ToString() == Definition.VARIABLE_Y)
                        {
                            bOnlyMain = true;
                        }
                    }
                    if (llstParam.Contains("ONLY_MAIN_GROUP"))
                    {
                        if (llstParam["ONLY_MAIN_GROUP"].ToString() == Definition.VARIABLE_Y)
                        {
                            bOnlyMainGroup = true;
                        }
                    }
                    if (!bOnlyMain)
                    {
                        dsReturn = spcModelData.ModifyATTSPCSubModel(configRawID, dtRule, dtRuleOpt, sUserID, ref sConfigRawid);

                        if (sConfigRawid.Length > 0)
                        {
                            sConfigRawid = sConfigRawid.Substring(1);
                        }
                    }

                    dsReturn = spcModelData.ModifyATTSPCSubModelContext(configRawID, dtContext, sUserID, bOnlyMainGroup, groupRawid);

                    if (_isGroup) //기존 Sub 전체 삭제.
                    {
                        bool bResult = spcModelData.DeleteATTSPCModelConfig(sConfigRawid);
                        if (!bResult)
                        {
                            base.RollBack();
                        }
                    }
                }

                this.Commit();

                // Increase version
                BISTel.eSPC.Data.Server.Common.CommonData commonData = new BISTel.eSPC.Data.Server.Common.CommonData();
                switch (configMode)
                {
                case BISTel.eSPC.Common.ConfigMode.CREATE_MAIN:
                case BISTel.eSPC.Common.ConfigMode.SAVE_AS:
                case BISTel.eSPC.Common.ConfigMode.CREATE_SUB:
                    this.BeginTrans();
                    foreach (string query in commonData.GetIncreaseATTVersionQuery(srefConfigRawid.ToString()))
                    {
                        this.Query(query);
                    }
                    this.Commit();
                    break;

                case BISTel.eSPC.Common.ConfigMode.MODIFY:
                case BISTel.eSPC.Common.ConfigMode.ROLLBACK:
                    this.BeginTrans();
                    foreach (DataRow dr in dtConfig.Rows)
                    {
                        foreach (string query in commonData.GetIncreaseATTVersionQuery(dr[BISTel.eSPC.Common.COLUMN.RAWID].ToString()))
                        {
                            this.Query(query);
                        }
                    }

                    if (!bOnlyMain && _sMainYN.Equals(Definition.VARIABLE_Y) && _hasSubconfigs)
                    {
                        //modified by enkim 2012.05.18 SPC-739
                        //IncreaseVersionOfSubConfigs(sConfigRawid.Split(';'));
                        //ATT//
                        bool bResultTmp = spcModelData.IncreaseVersionOfSubConfigs(configRawID);
                        /// ATT//
                        //modified end SPC-739
                    }
                    this.Commit();
                    break;
                }

                if (configMode.Equals(BISTel.eSPC.Common.ConfigMode.MODIFY) || configMode.Equals(BISTel.eSPC.Common.ConfigMode.ROLLBACK))
                {
                    LinkedList llstCondition = new LinkedList();
                    llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, configRawID);
                    llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, _sMainYN);
                    llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update");
                    llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[BISTel.eSPC.Common.COLUMN.USER_ID].ToString());

                    //수정했을 경우 Server로 변경에 대한 Inform을 준다.
                    Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.ATT.Interface.MsgInterfaceBusiness();
                    msgBussiness.SetSPCModel(llstCondition.GetSerialData());
                }

                if ((configMode.Equals(BISTel.eSPC.Common.ConfigMode.MODIFY) || configMode.Equals(BISTel.eSPC.Common.ConfigMode.ROLLBACK)) && _sMainYN.Equals(Definition.VARIABLE_Y) && _hasSubconfigs)
                {
                    if (!_isGroup)
                    {
                        if (!bOnlyMain)
                        {
                            LinkedList llstCondition = new LinkedList();
                            llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, sConfigRawid);
                            llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_N);
                            llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update");
                            llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[BISTel.eSPC.Common.COLUMN.USER_ID].ToString());

                            //수정했을 경우 Server로 변경에 대한 Inform을 준다.
                            Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.ATT.Interface.MsgInterfaceBusiness();
                            msgBussiness.SetSPCModel(llstCondition.GetSerialData());
                        }
                    }
                    else
                    {
                        if (!bOnlyMain)
                        {
                            LinkedList llstCondition = new LinkedList();
                            llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, sConfigRawid);
                            llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_N);
                            llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "remove");
                            llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[BISTel.eSPC.Common.COLUMN.USER_ID].ToString());

                            //수정했을 경우 Server로 변경에 대한 Inform을 준다.
                            Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.ATT.Interface.MsgInterfaceBusiness();
                            msgBussiness.SetSPCModel(llstCondition.GetSerialData());
                        }
                    }
                }

                if (configMode.Equals(BISTel.eSPC.Common.ConfigMode.CREATE_MAIN) || configMode.Equals(BISTel.eSPC.Common.ConfigMode.SAVE_AS))
                {
                    if (srefConfigRawid.Length > 0)
                    {
                        LinkedList llstCondition = new LinkedList();
                        llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, srefConfigRawid);
                        llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_Y);
                        llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "add");
                        llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[BISTel.eSPC.Common.COLUMN.USER_ID].ToString());
                        Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.ATT.Interface.MsgInterfaceBusiness();
                        msgBussiness.SetSPCModel(llstCondition.GetSerialData());
                    }
                }

                if (configMode.Equals(BISTel.eSPC.Common.ConfigMode.CREATE_SUB))
                {
                    if (srefConfigRawid.Length > 0)
                    {
                        LinkedList llstCondition = new LinkedList();
                        llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, srefConfigRawid);
                        llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_N);
                        llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "add");
                        llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[BISTel.eSPC.Common.COLUMN.USER_ID].ToString());
                        Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.ATT.Interface.MsgInterfaceBusiness();
                        msgBussiness.SetSPCModel(llstCondition.GetSerialData());
                    }
                }
            }
            catch (Exception ex)
            {
                BISTel.PeakPerformance.Client.CommonLibrary.LogHandler.ExceptionLogWrite(Definition.APPLICATION_NAME, ex);
                base.RollBack();
            }
            finally
            {
                this.Close();
            }

            return(dsReturn);
        }
コード例 #13
0
ファイル: Condition.cs プロジェクト: aliceshin/origine
        public void BindToControl(Control control, DataSet ds, string sDisplayMember, string sValueMumber, bool bAll)
        {
            try
            {
                if (ds.Tables.Count > 0)
                {
                    if (control is BISTel.PeakPerformance.Client.BISTelControl.BComboBox)
                    {
                        BISTel.PeakPerformance.Client.BISTelControl.BComboBox bComboBox = (BISTel.PeakPerformance.Client.BISTelControl.BComboBox)control;

                        bComboBox.Items.Clear();

                        //if (bAll)
                        //    combo.Items.Add(Definition.VARIABLE_ALL); //ALL
                        //else
                        //    combo.Items.Remove(Definition.VARIABLE_ALL);

                        bComboBox.BeginUpdate();

                        if (sDisplayMember != "")
                            bComboBox.DisplayMember = sDisplayMember;

                        if (sValueMumber != "")
                            bComboBox.ValueMember = sValueMumber;

                        if (DSUtil.GetResultSucceed(ds) != 0)
                        {
                            bComboBox.DataSource = ds.Tables[0];

                            //for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                            //{
                            //    bComboBox.Items.Add(ds.Tables[0].Rows[i][0].ToString());
                            //}
                            bComboBox.EndUpdate();

                            if (bComboBox.Items.Count > 0)
                            {
                                bComboBox.SelectedIndex = 0;
                            }
                        }
                        else
                            bComboBox.EndUpdate();
                    }
                    else if (control is BISTel.PeakPerformance.Client.BISTelControl.BCheckCombo)
                    {
                        BISTel.PeakPerformance.Client.BISTelControl.BCheckCombo bCheckComboBox = (BISTel.PeakPerformance.Client.BISTelControl.BCheckCombo)control;

                        bCheckComboBox.chkBox.Items.Clear();

                        bCheckComboBox.chkBox.BeginUpdate();

                        if (DSUtil.GetResultSucceed(ds) != 0)
                        {
                            ArrayList alItemList = new ArrayList();
                            string[] saItemList = new string[ds.Tables[0].Rows.Count];
                            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                            {
                                alItemList.Add(ds.Tables[0].Rows[i][sDisplayMember].ToString());
                                saItemList[i] = ds.Tables[0].Rows[i][sDisplayMember].ToString();
                            }

                            if (sDisplayMember != "")
                                bCheckComboBox.DisplayMember = sDisplayMember;

                            if (sValueMumber != "")
                                bCheckComboBox.ValueMember = sValueMumber;

                            bCheckComboBox.DataSource = ds.Tables[0];

                            //string[] saItemList = (string[])alItemList.ToArray(typeof(string[]));

                            //bCheckComboBox.AddItems(saItemList);

                            bCheckComboBox.chkBox.EndUpdate();
                            bCheckComboBox.chkBox.SelectedIndex = 0;
                        }
                        else
                            bCheckComboBox.chkBox.EndUpdate();
                    }
                    else if (control is System.Windows.Forms.ListBox)
                    {
                        System.Windows.Forms.ListBox lstbox = (System.Windows.Forms.ListBox)control;

                        lstbox.Items.Clear();

                        lstbox.BeginUpdate();

                        if (DSUtil.GetResultSucceed(ds) != 0)
                        {
                            ArrayList alItemList = new ArrayList();
                            string[] saItemList = new string[ds.Tables[0].Rows.Count];
                            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                            {
                                alItemList.Add(ds.Tables[0].Rows[i][sDisplayMember].ToString());
                                saItemList[i] = ds.Tables[0].Rows[i][sDisplayMember].ToString();
                            }

                            ////string[] saItemList = (string[])alItemList.ToArray(typeof(string[]));

                            //lstbox.Items.AddRange(saItemList);
                            ////lstbox.DataSource = ds;

                            if (sDisplayMember != "")
                                lstbox.DisplayMember = sDisplayMember;

                            if (sValueMumber != "")
                                lstbox.ValueMember = sValueMumber;

                            lstbox.DataSource = ds.Tables[0];
                            lstbox.EndUpdate();
                        }
                        else
                            lstbox.EndUpdate();
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }