Exemplo n.º 1
0
        /// <summary>
        /// 更新产线计划
        /// </summary>
        /// <param name="mdl"></param>
        /// <returns></returns>
        public int UpdatePlinePlan(PlinePlanMDL mdl)
        {
            int ret = 0;

            string strSql = string.Empty;


            try
            {
                strSql = "UPDATE  tlb_product_plan SET PLINE='{0}' ,NAME='{1}',OP1={2},OP1_T={3},OP1_BEGIN='{4}',OP1_RANGE={5},OP1_ITEMS='{6}',OP2={7},"
                         + "OP2_T={8},OP2_BEGIN='{9}',OP2_RANGE={10},OP2_ITEMS='{11}',REMARK='{12}' WHERE PLANID='{13}'";

                strSql = string.Format(strSql, mdl.PLINE, mdl.NAME, mdl.OP1, mdl.OP1_T, mdl.OP1_BEGIN.ToString("yyyy-MM-dd HH:mm:ss"),
                                       mdl.OP1_RANGE, OPMDL.BuildOPString(mdl.OP1_ITEMS), mdl.OP2, mdl.OP2_T, mdl.OP2_BEGIN.ToString("yyyy-MM-dd HH:mm:ss"),
                                       mdl.OP2_RANGE, OPMDL.BuildOPString(mdl.OP2_ITEMS), mdl.REMARK, mdl.PLANID);

                ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);

                return(ret);
            }
            catch
            {
                throw;
            }
        }
Exemplo n.º 2
0
        public List <PlinePlanMDL> GetPlanInfos(DateTime datetime)
        {
            List <PlinePlanMDL> list = null;

            try
            {
                DataSet dataSet = null;

                string strSql = "SELECT * FROM tlb_product_plan WHERE PLANID LIKE '{0}%'";

                strSql = string.Format(strSql, datetime.ToString("yyyyMMdd"));


                dataSet = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, strSql);

                if (dataSet == null || dataSet.Tables[0].Rows.Count <= 0)
                {
                    return(null);
                }

                list = new List <PlinePlanMDL>();

                foreach (DataRow row in dataSet.Tables[0].Rows)
                {
                    list.Add(PlinePlanMDL.PraseDataRow(row));
                }


                return(list);
            }
            catch
            {
                throw;
            }
        }
Exemplo n.º 3
0
        /// <summary>
        /// 添加采集数据单元
        /// </summary>
        /// <param name="mdl"></param>
        /// <returns></returns>
        public int AddPlinePlan(PlinePlanMDL mdl)
        {
            int ret = 0;

            string strSql = string.Empty;


            try
            {
                strSql = "INSERT INTO  tlb_product_plan ( PLANID,PLINE,NAME,OP1,OP1_T,OP1_BEGIN,OP1_RANGE,OP1_ITEMS,OP2,OP2_T,OP2_BEGIN,OP2_RANGE,OP2_ITEMS,CREATE_TIME,REMARK)" +
                         " VALUES ('{0}','{1}','{2}',{3},{4},'{5}',{6},'{7}',{8},{9},'{10}',{11},'{12}','{13}','{14}')";
                //"values('{0}','{1}','{2}',{3},{4},'{5}',{6},{7},{8},'{9}',{10},'{11}','{12}')";

                strSql = string.Format(strSql, mdl.PLANID, mdl.PLINE, mdl.NAME, mdl.OP1, mdl.OP1_T, mdl.OP1_BEGIN.ToString("yyyy-MM-dd HH:mm:ss"),
                                       mdl.OP1_RANGE, OPMDL.BuildOPString(mdl.OP1_ITEMS), mdl.OP2, mdl.OP2_T, mdl.OP2_BEGIN.ToString("yyyy-MM-dd HH:mm:ss"),
                                       mdl.OP2_RANGE, OPMDL.BuildOPString(mdl.OP2_ITEMS), mdl.CREATE_TIME.ToString("yyyy-MM-dd HH:mm:ss"), mdl.REMARK);

                ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);

                return(ret);
            }
            catch
            {
                throw;
            }
        }
Exemplo n.º 4
0
        /// <summary>
        /// 获取记录
        /// </summary>
        /// <param name="lineID"></param>
        /// <param name="range"></param>
        /// <returns>minutes</returns>
        public PlinePlanMDL GetPlanInfo(string lineID)
        {
            PlinePlanMDL mdl = null;

            try
            {
                DataSet dataSet = null;

                string strSql = "SELECT * FROM tlb_product_plan WHERE PLANID='{0}'";

                strSql = string.Format(strSql, lineID);


                dataSet = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, strSql);

                if (dataSet == null || dataSet.Tables[0].Rows.Count <= 0)
                {
                    return(null);
                }

                mdl = PlinePlanMDL.PraseDataRow(dataSet.Tables[0].Rows[0]);

                return(mdl);
            }
            catch
            {
                throw;
            }
        }
