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