1. 更新dll引用地址 2. 主界面PLC操作安全屏蔽功能添加密码输入界面

patrick.xu

2021-05-24 3c583b1091133e4af23c2534ae96bd094c132d58

 DetectionData.cs

@@ -15,6 +15,7 @@
        private SqlConnection connForUpload;
        private string _standardCheckMode;

        int enableUploadMinutes = 10;
        private static readonly object synObj = new object();
        public DetectionData()
        {
@@ -39,6 +40,18 @@
            catch (Exception)
            {
                CommonUtil.WriteLog(LogType.Err, "DataUpload连接数据库失败！");
            }

            string enableUploadMinutesStr = ConfigurationManager.AppSettings["EnableUploadMinutes"];

            int temp = 0;
            if (int.TryParse(enableUploadMinutesStr, out temp))
            {
                enableUploadMinutes = temp;
            }
            else
            {
                enableUploadMinutes = 10;
            }
        }

@@ -135,7 +148,8 @@
        #region add by Patrick 2018-07-13
        public void SaveTrayBarcode(int detectID)
        {
            string trayCode = CarrierBarcodeCtrl.GlobalCarrierBarcode;
            string trayCode = "";
            trayCode = CarrierBarcodeCtrl.GlobalCarrierBarcode;

            if (string.IsNullOrEmpty(trayCode))
            {
@@ -205,8 +219,8 @@
                                        AND ProductNoStatus  = 'OK' 
                                        AND ProductStatus<>'NA'
                                        AND (ISNULL(CarrierBarcode,'')<>'' OR ProductStatus  = 'NG')
                                        AND DATEDIFF(DAY,'{0}',DetectTime)>=-1
                                        ORDER BY DetectTime DESC", DateTime.Now.ToString("yyyy-MM-dd"));
                                        AND DATEDIFF(MINUTE,DetectTime,'{0}')<={1}
                                        ORDER BY DetectTime DESC", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), enableUploadMinutes.ToString());

            SqlDataReader dr = null;
            using (SqlCommand cmd = new SqlCommand(sql, connForUpload))