Example #1
0
        protected void Button1_Click1(object sender, EventArgs e)
        {
            Zhaopin   zp_t = FTInterviewBLL.ZhaopinManage.GetZhaopinById(zpid);
            ZhaopinFb zf_t = FTInterviewBLL.ZhaopinFbManage.GetZhaopinFbByid(zp_t.ZpfbId);

            Response.Redirect("SearchMsjg.aspx?zpitmid=" + zf_t.ZpitmId);
        }
Example #2
0
        public static List <Zhaopin> GetAllZhaopinListByparameters(int dep = -1, string pos = "", string st = "", string et = "")
        {
            string sqlstr = "select zhaopin.id as Id," +
                            "zhaopin.title as Title," +
                            "zhaopin.zpfbid as ZPfbId," +
                            "zhaopin.interviewtime as PubTime," +
                            "department.departname as Bm," +
                            "zpgw.zppos as Position," +
                            "zpfb.sums as ZpSum," +
                            "zhaopin.hege as HegeLine, " +
                            "zhaopin.ktid as KTID " +
                            "from zhaopin,zpfb,zpgw,department" +
                            " where zhaopin.zpfbid=zpfb.id and zpfb.zpgwid=zpgw.id and zpgw.zpbm=department.id and zpfb.fbstate=1 and zhaopin.zpstate=1 and department.bmstate=1 ";

            if (dep != -1)
            {
                sqlstr += " and department.id=" + dep + " ";
                if (pos != "")
                {
                    sqlstr += " and zpgw.zppos='" + pos + "' ";
                }
            }

            if (st != "")
            {
                sqlstr += " and zhaopin.interviewtime >='" + st + "' ";
            }
            if (et != "")
            {
                sqlstr += " and zhaopin.interviewtime<='" + et + "' ";
            }
            sqlstr += " order by zhaopin.interviewtime DESC";

            DataTable      dt = MySqlDBHelper.GetDataSet(sqlstr);
            List <Zhaopin> ls = new List <Zhaopin>();

            foreach (DataRow dr in dt.Rows)
            {
                Zhaopin zp = new Zhaopin();
                zp.Id    = Convert.ToInt32(dr["Id"].ToString());
                zp.Title = dr["Title"].ToString();

                // DateTime date = (DateTime)dr["PubTime"];
                //zp.InterviewTime = date.ToShortDateString();
                zp.InterviewTime = dr["PubTime"].ToString();
                zp.ZpfbId        = Convert.ToInt32(dr["ZPfbId"].ToString());

                zp.KaotiID  = dr["KTID"].ToString() == "" ? 0 : Convert.ToInt32(dr["KTID"].ToString());
                zp.HegeLine = Convert.ToInt32(dr["HegeLine"].ToString());

                zp.ZpbmName = dr["Bm"].ToString();
                zp.ZpgwName = dr["Position"].ToString();
                zp.ZpSums   = Convert.ToInt32(dr["ZpSum"].ToString());


                ls.Add(zp);
            }

            return(ls);
        }
        protected void BindData()
        {
            HttpCookie c*k = Request.Cookies["ftcook"];

            if (c*k != null)
            {
                zp_id = Convert.ToInt32(c*k["zpid"]);
            }
            if (zp_id != -1)
            {
                Zhaopin   zp  = FTInterviewBLL.ZhaopinManage.GetZhaopinById(zp_id);
                ZhaopinFb zfb = FTInterviewBLL.ZhaopinFbManage.GetZhaopinFbByid(zp.ZpfbId);
                DataProcess.DepartmentBind(department);
                department.SelectedValue = "" + zfb.FbBmId;

                DataProcess.PositionBind(Position, zfb.FbBmId);
                Position.SelectedValue = zfb.ZpPosName;

                ZpSum.Value   = zfb.ZpSums + "";
                PubTime.Value = zp.InterviewTime;

                department.Enabled = false;
                Position.Enabled   = false;
                ZpSum.Disabled     = true;
                PubTime.Disabled   = true;

                /*List<YingpinzheZhaopin>*/
                ls = FTInterviewBLL.YingpinzheZhaopinManage.GetAllYingpinzheInzhaopinID(zp_id);

                YpSum.Text = ls.Count + "人";

                MsOrderGridview.DataSource = ls;
                MsOrderGridview.DataBind();
            }
        }
