/// <summary>
/// 获取
/// </summary>
/// <param name="pins"></param>
/// <param name="ver"></param>
/// <returns></returns>
public List <TmpUserPicModel> Get(List <string> pins)
{
string sql = string.Format(@"
select * from TmpUserPic where pin in ({0});", Tools.UnionString(pins));
DataTable dt = SqliteHelper.GetDataTable(sql);
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
List <TmpUserPicModel> fps = new List <TmpUserPicModel>();
foreach (DataRow row in dt.Rows)
{
TmpUserPicModel fp = new TmpUserPicModel();
fp.ID = Convert.ToInt32(row["ID"].ToString());
fp.Pin = row["PIN"].ToString();
fp.FileName = row["FileName"].ToString();
fp.Size = Convert.ToInt32(row["Size"].ToString());
fp.Content = row["Content"].ToString();
fps.Add(fp);
}
return(fps);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(TmpUserPicModel model)
{
string sql = string.Format(@"
delete from TmpUserPic where Pin =@Pin ;
insert into TmpUserPic(Pin,FileName,Size,Content)
values(@Pin,@FileName,@Size,@Content);
");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@Pin", model.Pin),
new SQLiteParameter("@FileName", model.FileName),
new SQLiteParameter("@Size", model.Size),
new SQLiteParameter("@Content", model.Content)
};
return(SqliteHelper.ExecuteNonQuery(sql, parameters));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(TmpUserPicModel model)
{
return(_dal.Add(model));
}