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); }