Beispiel #1
0
        public void initdata()
        {
            String sql = "select sum(ceil(h.taskquantity/36)) as sl,h.regioncode as czxx,h.packagedesc " +
                         "FROM highspeed.T_PRODUCE_TASK h " +
                         "group by h.regioncode,h.packagedesc order by h.regioncode,h.packagedesc";
            OracleDataReader myread = DataPublic.ReadDb(sql);

            task_data.Rows.Clear();
            try
            {
                String sl = "", czxx = "", packagedesc = "";
                while (myread != null && myread.Read())
                {
                    sl          = myread["sl"].ToString().Trim();
                    czxx        = myread["czxx"].ToString().Trim();
                    packagedesc = myread["packagedesc"].ToString().Trim();


                    int index = this.task_data.Rows.Add();
                    this.task_data.Rows[index].Cells[0].Value = czxx;
                    this.task_data.Rows[index].Cells[1].Value = sl;
                    this.task_data.Rows[index].Cells[2].Value = packagedesc;
                }
            }
            finally
            {
                if (myread != null)
                {
                    myread.Close();
                    myread.Dispose();
                }
            }
        }
        /// <summary>
        /// 绑定DataGridView1
        /// </summary>
        /// <param name="sql">要查询的sql</param>
        private void Bind(string sql)
        {
            OracleDataReader myread = DataPublic.ReadDb(sql);

            task_data.Rows.Clear();
            try
            {
                String cigarettecode = "", tasknum = "", regioncode = "", cigarename = "", quantity = "", taskquantity = "";
                while (myread != null && myread.Read())
                {
                    cigarettecode = myread["cigarettecode"].ToString().Trim();
                    cigarename    = myread["cigarettename"].ToString().Trim();
                    quantity      = myread["replenishqty"].ToString().Trim();
                    tasknum       = myread["tasknum"].ToString().Trim();
                    regioncode    = myread["regioncode"].ToString().Trim();
                    int index = this.task_data.Rows.Add();
                    this.task_data.Rows[index].Cells[0].Value = cigarettecode;
                    this.task_data.Rows[index].Cells[1].Value = cigarename;
                    this.task_data.Rows[index].Cells[2].Value = quantity;
                    this.task_data.Rows[index].Cells[3].Value = tasknum;
                    this.task_data.Rows[index].Cells[4].Value = regioncode;
                }
            }
            finally
            {
                if (myread != null)
                {
                    myread.Close();
                    myread.Dispose();
                }
            }
        }
