毕业论文设计客户订单界面及代码（WinForm之间传递参数，公式的Sql计算方式）

客户订单界面及代码

 

        //查看订单明细表,通过传递序号参数

        private void TS_Edit_Click(object sender, EventArgs e)

        {

            string id = this.dbg_clientdetail.SelectedCells[0].Value.ToString();//得到所选单元格的值

            Frm_ClientOrderDetail FCOD = new Frm_ClientOrderDetail(id);//传递序号参数,同时创建订单明细表

            FCOD.Show();

        }

 

        //删除订单明细表记录

        private void TB_Del_Click(object sender, EventArgs e)

        {

            string id = this.dbg_clientdetail.SelectedCells[0].Value.ToString();//得到所选单元格的值

            ClientOrder CO = new ClientOrder();//创建客户订单业务处理类

            if (MessageBox.Show("确定要删除记录吗?") == DialogResult.OK)

            {

                if (CO.DelClientOrder(id))//删除记录

                {

                    MessageBox.Show("删除成功!");

                }

                else

                {

                    MessageBox.Show("删除失败!");

                }

            }

            ClientOrder co = new ClientOrder();                     //重新绑定数据库

            dbg_clientdetail.DataSource = co.GetClietnOrderDetail();

} 

 

   //编辑订单明细表

        private void btn_Save_Click(object sender, EventArgs e)

        {

            ClientDetail CD = new ClientDetail();   // 创建订单明细表业务处理类

            CD = SetValue(CD);

            string id = TB_Id.Text;                 // 订单编号

            string Formualsql = TB_SquareFor.Text; // 公式字符串

           

            CD.UpdateClientDetail(id);              // 增加数据

            TB_Square.Text = CD.FormulaValue(Formualsql,id).ToString();// 平方的值

            CD.UpdateClientDetail(id);             // 更新数据库

        }

 

        // 得到公式计算结果

        public double FormulaValue(string formula, string id)

        {

            string ProcedureStr = "select " + formula + " from OrderDetail where ODT_SequenceId='" + id + "'";// 生成的Sql语句

            double value = Convert.ToDouble(dbpro.GetObjectBySqlString(ProcedureStr));// 生成值

            return value;

        }

        // 生成生产通知单前,选择标注公式

        private void btn_product_Click(object sender, EventArgs e)

        {

            string id = TB_Id.Text.Trim();// 订单明细表的主键

            FrmDraw FD = new FrmDraw(id); // 传递参数给标注公式

            FD.Show();

        }