private static List <JODetailVM> GetFAFStatus(string jo)
{
var ret = new List <JODetailVM>();
var sql = "select [Checked],[ConfirmPeople],[ConfirmTime] from [NebulaTrace].[dbo].[FAFJoVM] where JO = @JO";
var dict = new Dictionary <string, string>();
dict.Add("@JO", jo);
var dbret = DBUtility.ExeNebulaSqlWithRes(sql, dict);
foreach (var line in dbret)
{
var check = UT.O2S(line[0]).ToUpper();
var tempvm = new JODetailVM();
tempvm.CRTWFName = "NO";
if (check.Contains("TRUE"))
{
tempvm.CRTWFName = "YES";
}
tempvm.CRTWFRev = UT.O2S(line[1]);
tempvm.CRTWFStepName = UT.O2S(line[2]);
ret.Add(tempvm);
break;
}
return(ret);
}
