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;
}
}
