public static List <StudentTable> getInfo(string user, out int id) { string sql = "select * from StudentTable where s_UserName = '******'"; SqlParameter[] p = new SqlParameter[] { }; DataTable dt = SqlHelper.ExecuteDataTable(sql, p); List <StudentTable> l = new List <StudentTable>(); id = 0; if (dt.Rows.Count > 0) { StudentTable stu = new StudentTable(); stu.s_id = Convert.ToInt32(dt.Rows[0]["s_Id"]); id = stu.s_id; stu.s_RealName = dt.Rows[0]["s_RealName"].ToString(); stu.s_Professional = dt.Rows[0]["s_Professional"].ToString(); stu.s_Department = dt.Rows[0]["s_Department"].ToString(); stu.s_Phone = dt.Rows[0]["s_Phone"].ToString(); stu.s_Sex = dt.Rows[0]["s_Sex"].ToString(); stu.s_Address = dt.Rows[0]["s_Address"].ToString(); stu.s_Email = dt.Rows[0]["s_Email"].ToString(); stu.s_PhotoPath = dt.Rows[0]["s_PhotoPath"].ToString(); l.Add(stu); } return(l); }
/// <summary> /// 将兼职表的数据行转换成model /// </summary> /// <param name="dr"></param> /// <param name="model">空</param> public static void SetDr2Model(DataRow dr, PTJob model) { if (dr["pt_Id"].ToString() != "") { model.pt_Id = int.Parse(dr["pt_Id"].ToString()); } model.pt_Kind = dr["pt_Kind"].ToString(); model.pt_Time = dr["pt_Time"].ToString(); model.pt_ReleaseTime = dr["pt_ReleaseTime"].ToString(); if (dr["pt_eId"].ToString() != "") { model.pt_eId = int.Parse(dr["pt_eId"].ToString()); model.Pt_employee = new Employee(); EmployeeTable.SetDr2Model(dr, model.Pt_employee); } if (dr["pt_Money"].ToString() != "") { model.pt_Money = int.Parse(dr["pt_Money"].ToString()); } model.pt_Address = dr["pt_Address"].ToString(); model.pt_Tel = dr["pt_Tel"].ToString(); model.pt_State = dr["pt_State"].ToString(); model.pt_Name = dr["pt_Name"].ToString(); model.pt_Kind = dr["pt_Kind"].ToString(); if (dr["pt_StuId"].ToString() != "") { model.pt_StuId = int.Parse(dr["pt_StuId"].ToString()); model.Pt_student = new Student(); StudentTable.SetDr2Model(dr, model.Pt_student); } if (dr["pt_Need"].ToString() != "") { model.pt_Need = int.Parse(dr["pt_Need"].ToString()); } }
/// <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)); }
public static void SetDr2Model(DataRow dr, Resume model) { if (dr["re_UserId"].ToString() != "") { model.re_UserId = int.Parse(dr["re_UserId"].ToString()); model.Re_Student = new Student(); StudentTable.SetDr2Model(dr, model.Re_Student); } if (dr["re_Id"].ToString() != "") { model.re_Id = int.Parse(dr["re_Id"].ToString()); } model.re_Skill = dr["re_Skill"].ToString(); model.re_Edu = dr["re_Edu"].ToString(); model.re_Describe = dr["re_Describe"].ToString(); model.re_WorkTime = dr["re_WorkTime"].ToString(); }
public static List <StudentTable> getAll(int page, string search) { string sql = "select * from StudentTable where s_Id = '" + search + "' or s_UserName like '%" + search + "%' or s_Professional like '%" + search + "%' or s_Department like '%" + search + "%' or s_Phone like '%" + search + "%' order by s_Id offset @page rows fetch next 5 rows only"; SqlParameter[] p = new SqlParameter[] { new SqlParameter("@page", (page - 1) * 5) }; DataTable dt = SqlHelper.ExecuteDataTable(sql, p); List <StudentTable> l = new List <StudentTable>(); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { StudentTable stu = new StudentTable(); stu.s_id = Convert.ToInt32(row["s_Id"]); stu.s_UserName = row["s_UserName"].ToString(); stu.s_Professional = row["s_Professional"].ToString(); stu.s_Department = row["s_Department"].ToString(); stu.s_Phone = row["s_Phone"].ToString(); l.Add(stu); } } return(l); }