protected void btnImport_Click(object sender, EventArgs e) { String sql; sql = ""; if (this.lblDisplay.Text == "") { this.lblReturnInformation.Text = "请先保存Excel文件!"; } else { sql = ""; sql = " select 姓名,日期,签到时间,签退时间,是否旷工,例外情况,部门 from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=''" + this.lblDisplay.Text + "'';User ID=admin;Password=;Extended properties=Excel 5.0')...Sheet1$ "; HyoaClass.DAO db = new HyoaClass.DAO(); HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain(); DataTable dt = db.GetDataTable(sql); HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); DataTable dtuser; for (int j = 0; j < dt.Rows.Count; j++) { HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); //文档ID Hyoa_flowmain.DOCID = Hyoa_global.GetRandom(); Hyoa_flowmain.hy_mudelid = "kqgl"; Hyoa_flowmain.hy_tableid = "74e7e280-4fc5-4ccb-be3d-0f995ac2c934"; Hyoa_flowmain.hy_flowid = ""; Hyoa_flowmain.hy_flowname = ""; Hyoa_flowmain.hy_curtacheid = ""; Hyoa_flowmain.hy_curtachename = ""; Hyoa_flowmain.hy_curclrid = ""; Hyoa_flowmain.hy_curclrname = ""; dtuser = Hyoa_user.GetusersbynameforCX(dt.Rows[j]["姓名"].ToString()); if (dtuser.Rows.Count > 0) { Hyoa_flowmain.hy_djrid = dtuser.Rows[0]["hy_userid"].ToString(); Hyoa_flowmain.hy_djrbmid = dtuser.Rows[0]["hy_deptid"].ToString(); } else { Hyoa_flowmain.hy_djrid = ""; Hyoa_flowmain.hy_djrbmid = ""; } Hyoa_flowmain.hy_djrname = dt.Rows[j]["姓名"].ToString(); Hyoa_flowmain.hy_djrbmname = dt.Rows[j]["部门"].ToString(); Hyoa_flowmain.hy_djsj = System.DateTime.Now.ToString(); Hyoa_flowmain.hy_bt = ""; Hyoa_flowmain.hy_content1 = ""; Hyoa_flowmain.hy_content2 = ""; Hyoa_flowmain.hy_content3 = ""; Hyoa_flowmain.hy_content4 = ""; Hyoa_flowmain.hy_content5 = ""; Hyoa_flowmain.hy_content6 = ""; Hyoa_flowmain.hy_content7 = ""; Hyoa_flowmain.hy_content8 = ""; Hyoa_flowmain.hy_content9 = ""; Hyoa_flowmain.hy_content10 = ""; Hyoa_flowmain.hy_content11 = ""; Hyoa_flowmain.hy_content12 = ""; Hyoa_flowmain.hy_content13 = ""; Hyoa_flowmain.hy_content14 = ""; Hyoa_flowmain.hy_content15 = ""; Hyoa_flowmain.hy_field1 = dt.Rows[j]["签到时间"].ToString(); Hyoa_flowmain.hy_field2 = dt.Rows[j]["签退时间"].ToString(); if (dt.Rows[j]["是否旷工"].ToString() == "True") { Hyoa_flowmain.hy_field3 = "是"; } else { Hyoa_flowmain.hy_field3 = ""; } Hyoa_flowmain.hy_field4 = dt.Rows[j]["例外情况"].ToString(); Hyoa_flowmain.hy_field5 = ""; Hyoa_flowmain.hy_field6 = ""; Hyoa_flowmain.hy_field7 = ""; Hyoa_flowmain.hy_field8 = ""; Hyoa_flowmain.hy_field9 = ""; Hyoa_flowmain.hy_field10 = ""; Hyoa_flowmain.hy_field11 = ""; Hyoa_flowmain.hy_field12 = ""; Hyoa_flowmain.hy_field13 = ""; Hyoa_flowmain.hy_field14 = ""; Hyoa_flowmain.hy_field15 = ""; Hyoa_flowmain.hy_field16 = ""; Hyoa_flowmain.hy_field17 = ""; Hyoa_flowmain.hy_field18 = ""; Hyoa_flowmain.hy_field19 = ""; Hyoa_flowmain.hy_field20 = ""; Hyoa_flowmain.hy_field21 = ""; Hyoa_flowmain.hy_field22 = ""; Hyoa_flowmain.hy_field23 = ""; Hyoa_flowmain.hy_field24 = ""; Hyoa_flowmain.hy_field25 = ""; Hyoa_flowmain.hy_field26 = ""; Hyoa_flowmain.hy_field27 = ""; Hyoa_flowmain.hy_field28 = ""; Hyoa_flowmain.hy_field29 = ""; Hyoa_flowmain.hy_field30 = ""; Hyoa_flowmain.hy_field31 = dt.Rows[j]["日期"].ToString(); ; Hyoa_flowmain.hy_field32 = ""; Hyoa_flowmain.hy_field33 = ""; Hyoa_flowmain.hy_field34 = ""; Hyoa_flowmain.hy_field35 = ""; Hyoa_flowmain.hy_field36 = 0; Hyoa_flowmain.hy_field37 = 0; Hyoa_flowmain.hy_field38 = 0; Hyoa_flowmain.hy_field39 = 0; Hyoa_flowmain.hy_field40 = 0; Hyoa_flowmain.hy_field41 = ""; Hyoa_flowmain.hy_field42 = ""; Hyoa_flowmain.hy_field43 = ""; Hyoa_flowmain.hy_field44 = ""; Hyoa_flowmain.hy_field45 = ""; Hyoa_flowmain.hy_field46 = ""; Hyoa_flowmain.hy_field47 = ""; Hyoa_flowmain.hy_field48 = ""; Hyoa_flowmain.hy_field49 = ""; Hyoa_flowmain.hy_field50 = ""; Hyoa_flowmain.hy_field51 = ""; Hyoa_flowmain.hy_field52 = ""; Hyoa_flowmain.hy_field53 = ""; Hyoa_flowmain.hy_field54 = ""; Hyoa_flowmain.hy_field55 = ""; Hyoa_flowmain.hy_field56 = ""; Hyoa_flowmain.hy_field57 = ""; Hyoa_flowmain.hy_field58 = ""; Hyoa_flowmain.hy_field59 = ""; Hyoa_flowmain.hy_field60 = ""; Hyoa_flowmain.hy_field61 = ""; Hyoa_flowmain.hy_field62 = ""; Hyoa_flowmain.hy_field63 = ""; Hyoa_flowmain.hy_field64 = ""; Hyoa_flowmain.hy_field65 = ""; Hyoa_flowmain.hy_field66 = ""; Hyoa_flowmain.hy_field67 = ""; Hyoa_flowmain.hy_field68 = ""; Hyoa_flowmain.hy_field69 = ""; Hyoa_flowmain.hy_field70 = ""; Hyoa_flowmain.hy_field71 = 0; Hyoa_flowmain.hy_field72 = 0; Hyoa_flowmain.hy_field73 = 0; Hyoa_flowmain.hy_field74 = 0; Hyoa_flowmain.hy_field75 = 0; Hyoa_flowmain.hy_field76 = 0; Hyoa_flowmain.hy_field77 = 0; Hyoa_flowmain.hy_field78 = 0; Hyoa_flowmain.hy_field79 = 0; Hyoa_flowmain.hy_field80 = 0; Hyoa_flowmain.hy_field81 = 0; Hyoa_flowmain.hy_field82 = 0; Hyoa_flowmain.hy_field83 = 0; Hyoa_flowmain.hy_field84 = 0; Hyoa_flowmain.hy_field85 = 0; Hyoa_flowmain.hy_field86 = 0; Hyoa_flowmain.hy_field87 = 0; Hyoa_flowmain.hy_field88 = 0; Hyoa_flowmain.hy_field89 = 0; Hyoa_flowmain.hy_field90 = 0; Hyoa_flowmain.hy_field91 = 0; Hyoa_flowmain.hy_field92 = 0; Hyoa_flowmain.hy_field93 = 0; Hyoa_flowmain.hy_field94 = 0; Hyoa_flowmain.hy_field95 = 0; Hyoa_flowmain.hy_field96 = 0; Hyoa_flowmain.hy_field97 = 0; Hyoa_flowmain.hy_field98 = 0; Hyoa_flowmain.hy_field99 = 0; Hyoa_flowmain.hy_field100 = 0; Hyoa_flowmain.hy_iftx = ""; Hyoa_flowmain.hy_zhtxsj = ""; Hyoa_flowmain.hy_readuserlist = ""; Hyoa_flowmain.Insert(); } db.Close(); this.lblReturnInformation.Text = "导入成功"; if (File.Exists(this.lblDisplay.Text)) { System.IO.File.Delete(this.lblDisplay.Text); } } }
private void DataPlay(int PageNo) { //判断当前用户是否有新建删除权限 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole("Role9990", this.Session["hyuid"].ToString())) { this.isrole.Value = "1"; this.tdnewdoc.Visible = true; //新建 this.tddeldoc.Visible = true; //删除 } else { this.isrole.Value = "0"; this.tdnewdoc.Visible = false; //新建 this.tddeldoc.Visible = false; //删除 } if (this.txtdeptid.Value == "") this.tdnewdoc.Visible = false; //新建 //得到当前页号 this.curpage.Text = PageNo.ToString(); HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); DataTable dt; if (this.hy_name.Value != "") { if (this.txtdeptid.Value == "") { dt = Hyoa_user.GetusersbynameforCX(this.hy_name.Value); } else { dt = Hyoa_user.GetusersbydeptidforCX(this.txtdeptid.Value, this.hy_name.Value); } } else { if (this.txtdeptid.Value == "") { //显示所有用户 dt = Hyoa_user.GetusersOrderbydeptsortandusersort(); } else { //按部门ID显示 dt = Hyoa_user.Getusersbydeptid(this.txtdeptid.Value); } } DataTable tempTable = dt.Clone(); DataColumn col = new DataColumn("ifjz", typeof(String)); //定义新的一列 是否兼职 tempTable.Columns.Add(col); //追加一列 add 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]; } if (dt.Rows[i]["hy_loginuid"].ToString() == "") { dr["ifjz"] = "<font color=red>[兼职信息]</font>"; //将新值赋给相应的列 add } else { dr["ifjz"] = ""; //将新值赋给相应的列 add } 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(); }
private void DataPlay(int PageNo) { //判断当前用户是否有新建删除权限 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString())) { this.isrole.Value = "1"; } else { this.isrole.Value = "0"; } //得到当前页号 this.curpage.Text = PageNo.ToString(); HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); DataTable dt; if (this.hy_name.Value != "") { if (this.txtdeptid.Value == "") { dt = Hyoa_user.GetusersbynameforCX(this.hy_name.Value); } else { dt = Hyoa_user.GetusersbydeptidforCX(this.txtdeptid.Value, this.hy_name.Value); } } else { if (this.txtdeptid.Value == "") { //显示所有用户 dt = Hyoa_user.GetusersOrderbydeptsortandusersort(); } else { //按部门ID显示 dt = Hyoa_user.Getusersbydeptid(this.txtdeptid.Value); } } DataTable tempTable = dt.Clone(); 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]; } 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(); }