예제 #1
0
        public static DataTable GetPersonal(string Uname, string inserttime)
        {
            COMDLL    com = new COMDLL();
            DataTable dt  = com.COM_Select("OA_PersonalTB", "Uname", "inserttime", Uname, inserttime, 8);

            return(dt);
        }
예제 #2
0
        public static void UpPersonal(string Id, string note, string inserttime)
        {
            COMDLL    com = new COMDLL();
            DataTable dt  = com.COM_Select("OA_PersonalTB", "Id", "", Id, "", 4);
            DataRow   dr  = dt.Rows[0];

            dr["note"]       = note;
            dr["inserttime"] = inserttime;
            com.COM_Up(dt, "OA_PersonalTB", "note=@note,inserttime=@inserttime", Id);
        }
예제 #3
0
        /// 添加个人便签
        public static void ADDPersonal(string Uname, string note, string inserttime)
        {
            COMDLL    com = new COMDLL();
            DataTable dt  = com.COM_Select("OA_PersonalTB", "", "", "", "", 3);

            dt.Rows.Clear();
            DataRow dr = dt.NewRow();

            dr["Uname"]      = Uname;
            dr["note"]       = note;
            dr["inserttime"] = inserttime;
            dt.Rows.Add(dr);
            com.COM_Add(dt, "OA_PersonalTB", "@Uname,@note,@inserttime");
        }
예제 #4
0
        /// <summary>
        /// 添加系统消息数据
        /// </summary>
        /// <param name="typeId">0 短信,1=通知公告,2=学习资料,3=邮件,4=未读任务,5=请求验收任务,6=任务验收结果通知,7=任务快到期限提醒,8=申请协调新时间提醒</param>
        /// <param name="recives">接收者</param>
        /// <param name="titles">内容主题</param>
        /// <param name="remark">详细内容</param>
        /// <param name="pages">链接到那个页面</param>
        public static void ADDsysMessage(int typeId, string recives, string titles, string remark, string pages)
        {
            COMDLL    com = new COMDLL();
            DataTable dt  = com.COM_Select("OA_SysMessage", "", "", "", "", 3);

            dt.Rows.Clear();
            DataRow dr = dt.NewRow();

            dr["typeId"]  = typeId;
            dr["recives"] = recives;
            dr["titles"]  = titles;
            dr["remark"]  = remark;
            dr["pages"]   = pages;
            dt.Rows.Add(dr);
            com.COM_Add(dt, "OA_SysMessage", "@typeId,@recives,@titles,@remark,@pages");
        }
예제 #5
0
        public static void DelPersonal(string sid)
        {
            COMDLL com = new COMDLL();

            com.COM_Del("OA_PersonalTB", sid, 1);
        }
예제 #6
0
        /// <summary>
        /// 得到消息框信息
        ///  0 短信,1=通知公告,2=学习资料,3=邮件,4=未读任务,5=请求验收任务,6=任务验收结果通知,7=任务快到期限提醒,8=申请协调新时间提醒
        /// </summary>
        /// <param name="uid">当前登录编号</param>
        /// <returns></returns>
        public static DataTable getsysMessage(string uid)
        {
            //0 短信,1=通知公告,2=学习资料,3=邮件,4=未读任务,5=请求验收任务,6=任务验收结果通知,7=任务快到期限提醒,8=申请协调新时间提醒
            COMDLL    com   = new COMDLL();
            DataTable table = com.COM_Proc_Sel2("Pc_SeltopSysMessage", "4", uid);

            if (table.Rows.Count != 0)
            {
                return(table);
            }
            else
            {
                table = com.COM_Proc_Sel2("Pc_SeltopSysMessage", "7", uid);
            }
            if (table.Rows.Count != 0)
            {
                return(table);
            }
            else
            {
                table = com.COM_Proc_Sel2("Pc_SeltopSysMessage", "1", uid);
            }
            if (table.Rows.Count != 0)
            {
                return(table);
            }
            else
            {
                table = com.COM_Proc_Sel2("Pc_SeltopSysMessage", "8", uid);
            }
            if (table.Rows.Count != 0)
            {
                return(table);
            }
            else
            {
                table = com.COM_Proc_Sel2("Pc_SeltopSysMessage", "5", uid);
            }
            if (table.Rows.Count != 0)
            {
                return(table);
            }
            else
            {
                table = com.COM_Proc_Sel2("Pc_SeltopSysMessage", "0", uid);
            }
            if (table.Rows.Count != 0)
            {
                return(table);
            }
            else
            {
                table = com.COM_Proc_Sel2("Pc_SeltopSysMessage", "6", uid);
            }
            if (table.Rows.Count != 0)
            {
                return(table);
            }
            else
            {
                table = com.COM_Proc_Sel2("Pc_SeltopSysMessage", "2", uid);
            }
            return(table);
        }
예제 #7
0
        /// <summary>
        /// 更新消息框状态
        ///
        /// </summary>
        ///
        /// <param name="recives">更新接收者</param>
        /// <param name="i">条件 0表示更新接收者,其他表示关闭此消息</param>
        ///
        public static void UPsysMessage(string Id, string recives, int i)
        {
            COMDLL com = new COMDLL();

            com.COM_Proc_DelorUp_3("Pc_UPSysMessage", Id, recives, Convert.ToString(i));
        }