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