private void butok_Click(object sender, EventArgs e) { if (cmbpyck.SelectedValue == null) { return; } DataTable tb = MZPY.Get_pyck("", cmbpyck.SelectedValue.ToString(), InstanceForm.BDatabase); string add = TrasenClasses.GeneralClasses.PubStaticFun.GetMacAddress().Trim(); if (tb.Rows.Count == 0) { return; } if (tb.Rows[0]["BZYBZ"].ToString() == "1") { if (add != tb.Rows[0]["wkdz"].ToString().Trim() && tb.Rows[0]["wkdz"].ToString().Trim() != "") { MessageBox.Show("这个窗口正在使用,您不能选择它"); return; } } MZPY.Update_pyck(add, cmbpyck.SelectedValue.ToString(), 1, InstanceForm.BDatabase); Frmmzpy f = new Frmmzpy(_menuTag, _chineseName, _mdiParent); f._Pyckh = cmbpyck.SelectedValue.ToString().Trim(); this.Close(); if (_mdiParent != null) { f.MdiParent = _mdiParent; } f.Show(); }
private void Frmcksz_Load(object sender, EventArgs e) { DataTable tb = MZPY.Get_pyck("", "", InstanceForm.BDatabase); tb.TableName = "tab"; cmbpyck.DataSource = tb; cmbpyck.ValueMember = "CODE"; cmbpyck.DisplayMember = "NAME"; if (cmbpyck.Items.Count > 0) { cmbpyck.SelectedIndex = 0; } }
private void cmbpyck_SelectedIndexChanged(object sender, EventArgs e) { DataTable tb = MZPY.SelectFyck(0, InstanceForm.BCurrentDept.DeptId, cmbpyck.SelectedValue.ToString().Trim(), InstanceForm.BDatabase); if (tb.Rows.Count != 0) { lblbz.Text = "当前选择的配药窗口管理以下发药窗口: "; for (int i = 0; i <= tb.Rows.Count - 1; i++) { lblbz.Text = lblbz.Text + tb.Rows[i]["ckmc"].ToString().Trim() + " "; } } else { lblbz.Text = "当前选择的配药窗口没有设置对应的发药窗口: "; } }
private void Frmpyck_Load(object sender, EventArgs e) { DataTable tb = MZPY.Get_pyck("", "", InstanceForm.BDatabase); tb.TableName = "tab"; cmbpyck.DataSource = tb; cmbpyck.ValueMember = "CODE"; cmbpyck.DisplayMember = "NAME"; cmbpyck.Text = ""; string ssql = @"select '' 序号,c.name 配药机,a.NAME 窗口名称,a.bscbz 停用,a.id from jc_fyck a inner join jc_pfdyk b on a.code=b.fyckdm and a.yfdm=b.yfdm inner join jc_pyck c on b.pyckdm=c.code and b.yfdm=c.yfdm where a.yfdm=" + InstanceForm.BCurrentDept.DeptId + " "; DataTable tab = InstanceForm.BDatabase.GetDataTable(ssql); FunBase.AddRowtNo(tab); dataGridView1.DataSource = tab; }
/// <summary> /// 根据函数名称实例化窗体 /// </summary> public void InstanceWorkForm() { if (_functionName == "") { throw new Exception("引出函数名不能为空!"); } switch (_functionName) { case "Fun_ts_yf_mzpy": string add = TrasenClasses.GeneralClasses.PubStaticFun.GetMacAddress(); DataTable tb = MZPY.Get_pyck(add, "", InstanceForm.BDatabase); if (tb.Rows.Count == 0) { Frmpyck f = new Frmpyck(_menuTag, _chineseName, _mdiParent); f.ShowDialog(); } else { Frmmzpy Frmmzpy = null; Frmmzpy = new Frmmzpy(_menuTag, _chineseName, _mdiParent); Frmmzpy._Pyckh = tb.Rows[0]["CODE"].ToString().Trim(); MZPY.Update_pyck(add, Frmmzpy._Pyckh, 1, InstanceForm.BDatabase); if (_mdiParent != null) { Frmmzpy.MdiParent = _mdiParent; } Frmmzpy.Show(); } break; case "Fun_ts_yf_cfdy": Frmcfdy fm = new Frmcfdy(); fm.MdiParent = _mdiParent; fm.WindowState = FormWindowState.Maximized; //fm.Dock = DockStyle.Fill; fm.Show(); break; } }