예제 #1
0
    protected void btninputrsxt_Click(object sender, EventArgs e)
    {
        HyoaClass.Hyoa_score Hyoa_score = new HyoaClass.Hyoa_score();
        HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
        Hyoa_score.hy_djsj_start = this.hy_djsj_start_1.Value;
        Hyoa_score.hy_djsj_end = this.hy_djsj_end_1.Value;
        Hyoa_score.hy_score = this.txtscortbyys.Text;
        DataTable dt3 = Hyoa_score.GetAllByScore();
        for (int kk = 0; kk < dt3.Rows.Count; kk++)
        {
            //更新内容
            HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
            //文档ID
            Hyoa_flowmain.DOCID = Hyoa_global.GetRandom();
            Hyoa_flowmain.hy_mudelid = "rsgl";
            Hyoa_flowmain.hy_tableid = "6047076e-6a95-4fb8-aec8-5551d3900590";
            Hyoa_flowmain.hy_flowid = "";
            Hyoa_flowmain.hy_flowname = "";
            Hyoa_flowmain.hy_curtacheid = "";
            Hyoa_flowmain.hy_curtachename = "";
            Hyoa_flowmain.hy_curclrid = "";
            Hyoa_flowmain.hy_curclrname = "";
            Hyoa_flowmain.hy_djrid = this.Session["hyuid"].ToString();
            Hyoa_flowmain.hy_djrname = this.Session["hyuname"].ToString();
            Hyoa_flowmain.hy_djrbmid = this.Session["hydeptid"].ToString();
            Hyoa_flowmain.hy_djrbmname = this.Session["hydeptname"].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_field1 = dt3.Rows[kk]["hy_username"].ToString();
            Hyoa_flowmain.hy_field2 = dt3.Rows[kk]["hy_deptname"].ToString();
            Hyoa_flowmain.hy_field3 = "";
            Hyoa_flowmain.hy_field4 = "";
            Hyoa_flowmain.hy_field5 = "";
            Hyoa_flowmain.hy_field6 = dt3.Rows[kk]["hy_officetel"].ToString();
            Hyoa_flowmain.hy_field7 = dt3.Rows[kk]["hy_hometel"].ToString();
            Hyoa_flowmain.hy_field8 = dt3.Rows[kk]["hy_mobile"].ToString();
            Hyoa_flowmain.hy_field9 = dt3.Rows[kk]["hy_virtualnumber"].ToString();
            Hyoa_flowmain.hy_field10 = dt3.Rows[kk]["hy_userid"].ToString();
            Hyoa_flowmain.hy_field11 = "考试得分";
            Hyoa_flowmain.hy_field12 = this.txtscort.Text;
            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 = "";
            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.Insert();
        }
        this.Response.Write("<script>alert('"+dt3.Rows.Count.ToString()+"条考试信息,成功导入到人事系统中!')</script>");
    }
예제 #2
0
    //保存
    protected void Button_Save_Click(object sender, EventArgs e)
    {
        if (this.Session["hyuid"].ToString() == "")
            this.Response.Redirect("/login.aspx");

        string ls_tip = "保存成功!";
        HyoaClass.Hyoa_score Hyoa_score = new HyoaClass.Hyoa_score();
        HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
        Hyoa_score.ID = Hyoa_global.GetRandom();
        Hyoa_score.hy_userid = this.Session["hyuid"].ToString();
        Hyoa_score.hy_score = this.txtsumscore.Text;
        Hyoa_score.hy_djsj = System.DateTime.Now.ToString();
        Hyoa_score.Insert();

        ////处理完成后的提示及跳转
        //if (this.txtifpop.Value == "")
        //{
        //    Response.Write("<script>alert('" + ls_tip + "');</script>");
        //}
        //else
        //{
        //    Response.Write("<script>alert('" + ls_tip + "');self.close();</script>");
        //}
    }
예제 #3
0
    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";
        //    this.tdnewdoc.Visible = true; //新建
        //    this.tddeldoc.Visible = true; //删除

        //}
        //else
        //{
        //    this.isrole.Value = "0";
        //    this.tdnewdoc.Visible = false; //新建
        //    this.tddeldoc.Visible = false; //删除
        //}

        //得到当前页号
        this.curpage.Text = PageNo.ToString();
        HyoaClass.Hyoa_score Hyoa_score = new HyoaClass.Hyoa_score();

        DataTable dt;
        Hyoa_score.hy_djsj_start = this.hy_djsj_start_1.Value;
        Hyoa_score.hy_djsj_end = this.hy_djsj_end_1.Value;
        dt = Hyoa_score.GetscoresUnionByUser();

        DataTable dt2 = Hyoa_score.GetAvgScores();
        this.lbavg.Text = dt2.Rows[0][0].ToString();

        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();
    }