Example #4
0
        protected void BindData()
        {
            HttpCookie c*k = Request.Cookies["ftcook"];

            if (c*k != null)
            {
                zpid = Convert.ToInt32(c*k["zpid"]);
            }
            if (zpid != -1)
            {
                string  xuantistate = "抽选考题";
                Zhaopin zp          = FTInterviewBLL.ZhaopinManage.GetZhaopinById(zpid);
                if (zp.KaotiID != -1)
                {
                    xuantistate = "已" + xuantistate;
                    XuanTi.ControlStyle.ForeColor = System.Drawing.Color.Green;

                    ResultID.Visible = true;
                    LabelRes.Text    = zp.KaotiID + "";
                }
                else
                {
                    xuantistate = "未" + xuantistate;
                    XuanTi.ControlStyle.ForeColor = System.Drawing.Color.Red;

                    ResultID.Visible = false;
                }
                XuanTi.Text = xuantistate;
                List <YingpinzheZhaopin> ls =
                    FTInterviewBLL.YingpinzheZhaopinManage.GetAllYingpinzheInzhaopinID(zpid);
                MsOrderGridview.DataSource = ls;
                MsOrderGridview.DataBind();
            }
        }
        protected void Save_Button_Click(object sender, EventArgs e)
        {
            if (id != -1)
            {
                Zhaopin zpt = FTInterviewBLL.ZhaopinManage.GetZhaopinById(id);
                zpt.InterviewTime = MsTime.Value;
                zpt.HegeLine      = Convert.ToInt32(HegeScore.Value);

                FTInterviewBLL.ZhaopinManage.Update(zpt);
                Response.Write("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>");
                Response.Write("<script language=javascript>alert('更新成功!')</script>");
            }
        }
Example #6
0
        public static int Add(Zhaopin zp)
        {
            String sqlstr = "insert into zhaopin(title,interviewtime,zpfbid,ktid,hege,zpstate) values(@title,@interviewtime,@zpfbid,@ktid,@hege,@zpstate)";
            List <MySqlParameter> para_list = new List <MySqlParameter>();

            para_list.Add(new MySqlParameter("@title", zp.Title));
            para_list.Add(new MySqlParameter("@interviewtime", zp.InterviewTime));
            para_list.Add(new MySqlParameter("@zpfbid", zp.ZpfbId));
            para_list.Add(new MySqlParameter("@ktid", zp.KaotiID));
            para_list.Add(new MySqlParameter("@hege", zp.HegeLine));
            para_list.Add(new MySqlParameter("@zpstate", 1));

            return(MySqlDBHelper.ExecuteCommand(sqlstr, para_list.ToArray()));
        }
Example #7
0
        public static int Update(Zhaopin zp)
        {
            String sqlstr = "update zhaopin set title=@title,interviewtime=@interviewtime,zpfbid=@zpfbid,ktid=@ktid,hege=@hege where id=@id";
            List <MySqlParameter> para_list = new List <MySqlParameter>();

            para_list.Add(new MySqlParameter("@id", zp.Id));
            para_list.Add(new MySqlParameter("@title", zp.Title));
            para_list.Add(new MySqlParameter("@interviewtime", zp.InterviewTime));
            para_list.Add(new MySqlParameter("@zpfbid", zp.ZpfbId));
            para_list.Add(new MySqlParameter("@ktid", zp.KaotiID));
            para_list.Add(new MySqlParameter("@hege", zp.HegeLine));

            return(MySqlDBHelper.ExecuteCommand(sqlstr, para_list.ToArray()));
        }
