C# Winform的查找，更新，插入,删除数据使用

查找

Main.cs

            // 通过Tray检查是，将其信息带出
            exeRes = controller.GetTrayWoValue(Tray);
            if (exeRes.Status)
            {
                dtTemp = new DataTable();
                dtTemp = (DataTable)exeRes.Anything;
                if (dtTemp.Rows.Count > 0)
                {
                    for (int i = 0; i < dtTemp.Rows.Count ; i++)
                    {
                        Wo = dtTemp.Rows[i]["WORK_ORDER"].ToString();
                        Ipn = dtTemp.Rows[i]["IPN"].ToString();
                        BoxQty = dtTemp.Rows[i]["BOX_QTY"].ToString();
                        Pkspec = dtTemp.Rows[i]["PKSPEC_NAME"].ToString();
                        Sn= dtTemp.Rows[i]["SERIAL_NUMBER"].ToString();
                        dgvTrayInfo.Rows.Add(Sn, Wo, Tray);
                        SuccessMSG(Sn + " 添加成功");
                        lblCountTrayNum.Text = (dgvTrayInfo.Rows.Count - 1).ToString();
                        showMain();
                    }  
                }
                if (lblCountTrayNum.Text.Trim() == lblTrayNum.Text.Trim())
                {
                    ErrorMSG("Tray：" + lblTrayValue.Text + "已包满，请更换下一个Tray！");
                    txtTray.Focus();
                    return;
                }
            }

controller.cs

 public ExecuteResult GetTrayWoValue(string Tray)
        {
            return selectDal.GetTrayWoValue(Tray);
        }

selectDal.cs

        public ExecuteResult GetTrayWoValue(string Tray)
        {
            try
            {
                exeRes = new ExecuteResult();
                string sqlStr = @" SELECT A.IPN,A.SERIAL_NUMBER,A.WORK_ORDER,C.BOX_QTY,C.PKSPEC_NAME
                                      FROM  IMES.P_SN_STATUS A,IMES.M_PART_PRODUCT_INFO B, IMES.M_PKSPEC C
                                     WHERE A.IPN = B.IPN
                                       AND B.PKSPEC_NAME = C.PKSPEC_NAME
                                       AND A.BOX_NO = :Tray";