Beispiel #3
0
        /// <summary>
        /// 绑定DataGridView1
        /// </summary>
        /// <param name="sql">要查询的sql</param>
        private void Bind(string sql)
        {
            OracleDataReader myread = DataPublic.ReadDb(sql);

            task_data.Rows.Clear();
            try
            {
                String machineseq = "", cusname = "", cigarename = "", pokenum = "", sortnum = "", regioncode = "";
                while (myread != null && myread.Read())
                {
                    machineseq = myread["machineseq"].ToString().Trim();
                    cusname    = myread["customername"].ToString().Trim();
                    cigarename = myread["cigarettename"].ToString().Trim();
                    pokenum    = myread["pokenum"].ToString().Trim();
                    sortnum    = myread["sortnum"].ToString().Trim();
                    regioncode = myread["regioncode"].ToString().Trim();
                    int index = this.task_data.Rows.Add();
                    this.task_data.Rows[index].Cells[0].Value = machineseq;
                    this.task_data.Rows[index].Cells[1].Value = cusname;
                    this.task_data.Rows[index].Cells[2].Value = cigarename;
                    this.task_data.Rows[index].Cells[3].Value = pokenum;
                    this.task_data.Rows[index].Cells[4].Value = sortnum;
                    this.task_data.Rows[index].Cells[5].Value = regioncode;
                }
            }
            finally
            {
                if (myread != null)
                {
                    myread.Close();
                    myread.Dispose();
                }
            }
        }
        /// <summary>
        /// 获取格式表
        /// DataColumns,则以其为准,否则,以DataColumns为准
        /// </summary>
        /// <returns>格式表</returns>
        public IEnumerable <DataField> GetColumns()
        {
            List <DataField> dataColumns = new List <DataField>();;

            if (DataFetcher.IsNotNull())
            {
                var schemaTable = DataFetcher.Value.GetDataSchema();
                var fields      = DataPublic.GetDataFieldsByTable(schemaTable);
                dataColumns.AddRange(fields);
            }

            if (DataColumns.IsNotNullOrEmpty())
            {
                foreach (DataField dataColumn in DataColumns)
                {
                    var foundColumn = dataColumns.Where(p => p.Name == dataColumn.Name).FirstOrDefault();
                    if (foundColumn != null)
                    {
                        dataColumns.Remove(foundColumn);
                    }
                    dataColumns.Add(dataColumn);
                }
            }
            return(dataColumns);
        }
        /// <summary>
        /// 绑定DataGridView1
        /// </summary>
        /// <param name="sql">要查询的sql</param>
        private void Bind(string sql)
        {
            OracleDataReader myread = DataPublic.ReadDb(sql);

            task_data.Rows.Clear();
            try
            {
                String machineseq = "", cusname = "", cigarename = "", sortseq = "", quantity = "", taskquantity = "", chezu, tasknum;
                while (myread != null && myread.Read())
                {
                    machineseq = myread["machineseq"].ToString().Trim();
                    cusname    = myread["customername"].ToString().Trim();
                    cigarename = myread["cigarettename"].ToString().Trim();
                    quantity   = myread["quantity"].ToString().Trim();
                    tasknum    = myread["tasknum"].ToString().Trim();
                    chezu      = myread["regioncode"].ToString().Trim();
                    sortseq    = myread["sortseq"].ToString().Trim();
                    int index = this.task_data.Rows.Add();
                    this.task_data.Rows[index].Cells[0].Value = machineseq;
                    this.task_data.Rows[index].Cells[1].Value = cusname;
                    this.task_data.Rows[index].Cells[2].Value = cigarename;
                    this.task_data.Rows[index].Cells[3].Value = quantity;
                    this.task_data.Rows[index].Cells[4].Value = tasknum;
                    this.task_data.Rows[index].Cells[5].Value = chezu + "/" + sortseq;
                }
            }
            finally
            {
                if (myread != null)
                {
                    myread.Close();
                    myread.Dispose();
                }
            }
        }
Beispiel #6
0
        private void seek()
        {
            String strsql = "SELECT tmp.* from(select rownum as num,t.* from (select id ,cigarettename,cigarettecode,mantissa,machineseq from t_produce_sorttrough where state=0 and cigarettetype=10"
                            + "  order by to_number(machineseq))t)tmp where  tmp.num>" + (pager1.CurrentPageIndex - 1) * pager1.PageSize + " and tmp.num<=" + pager1.CurrentPageIndex * pager1.PageSize + " order by tmp.num";
            //MessageBox.Show(strsql);
            int total = int.Parse(DataPublic.ExecuteScalar("SELECT count(*) FROM t_produce_sorttrough where state=0 and cigarettetype=10").ToString());

            Bind(strsql);
            pager1.RecordCount = total;
            this.pager1.InitPageInfo();
        }
Beispiel #7
0
        private void seek()
        {
            String strsql = "SELECT tmp.* FROM" +
                            "(SELECT rownum as num,batchcode,starttime,endtime,decode(state,'0','关闭','1','正常')AS status FROM T_UN_BATCH  ORDER BY batchcode DESC)tmp where tmp.num>" + (pager1.CurrentPageIndex - 1) * pager1.PageSize + " and tmp.num<=" + pager1.CurrentPageIndex * pager1.PageSize + "order by tmp.batchcode desc";

            int total = int.Parse(DataPublic.ExecuteScalar("SELECT count(*) FROM T_UN_BATCH").ToString());

            Bind(strsql);
            pager1.RecordCount = total;
            this.pager1.InitPageInfo();
        }
        public void initdata()
        {
            String sql = "SELECT rownum as seq ,total.*,finish.finishcuscount,finish.finishqty,round(finishqty/qty*100,2)AS percent FROM " +
                         "(SELECT o.regioncode,COUNT(o.billcode) AS cuscount,SUM(o.taskquantity)AS qty FROM t_produce_task o GROUP BY o.regioncode)total left outer join " +
                         "(SELECT o.regioncode,COUNT(o.billcode) AS finishcuscount,SUM(o.taskquantity)AS finishqty FROM t_produce_task o WHERE state='30' GROUP BY o.regioncode)finish " +
                         "on total.regioncode=finish.regioncode  ORDER BY total.regioncode";
            OracleDataReader myread = DataPublic.ReadDb(sql);

            task_data.Rows.Clear();
            try
            {
                String regioncode = "", cuscount = "", qty = "", finishcuscount = "", finishqty = "", percent = "", seq = "";
                while (myread != null && myread.Read())
                {
                    seq            = myread["seq"].ToString().Trim();
                    regioncode     = myread["regioncode"].ToString().Trim();
                    cuscount       = myread["cuscount"].ToString().Trim();
                    qty            = myread["qty"].ToString().Trim();
                    finishcuscount = myread["finishcuscount"].ToString().Trim();
                    if (finishcuscount == "")
                    {
                        finishcuscount = "0";
                    }
                    finishqty = myread["finishqty"].ToString().Trim();
                    if (finishqty == "")
                    {
                        finishqty = "0";
                    }
                    percent = myread["percent"].ToString().Trim();
                    if (finishqty == "0")
                    {
                        percent = "0";
                    }

                    int index = this.task_data.Rows.Add();
                    this.task_data.Rows[index].Cells[0].Value = seq;
                    this.task_data.Rows[index].Cells[1].Value = regioncode;
                    this.task_data.Rows[index].Cells[2].Value = regioncode;

                    this.task_data.Rows[index].Cells[3].Value = finishcuscount + "/" + cuscount;
                    this.task_data.Rows[index].Cells[4].Value = finishqty + "/" + qty;
                    this.task_data.Rows[index].Cells[5].Value = percent + "%";
                }
            }
            finally
            {
                if (myread != null)
                {
                    myread.Close();
                    myread.Dispose();
                }
            }
        }
