コード例 #1
0
        public void SortChannelSwap()
        {
            if (gridView.SelectedRowsCount <= 0)
            {
                XtraMessageBox.Show("请选择要交换的烟道!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                return;
            }
            Assembly assembly = Assembly.GetEntryAssembly();
            int handle = gridView.GetSelectedRows()[0];
            string lineCode = gridView.GetRowCellValue(handle, "LINECODE").ToString();
            string channelGroup = gridView.GetRowCellValue(handle, "CHANNELGROUP").ToString();
            string channelCode = gridView.GetRowCellValue(handle, "CHANNELCODE").ToString();
            string channelType = gridView.GetRowCellValue(handle, "CHANNELTYPE").ToString();
            DataTable table = channelDal.FindSortChannel(lineCode, channelType, channelGroup, channelCode);
            SortChannelSwapDialog swapDialog = new SortChannelSwapDialog();
            swapDialog.Icon = ((Form)Shell).Icon ?? Icon.ExtractAssociatedIcon(assembly.Location);
            swapDialog.txtStartPosition.Text = lineCode + "-" + channelGroup + "-" + channelType + "-" + gridView.GetRowCellValue(handle, "CHANNELNAME").ToString();
            swapDialog.cmbTargetPosition.Properties.DataSource = table;
            swapDialog.cmbTargetPosition.Properties.ValueMember = "CODE";
            swapDialog.cmbTargetPosition.Properties.DisplayMember = "CHANNEL";
            if (swapDialog.ShowDialog() == DialogResult.OK)
            {
                if (swapDialog.cmbTargetPosition.EditValue == null)
                    return;
                string tagetChannelCode = swapDialog.cmbTargetPosition.EditValue.ToString();
                DataRow sourceChannelRow = channelDal.FindSortChannelUSED(lineCode, channelCode);
                DataRow targetChannelRow = channelDal.FindSortChannelUSED(lineCode, tagetChannelCode);
                channelDal.UpdateSortChannelUSED(lineCode, tagetChannelCode,
                            sourceChannelRow["CIGARETTECODE"].ToString(),
                            sourceChannelRow["CIGARETTENAME"].ToString(),
                            sourceChannelRow["QUANTITY"].ToString(),
                            sourceChannelRow["SORTNO"].ToString());

                channelDal.UpdateSortChannelUSED(lineCode, channelCode,
                     targetChannelRow["CIGARETTECODE"].ToString(),
                     targetChannelRow["CIGARETTENAME"].ToString(),
                     targetChannelRow["QUANTITY"].ToString(),
                     targetChannelRow["SORTNO"].ToString());
                StockingDal stockingDal = new StockingDal();
                stockingDal.UpdateSortChannelUSED(lineCode, channelCode, "000000", targetChannelRow["GROUPNO"].ToString());
                stockingDal.UpdateSortChannelUSED(lineCode, tagetChannelCode, channelCode, sourceChannelRow["GROUPNO"].ToString());
                stockingDal.UpdateSortChannelUSED(lineCode, "000000", tagetChannelCode, targetChannelRow["GROUPNO"].ToString());

                Logger.Info(string.Format("{0}{1}号烟道与{2}号烟道交换成功!", channelGroup, channelCode, tagetChannelCode));
                Refresh();
            }
        }
コード例 #2
0
 public void SortChannelSwap()
 {
     if (gridView.SelectedRowsCount <= 0)
     {
         XtraMessageBox.Show("请选择要交换的烟道!", "提示",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
         return;
     }
     Assembly assembly = Assembly.GetEntryAssembly();
     int handle = gridView.GetSelectedRows()[0];
     string lineCode = gridView.GetRowCellValue(handle, "LINECODE").ToString();
     string channelGroup = gridView.GetRowCellValue(handle, "CHANNELGROUP").ToString();
     string channelCode = gridView.GetRowCellValue(handle, "CHANNELCODE").ToString();
     string channelType = gridView.GetRowCellValue(handle, "CHANNELTYPE").ToString();
     DataTable table = channelDal.FindSortChannel(lineCode, channelType, channelGroup, channelCode);
     SortChannelSwapDialog swapDialog = new SortChannelSwapDialog();
     swapDialog.Icon=((Form)Shell).Icon ?? Icon.ExtractAssociatedIcon(assembly.Location);
     swapDialog.txtStartPosition.Text = lineCode + "-" + channelGroup + "-" + channelType + "-" + gridView.GetRowCellValue(handle, "CHANNELNAME").ToString();
     swapDialog.cmbTargetPosition.Properties.DataSource = table;
     swapDialog.cmbTargetPosition.Properties.ValueMember = "CODE";
     swapDialog.cmbTargetPosition.Properties.DisplayMember = "CHANNEL";
     if (swapDialog.ShowDialog() == DialogResult.OK)
     {
         if (swapDialog.cmbTargetPosition.EditValue == null)
             return;
         string tagetChannelCode=swapDialog.cmbTargetPosition.EditValue.ToString();
         string[] data = new string[3];
         orderDal.UpdateOrderDetailByChannelCode(channelCode, "000000");
         orderDal.UpdateOrderDetailByChannelCode(tagetChannelCode, channelCode);
         orderDal.UpdateOrderDetailByChannelCode("000000",tagetChannelCode);
         DataRow row1=channelDal.FindSortChannelByCode(tagetChannelCode);
         DataRow row2 = channelDal.FindSortChannelByCode(channelCode);
         channelDal.UpdateSortChannelByChannelCode(channelCode, row1["CIGARETTECODE"].ToString(), row1["CIGARETTENAME"].ToString(), 
             row1["QUANTITY"].ToString(), row1["SORTNO"].ToString(), row1["STATUS"].ToString());
         data[0] = row1["CHANNELADDRESS"].ToString();
         channelDal.UpdateSortChannelByChannelCode(tagetChannelCode, row2["CIGARETTECODE"].ToString(), row2["CIGARETTENAME"].ToString(),
             row2["QUANTITY"].ToString(), row2["SORTNO"].ToString(), row2["STATUS"].ToString());
         data[1] = row2["CHANNELADDRESS"].ToString();
         data[2] = "1";
         if (channelGroup == "A线")
             Ops.Write(Global.ServiceName_SortingOPC, "A_Channel_Change", data);
         else
             Ops.Write(Global.ServiceName_SortingOPC, "B_Channel_Change", data);
         Logger.Info(string.Format("{0}{1}号烟道与{2}号烟道交换成功!", channelGroup, data[0], data[1]));
         Refresh(-1);
     }
 }