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