Example #8
0
        protected void Button4_Click(object sender, EventArgs e)
        {
            if (id == -1)
            {
                Zhaopin zpt = new Zhaopin();
                zpt.Title         = department.SelectedItem.Text + "-" + Position.SelectedItem.Text + "招聘";
                zpt.InterviewTime = MsTime.Value;
                zpt.KaotiID       = -1;
                zpt.HegeLine      = Convert.ToInt32(HegeScore.Value);
                zpt.ZpState       = 1;
                zpt.ZpfbId        = zpfbid;

                int zpid_new = FTInterviewBLL.ZhaopinManage.AddReturnID(zpt);
                id      = zpid_new;
                zpidstr = id + "";
                Response.Write("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>");
                Response.Write("<script language=javascript>alert('添加成功!')</script>");
            }
            else
            {
                HttpCookie c*k = Request.Cookies["ftcook"];

                if (c*k == null || c*k["addaction"] == null)
                //if( Session["addaction"] ==null)
                {
                    Zhaopin zpt = FTInterviewBLL.ZhaopinManage.GetZhaopinById(id);
                    zpt.InterviewTime = MsTime.Value;
                    zpt.HegeLine      = Convert.ToInt32(HegeScore.Value);

                    zpidstr = id + "";

                    FTInterviewBLL.ZhaopinManage.Update(zpt);
                    Response.Write("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>");
                    Response.Write("<script language=javascript>alert('更新成功!')</script>");
                }
                else
                {
                    //Session["addaction"] = null;
                    //if (c*k != null)
                    {
                        c*k.Values.Remove("addaction");
                        // Response.AppendCookie(c*k);
                    }
                }
            }


            BindData();
        }
        protected void BindData(int _id = -1)
        {
            DataProcess.DepartmentBind(department);
            List <KaoguanZhaopin> ls    = new List <KaoguanZhaopin>();
            List <Yingpinzhe>     ypzls = new List <Yingpinzhe>();

            int zpfbid = -1;

            if (id != -1)
            {
                Zhaopin zp = FTInterviewBLL.ZhaopinManage.GetZhaopinById(id);

                ZhaopinFb zf = FTInterviewBLL.ZhaopinFbManage.GetZhaopinFbByid(zp.ZpfbId);

                zpfbid = zp.ZpfbId;

                MsName.Value    = zp.Title;
                MsTime.Value    = zp.InterviewTime;
                HegeScore.Value = zp.HegeLine + "";

                /////////////////////msg
                ls = FTInterviewBLL.KaoguanZhaopinManage.GetKgZPbyzpId(id);
                MsgGridview.DataSource = ls;
                MsgGridview.DataBind();
                /////////////////////ypz
                ypzls = FTInterviewBLL.YingpinzheZhaopinManage.GetAllYingpinzheInzhaopin(id);
                YpzGridview.DataSource = ypzls;
                YpzGridview.DataBind();
            }
            else
            {
                Step2Part.Visible = false;
            }

            MsgGridview.DataSource = ls;
            MsgGridview.DataBind();
            YpzGridview.DataSource = ypzls;
            YpzGridview.DataBind();

            if (zpfbid != -1)
            {
                ZhaopinFb zf = FTInterviewBLL.ZhaopinFbManage.GetZhaopinFbByid(zpfbid);
                department.SelectedValue = zf.FbBmId + "";
                DataProcess.PositionBind(Position, zf.FbBmId);
                Position.SelectedValue = zf.ZpPosName;
            }
            department.Enabled = false;
            Position.Enabled   = false;
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            HttpCookie c*k = Request.Cookies["ftcook"];

            if (c*k != null)
            {
                if (c*k["zpid"] != null)
                {
                    zpid = Convert.ToInt32(c*k["zpid"].ToString());
                    Zhaopin zp = FTInterviewBLL.ZhaopinManage.GetZhaopinById(zpid);
                    ktid = zp.KaotiID;

                    c*k.Values.Remove("ktid");
                    c*k.Values.Add("ktid", ktid + "");
                    c*k.Expires = DateTime.Now.AddDays(1);
                    Response.AppendCookie(c*k);
                }
                else
                {
                    Response.Redirect("../login.aspx");
                }
            }
            else
            {
                Response.Redirect("../login.aspx");
            }

            if (Request.QueryString["ms_id"] != null)
            {
                int ypzzpid         = Convert.ToInt32(Request["ms_id"]);
                YingpinzheZhaopin y = FTInterviewBLL.YingpinzheZhaopinManage.GetYPZZPbyId(ypzzpid);

                c*k.Values.Remove("ypzzpid");
                c*k.Values.Add("ypzzpid", y.ID + "");
                c*k.Expires = DateTime.Now.AddDays(1);
                Response.AppendCookie(c*k);
            }

            if (!IsPostBack)
            {
                stls.Clear();
                index = 1;
                BindData();
            }
        }
