//public static List<SonImg> GetCheckedImgVal(string caprev)
//{
// var ret = new List<SonImg>();
// var dict = new Dictionary<string, string>();
// var sql = "";
// if (string.IsNullOrEmpty(caprev))
// {
// sql = @"select top 30000 s.ChildImg,s.ImgVal from [WAT].[dbo].[SonImg] (nolock) s
// where s.ImgChecked = 'TRUE' order by UpdateTime desc";
// }
// else
// {
// sql = @"select top 30000 s.ChildImg,s.ImgVal from [WAT].[dbo].[SonImg] (nolock) s
// inner join [WAT].[dbo].[FatherImg] (nolock) f on f.MainImgKey = s.MainImgKey
// where s.ImgChecked = 'TRUE' and f.CaptureRev = @CaptureRev order by UpdateTime desc";
// dict.Add("@CaptureRev", caprev);
// }
// var dbret = DBUtility.ExeLocalSqlWithRes(sql, dict);
// foreach (var line in dbret)
// {
// var tempvm = new SonImg();
// tempvm.ChildImg = UT.O2S(line[0]);
// tempvm.ImgVal = UT.O2I(line[1]);
// ret.Add(tempvm);
// }
// return ret;
//}
public static List <AITrainingData> GetTrainingData(string revision)
{
var ret = new List <AITrainingData>();
var dict = new Dictionary <string, string>();
var sql = "";
if (string.IsNullOrEmpty(revision))
{
sql = @"select top 30000 TrainingImg,ImgVal from [WAT].[dbo].[AITrainingData] order by UpdateTime desc";
}
else
{
sql = @"select top 30000 TrainingImg,ImgVal from [WAT].[dbo].[AITrainingData] where Revision=@Revision order by UpdateTime desc";
dict.Add("@Revision", revision);
}
var dbret = DBUtility.ExeLocalSqlWithRes(sql, dict);
foreach (var line in dbret)
{
var tempvm = new AITrainingData();
tempvm.TrainingImg = UT.O2S(line[0]);
tempvm.ImgVal = UT.O2I(line[1]);
ret.Add(tempvm);
}
return(ret);
}