public void LoadData()
        {
            ClientOrderManage ClientOrderManage = new ClientOrderManage();
            DataTable         dtl = ClientOrderManage.GetClientOrder(GetWhereSQL());

            gridControl1.DataSource = dtl;

            gridView1.Columns[0].Visible  = false;
            gridView1.Columns[1].MinWidth = 100;
        }
        //--------------------------------------------------

        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (gridView1.RowCount > 0)
            {
                DataRowView dr = (DataRowView)(gridView1.GetFocusedRow());


                if (MessageBox.Show("确定删除该数据!", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
                {
                    ClientOrderManage ClientOrderManage = new ClientOrderManage();
                    dr = (DataRowView)(gridView1.GetFocusedRow());

                    if (ClientOrderManage.GetIsCheck(dr["ClientOrderGuid"].ToString()) == false)
                    {
                        //-----------------------------------------------------
                        MaterialManage MaterialManage = new MaterialManage();
                        if (MaterialManage.OrderDeleteAlert() == true)
                        {
                            //加载出被引用的单据
                            List <YJOrderDelete> lst = IsYJOrderDelete(dr["ClientOrderGuid"].ToString());
                            if (lst.Count > 0)
                            {
                                frmShowYJOrderDelete frmShowYJOrderDelete = new frmShowYJOrderDelete();
                                frmShowYJOrderDelete.ShowFillData(lst);
                                return;
                            }
                        }
                        //---------------------------------------------------------


                        ClientOrderManage.DeleteBill(dr["ClientOrderGuid"].ToString());


                        //写日志
                        SysLog.AddOperateLog(SysParams.UserName, "客户订单删除", "删除", SysParams.UserName + "用户删除了客户订单,订单唯一号:" + dr["ClientOrderGuid"].ToString());

                        gridView1.DeleteSelectedRows();

                        this.ShowMessage("删除成功!");
                    }
                    else
                    {
                        this.ShowMessage("此单据已经审核或结单,不能删除!");
                    }
                }
            }
        }
        //--------------------------------------

        //判断将删除的单据是否已有别的单据引用
        public List <YJOrderDelete> IsYJOrderDelete(string ClientOrderGuID)
        {
            List <YJOrderDelete> lst           = new List <YJOrderDelete>();
            YJOrderDelete        YJOrderDelete = new YJOrderDelete();


            ClientOrderManage ClientOrderManage = new ClientOrderManage();
            DataTable         dtl = ClientOrderManage.GetSellOrderID(ClientOrderGuID);

            for (int i = 0; i < dtl.Rows.Count; i++)
            {
                string strOrderID = dtl.Rows[i]["SellOrderID"].ToString();
                YJOrderDelete           = new YJOrderDelete();
                YJOrderDelete.OrderID   = strOrderID;
                YJOrderDelete.OrderName = "销售订单";
                lst.Add(YJOrderDelete);
            }
            return(lst);
        }