Example #11
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                HttpCookie c*k = Request.Cookies["ftcook"];
                if (c*k["ypzzpid"] != null)
                {
                    ypzzpid = Convert.ToInt32(c*k["ypzzpid"].ToString());
                }


                if (c*k != null)
                {
                    int _zpid = Convert.ToInt32(c*k["zpid"]);
                    int _kgid = Convert.ToInt32(c*k["kgid"]);


                    KaoguanZhaopin kgzp = FTInterviewBLL.KaoguanZhaopinManage.GetKgZPbyKgIdZpid(_kgid, _zpid);
                    if (kgzp != null)
                    {
                        kgzpid = kgzp.Id;
                    }
                }

                if (ypzzpid != -1)
                {
                    YingpinzheZhaopin t  = FTInterviewBLL.YingpinzheZhaopinManage.GetYPZZPbyId(ypzzpid);
                    Zhaopin           zp = FTInterviewBLL.ZhaopinManage.GetZhaopinById(t.ZhaopinId);
                    kaotiid = zp.KaotiID;
                    if (c*k != null)
                    {
                        c*k.Values.Remove("kaotiid");
                        c*k.Values.Add("kaotiid", kaotiid + "");
                        c*k.Expires = DateTime.Now.AddDays(1);
                        Response.AppendCookie(c*k);
                    }
                }
                flag = false;
                shitils.Clear();
                xdls.Clear();
            }
            BindData();
        }
Example #12
0
        public static int AddReturnID(Zhaopin zp)
        {
            String sql     = "select uuid()";
            string uni_str = "";

            while (true)
            {
                DataTable dt = MySqlDBHelper.GetDataSet(sql);
                if (dt.Rows.Count == 1)
                {
                    uni_str = dt.Rows[0][0].ToString();
                    dt.Clear();
                    break;
                }
            }

            String sqlstr = "insert into zhaopin(title,interviewtime,zpfbid,ktid,hege,zpstate,identifity) values(@title,@interviewtime,@zpfbid,@ktid,@hege,@zpstate,@identifity)";
            List <MySqlParameter> para_list = new List <MySqlParameter>();

            para_list.Add(new MySqlParameter("@title", zp.Title));
            para_list.Add(new MySqlParameter("@interviewtime", zp.InterviewTime));
            para_list.Add(new MySqlParameter("@zpfbid", zp.ZpfbId));
            para_list.Add(new MySqlParameter("@ktid", zp.KaotiID));
            para_list.Add(new MySqlParameter("@hege", zp.HegeLine));
            para_list.Add(new MySqlParameter("@zpstate", 1));
            para_list.Add(new MySqlParameter("@identifity", uni_str));

            MySqlDBHelper.ExecuteCommand(sqlstr, para_list.ToArray());

            sqlstr = "select id from zhaopin where identifity='" + uni_str + "'";

            DataTable resdt = MySqlDBHelper.GetDataSet(sqlstr);
            int       id    = -1;

            if (resdt.Rows.Count > 0)
            {
                id = Convert.ToInt32(resdt.Rows[0]["id"]);
            }
            return(id);
        }
