/// <summary>
/// 检测是否能进行试验
/// </summary>
/// <param name="productCode">箱号</param>
/// <param name="error">出错时返回错误信息</param>
/// <returns>允许试验返回true</returns>
public bool CanOffLineTest(string productCode, out string error)
{
error = null;
Hashtable paramTable = new Hashtable();
DataSet ds = new DataSet();
paramTable.Add("@ProductNumber", productCode);
IDBOperate dbOperate = CommentParameter.GetDBOperatorOfDepotManagement();
Dictionary <OperateCMD, object> dicOperateCMD = dbOperate.RunProc_CMD("ZPX_AllowOffLineTest", ds, paramTable);
DataTable dataTable = ds.Tables[0];
if (dataTable.Rows[0][0].ToString() == "允许")
{
return(true);
}
error = dataTable.Rows[0][0].ToString();
if (dataTable.Columns.Count == 1)
{
return(false);
}
return(false);
}
/// <summary>
/// 检测是否能进行试验
/// </summary>
/// <param name="productCode">箱号</param>
/// <param name="error">出错时返回错误信息</param>
/// <returns>允许试验返回true</returns>
public bool CanOffLineTest(string productCode, out string error)
{
error = null;
Hashtable paramTable = new Hashtable();
DataSet ds = new DataSet();
paramTable.Add("@ProductNumber", productCode);
IDBOperate dbOperate = CommentParameter.GetDBOperatorOfDepotManagement();
Dictionary <OperateCMD, object> dicOperateCMD = dbOperate.RunProc_CMD("ZPX_AllowOffLineTest", ds, paramTable);
DataTable dataTable = ds.Tables[0];
if (dataTable.Rows[0][0].ToString() == "允许")
{
return(true);
}
error = dataTable.Rows[0][0].ToString();
if (dataTable.Columns.Count == 1)
{
return(false);
}
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varData = from a in ctx.ZPX_CVTOffLineTestResultLog
where a.ProdutCode == productCode
select a;
if (varData.Count() == 0)
{
ZPX_CVTOffLineTestResultLog lnqLog = new ZPX_CVTOffLineTestResultLog();
lnqLog.ProdutCode = productCode;
lnqLog.Z08FinishTime = Convert.ToDateTime(dataTable.Rows[0][1]);
ctx.ZPX_CVTOffLineTestResultLog.InsertOnSubmit(lnqLog);
}
else if (varData.Count() == 1)
{
ZPX_CVTOffLineTestResultLog lnqLog = varData.Single();
lnqLog.Z08FinishTime = Convert.ToDateTime(dataTable.Rows[0][1]);
}
ctx.SubmitChanges();
return(false);
}
