//待办事宜声音提醒
public void DbsyMusic()
{
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
DataTable dt = Hyoa_dbsy.Getdbsys_dbanddy(this.Session["hyuid"].ToString());
if (dt.Rows.Count > 0)
{
if (Session["dbsymusic"].ToString() == "")
{
lbldbsy_music.Text = "<bgsound src=\"hyhtml/images/dbsy.mp3\" loop=\"True\"></bgsound>";
Session["dbsymusic"] = dt.Rows[0]["hy_createtime"].ToString();
}
else
{
DateTime t1 = DateTime.Parse(Session["dbsymusic"].ToString());
DateTime t2 = DateTime.Parse(dt.Rows[0]["hy_createtime"].ToString());
System.TimeSpan ts = t2 - t1;
double days = ts.TotalSeconds;
if (days > 0)
{
lbldbsy_music.Text = "<bgsound src=\"hyhtml/images/dbsy.mp3\" loop=\"True\"></bgsound>";
Session["dbsymusic"] = dt.Rows[0]["hy_createtime"].ToString();
}
}
}
}
public void hy_dbsy()
{
string ls_uid = "";
if (this.Request.QueryString["uid"] != null)
ls_uid = this.Request.QueryString["uid"].ToString();
string ls_pwd = "";
if (this.Request.QueryString["pwd"] != null)
ls_pwd = this.Request.QueryString["pwd"].ToString();
if (ls_uid != "")
{
//得到待办事宜
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
DataTable dt;
dt = Hyoa_dbsy.Getdbsys_dbanddy(ls_uid);
int i, j;
string lstitle;
i = 20;//显示条数
if (dt.Rows.Count < i)
i = dt.Rows.Count;
for (j = 0; j < i; j++)
{
lstitle = dt.Rows[j]["hy_subbt"].ToString() + "-" + dt.Rows[j]["hy_bt"].ToString();
if (lstitle.Length > 18)
lstitle = lstitle.Substring(0, 18) + "...";
this.lbdbsy.Text += "·<a href='/ggdy/cy_login.aspx?uid=" + ls_uid + "&pwd=" + ls_pwd + "&redirectto=/ggdy/Hy_DbToYb.aspx?id=" + dt.Rows[j]["ID"].ToString() + "' title='" + dt.Rows[j]["hy_subbt"].ToString() + "-" + dt.Rows[j]["hy_bt"].ToString() + "' target='_blank'>" + lstitle + "</a> [" + System.DateTime.Parse(dt.Rows[j]["hy_createtime"].ToString()).ToString("MM-dd") + "]<br />";
}
if (this.lbdbsy.Text == "")
this.lbdbsy.Text = "·暂无记录！";
}
}
public void hy_dbsy()
{
//得到待办事宜
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
DataTable dt;
dt = Hyoa_dbsy.Getdbsys_dbanddy(this.Session["hyuid"].ToString());
int i, j;
string lstitle;
i = 8;//显示条数
if (dt.Rows.Count < i)
i = dt.Rows.Count;
for (j = 0; j < i; j++)
{
string ls_mudelid = dt.Rows[j]["hy_mudelid"].ToString();
string ls_mudelname = "";
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt_getmudel = Hyoa_mudel.Getmudel(ls_mudelid);
if (dt_getmudel.Rows.Count > 0)
ls_mudelname = dt_getmudel.Rows[0]["hy_mudelname"].ToString();
lstitle = "[" + ls_mudelname + "]" + dt.Rows[j]["hy_subbt"].ToString() + "-" + dt.Rows[j]["hy_bt"].ToString();
if (ls_mudelid == "yzgl")
{
lstitle = lstitle + "用印申请";
}
if (lstitle.Length > 35)
lstitle = lstitle.Substring(0, 35) + "...";
this.lbdbsy.Text += "<tr height='18px'><td valign='top'>·<a href='ggdy/Hy_DbToYb.aspx?id=" + dt.Rows[j]["ID"].ToString() + "' title='[" + ls_mudelname + "]" + dt.Rows[j]["hy_subbt"].ToString() + "-" + dt.Rows[j]["hy_bt"].ToString() + "' target='_blank'>" + lstitle + "</a> [" + System.DateTime.Parse(dt.Rows[j]["hy_createtime"].ToString()).ToShortDateString().ToString() + "]</td></tr>";
}
if (this.lbdbsy.Text == "")
this.lbdbsy.Text = "·暂无记录！";
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("/login.aspx");
if (!this.IsPostBack)
{
this.lbluserinfo.Text = "您好，" + Session["hyuname"].ToString() + "[" + Session["hydeptname"].ToString() + "]";
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
DataTable dt = Hyoa_dbsy.Getdbsys_dbanddy(Session["hyuid"].ToString());
this.lbldbsynum.Text = dt.Rows.Count.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//得到待办事宜数
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
DataTable dt = Hyoa_dbsy.Getdbsys_dbanddy(Session["hyuid"].ToString());
this.Response.Write(dt.Rows.Count.ToString());
this.Response.Write("|");
//得到未读站内消息
HyoaClass.Hyoa_jstx_info Hyoa_jstx_info = new HyoaClass.Hyoa_jstx_info();
DataTable dt2 = Hyoa_jstx_info.GetDocByReceiveuserid_wd(Session["hyuid"].ToString());
this.Response.Write(dt2.Rows.Count.ToString());
this.Response.Write("|");
//在线用户（得到人数前先更新一下数据）
//更新当前用户的在线时间
HyoaClass.Hyoa_jstx_zxry Hyoa_jstx_zxry = new HyoaClass.Hyoa_jstx_zxry();
DataTable dt3 = Hyoa_jstx_zxry.GetDocByUserid(this.Session["hyuid"].ToString());
if (dt3.Rows.Count > 0)
{
Hyoa_jstx_zxry.ID = dt3.Rows[0]["ID"].ToString();
Hyoa_jstx_zxry.hy_userid = dt3.Rows[0]["hy_userid"].ToString();
Hyoa_jstx_zxry.hy_username = dt3.Rows[0]["hy_username"].ToString();
Hyoa_jstx_zxry.hy_datetime = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
Hyoa_jstx_zxry.Update();
}
else
{
Hyoa_jstx_zxry.ID = System.Guid.NewGuid().ToString();
Hyoa_jstx_zxry.hy_userid = this.Session["hyuid"].ToString();
Hyoa_jstx_zxry.hy_username = this.Session["hyuname"].ToString();
Hyoa_jstx_zxry.hy_datetime = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
Hyoa_jstx_zxry.Insert();
}
//删除已经过期的在线用户数据(时间距离当前时间已有15分钟)
Hyoa_jstx_zxry.Delete_offline(15);
DataTable dt_zxry = Hyoa_jstx_zxry.GetDocs();
this.Response.Write(dt_zxry.Rows.Count.ToString());
//return ;
}
private void DataPlay()
{
//hy_json = "{\"success\":true,\"total\":\"60\",\"rows\":[{\"hy_mudelid\":\"111\",\"hy_mudelname\":\"1111\",\"hy_roleid\":\"111111\",\"hy_qqroleid\":\"111111\",\"hy_isenabled\":\"111111\"}]}";
string hy_json = "";
string ls_success = "true"; //调用方法成功
string ls_flag = "0"; //待办事宜条数
string username = "";
if (this.Request.QueryString["txt_username"] == null)
{
ls_flag = "-1"; //参数不对
}
else
{
username = this.Request.QueryString["txt_username"].ToString().ToLower();
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
DataTable dt = Hyoa_dbsy.Getdbsys_dbanddy(username);
ls_flag = dt.Rows.Count.ToString();
}
hy_json = "{\"success\":" + ls_success + ",\"flag\":\"" + ls_flag + "\"}";
Response.Write(hy_json);
}
public string Gethy_field(string ls_num)
{
string ls_return = "";
string ls_show = ""; //这个区域的内容
string ls_temp = "";
string lstitle = "";
string ls_url = "";
string ls_sql = "";
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//得到待办事宜
if (ls_num == "1")
{
ls_show = "待办事宜"; //这个区域的内容
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
DataTable dt = Hyoa_dbsy.Getdbsys_dbanddy(this.Session["hyuid"].ToString());
int i = 5; //显示条数
if (dt.Rows.Count < i)
i = dt.Rows.Count;
for (int j = 0; j < i; j++)
{
string ls_mudelid = dt.Rows[j]["hy_mudelid"].ToString();
string ls_mudelname = "";
DataTable dt_getmudel = Hyoa_mudel.Getmudel(ls_mudelid);
if (dt_getmudel.Rows.Count > 0)
ls_mudelname = dt_getmudel.Rows[0]["hy_mudelname"].ToString();
lstitle = "[" + ls_mudelname + "]" + dt.Rows[j]["hy_subbt"].ToString() + "-" + dt.Rows[j]["hy_bt"].ToString();
if (lstitle.Length > 20)
lstitle = lstitle.Substring(0, 20) + "...";
ls_url = "ggdy/Hy_DbToYb.aspx?id=" + dt.Rows[j]["ID"].ToString() + "&pop=1&rnd=" + System.Guid.NewGuid().ToString();
ls_temp += "<tr>";
ls_temp += "<td height=\"22\" background=\"hyhtml/desk/line.gif\">";
ls_temp += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_temp += "<tbody>";
ls_temp += "<tr>";
ls_temp += "<td width=\"72%\"> <a title=\"" + "[" + ls_mudelname + "]" + dt.Rows[j]["hy_subbt"].ToString() + "-" + dt.Rows[j]["hy_bt"].ToString() + "\" onclick=\"window.open('" + ls_url + "')\" href=\"javascript:\"><b>" + lstitle + "</b></a></td>";
ls_temp += "<td width=\"28%\" align=\"right\">";
ls_temp += "<font color=\"#056ea5\">" + System.DateTime.Parse(dt.Rows[j]["hy_createtime"].ToString()).ToShortDateString().ToString() + "</font> </td>";
ls_temp += "</tr>";
ls_temp += "</tbody>";
ls_temp += "</table>";
ls_temp += "</td>";
ls_temp += "</tr>";
}
if (ls_temp == "")
{
ls_temp += "<tr>";
ls_temp += "<td height=\"22\" background=\"hyhtml/desk/line.gif\">";
ls_temp += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_temp += "<tbody>";
ls_temp += "<tr>";
ls_temp += "<td width=\"100%\"> 暂无记录！</td>";
ls_temp += "</tr>";
ls_temp += "</tbody>";
ls_temp += "</table>";
ls_temp += "</td>";
ls_temp += "</tr>";
}
ls_return += "<div style=\"position: relative; padding-bottom: 0px\" id=\"module_1\">";
ls_return += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" style=\"height: 160px;border-bottom: 1px solid #cccccc\">";
ls_return += "<tbody>";
ls_return += "<tr>";
ls_return += "<td height=\"25\">";
ls_return += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_return += "<tbody>";
ls_return += "<tr>";
ls_return += "<td style=\"cursor: move; color: #262d33; font-weight: bold\" id=\"module_1_head\" class=\"Navigation\" width=\"72%\"> <img align=\"absMiddle\" src=\"hyhtml/images/ico/FUNC20029.gif\"> " + ls_show + "</td>";
ls_return += "</tr>";
ls_return += "</tbody>";
ls_return += "</table>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += ls_temp;
ls_return += "<tr>";
ls_return += "<td height=\"22\" align=\"right\">";
ls_return += "<a href=\"#\" onclick=\"window.open('system/list_dbsy.aspx')\"><font color=\"red\">";
ls_return += " 更多>>..</font></a>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += "<tr>";
ls_return += "<td>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += "</tbody>";
ls_return += "</table>";
ls_return += "</div>";
ls_return += "<div>";
ls_return += "</div>";
}
//得到电子邮件
if (ls_num == "2")
{
ls_show = "最新客户"; //这个区域的内容
ls_sql = "select * from hyc_Tablekhda order by hy_djsj desc ";
DataTable dt = Hyoa_global.GetDataTable(ls_sql);
int i = 5; //显示条数
if (dt.Rows.Count < i)
i = dt.Rows.Count;
for (int j = 0; j < i; j++)
{
lstitle = dt.Rows[j]["hyc_dwmc"].ToString();
if (lstitle.Length > 20)
lstitle = lstitle.Substring(0, 20) + "...";
ls_url = "main_look.aspx?op=modify&mid=Mudelkhda&tableid=Tablekhda&pop=1&docid=" + dt.Rows[j]["DOCID"].ToString();
ls_temp += "<tr>";
ls_temp += "<td height=\"22\" background=\"hyhtml/desk/line.gif\">";
ls_temp += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_temp += "<tbody>";
ls_temp += "<tr>";
ls_temp += "<td width=\"72%\"> <a title=\"" + lstitle + "\" onclick=\"window.open('" + ls_url + "&rnd='+Math.random())\" href=\"javascript:\">· " + lstitle + "</a></td>";
ls_temp += "<td width=\"28%\" align=\"right\"></td>";
ls_temp += "</tr>";
ls_temp += "</tbody>";
ls_temp += "</table>";
ls_temp += "</td>";
ls_temp += "</tr>";
}
if (ls_temp == "")
{
ls_temp += "<tr>";
ls_temp += "<td height=\"22\" background=\"hyhtml/desk/line.gif\">";
ls_temp += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_temp += "<tbody>";
ls_temp += "<tr>";
ls_temp += "<td width=\"100%\"> 暂无记录！</td>";
ls_temp += "</tr>";
ls_temp += "</tbody>";
ls_temp += "</table>";
ls_temp += "</td>";
ls_temp += "</tr>";
}
ls_return += "<div style=\"position: relative; padding-bottom: 0px\" id=\"module_2\">";
ls_return += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" style=\"height: 160px;border-bottom: 1px solid #cccccc\">";
ls_return += "<tbody>";
ls_return += "<tr>";
ls_return += "<td height=\"25\">";
ls_return += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_return += "<tbody>";
ls_return += "<tr>";
ls_return += "<td style=\"cursor: move; color: #262d33; font-weight: bold\" id=\"module_2_head\" class=\"Navigation\" width=\"72%\"> <img align=\"absMiddle\" src=\"hyhtml/images/ico/FUNC20029.gif\"> " + ls_show + "</td>";
ls_return += "</tr>";
ls_return += "</tbody>";
ls_return += "</table>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += ls_temp;
ls_return += "<tr>";
ls_return += "<td height=\"22\" align=\"right\">";
ls_return += "<a href=\"#\" onclick=\"window.open('list_flc.aspx?mid=Mudelkhda&tableid=Tablekhda&listid=d3044ced-8273-4e7a-83b2-870580dde7a1&rnd='+Math.random())\"><font color=\"red\">";
ls_return += " 更多>>..</font></a>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += "<tr>";
ls_return += "<td>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += "</tbody>";
ls_return += "</table>";
ls_return += "</div>";
ls_return += "<div>";
ls_return += "</div>";
}
//得到日程安排
if (ls_num == "3")
{
ls_show = "最新客户故障"; //这个区域的内容
ls_sql = "select * from hyc_Tablekhgzdj where hy_djrid='" + Session["hyuid"].ToString() + "' order by hy_djsj desc ";
DataTable dt = Hyoa_global.GetDataTable(ls_sql);
int i = 5; //显示条数
if (dt.Rows.Count < i)
i = dt.Rows.Count;
for (int j = 0; j < i; j++)
{
lstitle = dt.Rows[j]["hyc_dwmc"].ToString();
if (lstitle.Length > 20)
lstitle = lstitle.Substring(0, 20) + "...";
ls_url = "main_look.aspx?op=modify&mid=Mudelkhda&tableid=Tablekhgzdj&pop=1&docid=" + dt.Rows[j]["DOCID"].ToString();
ls_temp += "<tr>";
ls_temp += "<td height=\"22\" background=\"hyhtml/desk/line.gif\">";
ls_temp += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_temp += "<tbody>";
ls_temp += "<tr>";
ls_temp += "<td width=\"72%\"> <a title=\"" + dt.Rows[j]["hyc_dwmc"].ToString() + "\" onclick=\"window.open('" + ls_url + "&rnd='+Math.random())\" href=\"javascript:\">" + lstitle + "</a></td>";
ls_temp += "<td width=\"28%\" align=\"right\">";
ls_temp += "<font color=\"#056ea5\">" + System.DateTime.Parse(dt.Rows[j]["hy_djsj"].ToString()).ToShortDateString().ToString() + "</font> </td>";
ls_temp += "</tr>";
ls_temp += "</tbody>";
ls_temp += "</table>";
ls_temp += "</td>";
ls_temp += "</tr>";
}
if (ls_temp == "")
{
ls_temp += "<tr>";
ls_temp += "<td height=\"22\" background=\"hyhtml/desk/line.gif\">";
ls_temp += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_temp += "<tbody>";
ls_temp += "<tr>";
ls_temp += "<td width=\"100%\"> 暂无记录！</td>";
ls_temp += "</tr>";
ls_temp += "</tbody>";
ls_temp += "</table>";
ls_temp += "</td>";
ls_temp += "</tr>";
}
ls_return += "<div style=\"position: relative; padding-bottom: 0px\" id=\"module_3\">";
ls_return += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" style=\"height: 160px;border-bottom: 1px solid #cccccc\">";
ls_return += "<tbody>";
ls_return += "<tr>";
ls_return += "<td height=\"25\">";
ls_return += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_return += "<tbody>";
ls_return += "<tr>";
ls_return += "<td style=\"cursor: move; color: #262d33; font-weight: bold\" id=\"module_3_head\" class=\"Navigation\" width=\"72%\"> <img align=\"absMiddle\" src=\"hyhtml/images/ico/FUNC20029.gif\"> " + ls_show + "</td>";
ls_return += "</tr>";
ls_return += "</tbody>";
ls_return += "</table>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += ls_temp;
ls_return += "<tr>";
ls_return += "<td height=\"22\" align=\"right\">";
ls_return += "<a href=\"#\" onclick=\"window.open('list_flc.aspx?mid=Mudelkhda&tableid=Tablekhgzdj&listid=afbdf289-c511-4b91-a2c7-bdb4d510ca78&rnd='+Math.random())\"><font color=\"red\">";
ls_return += " 更多>>..</font></a>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += "<tr>";
ls_return += "<td>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += "</tbody>";
ls_return += "</table>";
ls_return += "</div>";
ls_return += "<div>";
ls_return += "</div>";
}
//得到通知公告
if (ls_num == "4")
{
ls_show = "最新合同"; //这个区域的内容
Dictionary<string, DateTime> dic = new Dictionary<string, DateTime>();
string sqlSelect = "";
//合同表单id
string[] arryStr = new string[] { "Tablesyyhfwxy", "Tablejdhazfwht", "TableVODfwxy", "Tableffpdfwht", "TableDVBazfwdght", "Tablejwdsjsxy", "Tablejwdscsxy", "Tablekdjrht", "Tablesjcsfwht", "Tablesjgdcsfwht", "Tablesjtxyyhzxy", "Tablezdyht" };
//将所有表单的登记时间和DOCID Tableid放入集合中
for (int i = 0; i < arryStr.Length; i++)
{
sqlSelect = " select docid,hy_djsj from hyc_" + arryStr[i] + " order by hy_djsj desc ";
DataTable dt = Hyoa_global.GetDataTable(sqlSelect);
//获取每个表单一个的表单id 表名 和登记时间
if (dt.Rows.Count > 0)
{
dic.Add(dt.Rows[0]["docid"].ToString() + "#" + arryStr[i], Convert.ToDateTime(dt.Rows[0]["hy_djsj"].ToString()));
}
}
//开始对登记时间进行排序
string[] arrayName = new string[dic.Count];
DateTime[] arrayValue = new DateTime[dic.Count];
dic.Keys.CopyTo(arrayName, 0);
dic.Values.CopyTo(arrayValue, 0);
//会根据arrayValue的值进行升序排序，arrayName对应的会进行位置调整
Array.Sort(arrayValue, arrayName);
//降序
Array.Reverse(arrayValue);
Array.Reverse(arrayName);
//重新将值放到新的集合中
IDictionary<string, DateTime> dicSorted = new Dictionary<string, DateTime>();
for (int i = 0; i < arrayName.Length; i++)
{
dicSorted.Add(arrayName[i], dic[arrayName[i]]);
}
//定义一个数组 通过循环 将key放入数组中
string[] Docid = new string[dicSorted.Count];
int j = 0;
foreach (string lsDocid in dicSorted.Keys)
{
Docid[j] = lsDocid;
j++;
}
//取集合前六个的值 通过数组中存储的key对集合进行删除操作
if (Docid.Length > 5)
{
for (int i = 5; i < Docid.Length; i++)
{
dicSorted.Remove(Docid[i]);
}
}
//对集合前六个合同进行数据加工 输出到前台
foreach (string lsDocid in dicSorted.Keys)
{
string lsTitle = "";
string[] lsData = lsDocid.Split('#');
sqlSelect = " select * from hyc_" + lsData[1] + " where docid ='" + lsData[0] + "' ";
DataTable dt = Hyoa_global.GetDataTable(sqlSelect);
sqlSelect = " select hy_name from hyt_tableconfig where id='" + lsData[1] + "' ";
DataTable dt2 = Hyoa_global.GetDataTable_BASE(sqlSelect);
if (dt.Rows.Count > 0 && dt2.Rows.Count > 0)
{
lsTitle = "[" + dt2.Rows[0]["hy_name"].ToString() + "]-" + dt.Rows[0]["hyc_jfmc"].ToString();
if (lsTitle.Length > 20)
lsTitle = lsTitle.Substring(0, 20) + "...";
ls_temp += "<tr>";
ls_temp += "<td height=\"22\" background=\"hyhtml/desk/line.gif\">";
ls_temp += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_temp += "<tbody>";
ls_temp += "<tr>";
ls_temp += "<td width=\"72%\"> <a href=\"#\" onclick=\" var path='main_look.aspx?op=modify&mid=" + dt.Rows[0]["hy_mudelid"].ToString() + "&tableid=" + dt.Rows[0]["hy_tableid"].ToString() + "&docid=" + dt.Rows[0]["docid"].ToString() + " ';window.open(path) \" >·" + lsTitle + "</a></td>";
ls_temp += "<td width=\"28%\" align=\"right\">";
ls_temp += "<font color=\"#056ea5\">" + System.DateTime.Parse(dt.Rows[0]["hy_djsj"].ToString()).ToShortDateString().ToString() + "</font> </td>";
ls_temp += "</tr>";
ls_temp += "</tbody>";
ls_temp += "</table>";
ls_temp += "</td>";
ls_temp += "</tr>";
}
}
if (ls_temp == "")
{
ls_temp += "<tr>";
ls_temp += "<td height=\"22\" background=\"hyhtml/desk/line.gif\">";
ls_temp += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_temp += "<tbody>";
ls_temp += "<tr>";
ls_temp += "<td width=\"100%\"> 暂无记录！</td>";
ls_temp += "</tr>";
ls_temp += "</tbody>";
ls_temp += "</table>";
ls_temp += "</td>";
ls_temp += "</tr>";
}
ls_return += "<div style=\"position: relative; padding-bottom: 0px\" id=\"module_4\">";
ls_return += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" style=\"height: 160px;border-bottom: 1px solid #cccccc\">";
ls_return += "<tbody>";
ls_return += "<tr>";
ls_return += "<td height=\"25\">";
ls_return += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_return += "<tbody>";
ls_return += "<tr>";
ls_return += "<td style=\"cursor: move; color: #262d33; font-weight: bold\" id=\"module_4_head\" class=\"Navigation\" width=\"72%\"> <img align=\"absMiddle\" src=\"hyhtml/images/ico/FUNC20029.gif\"> " + ls_show + "</td>";
ls_return += "</tr>";
ls_return += "</tbody>";
ls_return += "</table>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += ls_temp;
ls_return += "<tr>";
ls_return += "<td height=\"22\" align=\"right\">";
//ls_return += "<a href=\"#\" onclick=\"window.open('list_fl.aspx?key=%u5DF2%u53D1%u5E03&mid=Mudeltzgg&tableid=Tabletzgg&listid=fe10af45-e302-4e56-911e-e73fae37cf5a&rnd=c70a7237-f92f-4d9d-8bd3-e343efba54e3&rnd='+Math.random())\"><font color=\"red\">";
//ls_return += " 更多>>..</font></a>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += "<tr>";
ls_return += "<td>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += "</tbody>";
ls_return += "</table>";
ls_return += "</div>";
ls_return += "<div>";
ls_return += "</div>";
}
//得到会议动态
if (ls_num == "5")
{
ls_show = "即将过期合同"; //这个区域的内容
int j = 0;
string sqlSelect = "";
//合同表单id
string[] arryStr = new string[] { "Tablesyyhfwxy", "Tablejdhazfwht", "TableVODfwxy", "Tableffpdfwht", "TableDVBazfwdght", "Tablejwdsjsxy", "Tablejwdscsxy", "Tablekdjrht", "Tablesjcsfwht", "Tablesjgdcsfwht", "Tablesjtxyyhzxy" };
for (int i = 0; i < arryStr.Length; i++)
{
sqlSelect = " select * from hyc_" + arryStr[i] + " ";
DataTable dt = Hyoa_global.GetDataTable(sqlSelect);
string lsTitle = "";
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["hyc_htzzsj"].ToString() != "")
{
if ((Convert.ToDateTime(dt.Rows[0]["hyc_htzzsj"].ToString()).AddDays(-5) >= Convert.ToDateTime(DateTime.Now)))
{
sqlSelect = " select hy_name from hyt_tableconfig where id='" + arryStr[i] + "' ";
DataTable dt2 = Hyoa_global.GetDataTable_BASE(sqlSelect);
if (dt2.Rows.Count > 0)
{
lsTitle = "[" + dt2.Rows[0]["hy_name"].ToString() + "]-" + dt.Rows[0]["hyc_jfmc"].ToString();
if (lsTitle.Length > 20)
lsTitle = lsTitle.Substring(0, 20) + "...";
ls_temp += "<tr>";
ls_temp += "<td height=\"22\" background=\"hyhtml/desk/line.gif\">";
ls_temp += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_temp += "<tbody>";
ls_temp += "<tr>";
ls_temp += "<td width=\"72%\"> <a href=\"#\" onclick=\" var path='main_look.aspx?op=modify&mid=" + dt.Rows[0]["hy_mudelid"].ToString() + "&tableid=" + dt.Rows[0]["hy_tableid"].ToString() + "&docid=" + dt.Rows[0]["docid"].ToString() + " ';window.open(path) \" >·" + lsTitle + "</a></td>";
ls_temp += "<td width=\"28%\" align=\"right\">";
ls_temp += "<font color=\"#056ea5\">" + System.DateTime.Parse(dt.Rows[0]["hy_djsj"].ToString()).ToShortDateString().ToString() + "</font> </td>";
ls_temp += "</tr>";
ls_temp += "</tbody>";
ls_temp += "</table>";
ls_temp += "</td>";
ls_temp += "</tr>";
j++;
}
}
}
}
if (j == 5)
{
break;
}
}
if (ls_temp == "")
{
ls_temp += "<tr>";
ls_temp += "<td height=\"22\" background=\"hyhtml/desk/line.gif\">";
ls_temp += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_temp += "<tbody>";
ls_temp += "<tr>";
ls_temp += "<td width=\"100%\"> 暂无记录！</td>";
ls_temp += "</tr>";
ls_temp += "</tbody>";
ls_temp += "</table>";
ls_temp += "</td>";
ls_temp += "</tr>";
}
ls_return += "<div style=\"position: relative; padding-bottom: 0px\" id=\"module_5\">";
ls_return += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" style=\"height: 160px;border-bottom: 1px solid #cccccc\">";
ls_return += "<tbody>";
ls_return += "<tr>";
ls_return += "<td height=\"25\">";
ls_return += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_return += "<tbody>";
ls_return += "<tr>";
ls_return += "<td style=\"cursor: move; color: #262d33; font-weight: bold\" id=\"module_5_head\" class=\"Navigation\" width=\"72%\"> <img align=\"absMiddle\" src=\"hyhtml/images/ico/FUNC20029.gif\"> " + ls_show + "</td>";
ls_return += "</tr>";
ls_return += "</tbody>";
ls_return += "</table>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += ls_temp;
ls_return += "<tr>";
ls_return += "<td height=\"22\" align=\"right\">";
//ls_return += "<a href=\"#\" onclick=\"window.open('list.aspx?mid=Mudelhydt&tableid=Tablehydt&listid=72aeaf0e-5387-46c1-a329-654147c634f0&rnd='+Math.random())\"><font color=\"red\">";
//ls_return += " 更多>>..</font></a>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += "<tr>";
ls_return += "<td>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += "</tbody>";
ls_return += "</table>";
ls_return += "</div>";
ls_return += "<div>";
ls_return += "</div>";
}
//得到公文库
if (ls_num == "6")
{
ls_show = "已过期合同"; //这个区域的内容
string sqlSelect = "";
int j = 0;
//合同表单id
string[] arryStr = new string[] { "Tablesyyhfwxy", "Tablejdhazfwht", "TableVODfwxy", "Tableffpdfwht", "TableDVBazfwdght", "Tablejwdsjsxy", "Tablejwdscsxy", "Tablekdjrht", "Tablesjcsfwht", "Tablesjgdcsfwht", "Tablesjtxyyhzxy" };
for (int i = 0; i < arryStr.Length; i++)
{
sqlSelect = " select * from hyc_" + arryStr[i] + " order by hyc_htzzsj desc ";
DataTable dt = Hyoa_global.GetDataTable(sqlSelect);
string lsTitle = "";
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["hyc_htzzsj"].ToString() != "")
{
if ((Convert.ToDateTime(dt.Rows[0]["hyc_htzzsj"].ToString()) < Convert.ToDateTime(DateTime.Now)))
{
sqlSelect = " select hy_name from hyt_tableconfig where id='" + arryStr[i] + "' ";
DataTable dt2 = Hyoa_global.GetDataTable_BASE(sqlSelect);
if (dt2.Rows.Count > 0)
{
lsTitle = "[" + dt2.Rows[0]["hy_name"].ToString() + "]-" + dt.Rows[0]["hyc_jfmc"].ToString();
if (lsTitle.Length > 20)
lsTitle = lsTitle.Substring(0, 20) + "...";
ls_temp += "<tr>";
ls_temp += "<td height=\"22\" background=\"hyhtml/desk/line.gif\">";
ls_temp += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_temp += "<tbody>";
ls_temp += "<tr>";
ls_temp += "<td width=\"72%\"> <a href=\"#\" onclick=\" var path='main_look.aspx?op=modify&mid=" + dt.Rows[0]["hy_mudelid"].ToString() + "&tableid=" + dt.Rows[0]["hy_tableid"].ToString() + "&docid=" + dt.Rows[0]["docid"].ToString() + " ';window.open(path) \" >·" + lsTitle + "</a></td>";
ls_temp += "<td width=\"28%\" align=\"right\">";
ls_temp += "<font color=\"#056ea5\">" + Convert.ToDateTime(dt.Rows[0]["hy_djsj"].ToString()).ToString("yyyy/MM/dd") + "</font> </td>";
ls_temp += "</tr>";
ls_temp += "</tbody>";
ls_temp += "</table>";
ls_temp += "</td>";
ls_temp += "</tr>";
j++;
}
}
}
}
if (j == 5)
{
break;
}
}
if (ls_temp == "")
{
ls_temp += "<tr>";
ls_temp += "<td height=\"22\" background=\"hyhtml/desk/line.gif\">";
ls_temp += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_temp += "<tbody>";
ls_temp += "<tr>";
ls_temp += "<td width=\"100%\"> 暂无记录！</td>";
ls_temp += "</tr>";
ls_temp += "</tbody>";
ls_temp += "</table>";
ls_temp += "</td>";
ls_temp += "</tr>";
}
ls_return += "<div style=\"position: relative; padding-bottom: 0px\" id=\"module_6\">";
ls_return += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" style=\"height: 160px;border-bottom: 1px solid #cccccc\">";
ls_return += "<tbody>";
ls_return += "<tr>";
ls_return += "<td height=\"25\">";
ls_return += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_return += "<tbody>";
ls_return += "<tr>";
ls_return += "<td style=\"cursor: move; color: #262d33; font-weight: bold\" id=\"module_6_head\" class=\"Navigation\" width=\"72%\"> <img align=\"absMiddle\" src=\"hyhtml/images/ico/FUNC20029.gif\"> " + ls_show + "</td>";
ls_return += "</tr>";
ls_return += "</tbody>";
ls_return += "</table>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += ls_temp;
ls_return += "<tr>";
ls_return += "<td height=\"22\" align=\"right\">";
//ls_return += "<a href=\"#\" onclick=\"window.open('gwk/index.aspx?rnd='+Math.random())\"><font color=\"red\">";
//ls_return += " 更多>>..</font></a>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += "<tr>";
ls_return += "<td>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += "</tbody>";
ls_return += "</table>";
ls_return += "</div>";
ls_return += "<div>";
ls_return += "</div>";
}
return ls_return;
}
//得到待办事宜数
protected void getdbsys()
{
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
DataTable dt = Hyoa_dbsy.Getdbsys_dbanddy(Session["hyuid"].ToString());
this.lbldbsys.Text = dt.Rows.Count.ToString();
}
private void DataPlay(int PageNo)
{
//判断当前用户是否有新建删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
//{
// this.tddeldoc.Visible = true; //删除
//}
//else
//{
// this.tddeldoc.Visible = false; //删除
//}
//得到当前页号
this.curpage.Text = PageNo.ToString();
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
DataTable dt;
dt = Hyoa_dbsy.Getdbsys_dbanddy(Session["hyuid"].ToString());
DataTable tempTable = dt.Clone();
DataColumn col = new DataColumn("mudelname", typeof(String));
tempTable.Columns.Add(col);
for (int i = (PageNo - 1) * System.Int32.Parse(PageSize.Text); i < PageNo * System.Int32.Parse(PageSize.Text); i++)
{
if (i > dt.Rows.Count - 1)
break;
DataRow dr = tempTable.NewRow();
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
//根据模块ID得到模块名称
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt_mudel = Hyoa_mudel.Getmudel(dt.Rows[i]["hy_mudelid"].ToString());
if(dt_mudel.Rows.Count>0)
dr["mudelname"] = dt_mudel.Rows[0]["hy_mudelname"].ToString();
tempTable.Rows.Add(dr);
}
int TotalRecord = dt.Rows.Count;
this.sumts.Text = TotalRecord.ToString();
this.sumts2.Text = TotalRecord.ToString();
this.ShowTotalRecord.Text = TotalRecord.ToString();
//计算及显示总页数
int TotalPage;
if (TotalRecord < System.Int32.Parse(PageSize.Text))
{
TotalPage = 1;
}
else
{
if (TotalRecord % System.Int32.Parse(PageSize.Text) != 0)
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text) + 1;
}
else
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text);
}
}
this.ShowTotalPage.Text = TotalPage.ToString();
this.rptlist.DataSource = tempTable;
this.rptlist.DataBind();
dt.Clear();
}