Example #13
0
        public static Zhaopin GetZhaopinById(int zpid)
        {
            string sqlstr = "select zhaopin.id as Id," +
                            "zhaopin.title as Title," +
                            "zhaopin.zpfbid as ZPfbId," +
                            "zhaopin.interviewtime as PubTime," +
                            "department.departname as Bm," +
                            "zpgw.zppos as Position," +
                            "zpfb.sums as ZpSum," +
                            "zhaopin.hege as HegeLine, " +
                            "zhaopin.ktid as KTID " +
                            "from zhaopin,zpfb,zpgw,department" +
                            " where zhaopin.zpfbid=zpfb.id and zpfb.zpgwid=zpgw.id and zpgw.zpbm=department.id " +
                            " and zpfb.fbstate=1 and zhaopin.zpstate=1 and department.bmstate=1 and zhaopin.id=" + zpid;
            DataTable dt = MySqlDBHelper.GetDataSet(sqlstr);
            Zhaopin   zp = new Zhaopin();

            foreach (DataRow dr in dt.Rows)
            {
                zp.Id    = Convert.ToInt32(dr["Id"].ToString());
                zp.Title = dr["Title"].ToString();

                zp.InterviewTime = dr["PubTime"].ToString();
                zp.ZpfbId        = Convert.ToInt32(dr["ZPfbId"].ToString());

                zp.KaotiID  = dr["KTID"].ToString() == "" ? 0 : Convert.ToInt32(dr["KTID"].ToString());
                zp.HegeLine = Convert.ToInt32(dr["HegeLine"].ToString());

                zp.ZpbmName = dr["Bm"].ToString();
                zp.ZpgwName = dr["Position"].ToString();
                zp.ZpSums   = Convert.ToInt32(dr["ZpSum"].ToString());

                return(zp);
            }
            return(null);
        }
        private void BindData(int ypzid = -1, int zpid = -1)
        {
            YingpinzheZhaopin ypzzp = FTInterviewBLL.YingpinzheZhaopinManage.GetYPZZPbyId(ypzzpid);
            Yingpinzhe        ypz   = FTInterviewBLL.YingpinzheManage.GetYingpinzheById(ypzzp.YpzID);
            Zhaopin           zp    = FTInterviewBLL.ZhaopinManage.GetZhaopinById(ypzzp.ZhaopinId);

            yName.Text     = ypz.Name;
            BirthDay.Text  = ypz.Birthday;
            yDegree.Text   = ypz.XueliName;
            yJoinTime.Text = ypz.JoinTime;
            yDepart.Text   = ypz.YpDepName;
            yPosition.Text = ypz.YpPosName;
            yPolitic.Text  = ypz.XueliName;

            double sum = 0;

            List <KaoguanZhaopin> kgls = FTInterviewBLL.KaoguanZhaopinManage.GetKgZPbyzpId(ypzzp.ZhaopinId);
            int kgnum = kgls.Count;

            if (kgnum < 1)
            {
                return;
            }
            DataTable dt = new DataTable("Result");

            dt.Columns.Add("title", typeof(string));
            for (int i = 1; i <= kgnum; i++)
            {
                dt.Columns.Add("kg" + i, typeof(string));
            }
            DataRow dr = dt.NewRow();

            dr["title"] = "";
            for (int i = 1; i <= kgnum; i++)
            {
                dr["kg" + i] = kgls[i - 1].KgName;
            }
            dt.Rows.Add(dr);


            dr          = dt.NewRow();
            dr["title"] = "权重";
            for (int i = 1; i <= kgnum; i++)
            {
                dr["kg" + i] = "" + (Convert.ToDouble(kgls[i - 1].Weight) * 0.01);
            }
            dt.Rows.Add(dr);

            dr          = dt.NewRow();
            dr["title"] = "实际得分";
            for (int i = 1; i <= kgnum; i++)
            {
                double sco = FTInterviewBLL.PingfenManage.GetScoreSums(ypzzpid, kgls[i - 1].Id);
                dr["kg" + i] = "" + sco;
                sum         += kgls[i - 1].Weight * (double)sco * 0.01;
            }
            dt.Rows.Add(dr);

            dr          = dt.NewRow();
            dr["title"] = "面试得分";
            dr["kg1"]   = sum + "";//Convert.ToInt32(sum)+"";
            dt.Rows.Add(dr);

            ScoreDetailAll.DataSource = dt;
            ScoreDetailAll.DataBind();
            ScoreDetailAll.Rows[3].Cells[1].ColumnSpan = kgnum;
            for (int i = 2; i <= kgnum; i++)
            {
                ScoreDetailAll.Rows[3].Cells[i].Visible = false;
            }

            List <Shiti> stls  = FTInterviewBLL.ShitiManage.GetAllShitiByKaotiId(zp.KaotiID);
            int          tinum = stls.Count;
            //if(tinum>0)
            {
                DataTable dt1 = new DataTable("details");
                dt1.Columns.Add("title", typeof(string));
                for (int i = 1; i <= tinum; i++)
                {
                    dt1.Columns.Add("ti" + i, typeof(string));
                }

                DataRow dr1 = dt1.NewRow();
                dr1["title"] = "";
                for (int i = 1; i <= tinum; i++)
                {
                    dr1["ti" + i] = "试题" + i;
                }
                dt1.Rows.Add(dr1);


                for (int i = 0; i < kgls.Count; i++)
                {
                    dr1          = dt1.NewRow();
                    dr1["title"] = kgls[i].KgName;
                    dt1.Rows.Add(dr1);

                    dr1          = dt1.NewRow();
                    dr1["title"] = "权重";
                    for (int j = 1; j <= tinum; j++)
                    {
                        dr1["ti" + j] = stls[j - 1].Weight * 0.01;
                    }
                    dt1.Rows.Add(dr1);

                    List <double> realvalue = new List <double>();
                    double        sum_t     = 0;
                    dr1          = dt1.NewRow();
                    dr1["title"] = "实际得分";
                    for (int j = 0; j < tinum; j++)
                    {
                        int    val     = FTInterviewBLL.PingfenManage.GetScoreSumSingleTi(ypzzpid, kgls[i].Id, stls[j].Id);
                        double val_new = val * 0.01 * stls[j].Weight;
                        realvalue.Add(val_new);
                        sum_t += val_new;
                        dr1["ti" + (j + 1)] = val;
                    }
                    dt1.Rows.Add(dr1);

                    dr1          = dt1.NewRow();
                    dr1["title"] = "权重得分";
                    for (int j = 0; j < tinum; j++)
                    {
                        dr1["ti" + (j + 1)] = realvalue[j];
                    }
                    dt1.Rows.Add(dr1);

                    dr1          = dt1.NewRow();
                    dr1["title"] = "总分";
                    if (tinum > 0)
                    {
                        dr1["ti1"] = sum_t + "";
                    }
                    dt1.Rows.Add(dr1);
                }

                ScoreDetailEach.DataSource = dt1;
                ScoreDetailEach.DataBind();

                for (int k = 0; k < kgnum; k++)
                {
                    int myid = 1 + 5 * k;
                    ScoreDetailEach.Rows[myid].Cells[0].ColumnSpan = tinum + 1;
                    ScoreDetailEach.Rows[myid].Cells[0].ForeColor  = System.Drawing.Color.Red;

                    if (tinum > 0)
                    {
                        ScoreDetailEach.Rows[myid + 4].Cells[1].ColumnSpan = tinum;
                    }
                    for (int n = 1; n <= tinum; n++)
                    {
                        ScoreDetailEach.Rows[myid].Cells[n].Visible = false;
                    }
                    for (int n = 2; n <= tinum; n++)
                    {
                        ScoreDetailEach.Rows[myid + 4].Cells[n].Visible = false;
                    }
                }
            }
        }