Beispiel #9
0
        private void seek()
        {
            String strsql = "SELECT  cigarettecode,cigarettename,sl from(select t.* ,rownum num from(select cigarettecode,cigarettename,sum(pokenum)sl from t_produce_poke p,t_produce_sorttrough s " +
                            "where p.troughnum=s.troughnum and p.machineseq in(43,44,45)group by cigarettecode,cigarettename order by sl desc)t" +
                            " )tmp where  tmp.num>" + (pager1.CurrentPageIndex - 1) * pager1.PageSize + " and tmp.num<=" + pager1.CurrentPageIndex * pager1.PageSize + " order by tmp.num";
            //MessageBox.Show(strsql);
            int total = int.Parse(DataPublic.ExecuteScalar("SELECT count(*) FROM t_produce_poke p ,t_produce_sorttrough s where p.machineseq in(43,44,45) and p.troughnum=s.troughnum group by cigarettecode,cigarettename").ToString());

            this.
            Bind(strsql);
            pager1.RecordCount = total;
            this.pager1.InitPageInfo();
        }
Beispiel #10
0
        /// <summary>
        /// 绑定DataGridView1
        /// </summary>
        /// <param name="sql">要查询的sql</param>
        private void Bind(string sql)
        {
            OracleDataReader myread = DataPublic.ReadDb(sql);

            task_data.Rows.Clear();
            try
            {
                String tasknum = "", cusname = "", cigarename = "", quantity = "", taskquantity = "";
                while (myread != null && myread.Read())
                {
                    tasknum      = myread["tasknum"].ToString().Trim();
                    cusname      = myread["customername"].ToString().Trim();
                    cigarename   = myread["cigarettename"].ToString().Trim();
                    quantity     = myread["quantity"].ToString().Trim();
                    taskquantity = myread["taskquantity"].ToString().Trim();

                    int index = this.task_data.Rows.Add();
                    this.task_data.Rows[index].Cells[0].Value = tasknum;
                    this.task_data.Rows[index].Cells[1].Value = cusname;
                    this.task_data.Rows[index].Cells[2].Value = cigarename;
                    this.task_data.Rows[index].Cells[3].Value = quantity;
                    this.task_data.Rows[index].Cells[4].Value = taskquantity;
                }
                //MessageBox.Show(sFun.getCzcode("950"));

                /*int indexj=0;
                 * for (int i = 0; i < task_data.RowCount;i++ )
                 * {
                 *  if(this.task_data.Rows[i].Cells[0].Value.ToString()=="0204")
                 *  {
                 *       indexj=i;
                 *       break;
                 *  }
                 * }
                 * for (int i = 0; i < 10;i++ )
                 * {
                 *  double per=double.Parse(this.task_data.Rows[indexj].Cells[5].Value.ToString());
                 *  per = per + i;
                 *  this.task_data.Rows[indexj].Cells[5].Value = per;
                 * }
                 */
            }
            finally
            {
                if (myread != null)
                {
                    myread.Close();
                    myread.Dispose();
                }
            }
        }
