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