public ExternInfoModel Get(Guid id) { DataTable dt = SqlHelper.ExecuteDataTable("select * from T_ExternInfo where id=@id", new MySqlParameter("id", id)); if (dt.Rows.Count <= 0) { return(null); } else if (dt.Rows.Count == 1) { ExternInfoModel model = new ExternInfoModel(); DataRow row = dt.Rows[0]; model.id = new Guid(row["id"].ToString()); model.StuId = new Guid(row["StuId"].ToString()); model.GoSchoolTool = (string)GetNull(row["GoSchoolTool"]); model.ShuttleMode = (string)GetNull(row["ShuttleMode"]); model.ClassId = new Guid(row["ClassId"].ToString()); return(model); } else { throw new Exception("出现多条数据!"); } }
public int Update(ExternInfoModel model) { object obj = SqlHelper.ExecuteScalar("update T_ExternInfo set StuId=@StuId,GoSchoolTool=@GoSchoolTool,ShuttleMode=@ShuttleMode,ClassId=@ClassId where id=@id", new MySqlParameter("StuId", model.StuId), new MySqlParameter("GoSchoolTool", PutNull(model.GoSchoolTool)), new MySqlParameter("ShuttleMode", PutNull(model.ShuttleMode)), new MySqlParameter("ClassId", model.ClassId), new MySqlParameter("id", model.id)); return(Convert.ToInt32(obj)); }
public int AddNew(ExternInfoModel model) { object obj = SqlHelper.ExecuteScalar("insert into T_ExternInfo(id,StuId,GoSchoolTool,ShuttleMode,ClassId) values(@id,@StuId,@GoSchoolTool,@ShuttleMode,@ClassId )", new MySqlParameter("id", model.id), new MySqlParameter("StuId", model.StuId), new MySqlParameter("GoSchoolTool", PutNull(model.GoSchoolTool)), new MySqlParameter("ShuttleMode", PutNull(model.ShuttleMode)), new MySqlParameter("ClassId", model.ClassId)); return(Convert.ToInt32(obj)); }
public IEnumerable <ExternInfoModel> GetAll() { DataTable dt = SqlHelper.ExecuteDataTable("select * from T_ExternInfo"); List <ExternInfoModel> list = new List <ExternInfoModel>(); foreach (DataRow row in dt.Rows) { ExternInfoModel model = new ExternInfoModel(); model.id = new Guid(row["id"].ToString()); model.StuId = new Guid(row["StuId"].ToString()); model.GoSchoolTool = (string)GetNull(row["GoSchoolTool"]); model.ShuttleMode = (string)GetNull(row["ShuttleMode"]); model.ClassId = new Guid(row["ClassId"].ToString()); list.Add(model); } return(list); }
public int AddNew(ExternInfoModel model) { return(new ExternInfoDAL().AddNew(model)); }
public int Update(ExternInfoModel model) { return(new ExternInfoDAL().Update(model)); }