Beispiel #11
0
        private DataField[] GetParameters()
        {
            if (Filter.IsNull())
            {
                return(null);
            }

            List <DataField> dataFields = new List <Data.DataField>();
            var parameters = DataPublic.FindParameters(Filter);

            foreach (var parameter in parameters)
            {
                var dataField = new DataField(parameter);
                dataFields.Add(dataField);
            }
            return(dataFields.ToArray());
        }
        /// <summary>
        /// 根据对象填充属性字段
        /// </summary>
        /// <param name="groupItem">组项目</param>
        /// <param name="objType">对象类型</param>
        private void RetrieveFields(LayoutControlGroup groupItem)
        {
            this.DataLayoutControl.CloseControl();
            this.DataLayoutControl.SuspendLayout();
            EditControls.Clear();
            this.DataLayoutControl.Clear(true, true);
            var controller = Controller as DataParametersEditController;

            if (DataParameters == null)
            {
                return;
            }

            foreach (var dataParameter in DataParameters)
            {
                Control editControl = CreateEditControl(dataParameter);

                LayoutControlItem layoutControlItem = null;
                layoutControlItem = groupItem.AddItem();
                layoutControlItem.TextLocation = DevExpress.Utils.Locations.Left;

                layoutControlItem.Control = editControl;
                var parameterName = DataPublic.GetParameterName(dataParameter.Name);
                layoutControlItem.Name = parameterName;
                layoutControlItem.Text = parameterName;
                layoutControlItem.CustomizationFormText = dataParameter.Name;

                if (editControl is BaseObjectEditControl)
                {
                    layoutControlItem.TextVisible = false;
                }
                else
                {
                    layoutControlItem.TextVisible = true;
                }
            }
            this.DataLayoutControl.Refresh();
            this.DataLayoutControl.SetDefaultLayout();

            /// 读取布局数据
            if (controller.LayoutData.IsNotNull())
            {
                this.DataLayoutControl.SetLayoutData(controller.LayoutData);
            }
            this.DataLayoutControl.ResumeLayout();
        }
Beispiel #13
0
        private void seek()
        {
            String wherecause = "";

            if (comboBox1.SelectedIndex == 0)
            {
                wherecause = "and troughtype=10 and CIGARETTETYPE=20";
            }
            else
            {
                wherecause = "and troughtype=20";
            }
            String strsql = "SELECT tmp.* from(select rownum as num,t.* from (select cigarettename,cigarettecode,mantissa,machineseq,THRESHOLD,BOXCOUNT,clearup,maintissaless from t_produce_sorttrough where state=10 " + wherecause
                            + "  order by to_number(machineseq))t)tmp where  tmp.num>" + (pager1.CurrentPageIndex - 1) * pager1.PageSize + " and tmp.num<=" + pager1.CurrentPageIndex * pager1.PageSize + " order by tmp.num";
            //MessageBox.Show(strsql);
            int total = int.Parse(DataPublic.ExecuteScalar("SELECT count(*) FROM t_produce_sorttrough where state=10 " + wherecause).ToString());

            Bind(strsql);
            pager1.RecordCount = total;
            this.pager1.InitPageInfo();
        }
Beispiel #14
0
        private void seek()
        {
            // string linenum = this.box_sortline.SelectedValue+"";
            string types = this.box_condition.SelectedValue + "";
            string keywd = this.txt_keywd.Text.Trim();
            String tmp   = "";

            if (types != null && types != "" && keywd != null && keywd != "")
            {
                tmp = " and " + types + " like'%" + keywd + "%'";
            }
            String strsql = "SELECT tmp.* FROM (select rownum as num,t.* from(select  id,linenum,machineseq,troughdesc,'单独道'as troughtype" +
                            ",actcount,cigarettecode,state,cigarettename,decode(cigarettetype,'10','混合','20','正常','异型')as cigarettetype,replenishline,transportationline,decode(state,'0','正常','1','禁用')as status " +
                            "from t_produce_sorttrough t where  cigarettetype='30'" + tmp +
                            " ORDER BY machineseq)t)tmp where  tmp.num>" + (pager1.CurrentPageIndex - 1) * pager1.PageSize + " and tmp.num<=" + pager1.CurrentPageIndex * pager1.PageSize + " order by tmp.num";
            //MessageBox.Show(strsql);
            int total = int.Parse(DataPublic.ExecuteScalar("SELECT count(*) FROM t_produce_sorttrough where 1=1 and cigarettetype='30'" + tmp).ToString());

            Bind(strsql);
            pager1.RecordCount = total;
            this.pager1.InitPageInfo();
        }
