コード例 #1
0
        public static List <ResumeTable> getAll(int id)
        {
            string sql = "select * from ResumeTable where re_UserId = '" + id + "';";

            SqlParameter[]     p  = new SqlParameter[] { };
            DataTable          dt = SqlHelper.ExecuteDataTable(sql, p);
            List <ResumeTable> l  = new List <ResumeTable>();

            if (dt.Rows.Count > 0)
            {
                foreach (DataRow row in dt.Rows)
                {
                    try
                    {
                        ResumeTable re = new ResumeTable();
                        re.re_Edu      = row["re_Edu"].ToString();
                        re.re_WorkTime = row["re_WorkTime"].ToString();
                        re.re_Describe = row["re_Describe"].ToString();
                        re.re_Skill    = row["re_Skill"].ToString();
                        l.Add(re);
                    }
                    catch { }
                }
            }
            return(l);
        }
コード例 #2
0
        /// <summary>
        /// 插入数据[cat66]
        /// </summary>
        /// <param name="user"></param>
        public static void insertdata(string user, int ptid)
        {
            //int ptid=1;
            int sid  = StudentTable.getstuid(user);
            int reid = ResumeTable.getreid(sid);

            string sql = "insert into DeliveryTable(RE_Id,PT_Id) values(@reid,@ptid)";

            SqlHelper.ExecuteNonQuery(sql, new SqlParameter("reid", reid), new SqlParameter("ptid", ptid));
        }
コード例 #3
0
 public static void SetDr2Model(DataRow dr, Delivery model)
 {
     if (dr["PT_Id"].ToString() != "")
     {
         model.PT_Id    = int.Parse(dr["PT_Id"].ToString());
         model.DE_PTJob = new PTJob();
         PTJobTable.SetDr2Model(dr, model.DE_PTJob);
     }
     if (dr["DE_Id"].ToString() != "")
     {
         model.DE_Id = int.Parse(dr["DE_Id"].ToString());
     }
     if (dr["RE_Id"].ToString() != "")
     {
         model.RE_Id     = int.Parse(dr["RE_Id"].ToString());
         model.DE_Resume = new Resume();
         ResumeTable.SetDr2Model(dr, model.DE_Resume);
     }
     model.RE_Pass = dr["RE_Pass"].ToString();
     if (dr["DE_Time"].ToString() != "")
     {
         model.DE_Time = DateTime.Parse(dr["DE_Time"].ToString());
     }
 }