Exemplo n.º 5
0
        private void LoadRangeChange(int index)
        {
            if (this.comboBox1.DataSource != null && index == 1)
            {
                if (loadPlan)
                {
                    this.plineMDL.OP1_RANGE = this.comboBox1.SelectedIndex + 1;

                    this.plineMDL = PlinePlanMDL.ReLoadPlanMDL(this.plineMDL);
                }

                TimeRange range1 = this.plineMDL.GetTimeRange(1);
                this.dateTimePicker1.Value = range1.StartTime;
                this.lbEndTime1.Text       = range1.EndTime.ToString("HH:mm:ss");
            }

            if (this.comboBox2.DataSource != null && index == 2)
            {
                if (loadPlan)
                {
                    this.plineMDL.OP2_RANGE = this.comboBox2.SelectedIndex + 1;

                    this.plineMDL = PlinePlanMDL.ReLoadPlanMDL(this.plineMDL);
                }

                TimeRange range2 = this.plineMDL.GetTimeRange(2);
                this.dateTimePicker2.Value = range2.StartTime;
                this.LbEndTime2.Text       = range2.EndTime.ToString("HH:mm:ss");
            }
        }
Exemplo n.º 6
0
        /// <summary>
        /// 加载新计划
        /// </summary>
        /// <returns></returns>
        public static PlinePlanMDL ReloadNewPlan(string pId)
        {
            PlinePlanMDL mdl = null;

            try
            {
                PlinePlanDAL dal = new PlinePlanDAL();

                if (dal.PlanExists(pId) <= 0)
                {
                    mdl = PlinePlanMDL.BuildDefualtPlan(Convert.ToInt32(BaseVariable.LineID),
                                                        DateTime.Now);
                    if (dal.AddPlinePlan(mdl) > 0)
                    {
                        return(mdl);
                    }

                    return(null);
                }
                else
                {
                    mdl = dal.GetPlanInfo(pId);

                    return(mdl);
                }

                return(null);
            }
            catch (Exception ex)
            {
                CLog.WriteErrLog(ex.Message.ToString());
            }

            return(null);
        }
Exemplo n.º 7
0
        private void DoAssemblyPlan()
        {
            try
            {
                PlanInfoForm dialog = new PlanInfoForm();

                PlinePlanDAL dal = new PlinePlanDAL();

                string plineid = DateTime.Now.ToString("yyyyMMdd") + BaseVariable.LineID;

                if (dal.PlanExists(plineid) <= 0)
                {
                    if (dal.AddPlinePlan(PlinePlanMDL.BuildedPlan(Convert.ToInt32(BaseVariable.LineID)
                                                                  , DateTime.Now)) <= 0)
                    {
                        MessageBox.Show("加载产线配置失败,请检查配置文件信息!", "提示", MessageBoxButtons.OK);

                        return;
                    }
                }

                PlinePlanMDL mdl = dal.GetPlanInfo(plineid);

                if (mdl == null)
                {
                    MessageBox.Show("加载产线配置失败,请检查配置文件信息!", "提示", MessageBoxButtons.OK);
                    return;
                }

                dialog.PLAN = mdl;

                if (dialog.ShowDialog() == DialogResult.OK)
                {
                    if (dal.UpdatePlinePlan(dialog.PLAN) > 0)
                    {
                        MessageBox.Show("修改产线配置信息成功!", "提示", MessageBoxButtons.OK);
                        return;
                    }
                    else
                    {
                        MessageBox.Show("修改产线配置信息失败!", "提示", MessageBoxButtons.OK);
                        return;
                    }
                }
            }
            catch (System.Exception ex)
            {
                MessageBox.Show(ex.Message.ToString(), "提示", MessageBoxButtons.OK);
            }
        }
Exemplo n.º 8
0
        /// <summary>
        /// 加载模板计划
        /// </summary>
        public void LoadTempPlan()
        {
            try
            {
                List <PlinePlanMDL> lists = PlinePlanMDL.InitialPlans(BaseVariable.LineNames, DateTime.Now);


                PlinePlanDAL dal = new PlinePlanDAL();

                foreach (PlinePlanMDL mdl in lists)
                {
                    if (dal.PlanExists(mdl.PLANID) <= 0)
                    {
                        dal.AddPlinePlan(mdl);
                    }
                }
            }
            catch
            {
                throw;
            }
        }
Exemplo n.º 9
0
        /// <summary>
        /// 加载默认计划
        /// </summary>
        /// <returns></returns>
        public bool  LoadSystemDefualtPlan()
        {
            try
            {
                //  List<PlinePlanMDL> lists = PlinePlanMDL.InitialPlans(BaseVariable.LineNames, DateTime.Now);

                int linid = Convert.ToInt32(BaseVariable.LineID);

                PlinePlanMDL mdl = PlinePlanMDL.BuildDefualtPlan(linid, DateTime.Now);

                PlinePlanDAL dal = new PlinePlanDAL();

                if (dal.PlanExists(mdl.PLANID) <= 0)
                {
                    if (dal.AddPlinePlan(mdl) > 0)
                    {
                        this.curPlan = mdl;
                        return(true);
                    }
                }
                else
                {
                    curPlan = dal.GetPlanInfo(mdl.PLANID);

                    if (curPlan != null)
                    {
                        return(true);
                    }
                }

                return(false);
            }
            catch
            {
                throw;
            }
        }
