public TenantInfoModel Get(Guid id)
{
DataTable dt = SqlHelper.ExecuteDataTable("select * from T_TenantInfo where id=@id",
new MySqlParameter("id", id));
if (dt.Rows.Count <= 0)
{
return(null);
}
else if (dt.Rows.Count == 1)
{
TenantInfoModel model = new TenantInfoModel();
DataRow row = dt.Rows[0];
model.id = new Guid(row["id"].ToString());
model.StuId = new Guid(row["StuId"].ToString());
model.NowAddress = (string)GetNull(row["NowAddress"]);
model.Area = (int?)GetNull(row["Area"]);
model.TogetherStuNum = (int?)GetNull(row["TogetherStuNum"]);
model.LandlordName = (string)GetNull(row["LandlordName"]);
model.LandlordTel = (string)GetNull(row["LandlordTel"]);
model.Accompanyer1 = (Guid?)GetNull(row["Accompanyer1"]);
model.Accompanyer2 = (Guid?)GetNull(row["Accompanyer2"]);
model.IsInSchool = (bool)row["IsInSchool"];
model.ClassId = new Guid(row["ClassId"].ToString());
return(model);
}
else
{
throw new Exception("出现多条数据！");
}
}
public int Update(TenantInfoModel model)
{
object obj = SqlHelper.ExecuteScalar("update T_TenantInfo set StuId=@StuId,NowAddress=@NowAddress,Area=@Area,TogetherStuNum=@TogetherStuNum,LandlordName=@LandlordName,LandlordTel=@LandlordTel,Accompanyer1=@Accompanyer1,Accompanyer2=@Accompanyer2,IsInSchool=@IsInSchool,ClassId=@ClassId where id=@id",
new MySqlParameter("StuId", model.StuId),
new MySqlParameter("NowAddress", PutNull(model.NowAddress)),
new MySqlParameter("Area", PutNull(model.Area)),
new MySqlParameter("TogetherStuNum", PutNull(model.TogetherStuNum)),
new MySqlParameter("LandlordName", PutNull(model.LandlordName)),
new MySqlParameter("LandlordTel", PutNull(model.LandlordTel)),
new MySqlParameter("Accompanyer1", PutNull(model.Accompanyer1)),
new MySqlParameter("Accompanyer2", PutNull(model.Accompanyer2)),
new MySqlParameter("IsInSchool", model.IsInSchool),
new MySqlParameter("ClassId", model.ClassId),
new MySqlParameter("id", model.id));
return(Convert.ToInt32(obj));
}
public int AddNew(TenantInfoModel model)
{
object obj = SqlHelper.ExecuteScalar("insert into T_TenantInfo(id,StuId,NowAddress,Area,TogetherStuNum,LandlordName,LandlordTel,Accompanyer1,Accompanyer2,IsInSchool,ClassId) values(@id,@StuId,@NowAddress,@Area,@TogetherStuNum,@LandlordName,@LandlordTel,@Accompanyer1,@Accompanyer2,@IsInSchool,@ClassId )",
new MySqlParameter("id", model.id),
new MySqlParameter("StuId", model.StuId),
new MySqlParameter("NowAddress", PutNull(model.NowAddress)),
new MySqlParameter("Area", PutNull(model.Area)),
new MySqlParameter("TogetherStuNum", PutNull(model.TogetherStuNum)),
new MySqlParameter("LandlordName", PutNull(model.LandlordName)),
new MySqlParameter("LandlordTel", PutNull(model.LandlordTel)),
new MySqlParameter("Accompanyer1", PutNull(model.Accompanyer1)),
new MySqlParameter("Accompanyer2", PutNull(model.Accompanyer2)),
new MySqlParameter("IsInSchool", model.IsInSchool),
new MySqlParameter("ClassId", model.ClassId));
return(Convert.ToInt32(obj));
}
public IEnumerable <TenantInfoModel> GetAll()
{
DataTable dt = SqlHelper.ExecuteDataTable("select * from T_TenantInfo");
List <TenantInfoModel> list = new List <TenantInfoModel>();
foreach (DataRow row in dt.Rows)
{
TenantInfoModel model = new TenantInfoModel();
model.id = new Guid(row["id"].ToString());
model.StuId = new Guid(row["StuId"].ToString());
model.NowAddress = (string)GetNull(row["NowAddress"]);
model.Area = (int?)GetNull(row["Area"]);
model.TogetherStuNum = (int?)GetNull(row["TogetherStuNum"]);
model.LandlordName = (string)GetNull(row["LandlordName"]);
model.LandlordTel = (string)GetNull(row["LandlordTel"]);
model.Accompanyer1 = (Guid?)GetNull(row["Accompanyer1"]);
model.Accompanyer2 = (Guid?)GetNull(row["Accompanyer2"]);
model.IsInSchool = (bool)row["IsInSchool"];
model.ClassId = new Guid(row["ClassId"].ToString());
list.Add(model);
}
return(list);
}
public int AddNew(TenantInfoModel model)
{
return(new TenantInfoDAL().AddNew(model));
}
public int Update(TenantInfoModel model)
{
return(new TenantInfoDAL().Update(model));
}