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