/// <summary>
        /// 对象编辑
        /// </summary>
        /// <param name="tOaMessageInfoReceive_UpdateSet">UpdateSet用户对象</param>
        /// <param name="tOaMessageInfoReceive_UpdateWhere">UpdateWhere用户对象</param>
        /// <returns>是否成功</returns>
        public bool Edit(TOaMessageInfoReceiveVo tOaMessageInfoReceive_UpdateSet, TOaMessageInfoReceiveVo tOaMessageInfoReceive_UpdateWhere)
        {
            string strSQL = SqlHelper.BuildUpdateExpress(tOaMessageInfoReceive_UpdateSet, TOaMessageInfoReceiveVo.T_OA_MESSAGE_INFO_RECEIVE_TABLE);

            strSQL += this.BuildWhereStatement(tOaMessageInfoReceive_UpdateWhere);
            return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
        }
        /// <summary>
        /// 对象编辑
        /// </summary>
        /// <param name="tOaMessageInfoReceive">用户对象</param>
        /// <returns>是否成功</returns>
        public bool Edit(TOaMessageInfoReceiveVo tOaMessageInfoReceive)
        {
            string strSQL = SqlHelper.BuildUpdateExpress(tOaMessageInfoReceive, TOaMessageInfoReceiveVo.T_OA_MESSAGE_INFO_RECEIVE_TABLE);

            strSQL += string.Format(" where ID='{0}' ", tOaMessageInfoReceive.ID);
            return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
        }
        /// <summary>
        /// 获取对象DataTable
        /// </summary>
        /// <param name="tOaMessageInfoReceive">对象</param>
        /// <param name="iIndex">起始页码</param>
        /// <param name="iCount">每页数目</param>
        /// <returns>返回结果</returns>
        public DataTable SelectByTable(TOaMessageInfoReceiveVo tOaMessageInfoReceive, int iIndex, int iCount)
        {
            string strSQL = " select * from T_OA_MESSAGE_INFO_RECEIVE {0} ";

            strSQL = String.Format(strSQL, BuildWhereStatement(tOaMessageInfoReceive));
            return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
        }
        /// <summary>
        /// 对象删除
        /// </summary>
        /// <param name="Id">ID</param>
        /// <returns>是否成功</returns>
        public bool Delete(TOaMessageInfoReceiveVo tOaMessageInfoReceive)
        {
            string strSQL = "delete from T_OA_MESSAGE_INFO_RECEIVE ";

            strSQL += this.BuildWhereStatement(tOaMessageInfoReceive);

            return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
        }
        /// <summary>
        /// 根据对象构造条件语句
        /// </summary>
        /// <param name="tOaMessageInfoReceive"></param>
        /// <returns></returns>
        public string BuildWhereStatement(TOaMessageInfoReceiveVo tOaMessageInfoReceive)
        {
            StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 ");

            if (null != tOaMessageInfoReceive)
            {
                //消息阅读编号
                if (!String.IsNullOrEmpty(tOaMessageInfoReceive.ID.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND ID = '{0}'", tOaMessageInfoReceive.ID.ToString()));
                }
                //消息编号
                if (!String.IsNullOrEmpty(tOaMessageInfoReceive.MESSAGE_ID.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND MESSAGE_ID = '{0}'", tOaMessageInfoReceive.MESSAGE_ID.ToString()));
                }
                //消息接收人
                if (!String.IsNullOrEmpty(tOaMessageInfoReceive.RECEIVER.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND RECEIVER = '{0}'", tOaMessageInfoReceive.RECEIVER.ToString()));
                }
                //是否已阅读
                if (!String.IsNullOrEmpty(tOaMessageInfoReceive.IS_READ.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND IS_READ = '{0}'", tOaMessageInfoReceive.IS_READ.ToString()));
                }
                //消息查阅时间
                if (!String.IsNullOrEmpty(tOaMessageInfoReceive.READ_DATE.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND READ_DATE = '{0}'", tOaMessageInfoReceive.READ_DATE.ToString()));
                }
                //备注1
                if (!String.IsNullOrEmpty(tOaMessageInfoReceive.REMARK1.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tOaMessageInfoReceive.REMARK1.ToString()));
                }
                //备注2
                if (!String.IsNullOrEmpty(tOaMessageInfoReceive.REMARK2.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tOaMessageInfoReceive.REMARK2.ToString()));
                }
                //备注3
                if (!String.IsNullOrEmpty(tOaMessageInfoReceive.REMARK3.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tOaMessageInfoReceive.REMARK3.ToString()));
                }
            }
            return(strWhereStatement.ToString());
        }
Exemple #6
0
    // 更新消息状态(0:未读,1:已读)
    public string UpdateStatus(string strValue)
    {
        TOaMessageInfoReceiveVo objMessage_where = new TOaMessageInfoReceiveVo();
        TOaMessageInfoReceiveVo objMessage_set   = new TOaMessageInfoReceiveVo();

        objMessage_where.MESSAGE_ID = strValue;

        objMessage_where.RECEIVER = LogInfo.UserInfo.ID;

        objMessage_set.IS_READ = "1";

        bool isSuccess = new TOaMessageInfoReceiveLogic().Edit(objMessage_set, objMessage_where);

        if (isSuccess)
        {
            new PageBase().WriteLog("更新消息状态为:1(已读)", "", new UserLogInfo().UserInfo.USER_NAME + "更新消息状态" + objMessage_where.ID);
        }

        return("1");
    }
Exemple #7
0
    // 删除信息
    public string deleteData(string strValue)
    {
        //TOaMessageInfoVo objMessage = new TOaMessageInfoVo();
        //objMessage.ID = strValue;
        //bool isSuccess = new TOaMessageInfoLogic().Delete(objMessage);

        TOaMessageInfoReceiveVo objMessageRecv = new TOaMessageInfoReceiveVo();

        objMessageRecv.MESSAGE_ID = strValue;

        objMessageRecv.RECEIVER = LogInfo.UserInfo.ID;

        bool isSuccess = new TOaMessageInfoReceiveLogic().Delete(objMessageRecv);

        if (isSuccess)
        {
            new PageBase().WriteLog("删除接收短消息", "", new UserLogInfo().UserInfo.USER_NAME + "删除接收短消息" + objMessageRecv.ID);
        }

        return(isSuccess == true ? "1" : "0");
    }
        /// <summary>
        /// 对象明细
        /// </summary>
        /// <param name="tOaMessageInfoReceive">对象条件</param>
        /// <returns>对象</returns>
        public TOaMessageInfoReceiveVo Details(TOaMessageInfoReceiveVo tOaMessageInfoReceive)
        {
            string strSQL = String.Format("select * from  T_OA_MESSAGE_INFO_RECEIVE " + this.BuildWhereStatement(tOaMessageInfoReceive));

            return(SqlHelper.ExecuteObject(new TOaMessageInfoReceiveVo(), strSQL));
        }
        /// <summary>
        /// 获取对象List
        /// </summary>
        /// <param name="tOaMessageInfoReceive">对象</param>
        /// <param name="iIndex">起始页码</param>
        /// <param name="iCount">每页数目</param>
        /// <returns>返回结果</returns>
        public List <TOaMessageInfoReceiveVo> SelectByObject(TOaMessageInfoReceiveVo tOaMessageInfoReceive, int iIndex, int iCount)
        {
            string strSQL = String.Format("select * from  T_OA_MESSAGE_INFO_RECEIVE " + this.BuildWhereStatement(tOaMessageInfoReceive));

            return(SqlHelper.ExecuteObjectList(tOaMessageInfoReceive, BuildPagerExpress(strSQL, iIndex, iCount)));
        }
Exemple #10
0
 /// <summary>
 /// 对象编辑
 /// </summary>
 /// <param name="tOaMessageInfoReceive">用户对象</param>
 /// <returns>是否成功</returns>
 public bool Edit(TOaMessageInfoReceiveVo tOaMessageInfoReceive)
 {
     return(access.Edit(tOaMessageInfoReceive));
 }
        /// <summary>
        /// 获得查询结果总行数,用于分页
        /// </summary>
        /// <param name="tOaMessageInfoReceive">对象</param>
        /// <returns>返回行数</returns>
        public int GetSelectResultCount(TOaMessageInfoReceiveVo tOaMessageInfoReceive)
        {
            string strSQL = "select Count(*) from T_OA_MESSAGE_INFO_RECEIVE " + this.BuildWhereStatement(tOaMessageInfoReceive);

            return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
        }
Exemple #12
0
 /// <summary>
 /// 对象删除
 /// </summary>
 /// <param name="Id">ID</param>
 /// <returns>是否成功</returns>
 public bool Delete(TOaMessageInfoReceiveVo tOaMessageInfoReceive)
 {
     return(access.Delete(tOaMessageInfoReceive));
 }
Exemple #13
0
 /// <summary>
 /// 对象编辑
 /// </summary>
 /// <param name="tOaMessageInfoReceive_UpdateSet">UpdateSet用户对象</param>
 /// <param name="tOaMessageInfoReceive_UpdateWhere">UpdateWhere用户对象</param>
 /// <returns>是否成功</returns>
 public bool Edit(TOaMessageInfoReceiveVo tOaMessageInfoReceive_UpdateSet, TOaMessageInfoReceiveVo tOaMessageInfoReceive_UpdateWhere)
 {
     return(access.Edit(tOaMessageInfoReceive_UpdateSet, tOaMessageInfoReceive_UpdateWhere));
 }
        /// <summary>
        /// 对象添加
        /// </summary>
        /// <param name="tOaMessageInfoReceive">对象</param>
        /// <returns>是否成功</returns>
        public bool Create(TOaMessageInfoReceiveVo tOaMessageInfoReceive)
        {
            string strSQL = SqlHelper.BuildInsertExpress(tOaMessageInfoReceive, TOaMessageInfoReceiveVo.T_OA_MESSAGE_INFO_RECEIVE_TABLE);

            return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
        }
Exemple #15
0
 public TOaMessageInfoReceiveLogic(TOaMessageInfoReceiveVo _tOaMessageInfoReceive)
 {
     tOaMessageInfoReceive = _tOaMessageInfoReceive;
     access = new TOaMessageInfoReceiveAccess();
 }
        /// <summary>
        /// 根据对象获取全部数据,用Table承载
        ///  数据量较小时使用【不推荐】
        /// </summary>
        /// <param name="tOaMessageInfoReceive"></param>
        /// <returns></returns>
        public DataTable SelectByTable(TOaMessageInfoReceiveVo tOaMessageInfoReceive)
        {
            string strSQL = "select * from T_OA_MESSAGE_INFO_RECEIVE " + this.BuildWhereStatement(tOaMessageInfoReceive);

            return(SqlHelper.ExecuteDataTable(strSQL));
        }
Exemple #17
0
 /// <summary>
 /// 对象添加
 /// </summary>
 /// <param name="sysRole">对象</param>
 /// <returns>是否成功</returns>
 public bool Create(TOaMessageInfoReceiveVo tOaMessageInfoReceive)
 {
     return(access.Create(tOaMessageInfoReceive));
 }
Exemple #18
0
 /// <summary>
 /// 根据对象获取全部数据,用Table承载
 ///  数据量较小时使用【不推荐】
 /// </summary>
 /// <param name="tOaMessageInfoReceive"></param>
 /// <returns></returns>
 public DataTable SelectByTable(TOaMessageInfoReceiveVo tOaMessageInfoReceive)
 {
     return(access.SelectByTable(tOaMessageInfoReceive));
 }
Exemple #19
0
 /// <summary>
 /// 获取对象DataTable
 /// </summary>
 /// <param name="tOaMessageInfoReceive">对象</param>
 /// <param name="iIndex">起始页码</param>
 /// <param name="iCount">每页数目</param>
 /// <returns>返回结果</returns>
 public DataTable SelectByTable(TOaMessageInfoReceiveVo tOaMessageInfoReceive, int iIndex, int iCount)
 {
     return(access.SelectByTable(tOaMessageInfoReceive, iIndex, iCount));
 }
Exemple #20
0
 /// <summary>
 /// 获取对象List
 /// </summary>
 /// <param name="tOaMessageInfoReceive">对象</param>
 /// <param name="iIndex">起始页码</param>
 /// <param name="iCount">每页数目</param>
 /// <returns>返回结果</returns>
 public List <TOaMessageInfoReceiveVo> SelectByObject(TOaMessageInfoReceiveVo tOaMessageInfoReceive, int iIndex, int iCount)
 {
     return(access.SelectByObject(tOaMessageInfoReceive, iIndex, iCount));
 }
Exemple #21
0
 /// <summary>
 /// 对象明细
 /// </summary>
 /// <param name="tOaMessageInfoReceive">对象条件</param>
 /// <returns>对象</returns>
 public TOaMessageInfoReceiveVo Details(TOaMessageInfoReceiveVo tOaMessageInfoReceive)
 {
     return(access.Details(tOaMessageInfoReceive));
 }
Exemple #22
0
 /// <summary>
 /// 获得查询结果总行数,用于分页
 /// </summary>
 /// <param name="tOaMessageInfoReceive">对象</param>
 /// <returns>返回行数</returns>
 public int GetSelectResultCount(TOaMessageInfoReceiveVo tOaMessageInfoReceive)
 {
     return(access.GetSelectResultCount(tOaMessageInfoReceive));
 }
    //保存数据
    private static string SaveData(string strID, string strMessageTitle, string strSendBy, string strSendDate, string strAcceptType,
                                   string strAcceptRealNames, string strAcceptUserIDs, string strAcceptDeptNames, string strAcceptDeptIDs, string strMessageContent, string strUserID)
    {
        string strSendByName = strSendBy;

        TSysUserVo objUserFrom = new TSysUserVo();

        objUserFrom.ID = strSendBy;
        DataTable dtUserSender = new TSysUserLogic().SelectByTable_ByDept(objUserFrom, 0, 0);

        if (dtUserSender.Rows.Count > 0)
        {
            strSendByName = dtUserSender.Rows[0]["REAL_NAME"].ToString();
        }


        bool isSuccess = true;

        strAcceptRealNames = strAcceptRealNames.Trim();
        strAcceptUserIDs   = strAcceptUserIDs.Trim();
        strAcceptDeptNames = strAcceptDeptNames.Trim();
        strAcceptDeptIDs   = strAcceptDeptIDs.Trim();

        #region 消息查看--编辑消息阅读状态
        if (strID.Length > 0)
        {
            TOaMessageInfoReceiveVo objReceive = new TOaMessageInfoReceiveVo();
            objReceive.IS_READ    = "0";
            objReceive.MESSAGE_ID = strID;
            objReceive.RECEIVER   = strUserID;
            objReceive            = new TOaMessageInfoReceiveLogic().Details(objReceive);
            if (objReceive.ID.Length > 0)
            {
                objReceive.IS_READ = "1";
                if (new TOaMessageInfoReceiveLogic().Edit(objReceive))
                {
                    new PageBase().WriteLog("编辑消息阅读状态", "", new UserLogInfo().UserInfo.USER_NAME + "编辑消息阅读状态" + objReceive.ID);
                }

                return("1");
            }
        }
        #endregion

        DataTable dtDept = new TSysDictLogic().SelectByTable(new TSysDictVo()
        {
            DICT_TYPE = "dept"
        });
        strAcceptDeptNames = strAcceptDeptNames.Replace(";", ",");
        string[] arrAccDeptName = strAcceptDeptNames.Split(',');
        for (int i = 0; i < arrAccDeptName.Length; i++)
        {
            if (arrAccDeptName[i].Length > 0)
            {
                DataRow[] drDept = dtDept.Select("DICT_TEXT='" + arrAccDeptName[i] + "'");
                if (drDept.Length > 0)
                {
                    strAcceptDeptIDs += (strAcceptDeptIDs.Length > 0 ? "," : "") + drDept[0]["DICT_CODE"];
                }
            }
        }

        #region 清空对应的几个接收信息表,冗余操作,但可以防止错误
        if (strID.Length > 0)
        {
            //消息接收人表
            TOaMessageInfoManVo objMessageMan = new TOaMessageInfoManVo();
            objMessageMan.MESSAGE_ID = strID;
            if (new TOaMessageInfoManLogic().Delete(objMessageMan))
            {
                new PageBase().WriteLog("删除消息接收人", "", new UserLogInfo().UserInfo.USER_NAME + "删除消息接收人" + objMessageMan.ID);
            }


            //消息阅读状态表
            TOaMessageInfoReceiveVo objMessageReceive = new TOaMessageInfoReceiveVo();
            objMessageReceive.MESSAGE_ID = strID;
            if (new TOaMessageInfoReceiveLogic().Delete(objMessageReceive))
            {
                new PageBase().WriteLog("删除消息阅读状态", "", new UserLogInfo().UserInfo.USER_NAME + "删除消息阅读状态" + objMessageReceive.ID);
            }

            //消息接收部门表
            TOaMessageInfoDeptVo objMessageDept = new TOaMessageInfoDeptVo();
            objMessageDept.MESSAGE_ID = strID;
            if (new TOaMessageInfoDeptLogic().Delete(objMessageDept))
            {
                new PageBase().WriteLog("删除消息接收部门", "", new UserLogInfo().UserInfo.USER_NAME + "删除消息接收部门" + objMessageDept.ID);
            }
        }
        #endregion

        string strSQL = "";
        #region 新增消息
        if (strID.Length > 0)
        {
            strSQL  = "update T_OA_MESSAGE_INFO set MESSAGE_TITLE='{0}',SEND_BY='{1}',SEND_DATE='{2}',ACCEPT_TYPE='{3}',";
            strSQL += "ACCEPT_REALNAMES='{4}',ACCEPT_USERIDS='{5}',ACCEPT_DEPTNAMES='{6}',ACCEPT_DEPTIDS='{7}',";
            strSQL += "MESSAGE_CONTENT='{8}'";
            strSQL += " where ID='{9}'";
            strSQL  = string.Format(strSQL, strMessageTitle, strSendBy, strSendDate, (strAcceptType == "全站") ? "1" : "2",
                                    strAcceptRealNames.TrimEnd(','), strAcceptUserIDs.TrimEnd(','), strAcceptDeptNames, strAcceptDeptIDs,
                                    strMessageContent, strID);
        }
        else
        {
            strID   = GetSerialNumber("t_oa_messageinfo_id");
            strSQL  = "insert into T_OA_MESSAGE_INFO (ID,MESSAGE_TITLE,SEND_BY,SEND_DATE,ACCEPT_TYPE,ACCEPT_REALNAMES,ACCEPT_USERIDS,ACCEPT_DEPTNAMES,ACCEPT_DEPTIDS,MESSAGE_CONTENT)";
            strSQL += " values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')";
            strSQL  = string.Format(strSQL, strID, strMessageTitle, strSendBy, strSendDate, (strAcceptType == "全站") ? "1" : "2",
                                    strAcceptRealNames.TrimEnd(','), strAcceptUserIDs.TrimEnd(','), strAcceptDeptNames, strAcceptDeptIDs,
                                    strMessageContent);
        }
        #endregion

        string strAccUserIDs = "";
        if (strAcceptType == "全站")//全站
        {
            TSysUserVo objUser = new TSysUserVo();

            objUser.IS_DEL  = "0";
            objUser.IS_HIDE = "0";
            objUser.IS_USE  = "1";

            DataTable dtUser = new TSysUserLogic().SelectByTable(objUser);

            for (int j = 0; j < dtUser.Rows.Count; j++)
            {
                // by yinchengyi 2014-10-23  T_OA_MESSAGE_INFO_MAN 没用
                //strSQL += "\r\n";
                //strSQL += "insert into T_OA_MESSAGE_INFO_MAN (ID,MESSAGE_ID,RECEIVER_ID)";
                //strSQL += " values('{0}','{1}','{2}')";
                //strSQL = string.Format(strSQL, GetSerialNumber("t_oa_messageinfoman_id"), strID, dtUser.Rows[j]["ID"].ToString());

                string strErrMsg = cInstanceMsgHandle.SendMsg(strSendByName, dtUser.Rows[j]["REAL_NAME"].ToString(), dtUser.Rows[j]["PHONE_MOBILE"].ToString().Trim(), strMessageContent);

                strSQL += "\r\n";
                strSQL += "insert into T_OA_MESSAGE_INFO_RECEIVE (ID,MESSAGE_ID,RECEIVER,IS_READ,REMARK3)";
                strSQL += " values('{0}','{1}','{2}','{3}','{4}')";
                strSQL  = string.Format(strSQL, GetSerialNumber("t_oa_messageinfodel_id"), strID, dtUser.Rows[j]["ID"].ToString(), "0", strErrMsg);

                strAccUserIDs += (strAccUserIDs.Length > 0 ? "," : "") + dtUser.Rows[j]["ID"].ToString();
            }
        }
        else//按部门,按个人分配消息
        {
            // by yinchengyi 2014-10-23  T_OA_MESSAGE_INFO_MAN 没用
            //for (int i = 0; i < strAcceptUserIDs.Split(',').Length; i++)
            //{
            //    if (strAcceptUserIDs.Split(',')[i].Length > 0)
            //    {
            //        strSQL += "\r\n";
            //        strSQL += "insert into T_OA_MESSAGE_INFO_MAN (ID,MESSAGE_ID,RECEIVER_ID)";
            //        strSQL += " values('{0}','{1}','{2}')";
            //        strSQL = string.Format(strSQL, GetSerialNumber("t_oa_messageinfoman_id"), strID, strAcceptUserIDs.Split(',')[i]);
            //    }
            //}

            // by yinchengyi 2014-10-23  T_OA_MESSAGE_INFO_DEPT 没用
            //for (int i = 0; i < strAcceptDeptIDs.Split(',').Length; i++)
            //{
            //    if (strAcceptDeptIDs.Split(',')[i].Length > 0)
            //    {
            //        strSQL += "\r\n";
            //        strSQL += "insert into T_OA_MESSAGE_INFO_DEPT (ID,MESSAGE_ID,DEPT_ID)";
            //        strSQL += " values('{0}','{1}','{2}')";
            //        strSQL = string.Format(strSQL, GetSerialNumber("t_oa_messageinfodept_id"), strID, strAcceptDeptIDs.Split(',')[i]);
            //    }
            //}


            //部门人员添加
            if (strAcceptDeptIDs.Length > 0)
            {
                TSysUserVo objUser = new TSysUserVo();

                objUser.IS_DEL  = "0";
                objUser.REMARK4 = strAcceptDeptIDs.Replace(",", "','");
                DataTable dtUserByDept = new TSysUserLogic().SelectByTable_ByDept(objUser, 0, 0);
                for (int j = 0; j < dtUserByDept.Rows.Count; j++)
                {
                    if (!strAcceptUserIDs.Contains(dtUserByDept.Rows[j]["ID"].ToString()))
                    {
                        strAcceptUserIDs += (strAcceptUserIDs.Length > 0 ? "," : "") + dtUserByDept.Rows[j]["ID"].ToString();
                    }
                }
            }

            for (int i = 0; i < strAcceptUserIDs.Split(',').Length; i++)
            {
                if (strAcceptUserIDs.Split(',')[i].Length > 0)
                {
                    TSysUserVo objUser = new TSysUserVo();
                    objUser.ID = strAcceptUserIDs.Split(',')[i];
                    DataTable dtUserByDept = new TSysUserLogic().SelectByTable_ByDept(objUser, 0, 0);

                    string strErrMsg = "unknown user";

                    if (dtUserByDept.Rows.Count > 0)
                    {
                        strErrMsg = cInstanceMsgHandle.SendMsg(strSendByName, dtUserByDept.Rows[0]["REAL_NAME"].ToString(), dtUserByDept.Rows[0]["PHONE_MOBILE"].ToString().Trim(), strMessageContent);
                    }

                    strSQL += "\r\n";
                    strSQL += "insert into T_OA_MESSAGE_INFO_RECEIVE (ID,MESSAGE_ID,RECEIVER,IS_READ,REMARK3)";
                    strSQL += " values('{0}','{1}','{2}','{3}','{4}')";
                    strSQL  = string.Format(strSQL, GetSerialNumber("t_oa_messageinfodel_id"), strID, strAcceptUserIDs.Split(',')[i], "0", strErrMsg);
                }
            }

            strAccUserIDs += (strAccUserIDs.Length > 0 ? "," : "") + strAcceptUserIDs;
        }

        //if (strAccUserIDs.Length > 0)
        //{
        //    string strErrMsg = "";
        //    //new SendMobileMsg().AutoSenMobilMsg(strMessageContent, strSendBy, strAccUserIDs, true, "", ref strErrMsg);

        //}

        #region 消息体
        isSuccess = SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false;
        if (isSuccess)
        {
            if (strID.Length > 0)
            {
                new PageBase().WriteLog("编辑短消息信息", "", new UserLogInfo().UserInfo.USER_NAME + "编辑短消息信息" + strID);
            }
            else
            {
                new PageBase().WriteLog("添加短消息信息", "", new UserLogInfo().UserInfo.USER_NAME + "添加短消息信息" + strID);
            }
        }
        #endregion

        if (isSuccess)
        {
            return("1");
        }
        else
        {
            return("0");
        }
    }
Exemple #24
0
 /// <summary>
 /// 根据对象特征获取单一对象
 /// </summary>
 /// <param name="tOaMessageInfoReceive">对象</param>
 /// <returns></returns>
 public TOaMessageInfoReceiveVo SelectByObject(TOaMessageInfoReceiveVo tOaMessageInfoReceive)
 {
     return(access.SelectByObject(tOaMessageInfoReceive));
 }