Esempio n. 1
0
        //发送任务信息更新
        public Message TaskList_Update()
        {
            string   serverIP     = "";
            int      userbyID     = 0;
            int      taskID       = 0;
            DateTime beginTime    = DateTime.Now;
            DateTime endTime      = DateTime.Now;
            int      interval     = 0;
            int      status       = 0;
            string   boardMessage = "";
            int      result       = -1;

            try
            {
                //操作员ID
                TLV_Structure tlvStrut = new TLV_Structure(TagName.UserByID, 3, msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer);
                userbyID = (int)tlvStrut.toInteger();
                //发送状态
                tlvStrut = new TLV_Structure(TagName.SDO_Status, 3, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_Status).m_bValueBuffer);
                status   = (int)tlvStrut.toInteger();
                //任务ID
                tlvStrut = new TLV_Structure(TagName.SDO_TaskID, 3, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_TaskID).m_bValueBuffer);
                taskID   = (int)tlvStrut.toInteger();
                if (status == 0)
                {
                    serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer);

                    tlvStrut  = new TLV_Structure(TagName.SDO_BeginTime, 6, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_BeginTime).m_bValueBuffer);
                    beginTime = tlvStrut.toTimeStamp();

                    tlvStrut = new TLV_Structure(TagName.SDO_EndTime, 6, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_EndTime).m_bValueBuffer);
                    endTime  = tlvStrut.toTimeStamp();
                    //发送间隔
                    tlvStrut = new TLV_Structure(TagName.SDO_Interval, 3, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_Interval).m_bValueBuffer);
                    interval = (int)tlvStrut.toInteger();

                    boardMessage = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_BoardMessage).m_bValueBuffer);
                }
                SqlHelper.log.WriteLog(lg.API_Update + lg.SDOAPI_SDO + "+>" + lg.SDOAPI_SDONoticeInfoAPI_SendNoticeList + "!");
                Console.WriteLine(DateTime.Now + " - " + lg.API_Update + lg.SDOAPI_SDO + "+>" + lg.SDOAPI_SDONoticeInfoAPI_SendNoticeList + "!");

                result = NoticeDataInfo.BoardTask_Update(serverIP, userbyID, taskID, beginTime, endTime, interval, status, boardMessage);
                if (result == 1)
                {
                    return(Message.COMMON_MES_RESP("SCUESS", Msg_Category.SDO_ADMIN, ServiceKey.SDO_BOARDTASK_UPDATE_RESP));
                }
                else
                {
                    return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.SDO_ADMIN, ServiceKey.SDO_BOARDTASK_UPDATE_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
                }
            }
            catch (System.Exception ex)
            {
                Console.WriteLine(ex.Message);
                return(Message.COMMON_MES_RESP(lg.API_Update + lg.API_Failure, Msg_Category.SDO_ADMIN, ServiceKey.SDO_BOARDTASK_UPDATE_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
            }
        }
        /// <summary>
        /// 更新公告表
        /// </summary>
        /// <returns></returns>
        public Message CR_CallBoardInfo_Update()
        {
            int      result           = -1;
            int      userByID         = 0;
            string   serverIP         = null;
            int      boardID          = 0;
            string   callBoardContext = null;
            string   callBoardColor   = null;
            DateTime validTime;
            DateTime invalidTime;
            int      everyDay = 0;

            try
            {
                TLV_Structure tlv = new TLV_Structure(TagName.UserByID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer);
                userByID         = (int)tlv.toInteger();
                serverIP         = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_ServerIP).m_bValueBuffer);
                tlv              = new TLV_Structure(TagName.CR_BoardID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.CR_BoardID).m_bValueBuffer);
                boardID          = (int)tlv.toInteger();
                callBoardContext = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_BoardContext).m_bValueBuffer);
                string callBoardContext1 = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_BoardContext1).m_bValueBuffer);
                string callBoardContext2 = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_BoardContext2).m_bValueBuffer);
                callBoardContext = callBoardContext + callBoardContext1 + callBoardContext2;
                callBoardColor   = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_BoardColor).m_bValueBuffer);
                tlv         = new TLV_Structure(TagName.CR_ValidTime, 6, msg.m_packet.m_Body.getTLVByTag(TagName.CR_ValidTime).m_bValueBuffer);
                validTime   = tlv.toTimeStamp();
                tlv         = new TLV_Structure(TagName.CR_InValidTime, 6, msg.m_packet.m_Body.getTLVByTag(TagName.CR_InValidTime).m_bValueBuffer);
                invalidTime = tlv.toTimeStamp();
                tlv         = new TLV_Structure(TagName.CR_DayLoop, 4, msg.m_packet.m_Body.getTLVByTag(TagName.CR_DayLoop).m_bValueBuffer);
                everyDay    = (int)tlv.toInteger();
                result      = CRCallBoardInfo.CallBoardInfo_Update(userByID, serverIP, boardID, callBoardContext, callBoardColor, validTime, invalidTime, everyDay);
                if (result == 1)
                {
                    SqlHelper.log.WriteLog(lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_AllNoticeInfo + callBoardContext + lg.API_Update + lg.API_Success + "!");
                    Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_AllNoticeInfo + callBoardContext + lg.API_Update + lg.API_Success + "!");
                    return(Message.COMMON_MES_RESP("SUCESS", Msg_Category.CR_ADMIN, ServiceKey.CR_CALLBOARD_UPDATE_RESP));
                }
                else
                {
                    SqlHelper.log.WriteLog(lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_AllNoticeInfo + callBoardContext + lg.API_Update + lg.API_Failure + "!");
                    Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_AllNoticeInfo + callBoardContext + lg.API_Update + lg.API_Failure + "!");
                    return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.CR_ADMIN, ServiceKey.CR_CALLBOARD_UPDATE_RESP));
                }
            }
            catch (System.Exception ex)
            {
                SqlHelper.log.WriteLog(lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_AllNoticeInfo + callBoardContext + lg.API_Update + lg.API_Failure + "!");
                Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_AllNoticeInfo + callBoardContext + lg.API_Update + lg.API_Failure + "!");
                return(Message.COMMON_MES_RESP(ex.Message, Msg_Category.CR_ADMIN, ServiceKey.CR_CALLBOARD_UPDATE_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
            }
        }
        /// <summary>
        /// 添加公告内容
        /// </summary>
        /// <returns></returns>
        public Message RayCity_BoardList_Insert()
        {
            int      result        = -1;
            int      operateUserID = 0;
            string   serverIP      = null;
            string   city          = null;
            int      interval      = 0;
            string   msgContent    = null;
            DateTime startDate     = new DateTime();
            DateTime endDate       = new DateTime();

            try
            {
                TLV_Structure strut = new TLV_Structure(TagName.UserByID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer);
                operateUserID = (int)strut.toInteger();
                serverIP      = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_ServerIP).m_bValueBuffer);
                strut         = new TLV_Structure(TagName.RayCity_BeginDate, 6, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_BeginDate).m_bValueBuffer);
                startDate     = strut.toTimeStamp();
                strut         = new TLV_Structure(TagName.RayCity_EndDate, 6, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_EndDate).m_bValueBuffer);
                endDate       = strut.toTimeStamp();
                strut         = new TLV_Structure(TagName.FJ_Interval, 4, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_Interval).m_bValueBuffer);
                interval      = (int)strut.toInteger();
                msgContent    = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_Message).m_bValueBuffer);
                result        = GlobalAccount.RayCityBoardList_Insert(operateUserID, serverIP, city, msgContent, startDate, endDate, interval);
                if (result == 1)
                {
                    SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + serverIP + lg.RayCityAPI_Notices + lg.API_Add + lg.API_Success);
                    Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + serverIP + lg.RayCityAPI_Notices + lg.API_Add + lg.API_Success);
                    return(Message.COMMON_MES_RESP("SUCESS", Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_BoardList_Insert_Resp));
                }
                else
                {
                    SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + serverIP + lg.RayCityAPI_Notices + lg.API_Add + lg.API_Failure);
                    Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + serverIP + lg.RayCityAPI_Notices + lg.API_Add + lg.API_Failure);
                    return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_BoardList_Insert_Resp));
                }
            }
            catch (System.Exception e)
            {
                return(Message.COMMON_MES_RESP(lg.RayCityAPI_Notices + lg.API_Add + lg.API_Failure, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_BoardList_Insert_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING));
            }
        }
        public Message CR_CallBoard_Query(int index, int pageSize)
        {
            string   serverIP = null;
            DateTime validTime;
            int      publicID = 0;
            int      valid    = 0;
            int      action   = 0;

            System.Data.DataSet ds = null;
            try
            {
                serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_ServerIP).m_bValueBuffer);
                TLV_Structure tlv = new TLV_Structure(TagName.CR_ValidTime, 6, msg.m_packet.m_Body.getTLVByTag(TagName.CR_ValidTime).m_bValueBuffer);
                validTime = tlv.toTimeStamp();
                tlv       = new TLV_Structure(TagName.CR_PublishID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.CR_PublishID).m_bValueBuffer);
                publicID  = (int)tlv.toInteger();
                //tlv = new TLV_Structure(TagName.CR_Valid, 4, msg.m_packet.m_Body.getTLVByTag(TagName.CR_Valid).m_bValueBuffer);
                //valid = (int) tlv.toInteger();
                tlv    = new TLV_Structure(TagName.CR_ACTION, 4, msg.m_packet.m_Body.getTLVByTag(TagName.CR_ACTION).m_bValueBuffer);
                action = (int)tlv.toInteger();
                SqlHelper.log.WriteLog(lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_AllNoticeInfo);
                Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_AllNoticeInfo);
                ds = CRCallBoardInfo.CallBoardInfo_Query(serverIP, validTime, publicID, valid, action);
                if (ds != null && ds.Tables[0].Rows.Count > 0)
                {
                    //总页数
                    int pageCount = 0;
                    pageCount = ds.Tables[0].Rows.Count % pageSize;
                    if (pageCount > 0)
                    {
                        pageCount = ds.Tables[0].Rows.Count / pageSize + 1;
                    }
                    else
                    {
                        pageCount = ds.Tables[0].Rows.Count / pageSize;
                    }
                    if (index + pageSize > ds.Tables[0].Rows.Count)
                    {
                        pageSize = ds.Tables[0].Rows.Count - index;
                    }
                    Query_Structure[] structList = new Query_Structure[pageSize];
                    for (int i = index; i < index + pageSize; i++)
                    {
                        Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length + 3);
                        byte[]          bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[0]));
                        strut.AddTagKey(TagName.CR_BoardID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
                        string context  = "";
                        string context1 = "";
                        string context2 = "";
                        if (ds.Tables[0].Rows[i].IsNull(1) == false)
                        {
                            if ((ds.Tables[0].Rows[i].ItemArray[1].ToString().Length / 150) > 2)
                            {
                                context  = ds.Tables[0].Rows[i].ItemArray[1].ToString().Substring(0, 150);
                                context1 = ds.Tables[0].Rows[i].ItemArray[1].ToString().Substring(150, 150);
                                context2 = ds.Tables[0].Rows[i].ItemArray[1].ToString().Substring(300, ds.Tables[0].Rows[i].ItemArray[1].ToString().Length - 300);
                            }
                            else if ((ds.Tables[0].Rows[i].ItemArray[1].ToString().Length / 150) > 1)
                            {
                                context  = ds.Tables[0].Rows[i].ItemArray[1].ToString().Substring(0, 150);
                                context1 = ds.Tables[0].Rows[i].ItemArray[1].ToString().Substring(150, ds.Tables[0].Rows[i].ItemArray[1].ToString().Length - 150);
                            }
                            else
                            {
                                context = ds.Tables[0].Rows[i].ItemArray[1].ToString();
                            }
                        }
                        bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, context);
                        strut.AddTagKey(TagName.CR_BoardContext, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
                        bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, context1);
                        strut.AddTagKey(TagName.CR_BoardContext1, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
                        bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, context2);
                        strut.AddTagKey(TagName.CR_BoardContext2, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
                        bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(ds.Tables[0].Rows[i].ItemArray[2]));
                        strut.AddTagKey(TagName.CR_BoardColor, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
                        bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[3]));
                        strut.AddTagKey(TagName.CR_PublishID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
                        bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[4]));
                        strut.AddTagKey(TagName.CR_DayLoop, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
                        bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, Convert.ToDateTime(ds.Tables[0].Rows[i].ItemArray[5]));
                        strut.AddTagKey(TagName.CR_ValidTime, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes);
                        bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, Convert.ToDateTime(ds.Tables[0].Rows[i].ItemArray[6]));
                        strut.AddTagKey(TagName.CR_InValidTime, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes);
                        bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[7]));
                        strut.AddTagKey(TagName.CR_SPEED, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
                        //状态
                        int status = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[8]);
                        if (status == -1)
                        {
                            status = 0;
                        }
                        bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, status);
                        strut.AddTagKey(TagName.CR_STATUS, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
                        //生效格式
                        int expire = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[9]);
                        if (expire <= 0)
                        {
                            expire = 1;
                        }
                        else
                        {
                            expire = 0;
                        }
                        bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, expire);
                        strut.AddTagKey(TagName.CR_Expire, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
                        //总页数
                        strut.AddTagKey(TagName.PageCount, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, pageCount));
                        structList[i - index] = strut;
                    }
                    return(Message.COMMON_MES_RESP(structList, Msg_Category.CR_ADMIN, ServiceKey.CR_CALLBOARD_QUERY_RESP, 13));
                }
                else
                {
                    return(Message.COMMON_MES_RESP(lg.CR_CallBoardAPI_NoNoticeInfo, Msg_Category.CR_ADMIN, ServiceKey.CR_CALLBOARD_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
                }
            }
            catch (System.Exception ex)
            {
                Console.WriteLine(ex.Message);
                return(Message.COMMON_MES_RESP(lg.CR_CallBoardAPI_NoNoticeInfo, Msg_Category.CR_ADMIN, ServiceKey.CR_CALLBOARD_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
            }
        }
        /// <summary>
        /// 发布公告表
        /// </summary>
        /// <returns></returns>
        public Message CR_CallBoardInfo_Insert()
        {
            string   err_channels     = null;
            int      result           = -1;
            int      userByID         = 0;
            int      operID           = 0;
            string   serverIP         = null;
            string   callBoardContext = null;
            string   callBoardColor   = null;
            int      status           = 0;
            int      license          = 0;
            DateTime validTime;
            DateTime invalidTime;
            int      speed    = 0;
            int      everyDay = 0;
            string   channel  = null;

            try
            {
                TLV_Structure tlv = new TLV_Structure(TagName.UserByID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer);
                userByID         = (int)tlv.toInteger();
                serverIP         = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_ServerIP).m_bValueBuffer);
                tlv              = new TLV_Structure(TagName.CR_PublishID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.CR_PublishID).m_bValueBuffer);
                operID           = (int)tlv.toInteger();
                callBoardContext = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_BoardContext).m_bValueBuffer);
                string callBoardContext1 = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_BoardContext1).m_bValueBuffer);
                string callBoardContext2 = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_BoardContext2).m_bValueBuffer);
                callBoardContext = callBoardContext + callBoardContext1 + callBoardContext2;
                callBoardColor   = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_BoardColor).m_bValueBuffer);
                tlv          = new TLV_Structure(TagName.CR_STATUS, 4, msg.m_packet.m_Body.getTLVByTag(TagName.CR_STATUS).m_bValueBuffer);
                status       = (int)tlv.toInteger();
                tlv          = new TLV_Structure(TagName.CR_ValidTime, 6, msg.m_packet.m_Body.getTLVByTag(TagName.CR_ValidTime).m_bValueBuffer);
                validTime    = tlv.toTimeStamp();
                tlv          = new TLV_Structure(TagName.CR_InValidTime, 6, msg.m_packet.m_Body.getTLVByTag(TagName.CR_InValidTime).m_bValueBuffer);
                invalidTime  = tlv.toTimeStamp();
                tlv          = new TLV_Structure(TagName.CR_SPEED, 4, msg.m_packet.m_Body.getTLVByTag(TagName.CR_SPEED).m_bValueBuffer);
                speed        = (int)tlv.toInteger();
                tlv          = new TLV_Structure(TagName.CR_DayLoop, 4, msg.m_packet.m_Body.getTLVByTag(TagName.CR_DayLoop).m_bValueBuffer);
                everyDay     = (int)tlv.toInteger();
                channel      = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_Channel).m_bValueBuffer);
                err_channels = CRCallBoardInfo.CallBoardInfo_ADD(userByID, serverIP, callBoardContext, callBoardColor, status, validTime, invalidTime, operID, speed, everyDay, license, channel);
                string[] channels = err_channels.Split(',');
                if (channels.Length == 1)
                {
                    SqlHelper.log.WriteLog(lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_AllNoticeInfo + callBoardContext + lg.API_Add + lg.API_Success + "!");
                    Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_AllNoticeInfo + callBoardContext + lg.API_Add + lg.API_Success + "!");
                    return(Message.COMMON_MES_RESP("SUCESS", Msg_Category.CR_ADMIN, ServiceKey.CR_CALLBOARD_CREATE_RESP));
                }
                else
                {
                    SqlHelper.log.WriteLog(lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_AllNoticeInfo + callBoardContext + lg.API_Add + lg.API_Failure + "!");
                    Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_AllNoticeInfo + callBoardContext + lg.API_Add + lg.API_Failure + "!");
                    return(Message.COMMON_MES_RESP(err_channels, Msg_Category.CR_ADMIN, ServiceKey.CR_CALLBOARD_CREATE_RESP));
                }
            }
            catch (System.Exception ex)
            {
                SqlHelper.log.WriteLog(lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_AllNoticeInfo + callBoardContext + lg.API_Add + lg.API_Failure + "!");
                Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_AllNoticeInfo + callBoardContext + lg.API_Add + lg.API_Failure + "!");
                return(Message.COMMON_MES_RESP(ex.Message, Msg_Category.CR_ADMIN, ServiceKey.CR_CALLBOARD_CREATE_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
            }
        }