Example #15
0
        protected void BindData()
        {
            DataProcess.DepartmentBind(department);
            if (zpid != -1)
            {
                Zhaopin   zp   = FTInterviewBLL.ZhaopinManage.GetZhaopinById(zpid);
                ZhaopinFb zpfb = FTInterviewBLL.ZhaopinFbManage.GetZhaopinFbByid(zp.ZpfbId);
                department.SelectedValue = zpfb.FbBmId.ToString();
                department.Enabled       = false;

                DataProcess.PositionBind(Position, zpfb.FbBmId);
                Position.SelectedValue = zpfb.ZpPosName;
                Position.Enabled       = false;

                MsTime.Value    = zp.InterviewTime;
                MsTime.Disabled = true;


                DateTime ddt = Convert.ToDateTime(zp.InterviewTime);

                title_f.Text = ddt.Year + "年北京铁路局丰台机务段公开招聘面试成绩";


                List <YingpinzheZhaopin> ls = FTInterviewBLL.YingpinzheZhaopinManage.GetAllYingpinzheInzhaopinID(zpid);

                DataTable dt = new DataTable("msg");
                dt.Columns.Add("Id", typeof(int));
                dt.Columns.Add("Name", typeof(string));
                dt.Columns.Add("bm_duty", typeof(string));
                dt.Columns.Add("duty", typeof(string));
                dt.Columns.Add("ypdep_pos", typeof(string));
                dt.Columns.Add("yppos", typeof(string));
                dt.Columns.Add("score", typeof(string));
                dt.Columns.Add("info", typeof(string));

                for (int i = 0; i < ls.Count; i++)
                {
                    DataRow           dr      = dt.NewRow();
                    YingpinzheZhaopin t_ypzzp = ls[i];
                    dr["Id"]      = t_ypzzp.ID;
                    dr["Name"]    = t_ypzzp.YpzName;
                    dr["bm_duty"] = t_ypzzp.YpzDepName + "-" + t_ypzzp.YpzPosName;
                    dr["duty"]    = t_ypzzp.YpzPosName;

                    dr["ypdep_pos"] = zp.ZpbmName + "-" + zp.ZpgwName;
                    dr["yppos"]     = zp.ZpgwName;
                    double sc = FTInterviewBLL.PingfenManage.GetScoreSums(t_ypzzp.ID);
                    dr["score"] = Convert.ToString(sc);
                    if (sc < zp.HegeLine)
                    {
                        dr["info"] = "不及格";
                    }
                    else
                    {
                        dr["info"] = "";
                    }
                    dt.Rows.Add(dr);
                }
                MsjgGridview.DataSource = dt;
                MsjgGridview.DataBind();
            }
        }
 public static int AddReturnID(Zhaopin zp)
 {
     return(FTInterviewDAL.ZhaopinService.AddReturnID(zp));
 }
