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));
}
