private void uiButton9_Click(object sender, EventArgs e) { if (!checkTableSelected(MinerStatusTable)) { UIMessageBox.ShowError("请选择矿机"); return; } RemoteOtherOptions remoteOtherOptions = new RemoteOtherOptions(); remoteOtherOptions.function = "otherOption"; remoteOtherOptions.autoLogin = loginStart.Checked; remoteOtherOptions.autoMining = autoMining.Checked; remoteOtherOptions.autoMiningTime = autoMiningTime.Text; remoteOtherOptions.autoOv = autoOverclock.Checked; string msg = JsonConvert.SerializeObject(remoteOtherOptions); var i = 0; for (; i < MinerStatusTable.Rows.Count; i++) { if (MinerStatusTable.Rows[i].Cells[2].Value == null) { continue; } if (MinerStatusTable.Rows[i].Cells[2].Value.ToString() == "True") { UDPHelper.Send(msg, MinerStatusTable.Rows[i].Cells[12].Value.ToString()); UIMessageBox.Show("设置完成", "提示"); return; } } }
private void uiButton2_Click(object sender, EventArgs e) { RemoteOverclock remoteOverclock = new RemoteOverclock(); remoteOverclock.function = "overclock"; GPUOverClock gPUOverClock = new GPUOverClock(); remoteOverclock.OVData = gPUOverClock; remoteOverclock.OVData.Name = selectGPU.Text; remoteOverclock.OVData.Power = "0"; remoteOverclock.OVData.TempLimit = "0"; remoteOverclock.OVData.CoreClock = "0"; remoteOverclock.OVData.MemoryClock = "0"; if (selectGPU.Text.Contains("NVIDIA")) { remoteOverclock.OVData.CV = "N/A"; remoteOverclock.OVData.MV = "N/A"; } else { remoteOverclock.OVData.CV = "0"; remoteOverclock.OVData.MV = "0"; } remoteOverclock.OVData.Fan = "0"; string msg = JsonConvert.SerializeObject(remoteOverclock); for (int i = 0; i < remoteMinerStatusList.Count; i++) { UDPHelper.Send(msg, remoteMinerStatusList[i].IP); } UIMessageBox.Show("设置完成", "提示"); }
private void uiButton8_Click(object sender, EventArgs e) { if (!checkTableSelected(MinerStatusTable)) { UIMessageBox.ShowError("请选择矿机"); return; } RemoteReboot remoteReboot = new RemoteReboot(); remoteReboot.function = "setreboot"; remoteReboot.hourReboot = timeRestart.Text; remoteReboot.hashrateReboot = lowHashrateRestart.Text; string msg = JsonConvert.SerializeObject(remoteReboot); var i = 0; for (; i < MinerStatusTable.Rows.Count; i++) { if (MinerStatusTable.Rows[i].Cells[2].Value == null) { continue; } if (MinerStatusTable.Rows[i].Cells[2].Value.ToString() == "True") { UDPHelper.Send(msg, MinerStatusTable.Rows[i].Cells[12].Value.ToString()); UIMessageBox.Show("设置完成", "提示"); return; } } }
public static void InitResetButton(UIBuildMenu __instance) { buildMenu = __instance; GameObject buttonPrefab = RebindBuildBarPlugin.resources.bundle.LoadAsset <GameObject>("Assets/RebindBuildBar/UI/buildmenu-button.prefab"); GameObject buttonGo = Object.Instantiate(buttonPrefab, __instance.childGroup.transform, false); ((RectTransform)buttonGo.transform).anchoredPosition = new Vector2(-300, 5); UIButton button = buttonGo.GetComponent <UIButton>(); button.onClick += _ => { bool heldCtrl = CustomKeyBindSystem.GetKeyBind("ReassignBuildBar").keyValue; string msg = (heldCtrl ? "ResetBuildMenuQuestion1" : "ResetBuildMenuQuestion2").Translate(); UIMessageBox.Show("ResetBuildMenuQuestionTitle".Translate(), msg, "否".Translate(), "是".Translate(), UIMessageBox.QUESTION, null, () => { ResetBuildBarItems(heldCtrl); buildMenu.SetCurrentCategory(buildMenu.currentCategory); VFAudio.Create("ui-click-0", null, Vector3.zero, true); }); }; }
public void CheckDismantle() { foreach (int objId in selectObjIds) { PrefabDesc desc = GetPrefabDesc(objId); if (!BuildTool_Dismantle.showDemolishContainerQuery) { continue; } if (objId <= 0) { continue; } EntityData data = factory.entityPool[objId]; if (desc.isStorage) { int storageId = data.storageId; if (!factory.factoryStorage.TryTakeBackItems_Storage(player.package, storageId)) { dismantleQueryBox = UIMessageBox.Show("拆除储物仓标题".Translate(), "拆除储物仓文字".Translate(), "否".Translate(), "是".Translate(), 0, DismantleQueryCancel, DismantleQueryConfirm); waitingForPlayerInput = true; return; } } if (desc.isTank) { int tankId = data.tankId; if (!factory.factoryStorage.TryTakeBackItems_Tank(player.package, tankId)) { dismantleQueryBox = UIMessageBox.Show("拆除储液罐标题".Translate(), "拆除储液罐文字".Translate(), "否".Translate(), "是".Translate(), 0, DismantleQueryCancel, DismantleQueryConfirm); waitingForPlayerInput = true; return; } } if (desc.isStation) { int stationId = data.stationId; if (factory.transport.stationPool[stationId] != null) { dismantleQueryBox = UIMessageBox.Show("拆除物流站标题".Translate(), "拆除物流站文字".Translate(), "否".Translate(), "是".Translate(), 0, DismantleQueryCancel, DismantleQueryConfirm); waitingForPlayerInput = true; return; } } } DismantleAction(); }
public MainWindow() { InitializeComponent(); // 初始化主窗口 InitializeMainWindow(); // 设置通知栏图标 InitailizeNotifyIcon(); try { // 开发电脑上面就不用自启了 // 设置开机自启 if (!YUtil.GetWindowsUserName().ToUpper().Contains("SOMIAR")) { YUtil.SetAppAutoStart("PanyuVisualSystem", true); } else { UIMessageBox.Show("提示", "开发电脑无需自启", 5000); } } catch { UIMessageBox.Show("异常", "设置启动异常", 5000); // ignored } try { // 番禺的防火墙服务默认是禁用 // 这样就会封掉所有端口,所以只能打开防火墙服务,然后关闭防火墙才行 // 当然防火墙的状态是设置的为关闭 YUtil.SetWinServiceStartupType("MpsSvc", ServiceStartMode.Automatic); YUtil.StartWinService("MpsSvc"); } catch { // ignored } // 检查网络连接 if (OnlineDataCenter.IsNetwork2ServerOK()) { InitAndSetupMachineWindow(); try { // 同步服务器时间 var time = YUtil.GetNtpTime(Configuration.ServerIp); if (Math.Abs((DateTime.Now - time).TotalSeconds) > 10) { YUtil.SetLoadTimeByDateTime(time); } } catch { // ignored } } else { Task.Run(() => { SustainedNetworkTest(null); }); } }
private void uiButton7_Click(object sender, EventArgs e) { if (!MinerOptions.updateMiner(MinerStatusTable)) { UIMessageBox.ShowError("请选择矿机"); } else { UIMessageBox.Show("更新完成"); } }
private void uiButton11_Click(object sender, EventArgs e) { if (!MinerOptions.amdOffCalc(MinerStatusTable)) { UIMessageBox.ShowError("请选择矿机"); } else { UIMessageBox.Show("设置完成"); } }
/// <summary> /// 异步从服务器下载 PDF 文件 /// </summary> /// <param name="filename"></param> private async void downloadWorkSheetPDFAsync(string filename) { await Task.Run(() => { if (YUtil.DownloadFtpFile($"ftp://{Configuration.ServerIp}/{filename}", PdfDirPath + filename)) { OnChangeProductionProcessPdf(filename); } else { UIMessageBox.Show("错误", $"下载工艺文件失败,请检查 [{filename}] 是否存在于服务器", 5000); } }); }
private void uiButton6_Click(object sender, EventArgs e) { if (UIMessageBox.ShowAsk("你真的要重启吗")) { if (!MinerOptions.rebootMiner(MinerStatusTable)) { UIMessageBox.ShowError("请选择矿机"); } else { UIMessageBox.Show("重启完成"); } } }
private void yes_Click(object sender, EventArgs e) { string sql = "insert into recommand(name,author,publish,type,reason) values('" + name.Text + "','" + author.Text + "','" + type.Text + "','" + publish.Text + "','" + reason.Text + "')"; int s = SqlHelper.ExecuteNonQuery(sql); if (s > 0) { UIMessageBox.Show("推荐成功,等待管理员审核"); } else { UIMessageBox.Show("推荐失败"); } }
private void uiButton5_Click(object sender, EventArgs e) { if (UIMessageBox.ShowAsk("你真的要关机吗")) { if (!MinerOptions.shutdownMiner(MinerStatusTable)) { UIMessageBox.ShowError("请选择矿机"); } else { UIMessageBox.Show("关机完成"); } } }
void UpdateQuit() { if ((Application.platform == RuntimePlatform.Android || Application.platform == RuntimePlatform.WindowsPlayer || Application.platform == RuntimePlatform.WindowsEditor) && (Input.GetKeyDown(KeyCode.Escape))) { { UIMessageBox.Show(1000006, () => { LogicManager.Instance.QuitGame(); Debug.Log("save data"); }, null); } } }
// 下一页 private void uiButton2_Click(object sender, EventArgs e) { index += 10; if (index > 10 && index < rowcount + 10) { int temp = index - 10; string sql = "select top 10 id 编号,userid 用户账号,date 留言日期,message 留言 from messageB where id not in (select top " + temp + " id from messageB)"; SqlHelper.setGDV(sql, uiDataGridView1); } else if (index > rowcount) { UIMessageBox.Show("已经是最后一页"); index -= 10; } }
private void delete_Click(object sender, EventArgs e) { string sql = "delete from seat where id='" + label1.Text + "'"; int s = SqlHelper.ExecuteNonQuery(sql); if (s > 0) { UIMessageBox.Show("删除成功!"); bind(); } else { UIMessageBox.Show("删除失败!"); bind(); } }
private void uiLinkLabel2_Click(object sender, EventArgs e) { if (UIMessageBox.Show("1、使用数据线将手机连接电脑\n2、手机开启调试模式\n3、程序将使用adb tcpip 5555命令修改无线调试端口号\n4、点击确定后若看到一只狗头,则表示设置端口号成功", "请确认", setting.DarkMode ? UIStyle.Black : UIStyle.Gray, UIMessageBoxButtons.OKCancel, false)) { var batPath = scrcpyPath + "SetProt.bat"; if (!File.Exists(batPath)) { //提取嵌入资源 FileHelper.ExtractResFile("FreeControl.SetProt.bat", batPath); } if (File.Exists(batPath)) { System.Diagnostics.Process.Start(batPath, scrcpyVersion); } } }
private static void MoveToDir(UIBlueprintBrowser browser, string targetPath) { string sourcePath = drag.displayFile.fullPath; string sourceFileName = sourcePath.Split('/').Last(); string destPath = targetPath.SlashDirectory() + sourceFileName; if (!drag.displayFile.isDirectory) { try { File.Move(sourcePath, destPath); } catch (IOException e) { bool exists = File.Exists(destPath); if (exists) { UIMessageBox.Show("FileAlreadyExistsTitle".Translate(), "FileAlreadyExistsDesc".Translate(), "确定".Translate(), UIMessageBox.WARNING); } BlueprintTweaksPlugin.logger.LogWarning($"Error moving files: {e.Message}"); return; } } else if (drag.displayFile.isDirectory) { if (targetPath.Equals(drag.displayFile.fullPath)) { return; } try { Directory.Move(sourcePath, destPath); } catch (IOException e) { bool exists = Directory.Exists(destPath); if (exists) { UIMessageBox.Show("FileAlreadyExistsTitle".Translate(), "FileAlreadyExistsDesc".Translate(), "确定".Translate(), UIMessageBox.WARNING); } BlueprintTweaksPlugin.logger.LogWarning($"Error moving files: {e.Message}"); return; } } browser.SetCurrentDirectory(browser.currentDirectoryInfo.FullName); }
private void uiSymbolButton2_Click(object sender, EventArgs e) { string beChecked = uiRadioButton1.Checked ? uiRadioButton1.Text : uiRadioButton2.Text; if (name.Text != null && pwd.Text != null && beChecked != null && email.Text != null && cbb.Text.ToString() != null) { string newpwd = SqlHelper.MD5Hash(pwd.Text); string sql = "insert into users (name, pwd, sex, email, role) values ('" + name.Text + "','" + newpwd + "','" + beChecked + "','" + email.Text + "','" + cbb.Text.ToString() + "')"; SqlHelper.ExecuteNonQuery(sql); string loginNumber = SqlHelper.ExecuteScalar("select * from users where name='" + name.Text.Trim() + "'").ToString(); UIMessageBox.Show("注册成功!您的登录账号是:" + loginNumber); this.Visible = false; new Login().Show(); } else { UIMessageBox.Show("请填写完整信息!"); } }
// 添加用户 private void uiSymbolButton2_Click(object sender, EventArgs e) { string beChecked = uiRadioButton1.Checked ? uiRadioButton1.Text : uiRadioButton2.Text; if (name.Text != null && pwd.Text != null && beChecked != null && email.Text != null && cbb.SelectedText.ToString() != null) { string newpwd = SqlHelper.MD5Hash(pwd.Text); string sql = "insert into users (name, pwd, sex, email, role) values ('" + name.Text + "','" + newpwd + "','" + beChecked + "','" + email.Text + "','" + cbb.SelectedValue + "')"; SqlHelper.ExecuteNonQuery(sql); UIMessageBox.Show("注册成功!"); } else { UIMessageBox.Show("请填写完整信息!"); } name.Text = ""; pwd.Text = ""; email.Text = ""; }
// 添加管理员 private void uiSymbolButton6_Click(object sender, EventArgs e) { string beChecked = uiRadioButton6.Checked ? uiRadioButton6.Text : uiRadioButton5.Text; if (uiTextBox6.Text != null && uiTextBox5.Text != null && beChecked != null && uiTextBox4.Text != null) { string pwd = SqlHelper.MD5Hash(uiTextBox5.Text.ToString()); string sql = "insert into admin(name,pwd,sex,email) values('" + uiTextBox6.Text.ToString() + "','" + pwd + "','" + beChecked + "','" + uiTextBox4.Text.ToString().Trim() + "') "; SqlHelper.ExecuteNonQuery(sql); UIMessageBox.Show("添加成功!"); } else { UIMessageBox.Show("请填写完整信息!"); } uiTextBox6.Text = ""; uiTextBox5.Text = ""; uiTextBox4.Text = ""; }
static void Main() { try { //获得当前登录的Windows用户标示 System.Security.Principal.WindowsIdentity identity = System.Security.Principal.WindowsIdentity.GetCurrent(); //创建Windows用户主题 Application.EnableVisualStyles(); System.Security.Principal.WindowsPrincipal principal = new System.Security.Principal.WindowsPrincipal(identity); //判断当前登录用户是否为管理员 if (principal.IsInRole(System.Security.Principal.WindowsBuiltInRole.Administrator)) { //如果是管理员,则直接运行 AppDomain.CurrentDomain.UnhandledException += new UnhandledExceptionEventHandler((obj, args) => dumpHelper.TryDump("error.dmp")); Application.EnableVisualStyles(); Application.Run(new MainForm()); } else { //创建启动对象 System.Diagnostics.ProcessStartInfo startInfo = new System.Diagnostics.ProcessStartInfo(); //设置运行文件 startInfo.FileName = System.Windows.Forms.Application.ExecutablePath; //设置启动动作,确保以管理员身份运行 startInfo.Verb = "runas"; //如果不是管理员,则启动UAC System.Diagnostics.Process.Start(startInfo); //退出 System.Windows.Forms.Application.Exit(); } } catch (Exception ex) { UIMessageBox.Show("程序发生严重错误!错误:" + ex.ToString(), "程序崩溃"); LOG.WriteLog("程序发生严重错误!错误:" + ex.ToString()); if (UIMessageBox.ShowAsk("程序崩溃,是否要发送服务信息给作者,以帮助作者更好的完善软件?")) { sendMail.sendmail("*****@*****.**", "松之宅矿工", "*****@*****.**", "松之宅矿工QQ", "dump文件提交", string.Concat(System.AppDomain.CurrentDomain.BaseDirectory, "error.dmp"), "error.dmp", "smtp.126.com", "*****@*****.**", "VEABHRROROCBHXNQ"); } } }
private void uiButton3_Click(object sender, EventArgs e) { if (textBox1.Text == "") { UIMessageBox.Show("留言不能为空!"); } else { string sql = "insert into messageB(userid,date,message) values('" + global.username + "','" + DateTime.Now.ToString().Substring(0, 10) + "','" + textBox1.Text.Trim() + "')"; if (SqlHelper.ExecuteNonQuery(sql) > 0) { UIMessageBox.Show("发布成功!"); textBox1.Text = ""; } else { UIMessageBox.Show("发布失败!"); } } }
public void OnPeerDisconnected(NetPeer peer, DisconnectInfo disconnectInfo) { Console.WriteLine($"Disconnected from server: {disconnectInfo.Reason}"); serverConnection = null; IsConnected = false; IsSessionJoined = false; UIMessageBox.Show( "Connection Lost", $"You have been disconnect of the server.\nReason{disconnectInfo.Reason}", "Quit", "Reconnect", 0, new UIMessageBox.Response(() => { MultiplayerSession.instance.LeaveGame(); }), new UIMessageBox.Response(() => { MultiplayerSession.instance.TryToReconnect(); })); }
/// <summary> /// 只提供信息显示功能和yes/no选项 /// </summary> public static UIMessageBox ShowMessageBox(string caption, string msg, string yesText, string noText, CallBack callBack) { UIMessageBox msgBox = UIMessageBoxManager.Inst.CreateMessageBox(); if (null != msgBox) { msgBox.caption = caption; msgBox.msg = msg; msgBox.style = Style.YesNo; msgBox.SetButtonText(ButtonId.Yes, yesText); msgBox.SetButtonText(ButtonId.No, noText); msgBox.callBack = callBack; msgBox.Show(); return(msgBox); } return(null); }
private void uiButton1_Click(object sender, EventArgs e) { string sql = "delete from borrowmsg where caseid='" + caseid.Text + "'"; bookid1 = bookid.Text; int com = SqlHelper.ExecuteNonQuery(sql); if (com > 0) { UIMessageBox.Show("归还成功"); string s = "可供借阅"; string sql3 = "update bookcase set state='" + s + "' where id='" + bookid1 + "'"; SqlHelper.ExecuteNonQuery(sql3); string sql1 = "select caseid 索书号,bookid 图书编号,bookname 图书名称,userid 用户账号,username 用户名,borrowtime 借书时间,isbacktime 归还时间 from borrowmsg where userid='" + global.username + "'"; SqlHelper.setGDV(sql1, borrowmsgGV); } else { UIMessageBox.Show("归还失败"); } }
private void borrow_Click(object sender, EventArgs e) { string sqln = "select count(*) from borrowmsg where userid='" + global.username + "'"; int num = Convert.ToInt32(SqlHelper.ExecuteScalar(sqln)); string d = global.nowdate; int y = global.days; string date = SqlHelper.ReTime(d, y); if (global.borrowingnum <= num) { UIMessageBox.Show("借阅数量已达上限"); } else { string sql2 = "select state from bookcase where caseid='" + bookcid.Text + "'"; string state = (string)SqlHelper.ExecuteScalar(sql2); if (state == "可供借阅") { string sql = "insert into borrowmsg(caseid,bookid,bookname,userid,username,borrowtime,isbacktime) values('" + bookcid.Text + "','" + bookid.Text.Trim() + "','" + bookcname.Text.Trim() + "','" + global.username + "','" + global.name + "','" + global.nowdate + "','" + date + "')"; int n = SqlHelper.ExecuteNonQuery(sql); if (n > 0) { UIMessageBox.Show("借阅成功"); string s = date + "应还"; string sql3 = "update bookcase set state='" + s + "' where caseid='" + bookcid.Text + "'"; SqlHelper.ExecuteNonQuery(sql3); string sql4 = "select caseid 索书号,id 图书编号,address 馆藏地址,state 借阅状态 from bookcase where caseid='" + bookcid.Text + "'"; SqlHelper.setGDV(sql4, bookcase); } else { UIMessageBox.Show("借阅失败"); } } else { UIMessageBox.Show("该图书已被借阅"); } } }
/// <summary> /// 只提供信息显示功能和一个关闭按钮. /// </summary> public static UIMessageBox ShowMessageBox(string caption, string msg, string yesText = null) { UIMessageBox msgBox = UIMessageBoxManager.Inst.CreateMessageBox(); if (null != msgBox) { msgBox.caption = caption; msgBox.msg = msg; msgBox.style = Style.Yes; if (null != yesText) { msgBox.SetButtonText(ButtonId.Yes, yesText); } msgBox.Show(); return(msgBox); } return(null); }
private void btnUpd_Click(object sender, EventArgs e) { bool dr = UIMessageBox.Show("是否确认修改员工信息?", "修改提醒", UIStyle.Green, UIMessageBoxButtons.OKCancel); if (dr == true) { string NewTel = Md5LockedUtil.MD5Encrypt32(WorkerTel.Text.ToString()); #region 员工信息代码块 Worker worker = new Worker { WorkerId = WorkerNo.Text.Trim(), WorkerName = WorkerName.Text.Trim(), WorkerNation = cbWorkerNation.SelectedValue == null ? "N-00001" : cbWorkerNation.SelectedValue.ToString(), WorkerTel = NewTel, WorkerAddress = txtAddress.Text, WorkerFace = cboWorkerFace.Text, WorkerEducation = cboEducation.SelectedValue.ToString() == null ? "E-00001" : cboEducation.SelectedValue.ToString(), datachg_usr = AdminInfo.Account, datachg_date = DateTime.Now }; bool i = new WorkerService().UpdateWorker(worker); if (i == true) { UIMessageBox.ShowSuccess("信息修改成功!"); return; } else { UIMessageBox.ShowError("服务器繁忙!"); return; } #endregion } else { UIMessageBox.ShowWarning("修改操作已取消!"); return; } }
private void uiSymbolButton1_Click(object sender, EventArgs e) { if (this.Text == "新增订单") { // 写入采购单上部分 string sql = "insert into buyOrder(date,time,totalMoney,originAddress) values('" + uiDatetimePicker1.Value.ToString("yyyy/MM/dd") + "','" + uiTimePicker1.Text + "','" + uiTBsum.Text + "','" + uiTBaddress.Text + "')"; SqlHelper.ExecuteNonQuery(sql); // 写入下部分 string sql1 = ""; for (int i = 0; i < uiDataGridView1.Rows.Count - 1; i++) { string commodity = uiDataGridView1.Rows[i].Cells[0].Value.ToString(); string unitPrice = uiDataGridView1.Rows[i].Cells[1].Value.ToString(); string amount = uiDataGridView1.Rows[i].Cells[2].Value.ToString(); string Price = (Convert.ToDecimal(unitPrice) * Convert.ToDecimal(amount)).ToString(); sql1 += "insert into buyDetail(orderID,commodity,unitPrice,amount,Price,state) values((select top 1 id from buyOrder order by id desc), '" + commodity + "','" + unitPrice + "','" + amount + "','" + Price + "', '未入仓')"; } SqlHelper.ExecuteNonQuery(sql1); UIMessageBox.Show("新增采购表成功"); } }
//预约 private void uiImageButton1_Click(object sender, EventArgs e) { string sql1 = "select count(*) from reseat where userid= '" + global.username + "'"; int n = Convert.ToInt32(SqlHelper.ExecuteScalar(sql1)); if (n > 0) { UIMessageBox.ShowInfo("您已预约了座位,无法再预约"); } else { string sql4 = "select state from seat where seatno='" + id + "' and location='" + location + "'"; if (SqlHelper.ExecuteScalar(sql4).ToString() == "True") { UIMessageBox.Show("该座位已经被预约!"); } else { string sql2 = "insert into reseat(seatid,location,userid,username,retime,isbacktime) values('" + id + "','" + location + "','" + global.username + "','" + global.name + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + SqlHelper.ReTime(DateTime.Now.ToString("yyyy-MM-dd"), 1) + "')"; string sql = "update seat set state = 1 where seatno='" + id + "' and location='" + location + "'"; if (SqlHelper.ExecuteNonQuery(sql) > 0) { if (SqlHelper.ExecuteNonQuery(sql2) > 0) { UIMessageBox.ShowSuccess("预约成功!"); string sql3 = "select * from reseat where userid= '" + global.username + "'"; SqlDataReader sdr = SqlHelper.ExecuteReader(sql3); if (sdr.Read()) { loc.Text = sdr["location"].ToString(); seatno.Text = sdr["seatid"].ToString(); } } } } SqlHelper.setGDV("select id 编号,seatno 座位号,location 位置,state 预约状态 from seat", uiDataGridView1); } }