Exemplo n.º 10
0
        private void IntialPalnData()
        {
            ProductLineCaculator plc = new ProductLineCaculator();

            plc.ReLoad();

            int line = Convert.ToInt32(BaseVariable.LineID);

            string plainid = DateTime.Now.ToString("yyyyMMdd") + string.Format("{0:D2}", line);

            this.planMDL = ReloadNewPlan(plainid);

            this.planMDL.PLINE = string.Format("{0:D2}", line);


            GraphPane myPane = zg1.GraphPane;

            myPane.Fill = new Fill(Color.Black);

            myPane.XAxis.Title.Text = "Section of plan";
            myPane.XAxis.Title.FontSpec.FontColor = Color.White;
            myPane.XAxis.Type         = AxisType.Date;
            myPane.XAxis.Scale.Format = "HH:mm";



            myPane.YAxis.Title.Text = "Changeover Time";
            myPane.YAxis.Title.FontSpec.FontColor = Color.White;


            int type = 1;

            List <OPMDL> opItems = null;

            if (!planMDL.GetTimeRange(1).IsInRange(DateTime.Now))
            {
                opItems = this.planMDL.OP2_ITEMS;
                type    = 2;
            }
            else
            {
                opItems = this.planMDL.OP1_ITEMS;
            }

            LineDTDAL dtDal = new LineDTDAL();

            ChangeTimeDAL ctDal = new ChangeTimeDAL();

            TimeRange tRange = new TimeRange(opItems[0].IIME_RANGE.StartTime, opItems[opItems.Count - 1].IIME_RANGE.EndTime);

            List <TimeRange> dtrangs = dtDal.GetTimeRangeByRange(this.planMDL.PLINE, tRange);



            PointPairList list       = new PointPairList();
            PointPairList changelist = new PointPairList();



            Color changeColor = Color.White;



            for (int i = 0; i < opItems.Count; i++)
            {
                int haveDt = 0;

                if (dtrangs != null && dtrangs.Count > 0)
                {
                    foreach (TimeRange item in dtrangs)
                    {
                        if (item.IsInFullRange(opItems[i].IIME_RANGE.StartTime, opItems[i].IIME_RANGE.EndTime))
                        {
                            haveDt = 1;
                            continue;
                        }
                    }
                }


                // double x = (double)i * 5.0;
                double x = (double)new XDate(opItems[i].IIME_RANGE.StartTime);

                int count = 0;

                if (haveDt <= 0)
                {
                    count = ctDal.GetChangeTime(opItems[i].LINEID.Substring(opItems[i].LINEID.Length - 2, 2), opItems[i].IIME_RANGE);
                }


                double changeOver = 0;

                if (count > 0)
                {
                    //除以分钟
                    changeOver = Math.Round((double)count / (double)60, 2);

                    if (changeOver > 18)
                    {
                        changeOver = 18;
                    }

                    if (changeOver > 10)
                    {
                        changeColor = Color.Red;
                    }
                }

                double y = 5;

                changelist.Add(x, changeOver);
                list.Add(x, y);
            }

            LineItem defualtCurve = myPane.AddCurve("Standard",
                                                    list, Color.Yellow, SymbolType.None);

            LineItem changeOverCurve = myPane.AddCurve("ChangeOver",
                                                       changelist, changeColor, SymbolType.Circle);

            // changeOverCurve.Symbol.Fill.Color = Color.White;
            changeOverCurve.Line.Width  = 2;
            changeOverCurve.Symbol.Fill = new Fill(changeColor);


            defualtCurve.Label.IsVisible    = false;
            changeOverCurve.Label.IsVisible = false;

            myPane.XAxis.Scale.FontSpec.FontColor = Color.White;
            myPane.XAxis.Title.FontSpec.FontColor = Color.White;

            myPane.XAxis.MajorGrid.IsVisible      = true;
            myPane.YAxis.Scale.FontSpec.FontColor = Color.White;
            myPane.YAxis.Title.FontSpec.FontColor = Color.White;
            myPane.YAxis.Scale.Max = 18;
            myPane.YAxis.Scale.Min = -1;



            //// Fill the axis background with a gradient
            myPane.Chart.Fill = new Fill(Color.Black, Color.Black, 45.0f);


            //// Enable scrollbars if needed
            zg1.IsShowHScrollBar  = false;
            zg1.IsShowVScrollBar  = false;
            zg1.IsAutoScrollRange = true;
            zg1.IsScrollY2        = true;

            //// OPTIONAL: Show tooltips when the mouse hovers over a point
            zg1.IsShowPointValues = true;
            zg1.PointValueEvent  += new ZedGraphControl.PointValueHandler(MyPointValueHandler);


            SetSize();

            //// Tell ZedGraph to calculate the axis ranges
            //// Note that you MUST call this after enabling IsAutoScrollRange, since AxisChange() sets
            //// up the proper scrolling parameters
            zg1.AxisChange();
            zg1.IsEnableHZoom     = false;
            zg1.IsEnableVZoom     = false;
            zg1.IsEnableWheelZoom = false;
            //// Make sure the Graph gets redrawn
            zg1.Invalidate();
        }