Пример #1
0
        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("出现多条数据!");
            }
        }
Пример #2
0
        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));
        }
Пример #3
0
        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));
        }
Пример #4
0
        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);
        }
Пример #5
0
 public int AddNew(TenantInfoModel model)
 {
     return(new TenantInfoDAL().AddNew(model));
 }
Пример #6
0
 public int Update(TenantInfoModel model)
 {
     return(new TenantInfoDAL().Update(model));
 }