移除节点

最新推荐文章于 2024-08-02 13:42:59 发布
清空回声
最新推荐文章于 2024-08-02 13:42:59 发布
阅读量389
点赞数
分类专栏： WinFrom系统控件的使用
本文链接：https://blog.csdn.net/u013908405/article/details/48575351
版权
WinFrom系统控件的使用专栏收录该内容
40 篇文章 1 订阅
订阅专栏
    public void SelectVehicleStateType_IDByTinID(int timcarid, ListView vi)
        {
            FrmEMTinCar fmt = null;
            Form YieldTransitEditForm = this.Owner;
            TabPage tc = (TabPage)YieldTransitEditForm.Parent;
            foreach (var f in tc.Controls )
            {
                if (tc.Controls .Count >0)
                {
                    if (tc.Text == "生产运送")
                    {
                        fmt = null;
                    }else if (tc.Text != "车辆状态监控")
                    {
                        fmt = null;
                    }
                    else
                    {
                        fmt = (FrmEMTinCar)f;
                    }
                    
                }
               
            }
        
            string sqlsd = string.Empty;
            string CheckVehicleOrder_ID = string.Empty;
            int checkorder_id = 0;
            //选中车的排序顺序
            string CheckVehicleOrderSql = "SELECT VehicleOrder_ID FROM EMTinCar where  ID=" + timcarid;
            CheckVehicleOrder_ID = Common.Conn.SqlHelper.getSqlValue(CheckVehicleOrderSql);
            if (!string.IsNullOrEmpty(CheckVehicleOrder_ID))
            {
                checkorder_id = Convert.ToInt32(CheckVehicleOrder_ID);
            }
            string CheckVehicleStateType_ID = string.Empty;//选中的类型
            int oldVehicleStateType_ID = 0;
            string value = string.Empty;
            sqlsd = "SELECT VehicleStateType_ID FROM EMTinCar where ID=" + timcarid;
            CheckVehicleStateType_ID = Common.Conn.SqlHelper.getSqlValue(sqlsd);
            if (!string.IsNullOrEmpty(CheckVehicleStateType_ID))
            {
                oldVehicleStateType_ID = Convert.ToInt32(CheckVehicleStateType_ID);
            }

            if (!string.IsNullOrEmpty(CheckVehicleStateType_ID))
            {
                //根据查询出来的VehicleStateType_ID判断是那种车辆,原始状态,
                //1排队车辆往出站车辆添加，出站车辆本身存在顺序是好的，只是往最后一个排
                //2选中出站车辆发货，是顺序相当于出站车辆拖拽最后一个
                //3选中车属于暂停车辆发货，跟第一种情况一样
                if (CheckVehicleStateType_ID == "1")
                {
                    sqlsd = "SELECT NO FROM EMTinCar where VehicleStateType_ID =1 AND ID=" + mi.EMTinCar_ID;
                    value = Common.Conn.SqlHelper.getSqlValue(sqlsd);
                    if (!string.IsNullOrEmpty(value))//当前车在排队里面修改为出站,还要及时更新5个车给treeview
                    {
                        updates(checkorder_id, 2, CheckVehicleStateType_ID);
                        updateTransportorder_proc(oldVehicleStateType_ID);
                        if (fmt != null)
                        {
                            RemoveMySofeNode(fmt, CheckVehicleStateType_ID, value);
                        }
                        else { //车辆监控车辆没有打开的情况下直接更新数据库的二个字段数据
                        }
                        Messages(value, CheckVehicleStateType_ID);
                        #region   移除刚新建的项排队车
                        string te = "";
                        foreach (ListViewItem item in vi.Items)
                        {
                            te = item.Text;
                            if (value.Contains(te))//找到59
                            {
                                vi.Items.Remove(item);
                            }
                        }
                        //vi.Items.Clear();
                        //fmm.BindListView();
                        #endregion
                    }
                }
                else if (CheckVehicleStateType_ID == "2")
                {
                    sqlsd = "SELECT NO FROM EMTinCar where VehicleStateType_ID =2 AND ID=" + mi.EMTinCar_ID;
                    value = Common.Conn.SqlHelper.getSqlValue(sqlsd);
                    if (!string.IsNullOrEmpty(value))//当前车在出站里面重新刷新排序
                    {
                        updates(checkorder_id, 2, CheckVehicleStateType_ID);
                        if (fmt != null)
                        {
                            RemoveMySofeNode(fmt, CheckVehicleStateType_ID, value);
                        }
                        Messages(value, CheckVehicleStateType_ID);
                    }
                }
                else if (CheckVehicleStateType_ID == "3")
                {
                    sqlsd = "SELECT NO FROM EMTinCar where VehicleStateType_ID =3 AND ID=" + mi.EMTinCar_ID;
                    value = Common.Conn.SqlHelper.getSqlValue(sqlsd);
                    if (!string.IsNullOrEmpty(value))//当前暂停重新排序
                    {
                        updates(checkorder_id, 2, CheckVehicleStateType_ID);
                        updateTransportorder_proc(oldVehicleStateType_ID);
                        if (fmt != null)
                        {
                            RemoveMySofeNode(fmt, CheckVehicleStateType_ID, value);
                        }
                        Messages(value, CheckVehicleStateType_ID);
                    }
                }
                else if (CheckVehicleStateType_ID == "4")//新建车辆就是不显示的车
                {
                    //sqlsd = "SELECT NO FROM EMTinCar where VehicleStateType_ID =4 AND ID=" + mi.EMTinCar_ID;
                    //value = Common.Conn.SqlHelper.getSqlValue(sqlsd);
                    //if (!string.IsNullOrEmpty(value))//当前暂停重新排序
                    //{
                    //    updates(checkorder_id, 2, CheckVehicleStateType_ID);
                    //    updateTransportorder_proc(oldVehicleStateType_ID);
                    //    if (fmt != null)
                    //    {
                    //        RemoveMySofeNode(fmt, CheckVehicleStateType_ID, value);
                    //    }
                    //    Messages(value, CheckVehicleStateType_ID);
                    //}
                }

            }
        }