/// <summary> /// 获取参数列表 /// </summary> /// <param name="model"></param> /// <returns></returns> private static List <SQLiteParameter> GetParameters(People model) { List <SQLiteParameter> parameters = new List <SQLiteParameter>() { new SQLiteParameter("@user_id", DbType.Int32, 8), new SQLiteParameter("@first_name", DbType.String), new SQLiteParameter("@last_name", DbType.String), new SQLiteParameter("@alias", DbType.String), new SQLiteParameter("@gender", DbType.String), new SQLiteParameter("@birthday", DbType.Int64, 8), new SQLiteParameter("@age", DbType.Int32, 8), new SQLiteParameter("@identity", DbType.String), new SQLiteParameter("@photo", DbType.String), new SQLiteParameter("@country_id", DbType.Int32, 8), new SQLiteParameter("@province_id", DbType.Int32, 8), new SQLiteParameter("@city_id", DbType.Int32, 8), new SQLiteParameter("@county_id", DbType.Int32, 8), new SQLiteParameter("@address", DbType.String), new SQLiteParameter("@phone", DbType.String), new SQLiteParameter("@tel", DbType.String), new SQLiteParameter("@email", DbType.String), new SQLiteParameter("@qq", DbType.String), new SQLiteParameter("@msn", DbType.String), new SQLiteParameter("@weight", DbType.Decimal, 4), new SQLiteParameter("@height", DbType.Decimal, 4), new SQLiteParameter("@hobby", DbType.String), new SQLiteParameter("@interest", DbType.String), new SQLiteParameter("@introduce", DbType.String), new SQLiteParameter("@motto", DbType.String), new SQLiteParameter("@created_at", DbType.Int64, 8), new SQLiteParameter("@updated_at", DbType.Int64, 8) }; parameters[0].Value = model.UserId; parameters[1].Value = model.FirstName; parameters[2].Value = model.LastName; parameters[3].Value = model.Alias; parameters[4].Value = model.Gender; parameters[5].Value = model.ConvertDateTimeInt(model.Birthday); parameters[6].Value = model.Age; parameters[7].Value = model.Identity; parameters[8].Value = model.Photo; parameters[9].Value = model.CountryId; parameters[10].Value = model.ProvinceId; parameters[11].Value = model.CityId; parameters[12].Value = model.CountyId; parameters[13].Value = model.Address; parameters[14].Value = model.Phone; parameters[15].Value = model.Tel; parameters[16].Value = model.Email; parameters[17].Value = model.Qq; parameters[18].Value = model.Msn; parameters[19].Value = model.Weight; parameters[20].Value = model.Height; parameters[21].Value = model.Hobby; parameters[22].Value = model.Interest; parameters[23].Value = model.Introduce; parameters[24].Value = model.Motto; parameters[25].Value = model.ConvertDateTimeInt(model.CreatedAt); parameters[26].Value = model.ConvertDateTimeInt(model.UpdatedAt); return(parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> private static People DataRowToModel(SQLiteDataReader row) { People model = new People(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.Id = int.Parse(row["id"].ToString()); } if (row["user_id"] != null && row["user_id"].ToString() != "") { model.UserId = int.Parse(row["user_id"].ToString()); } if (row["first_name"] != null) { model.FirstName = row["first_name"].ToString(); } if (row["last_name"] != null) { model.LastName = row["last_name"].ToString(); } if (row["alias"] != null) { model.Alias = row["alias"].ToString(); } if (row["gender"] != null) { model.Gender = row["gender"].ToString(); } if (row["birthday"] != null && row["birthday"].ToString() != "") { model.Birthday = model.ConvertIntDateTime(int.Parse(row["birthday"].ToString())); } if (row["age"] != null && row["age"].ToString() != "") { model.Age = int.Parse(row["age"].ToString()); } if (row["identity"] != null) { model.Identity = row["identity"].ToString(); } if (row["photo"] != null) { model.Photo = row["photo"].ToString(); } if (row["country_id"] != null && row["country_id"].ToString() != "") { model.CountryId = int.Parse(row["country_id"].ToString()); } if (row["province_id"] != null && row["province_id"].ToString() != "") { model.ProvinceId = int.Parse(row["province_id"].ToString()); } if (row["city_id"] != null && row["city_id"].ToString() != "") { model.CityId = int.Parse(row["city_id"].ToString()); } if (row["county_id"] != null && row["county_id"].ToString() != "") { model.CountyId = int.Parse(row["county_id"].ToString()); } if (row["address"] != null) { model.Address = row["address"].ToString(); } if (row["phone"] != null) { model.Phone = row["phone"].ToString(); } if (row["tel"] != null) { model.Tel = row["tel"].ToString(); } if (row["email"] != null) { model.Email = row["email"].ToString(); } if (row["qq"] != null) { model.Qq = row["qq"].ToString(); } if (row["msn"] != null) { model.Msn = row["msn"].ToString(); } if (row["weight"] != null && row["weight"].ToString() != "") { model.Weight = Double.Parse(row["weight"].ToString()); } if (row["height"] != null && row["height"].ToString() != "") { model.Height = Double.Parse(row["height"].ToString()); } if (row["hobby"] != null) { model.Hobby = row["hobby"].ToString(); } if (row["interest"] != null) { model.Interest = row["interest"].ToString(); } if (row["introduce"] != null) { model.Introduce = row["introduce"].ToString(); } if (row["motto"] != null) { model.Motto = row["motto"].ToString(); } if (row["created_at"] != null && row["created_at"].ToString() != "") { model.CreatedAt = model.ConvertIntDateTime(int.Parse(row["created_at"].ToString())); } if (row["updated_at"] != null && row["updated_at"].ToString() != "") { model.UpdatedAt = model.ConvertIntDateTime(int.Parse(row["updated_at"].ToString())); } } return(model); }