Exemplo n.º 1
0
        /// <summary>
        /// 查询生产信息
        /// </summary>
        /// <param name="datePicker1">起始时间</param>
        /// <param name="datePicker2">终止时间</param>
        /// <returns>生产信息</returns>
        public static DataTable SearchSubsidiaryInfo(string datePicker1, string datePicker2)
        {
            DataTable     dt           = ProductionSubsidiary.GetTableSchema();
            string        sql          = DB_SQL.Sel_SubsidiaryInfo(datePicker1, datePicker2);
            SqlConnection conn         = null;
            SqlCommand    cmd          = null;
            SqlDataReader objSqlReader = null;

            try
            {
                using (conn = new SqlConnection(DB_SQL.conStr))
                {
                    using (cmd = new SqlCommand(sql, conn))
                    {
                        conn.Open();
                        objSqlReader = cmd.ExecuteReader();
                        int n = 0;
                        while (objSqlReader.Read())
                        {
                            n += 1;
                            DataRow dr = dt.NewRow();
                            dr[0] = objSqlReader[0].ToString();
                            dr[1] = objSqlReader[1].ToString();
                            dr[2] = objSqlReader[2].ToString();
                            dr[3] = objSqlReader[3].ToString();
                            dr[4] = objSqlReader[4].ToString();
                            dt.Rows.Add(dr);
                        }
                        if (n == 0)
                        {
                            MessageBox.Show("没有生产数据!");
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString() + "打开数据库失败!");
            }
            finally
            {
                if (objSqlReader != null)
                {
                    objSqlReader.Close();
                }
                if (cmd != null)
                {
                    cmd.Dispose();
                }
                if (conn != null)
                {
                    conn.Close();
                    conn.Dispose();
                }
            }
            return(dt);
        }
Exemplo n.º 2
0
        /// <summary>
        /// 查询同一订单编号已上料数量
        /// </summary>
        /// <param name="orderNum">订单编号</param>
        /// <returns>已上料数量</returns>
        public static int SearchLoadNumAllByOrderNum(string orderNum, out int orderQuantity)
        {
            int loadNumAll = 0;

            orderQuantity = 0;
            string        sql          = DB_SQL.Sel_LoadNumAllByOrderNum(orderNum);
            SqlConnection conn         = null;
            SqlCommand    cmd          = null;
            SqlDataReader objSqlReader = null;

            try
            {
                using (conn = new SqlConnection(DB_SQL.conStr))
                {
                    using (cmd = new SqlCommand(sql, conn))
                    {
                        conn.Open();
                        objSqlReader = cmd.ExecuteReader();
                        while (objSqlReader.Read())
                        {
                            int.TryParse(objSqlReader[1].ToString(), out int quantity);
                            orderQuantity = quantity;
                            int.TryParse(objSqlReader[2].ToString(), out int loadNum);
                            loadNumAll = loadNumAll + loadNum;
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString() + "打开数据库失败!");
            }
            finally
            {
                if (objSqlReader != null)
                {
                    objSqlReader.Close();
                }
                if (cmd != null)
                {
                    cmd.Dispose();
                }
                if (conn != null)
                {
                    conn.Close();
                    conn.Dispose();
                }
            }
            return(loadNumAll);
        }
Exemplo n.º 3
0
        /// <summary>
        /// 查询上料批次ID是否存在
        /// </summary>
        /// <param name="loadBatchID">上料批次ID</param>
        /// <returns>true or false</returns>
        public static bool SearchLoadBatchID(string loadBatchID)
        {
            bool          flag         = false;
            string        sql          = DB_SQL.Sel_InfoByLoadBatchID(loadBatchID);
            SqlConnection conn         = null;
            SqlCommand    cmd          = null;
            SqlDataReader objSqlReader = null;

            try
            {
                using (conn = new SqlConnection(DB_SQL.conStr))
                {
                    using (cmd = new SqlCommand(sql, conn))
                    {
                        conn.Open();
                        objSqlReader = cmd.ExecuteReader();
                        while (objSqlReader.Read())
                        {
                            flag = true;
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString() + "打开数据库失败!");
            }
            finally
            {
                if (objSqlReader != null)
                {
                    objSqlReader.Close();
                }
                if (cmd != null)
                {
                    cmd.Dispose();
                }
                if (conn != null)
                {
                    conn.Close();
                    conn.Dispose();
                }
            }
            return(flag);
        }
Exemplo n.º 4
0
        /// <summary>
        /// 插入新上料信息
        /// </summary>
        /// <param name="doorInformation">门信息类</param>
        /// <returns>true or false</returns>
        public static bool InsertLoadDoorInfo(DoorInformation doorInformation)
        {
            bool          flag = false;
            string        sql  = DB_SQL.In_LoadDoorInfo(doorInformation);
            SqlConnection conn = null;
            SqlCommand    cmd  = null;

            try
            {
                using (conn = new SqlConnection(DB_SQL.conStr))
                {
                    using (cmd = new SqlCommand(sql, conn))
                    {
                        conn.Open();
                        int n = cmd.ExecuteNonQuery();
                        if (n > 0)
                        {
                            flag = true;
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString() + "打开数据库失败!");
            }
            finally
            {
                if (cmd != null)
                {
                    cmd.Dispose();
                }
                if (conn != null)
                {
                    conn.Close();
                    conn.Dispose();
                }
            }
            return(flag);
        }
Exemplo n.º 5
0
        /// <summary>
        /// 根据订单号查询门信息
        /// </summary>
        /// <param name="orderNum">订单号</param>
        /// <returns>门信息</returns>
        public static OrderInformation SearchOrderInfoByOrderNum(string orderNum)
        {
            OrderInformation orderInformation = null;
            string           sql          = DB_SQL.Sel_InfoByOrderNum(orderNum);
            SqlConnection    conn         = null;
            SqlCommand       cmd          = null;
            SqlDataReader    objSqlReader = null;

            try
            {
                using (conn = new SqlConnection(DB_SQL.conStr))
                {
                    using (cmd = new SqlCommand(sql, conn))
                    {
                        conn.Open();
                        objSqlReader = cmd.ExecuteReader();
                        int n = 0;
                        while (objSqlReader.Read())
                        {
                            n += 1;
                            orderInformation = new OrderInformation
                            {
                                OrderNum           = objSqlReader[0].ToString().Trim(),
                                OrderQuantity      = objSqlReader[1].ToString().Trim(),
                                ProductLine        = objSqlReader[2].ToString().Trim(),
                                DoorThickness      = objSqlReader[3].ToString().Trim(),
                                DoorStructure      = objSqlReader[4].ToString().Trim(),
                                SpecificationsWide = objSqlReader[5].ToString().Trim(),
                                SpecificationHigh  = objSqlReader[6].ToString().Trim(),
                                FacadeStyle        = objSqlReader[7].ToString().Trim(),
                                ChildDoorStyle     = objSqlReader[8].ToString().Trim(),
                                Lock                        = objSqlReader[9].ToString().Trim(),
                                Overdye                     = objSqlReader[10].ToString().Trim(),
                                Doorframe                   = objSqlReader[11].ToString().Trim(),
                                OpenTo                      = objSqlReader[12].ToString().Trim(),
                                Buckles                     = objSqlReader[13].ToString().Trim(),
                                ColorCategories             = objSqlReader[14].ToString().Trim(),
                                PictureDoorSpecification    = objSqlReader[15].ToString().Trim(),
                                CustomerSpecialRequirements = objSqlReader[16].ToString().Trim()
                            };
                        }
                        if (n == 0)
                        {
                            MessageBox.Show("订单号" + orderNum + "不存在!");
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString() + "打开数据库失败!");
            }
            finally
            {
                if (objSqlReader != null)
                {
                    objSqlReader.Close();
                }
                if (cmd != null)
                {
                    cmd.Dispose();
                }
                if (conn != null)
                {
                    conn.Close();
                    conn.Dispose();
                }
            }
            return(orderInformation);
        }
Exemplo n.º 6
0
        public static UserInformation_Kp SearchUserInfo(string accountID)
        {
            UserInformation_Kp userInformation_Kp = null;
            string             sql          = DB_SQL.Sel_LoginInfo(accountID);
            SqlConnection      conn         = null;
            SqlCommand         cmd          = null;
            SqlDataReader      objSqlReader = null;

            try
            {
                using (conn = new SqlConnection(DB_SQL.conStr))
                {
                    using (cmd = new SqlCommand(sql, conn))
                    {
                        conn.Open();
                        objSqlReader = cmd.ExecuteReader();
                        int n = 0;
                        while (objSqlReader.Read())
                        {
                            n += 1;
                            userInformation_Kp = new UserInformation_Kp()
                            {
                                AccountID      = objSqlReader[0].ToString().Trim(),
                                UserName       = objSqlReader[1].ToString().Trim(),
                                Password       = objSqlReader[2].ToString().Trim(),
                                Status         = objSqlReader[3].ToString().Trim(),
                                UserLevel      = objSqlReader[4].ToString().Trim(),
                                CreateUserID   = objSqlReader[5].ToString().Trim(),
                                CreateTime     = objSqlReader[6].ToString().Trim(),
                                UpdateUserID   = objSqlReader[7].ToString().Trim(),
                                UpdateUserName = objSqlReader[8].ToString().Trim(),
                                UpdateTime     = objSqlReader[9].ToString().Trim()
                            };
                        }
                        if (n == 0)
                        {
                            MessageBox.Show("用户名不存在!");
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString() + "打开数据库失败!");
            }
            finally
            {
                if (objSqlReader != null)
                {
                    objSqlReader.Close();
                }
                if (cmd != null)
                {
                    cmd.Dispose();
                }
                if (conn != null)
                {
                    conn.Close();
                    conn.Dispose();
                }
            }
            return(userInformation_Kp);
        }
Exemplo n.º 7
0
        public static DataTable searchProductInfo(string datePicker1, string datePicker2)
        {
            DataTable dt = Product.GetTableSchema();

            if (datePicker1 != "" && datePicker2 != "")
            {
                string        sql          = DB_SQL.Sel_ProductInfo(datePicker1, datePicker2);
                SqlConnection conn         = null;
                SqlCommand    cmd          = null;
                SqlDataReader objSqlReader = null;
                try
                {
                    using (conn = new SqlConnection(DB_SQL.conStr))
                    {
                        using (cmd = new SqlCommand(sql, conn))
                        {
                            conn.Open();
                            objSqlReader = cmd.ExecuteReader();
                            int n = 0;
                            while (objSqlReader.Read())
                            {
                                n += 1;
                                DataRow dr = dt.NewRow();
                                dr[0] = objSqlReader[0].ToString().Trim();
                                string   str      = objSqlReader[1].ToString().Trim();
                                string[] strArray = str.Split(' ');
                                dr[1] = strArray[0];
                                //dr[1] = objSqlReader[1].ToString().Trim().Remove(10);
                                dr[2] = objSqlReader[2].ToString().Trim();
                                dr[3] = objSqlReader[3].ToString().Trim();
                                dt.Rows.Add(dr);
                            }
                            if (n == 0)
                            {
                                MessageBox.Show("没有生产数据!");
                            }
                        }
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message.ToString() + "打开数据库失败!");
                }
                finally
                {
                    if (objSqlReader != null)
                    {
                        objSqlReader.Close();
                    }
                    if (cmd != null)
                    {
                        cmd.Dispose();
                    }
                    if (conn != null)
                    {
                        conn.Close();
                        conn.Dispose();
                    }
                }
            }
            else
            {
                MessageBox.Show("请选择需要的时间!");
            }
            return(dt);
        }
Exemplo n.º 8
0
        public static DataTable searchAlarmInfo(string alarmDatePicker1, string alarmDatePicker2, string selKeyTxt)
        {
            DataTable     dt           = HistoryAlarm.GetAlarmTable();
            string        sql          = DB_SQL.Sel_AlarmInfo(alarmDatePicker1, alarmDatePicker2, selKeyTxt);
            SqlConnection conn         = null;
            SqlCommand    cmd          = null;
            SqlDataReader objSqlReader = null;

            if ((alarmDatePicker1 == "" || alarmDatePicker2 == "") && selKeyTxt == "")
            {
                MessageBox.Show("请选择正确的时间段!");
            }
            else
            {
                try
                {
                    using (conn = new SqlConnection(DB_SQL.conStr))
                    {
                        using (cmd = new SqlCommand(sql, conn))
                        {
                            conn.Open();
                            objSqlReader = cmd.ExecuteReader();
                            int n = 0;
                            while (objSqlReader.Read())
                            {
                                n += 1;
                                DataRow dr = dt.NewRow();
                                dr[0] = objSqlReader[0].ToString().Trim();
                                dr[1] = objSqlReader[1].ToString().Trim();
                                switch (objSqlReader[2].ToString().Trim())
                                {
                                case "0":
                                    dr[2] = "已处理";
                                    break;

                                case "1":
                                    dr[2] = "未处理";
                                    break;
                                }
                                dt.Rows.Add(dr);
                            }
                            if (n == 0)
                            {
                                MessageBox.Show("没有报警!");
                            }
                        }
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message.ToString() + "打开数据库失败!");
                }
                finally
                {
                    if (objSqlReader != null)
                    {
                        objSqlReader.Close();
                    }
                    if (cmd != null)
                    {
                        cmd.Dispose();
                    }
                    if (conn != null)
                    {
                        conn.Close();
                        conn.Dispose();
                    }
                }
            }
            return(dt);
        }
Exemplo n.º 9
0
        /// <summary>
        /// 查询生产信息详情
        /// </summary>
        /// <param name="doorID">门ID</param>
        /// <param name="workSheetNumber">工单编号</param>
        /// <returns>详情信息</returns>
        public static SubsidiaryInformation SearchInfoByID(string doorID, string workSheetNumber)
        {
            SubsidiaryInformation subsidiaryInformation = null;
            string        sql          = DB_SQL.Sel_SubsidiaryInfoByID(doorID, workSheetNumber);
            SqlConnection conn         = null;
            SqlCommand    cmd          = null;
            SqlDataReader objSqlReader = null;

            try
            {
                using (conn = new SqlConnection(DB_SQL.conStr))
                {
                    using (cmd = new SqlCommand(sql, conn))
                    {
                        conn.Open();
                        objSqlReader = cmd.ExecuteReader();
                        int n = 0;
                        while (objSqlReader.Read())
                        {
                            subsidiaryInformation               = new SubsidiaryInformation();
                            subsidiaryInformation.DoorID        = objSqlReader[0].ToString();
                            subsidiaryInformation.DoorMold      = objSqlReader[1].ToString();
                            subsidiaryInformation.OrderNum      = objSqlReader[2].ToString();
                            subsidiaryInformation.OpenDirection = objSqlReader[3].ToString();
                            int.TryParse(objSqlReader[4].ToString(), out int thinPlateLength);
                            subsidiaryInformation.ThinPlateLength = thinPlateLength;
                            int.TryParse(objSqlReader[5].ToString(), out int thinPlateWidth);
                            subsidiaryInformation.ThinPlateWidth = thinPlateWidth;
                            int.TryParse(objSqlReader[6].ToString(), out int thickPlateLength);
                            subsidiaryInformation.ThickPlateLength = thickPlateLength;
                            int.TryParse(objSqlReader[7].ToString(), out int thickPlateWidth);
                            subsidiaryInformation.ThickPlateWidth = thickPlateWidth;
                            int.TryParse(objSqlReader[8].ToString(), out int thickness);
                            subsidiaryInformation.Thickness             = thickness;
                            subsidiaryInformation.FeedingTime           = objSqlReader[9].ToString();
                            subsidiaryInformation.LaminationPullInTime  = objSqlReader[10].ToString();
                            subsidiaryInformation.LaminationPullOutTime = objSqlReader[11].ToString();
                            int.TryParse(objSqlReader[12].ToString(), out int laminationDosage);
                            subsidiaryInformation.LaminationDosage = laminationDosage;
                            int.TryParse(objSqlReader[13].ToString(), out int episporiumAllowance);
                            subsidiaryInformation.EpisporiumAllowance = episporiumAllowance;
                            int.TryParse(objSqlReader[14].ToString(), out int counterdieAllowance);
                            subsidiaryInformation.CounterdieAllowance = counterdieAllowance;
                            int.TryParse(objSqlReader[15].ToString(), out int cuttingLength);
                            subsidiaryInformation.CuttingLength = cuttingLength;
                            int.TryParse(objSqlReader[16].ToString(), out int cuttingWidth);
                            subsidiaryInformation.CuttingWidth      = cuttingWidth;
                            subsidiaryInformation.GluingPullInTime  = objSqlReader[17].ToString();
                            subsidiaryInformation.GluingPullOutTime = objSqlReader[18].ToString();
                            int.TryParse(objSqlReader[19].ToString(), out int thinPlateKeyholeX);
                            subsidiaryInformation.ThinPlateKeyholeX = thinPlateKeyholeX;
                            int.TryParse(objSqlReader[20].ToString(), out int thinPlateKeyholeY);
                            subsidiaryInformation.ThinPlateKeyholeY = thinPlateKeyholeY;
                            int.TryParse(objSqlReader[21].ToString(), out int thickPlateKeyholeX);
                            subsidiaryInformation.ThickPlateKeyholeX = thickPlateKeyholeX;
                            int.TryParse(objSqlReader[22].ToString(), out int thickPlateKeyholeY);
                            subsidiaryInformation.ThickPlateKeyholeY = thickPlateKeyholeY;
                            int.TryParse(objSqlReader[23].ToString(), out int thinPlateViewerX);
                            subsidiaryInformation.ThinPlateViewerX = thinPlateViewerX;
                            int.TryParse(objSqlReader[24].ToString(), out int thinPlateViewerY);
                            subsidiaryInformation.ThinPlateViewerY = thinPlateViewerY;
                            int.TryParse(objSqlReader[25].ToString(), out int thickPlateViewerX);
                            subsidiaryInformation.ThickPlateViewerX = thickPlateViewerX;
                            int.TryParse(objSqlReader[26].ToString(), out int thickPlateViewerY);
                            subsidiaryInformation.ThickPlateViewerY = thickPlateViewerY;
                            int.TryParse(objSqlReader[27].ToString(), out int lockWidth);
                            subsidiaryInformation.LockWidth = lockWidth;
                            int.TryParse(objSqlReader[28].ToString(), out int lockLength);
                            subsidiaryInformation.LockLength = lockLength;
                            int.TryParse(objSqlReader[29].ToString(), out int actualSerlantVolume);
                            subsidiaryInformation.ActualSerlantVolume = actualSerlantVolume;
                            int.TryParse(objSqlReader[30].ToString(), out int quantityGlue);
                            subsidiaryInformation.QuantityGlue = quantityGlue;
                            int.TryParse(objSqlReader[31].ToString(), out int gelatinizeTime);
                            subsidiaryInformation.GelatinizeTime            = gelatinizeTime;
                            subsidiaryInformation.PerliteFillingPullInTime  = objSqlReader[32].ToString();
                            subsidiaryInformation.PerliteFillingPullOutTime = objSqlReader[33].ToString();
                            int.TryParse(objSqlReader[34].ToString(), out int perliteLength);
                            subsidiaryInformation.PerliteLength = perliteLength;
                            int.TryParse(objSqlReader[35].ToString(), out int perliteWidth);
                            subsidiaryInformation.PerliteWidth = perliteWidth;
                            int.TryParse(objSqlReader[36].ToString(), out int perliteThickness);
                            subsidiaryInformation.PerliteThickness    = perliteThickness;
                            subsidiaryInformation.PressFitPullInTime  = objSqlReader[37].ToString();
                            subsidiaryInformation.PressFitPullOutTime = objSqlReader[38].ToString();
                            int.TryParse(objSqlReader[39].ToString(), out int pressFitTemperature);
                            subsidiaryInformation.PressFitTemperature   = pressFitTemperature;
                            subsidiaryInformation.PolishedPullInTime    = objSqlReader[40].ToString();
                            subsidiaryInformation.PolishedPullOutTime   = objSqlReader[41].ToString();
                            subsidiaryInformation.WeldingPullInTime     = objSqlReader[42].ToString();
                            subsidiaryInformation.WeldingPullOutTime    = objSqlReader[43].ToString();
                            subsidiaryInformation.WeldSpacingUpDownStr  = objSqlReader[44].ToString();
                            subsidiaryInformation.WeldSpacingHingeStr   = objSqlReader[45].ToString();
                            subsidiaryInformation.WeldSpacingKeyholeStr = objSqlReader[46].ToString();
                            int.TryParse(objSqlReader[47].ToString(), out int weldNumUpDown);
                            subsidiaryInformation.WeldNumUpDown = weldNumUpDown;
                            int.TryParse(objSqlReader[48].ToString(), out int weldNumHinge);
                            subsidiaryInformation.WeldNumHinge = weldNumHinge;
                            int.TryParse(objSqlReader[49].ToString(), out int weldNumKeyhole);
                            subsidiaryInformation.WeldNumKeyhole = weldNumKeyhole;
                            int.TryParse(objSqlReader[50].ToString(), out int weldingVoltage);
                            subsidiaryInformation.WeldingVoltage = weldingVoltage;
                            int.TryParse(objSqlReader[51].ToString(), out int weldingElectricity);
                            subsidiaryInformation.WeldingElectricity = weldingElectricity;
                            int.TryParse(objSqlReader[52].ToString(), out int weldingSpendTime);
                            subsidiaryInformation.WeldingSpendTime = weldingSpendTime;
                            int.TryParse(objSqlReader[53].ToString(), out int wireFeedRate);
                            subsidiaryInformation.WireFeedRate          = wireFeedRate;
                            subsidiaryInformation.SprayPaintPullInTime  = objSqlReader[54].ToString();
                            subsidiaryInformation.SprayPaintPullOutTime = objSqlReader[55].ToString();
                            int.TryParse(objSqlReader[56].ToString(), out int sprayPaintSpendTime);
                            subsidiaryInformation.SprayPaintSpendTime         = sprayPaintSpendTime;
                            subsidiaryInformation.VisualInspectionPullInTime  = objSqlReader[57].ToString();
                            subsidiaryInformation.VisualInspectionPullOutTime = objSqlReader[58].ToString();
                            subsidiaryInformation.VisualInspectionResult      = objSqlReader[59].ToString();
                            subsidiaryInformation.BlankingTime = objSqlReader[60].ToString();
                        }
                        if (n == 0)
                        {
                            MessageBox.Show("该数据不存在!");
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString() + "打开数据库失败!");
            }
            finally
            {
                if (objSqlReader != null)
                {
                    objSqlReader.Close();
                }
                if (cmd != null)
                {
                    cmd.Dispose();
                }
                if (conn != null)
                {
                    conn.Close();
                    conn.Dispose();
                }
            }
            return(subsidiaryInformation);
        }
Exemplo n.º 10
0
        /// <summary>
        /// 查询检测详情
        /// </summary>
        /// <param name="doorID">门ID</param>
        /// <param name="orderNum">订单编号</param>
        /// <returns>详情信息</returns>
        public static TestingResultInformation SearchInfoByID(string doorID, string orderNum)
        {
            TestingResultInformation testingResultInformation = null;
            string        sql          = DB_SQL.Sel_InfoByID(doorID, orderNum);
            SqlConnection conn         = null;
            SqlCommand    cmd          = null;
            SqlDataReader objSqlReader = null;

            try
            {
                using (conn = new SqlConnection(DB_SQL.conStr))
                {
                    using (cmd = new SqlCommand(sql, conn))
                    {
                        conn.Open();
                        objSqlReader = cmd.ExecuteReader();
                        while (objSqlReader.Read())
                        {
                            testingResultInformation = new TestingResultInformation();
                            switch (objSqlReader[0].ToString())
                            {
                            case "0":
                                testingResultInformation.DoorEdgeResult0       = "NG";
                                testingResultInformation.DoorEdgeFailedReason0 = DetailValue(objSqlReader[1].ToString());
                                break;

                            case "1":
                                testingResultInformation.DoorEdgeResult0       = "OK";
                                testingResultInformation.DoorEdgeFailedReason0 = "-";
                                break;
                            }
                            switch (objSqlReader[2].ToString())
                            {
                            case "0":
                                testingResultInformation.DoorEdgeResult1       = "NG";
                                testingResultInformation.DoorEdgeFailedReason1 = DetailValue(objSqlReader[3].ToString());
                                break;

                            case "1":
                                testingResultInformation.DoorEdgeResult1       = "OK";
                                testingResultInformation.DoorEdgeFailedReason1 = "-";
                                break;
                            }
                            switch (objSqlReader[4].ToString())
                            {
                            case "0":
                                testingResultInformation.DoorEdgeResult2       = "NG";
                                testingResultInformation.DoorEdgeFailedReason2 = DetailValue(objSqlReader[5].ToString());
                                break;

                            case "1":
                                testingResultInformation.DoorEdgeResult2       = "OK";
                                testingResultInformation.DoorEdgeFailedReason2 = "-";
                                break;
                            }
                            switch (objSqlReader[6].ToString())
                            {
                            case "0":
                                testingResultInformation.DoorEdgeResult3       = "NG";
                                testingResultInformation.DoorEdgeFailedReason3 = DetailValue(objSqlReader[7].ToString());
                                break;

                            case "1":
                                testingResultInformation.DoorEdgeResult3       = "OK";
                                testingResultInformation.DoorEdgeFailedReason3 = "-";
                                break;
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString() + "打开数据库失败!");
            }
            finally
            {
                if (objSqlReader != null)
                {
                    objSqlReader.Close();
                }
                if (cmd != null)
                {
                    cmd.Dispose();
                }
                if (conn != null)
                {
                    conn.Close();
                    conn.Dispose();
                }
            }
            return(testingResultInformation);
        }
Exemplo n.º 11
0
        /// <summary>
        /// 查询NG个数
        /// </summary>
        /// <param name="time">时间</param>
        /// <param name="num">NG原因</param>
        /// <param name="NGno">NG边</param>
        /// <returns>NG个数</returns>
        public static int SearchNGCountNum(string time, int num, string NGno)
        {
            int    NGCount      = 0;
            string failedReason = "";

            switch (num)
            {
            case 0:
                failedReason = "1";
                break;

            case 1:
                failedReason = "2";
                break;

            case 2:
                failedReason = "4";
                break;

            case 3:
                failedReason = "8";
                break;

            case 4:
                failedReason = "16";
                break;

            case 5:
                failedReason = "32";
                break;

            case 6:
                failedReason = "64";
                break;

            case 7:
                failedReason = "128";
                break;
            }
            string        sql          = DB_SQL.Sel_NGCountNum(time, failedReason, NGno);
            SqlConnection conn         = null;
            SqlCommand    cmd          = null;
            SqlDataReader objSqlReader = null;

            try
            {
                using (conn = new SqlConnection(DB_SQL.conStr))
                {
                    using (cmd = new SqlCommand(sql, conn))
                    {
                        conn.Open();
                        objSqlReader = cmd.ExecuteReader();
                        while (objSqlReader.Read())
                        {
                            NGCount = int.Parse(objSqlReader[0].ToString());
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString() + "打开数据库失败!");
            }
            finally
            {
                if (objSqlReader != null)
                {
                    objSqlReader.Close();
                }
                if (cmd != null)
                {
                    cmd.Dispose();
                }
                if (conn != null)
                {
                    conn.Close();
                    conn.Dispose();
                }
            }
            return(NGCount);
        }