/// <summary> /// 根据学号查询某学生异动信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public DataTable GetAllChangeTypeRecode(ChangeTypesRecodeModel model) { string sql = "select ChangeTypesRecode_ID 异动编号, ChangeReason 异动原因,ChangeDate 异动时间,ChangeTypes_Name 异动类型 from ChangeTypes a join ChangeTypesRecode b on a.ChangeTypes_ID=b.ChangeTypes_ID where ChangeStudentID=@0"; DataTable dt = SqlHelper.GetDataTable(sql, model.ChangeStudentID); return(dt); }
void BindChangeType() { ChangeRecodeBLL recode = new ChangeRecodeBLL(); ChangeTypesRecodeModel model = new ChangeTypesRecodeModel(); model.ChangeStudentID = sid; this.dgvXueJiType.DataSource = recode.GetAllChangeTypeRecode(model); }
/// <summary> /// 删除异动信息 /// </summary> /// <param name="model"></param> public void DelAllChangeRecode(ChangeTypesRecodeModel model) { string sql = "delete ChangeTypesRecode where ChangeTypesRecode_ID=@0"; SqlHelper.ExNonQuery(sql, "删除异动信息", model.ChangeTypesRecode_ID); }
/// <summary> /// 添加学籍异动信息 /// </summary> /// <param name="model"></param> public void AddChangeRecode(ChangeTypesRecodeModel model) { string sql = "insert into ChangeTypesRecode values(@0,@1,@2,@3)"; SqlHelper.ExNonQuery(sql, "添加学籍异动信息", model.ChangeTypes_ID, model.ChangeReason, model.ChangeStudentID, model.ChangeDate); }
/// <summary> /// 获取指定学生异动记录 /// </summary> /// <param name="model">异动记录实体对象</param> /// <returns></returns> public DataTable GetChangeRecodeByStudent(ChangeTypesRecodeModel model) { string sql = "select * from ChangeTypesRecode where ChangeStudentID=@0"; return(SqlHelper.GetDataTable(sql, model.ChangeStudentID)); }
public void DelAllChangeRecode(ChangeTypesRecodeModel model) { change.DelAllChangeRecode(model); }
public DataTable GetAllChangeTypeRecode(ChangeTypesRecodeModel model) { return(change.GetAllChangeTypeRecode(model)); }
public void AddChangeRecode(ChangeTypesRecodeModel model) { change.AddChangeRecode(model); }
public DataTable GetChangeRecodeByStudent(ChangeTypesRecodeModel model) { return(change.GetChangeRecodeByStudent(model)); }