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); }
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); }
/// 添加个人便签 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"); }
/// <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"); }