Beispiel #15
0
        public void init()
        {
            //初始化分拣线选择下拉框
            String           sSql1  = "select min(tasknum) num from t_produce_task";
            String           sSql2  = "select max(tasknum) num from t_produce_task";
            OracleDataReader myread = DataPublic.ReadDb(sSql1);

            try
            {
                if (myread != null && myread.Read())
                {
                    textBox1.Text = myread["num"].ToString();
                }
            }
            finally
            {
                if (myread != null)
                {
                    myread.Close();
                    myread.Dispose();
                }
            }
            myread = DataPublic.ReadDb(sSql2);
            try
            {
                if (myread != null && myread.Read())
                {
                    textBox2.Text = myread["num"].ToString();
                }
            }
            finally
            {
                if (myread != null)
                {
                    myread.Close();
                    myread.Dispose();
                }
            }
        }
        /// <summary>
        /// 获取格式表
        /// DataColumns,则以其为准,否则,以DataColumns为准
        /// </summary>
        /// <returns>格式表</returns>
        public DataTable GetSchemaTable()
        {
            DataTable schemaTable = null;

            if (DataFetcher.IsNotNull())
            {
                schemaTable = DataFetcher.Value.GetDataSchema();
            }
            else
            {
                schemaTable = new DataTable();
            }

            // 根据DataColumn填充DataChema
            var columnSchemaTable = DataPublic.GetTableByDataItems(DataColumns);

            if (columnSchemaTable != null)
            {
                schemaTable.Merge(columnSchemaTable);
            }
            schemaTable.TableName = TableName;
            return(schemaTable);
        }
Beispiel #17
0
        private void seek()//显示通道信息
        {
            // string linenum = this.box_sortline.SelectedValue+"";
            string types = this.box_condition.SelectedValue + "";
            string keywd = this.txt_keywd.Text.Trim();
            int    type  = cbtype.SelectedIndex;
            int    ctype = cbctype.SelectedIndex;

            if (ctype == 1)
            {
                ctype = 20;
            }
            else if (ctype == 2)
            {
                ctype = 30;
            }
            else if (ctype == 3)
            {
                ctype = 40;
            }

            if (type == 0)
            {
                type = 10;
            }
            else if (type == 1)
            {
                type = 20;
            }
            else if (type == 2)
            {
                type = 30;
            }
            else if (type == 3)
            {
                type = 40;
            }
            String tmp = "";

            if (types != null && types != "" && keywd != null && keywd != "")
            {
                tmp = " and " + types + " like'%" + keywd + "%'";
            }
            if (type != 0)
            {
                tmp += "and troughtype=" + type;
            }
            if (ctype != 0)
            {
                tmp += "and cigarettetype=" + ctype;
            }
            String strsql = "SELECT tmp.* FROM (select  rownum as num, troughnum,id,machineseq," +
                            "cigarettecode,cigarettename,state,troughtype as type,cigarettetype as ctype,decode(cigarettetype,'10','混合','20','标准','30','异型','异型混合')as cigarettetype,decode(state,'10','正常','0','禁用')as status, " +
                            "decode(troughtype,10,'分拣',20,'重力式货架',30,'皮带机',40,'分拣出口')as troughtypes,groupno from t_produce_sorttrough t where  1=1 " + tmp +
                            " )tmp where  tmp.num>" + (pager1.CurrentPageIndex - 1) * pager1.PageSize + " and tmp.num<=" + pager1.CurrentPageIndex * pager1.PageSize + " order by to_number(tmp.troughnum)";
            String temps = tmp +
                           " ORDER BY troughnum)tmp where  tmp.num>" + (pager1.CurrentPageIndex - 1) * pager1.PageSize + " and tmp.num<=" + pager1.CurrentPageIndex * pager1.PageSize + " order by to_number(tmp.troughnum)";
            //MessageBox.Show(strsql);
            int total = int.Parse(DataPublic.ExecuteScalar("SELECT count(*) FROM t_produce_sorttrough where 1=1 " + tmp).ToString());

            Console.WriteLine(strsql);
            //Db.Open();
            Bind(strsql);
            // Db.Close();
            pager1.RecordCount = total;
            this.pager1.InitPageInfo();
        }