Example #17
0
        protected void BindData()
        {
            HttpCookie c*k = Request.Cookies["ftcook"];

            if (c*k != null)
            {
                zpid   = Convert.ToInt32(c*k["zpid"]);
                kgzpid = Convert.ToInt32(c*k["kgzpid"]);
            }


            if (zpid != -1 && kgzpid != -1)
            {
                try
                {
                    Zhaopin zp = FTInterviewBLL.ZhaopinManage.GetZhaopinById(zpid);
                    MsTitle.Text = zp.Title;

                    ZhaopinFb fb = FTInterviewBLL.ZhaopinFbManage.GetZhaopinFbByid(zp.ZpfbId);
                    DataProcess.DepartmentBind(department, fb.FbBmId);
                    department.Enabled = false;
                    DataProcess.PositionBind(Position, fb.FbBmId);
                    Position.SelectedValue = fb.ZpPosName;
                    Position.Enabled       = false;

                    ZpSum.Value      = fb.ZpSums + "";
                    PubTime.Value    = zp.InterviewTime;
                    ZpSum.Disabled   = true;
                    PubTime.Disabled = true;

                    DataTable dt = FTInterviewBLL.YingpinzheZhaopinManage.GetAllYPZZPInzpId(zpid);

                    dt.Columns.Add("Score", typeof(string));
                    dt.Columns.Add("State", typeof(string));
                    foreach (DataRow dr in dt.Rows)
                    {
                        dr["SubState"] = FTInterviewBLL.YpzZhaopinkgzpManage.GetByypzidkgid(
                            Convert.ToInt32(dr["Id"].ToString()), kgzpid).KgYpzSubmitState + "";

                        if (dr["SubState"].ToString() == "1")
                        {
                            dr["State"] = "已提交";
                        }
                        else if (dr["SubState"].ToString() == "0")
                        {
                            dr["State"] = "未提交";
                        }

                        dr["Score"] = FTInterviewBLL.PingfenManage.GetScoreSums(Convert.ToInt32(dr["Id"].ToString()),
                                                                                kgzpid);
                    }

                    /*
                     * DataTable dtCopy = dt.Copy();
                     * DataView dv = dt.DefaultView;
                     * dv.Sort = "Score desc";
                     * dtCopy = dv.ToTable();
                     */

                    MszGridview.DataSource           = dt;
                    AspNetPagerAskAnswer.RecordCount = dt.Rows.Count;
                    MszGridview.DataBind();
                }
                catch (System.Exception ex)
                {
                }
            }
        }
 public static int Update(Zhaopin zp)
 {
     return(FTInterviewDAL.ZhaopinService.Update(zp));
 }