//待办事宜声音提醒 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(); }