/// <summary>
/// 作废预约
/// </summary>
private void DeleteOrder()
{
try
{
if (this.Dgv_OrderInfo.SelectedRows.Count < 1)
{
MessageBox.Show("请先选择需要删除的预约挂号记录", "提示");
return;
}
if (Convert.ToInt16(this.Dgv_OrderInfo.SelectedRows[0].Cells["Cl_bqhbz"].Value) == 1)
{
MessageBox.Show("当前预约记录已取号!无法进行删除操作!", "提示");
return;
}
if (Convert.ToInt32(this.Dgv_OrderInfo.SelectedRows[0].Cells["Cl_yylxid"].Value) != (int)_CurrentYylx)
{
MessageBox.Show("不能删除当前预约类型的预约记录!", "提示");
return;
}
Guid yyid = new Guid(this.Dgv_OrderInfo.SelectedRows[0].Cells["Cl_yyid"].Value.ToString());
string name = Convertor.IsNull(this.Dgv_OrderInfo.SelectedRows[0].Cells["Cl_Name"].Value, "");
if (_cfg1081.Config == "1") //平台注销
{
string msg = string.Empty;
string ptbh = Convertor.IsNull(this.Dgv_OrderInfo.SelectedRows[0].Cells["cl_ptid"].Value, "");
string qhpwd = Convertor.IsNull(this.Dgv_OrderInfo.SelectedRows[0].Cells["cl_yzm"].Value, "");
if (!_orderMeans.CancelOrder(ptbh, qhpwd, _cfg3060.Config.Trim(), ref msg))
{
MessageBox.Show("撤销预约失败!原因:" + msg, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
else
{
MessageBox.Show("删除成功!", "提示");
}
}
else
{
if (!Mz_YYgh.CanCelYYGH(yyid, name, InstanceForm.BDatabase))
{
MessageBox.Show("删除失败!", "提示");
}
else
{
MessageBox.Show("删除成功!", "提示");
}
}
}
catch (Exception ea)
{
MessageBox.Show("出现错误!原因:" + ea.ToString());
}
}
/// <summary>
/// 获取限号信息
/// </summary>
private void FullLabXh()
{
if (!IsSelect)
{
return;
}
if (_cfg1081.Config == "1")
{
return;
}
string memo = "";
int err_code = 0;
string err_text = "";
try
{
if (this.Lab_Dept.SelectedValue == null)
{
return;
}
if (this.Lab_Doctor.SelectedValue == null)
{
return;
}
if (this.cmbghjb.SelectedValue == null)
{
return;
}
int ksdm = Convert.ToInt32(this.Lab_Dept.SelectedValue);
int ysdm = Convert.ToInt32(this.Lab_Doctor.SelectedValue);
int level = Convert.ToInt32(this.cmbghjb.SelectedValue);
int sxw = cmb_sxw.Text.Trim() == "上午" ? 1 : 2;
Mz_YYgh.GetOrderXhInfo(ksdm, ysdm, level, 1, sxw, this.dateTimePicker1.Value.ToString(), out memo, out err_code, out err_text, InstanceForm.BDatabase);
this.lblxh.Text = memo.Trim();
if (err_code != 0)
{
this.lblxh.ForeColor = Color.Red;
}
else
{
this.lblxh.ForeColor = Color.Black;
}
}
catch (Exception ea)
{
MessageBox.Show("出现错误!原因:" + ea.ToString(), "错误");
}
}
/// <summary>
/// 绑定dgv
/// </summary>
private void BindDgv()
{
try
{
string cardno = this.txtkh.Text.Trim();
string sfzh = this.txt_Sfzh.Text.Trim();
int klx = -1;
if (!string.IsNullOrEmpty(cardno))
{
klx = Convert.ToInt32(this.cmbklx.SelectedValue);
}
int err_code;
string err_text;
DataTable dt = Mz_YYgh.GetYYghInfo("", sfzh, cardno, "", Mz_YYgh.YYgh_Status.未作废未取号记录, "", "", klx, 0, 0, Mz_YYgh.YYgh_Sort.所有预约方式, out err_code,
out err_text, InstanceForm.BDatabase);
this.Dgv_OrderInfo.DataSource = dt;
}
catch (Exception ea)
{
MessageBox.Show("出现错误!原因:" + ea.ToString(), "错误");
}
}
/// <summary>
/// 通过日期排班绑定医生级别 zp 2013-05-17
/// </summary>
private void FullDocLevel()
{
try
{
int pblx = this.cmb_sxw.Text == "上午" ? 1 : 2;
DataTable dt_level = Mz_YYgh.BindDocLevelByPb(this.dateTimePicker1.Value.ToString("yyyy-MM-dd"), Convert.ToInt32(_currentuser.EmployeeId),
pblx, _currentdeptid, InstanceForm.BDatabase);
cmbghjb.ValueMember = "ZZJBID";
cmbghjb.DisplayMember = "ZZJB";
cmbghjb.DataSource = dt_level;
//Add by zp 2014-11-14 如果有排班就赋值 否则SelectedValue为null
if (cmbghjb.DataSource != null && dt_level.Rows.Count > 0)
{
cmbghjb.SelectedValue = dt_level.Rows[0]["ZZJBID"];
}
}
catch (Exception ea)
{
MessageBox.Show("出现错误!原因:" + ea.ToString(), "错误");
}
}
private void butcx_Click(object sender, EventArgs e)
{
//Modify by zouchihua 2013-5-9 如果使用公司平台调用另外方式
if (new SystemCfg(3061).Config.Trim() == "0")
{
try
{
int err_code = -1;
string err_text = "";
DataTable tb = mz_ghxx.YYQH(txtsfzh.Text.Trim(), kh, brxm, txtyzm.Text, "", out err_code, out err_text, TrasenFrame.Forms.FrmMdiMain.Database);
dataGridView1.DataSource = tb;
if (tb.Rows.Count > 0)
{
if (txtkh.Enabled == true)
{
txtkh.Focus();
}
else
{
butok.Focus();
}
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
try
{
int err_code = -1;
string err_text = "";
int klx = -1;
if (!string.IsNullOrEmpty(this.txtkh.Text.Trim()))
{
kh = this.txtkh.Text.Trim();
klx = Convert.ToInt32(this.cmbklx.SelectedValue);
}
string bdate = DateManager.ServerDateTimeByDBType(TrasenFrame.Forms.FrmMdiMain.Database).ToString("yyyy-MM-dd");
//Modify by zp 2014-07-30
DataTable tb = Mz_YYgh.GetYYghInfo("", txtsfzh.Text.Trim(), kh, txtyzm.Text, Mz_YYgh.YYgh_Status.未取号记录, "", "", klx, out err_code, out err_text, TrasenFrame.Forms.FrmMdiMain.Database);
dataGridView1.DataSource = tb;
if (tb.Rows.Count > 0)
{
if (txtkh.Enabled == true)
{
txtkh.Focus();
}
else
{
butok.Focus();
}
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
/// <summary>
/// 保存预约挂号
/// </summary>
private void SaveOrder()
{
try
{
#region 常规验证
if (string.IsNullOrEmpty(this.txtkh.Text.Trim()))
{
MessageBox.Show("请输入卡号!", "提示");
return;
}
if (string.IsNullOrEmpty(this.txtxm.Text.Trim()))
{
MessageBox.Show("输入的卡号获取不到病人信息!请确定输入的卡号是否正确!");
return;
}
if (Lab_Dept.SelectedValue == null)
{
MessageBox.Show("预约科室不能为空!", "提示");
return;
}
if (Lab_Doctor.SelectedValue == null)
{
MessageBox.Show("预约医生不能为空!", "提示");
return;
}
string sex = this.cmb_sex.SelectedValue.ToString();
if (sex == "")
{
MessageBox.Show("当前病人信息异常,找不到性别代码!请联系管理员", "提示");
return;
}
int ghjb = Convert.ToInt32(Convertor.IsNull(cmbghjb.SelectedValue, "0"));
if (ghjb == 0)
{
MessageBox.Show("未选择挂号级别!", "提示");
return;
}
int ghys = Convert.ToInt32(Convertor.IsNull(this.Lab_Doctor.SelectedValue, "0"));
if (ghys == 0)
{
MessageBox.Show("未选择挂号医生!", "提示");
return;
}
if (string.IsNullOrEmpty(this.cmb_sxw.Text.Trim()))
{
MessageBox.Show("未选择上下午就诊时间", "提示");
return;
}
#endregion
#region 数据保存
Guid order_guid = Guid.Empty;//.NewGuid();
int yyqjd = this.cmb_sxw.Text.Trim() == "上午" ? 1 : 2;
string qhyzm = "";
if (this._cfg1081.Config.Trim() == "0")
{
qhyzm = Mz_YYgh.GetCheckNo(this.dateTimePicker1.Value.ToString("yyyy-MM-dd"), this.dateTimePicker1.Value.Date.AddDays(1).ToString("yyyy-MM-dd"), InstanceForm.BDatabase);
}
string new_dlxh = string.Empty;
string new_yzm = string.Empty;
Guid new_yyid = new Guid();
int err_code = 0;
string err_text = string.Empty;
decimal gh_fee = 0;
int ghks = Convert.ToInt32(this.Lab_Dept.SelectedValue);
string blb = cfgBlb.Config.Trim();
Guid yhlx = Guid.Empty;
string Memo = this.Txt_Bz.Text.Trim(); //备注信息 Add by zp 2014-09-25
DataSet dset = mz_ghxx.mzgh_get_sfmx(1, 0, 0, ghks, ghjb,
ghys, "", 0, 0, yhlx, TrasenFrame.Forms.FrmMdiMain.Jgbm, out err_code, out err_text, _menuTag.Function_Name, InstanceForm.BDatabase);
if (err_code != 0)
{
MessageBox.Show(err_text, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return;
}
//填写流水号,一张发票对应一个流水号
for (int iFp = 0; iFp < dset.Tables[0].Rows.Count; iFp++)
{
gh_fee = Convert.ToDecimal(dset.Tables[0].Compute("sum(zje)", "")); //计算结果集1表的总金额
}
if (this._cfg1081.Config == "0") //HIS方式
{
int klx = Convert.ToInt32(this.cmbklx.SelectedValue);
//InstanceForm.BDatabase.BeginTransaction();
try
{
string yysd = this.Cmb_Times.Text.Trim();
Mz_YYgh.YYGH_save(order_guid, _CurrentYylx, this.txtkh.Text.Trim(), this.txtxm.Text.Trim(), sex,
this.txt_csrq.Text.Trim(), this.txtjtdz.Text.Trim(), this.txtgrlxfs.Text.Trim(), this.txt_Sfzh.Text.Trim(),
qhyzm, ghks, ghjb, ghys, 0, DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToString(),
_currentuser.EmployeeId, this.dateTimePicker1.Value.ToString("yyyy-MM-dd 00:00:00"), yysd,
null, 0, yyqjd, 1, 0, gh_fee, klx, out new_yzm, "", out new_dlxh, out new_yyid, out err_code, out err_text,
InstanceForm.BDatabase, Memo);
if (err_code == 0)
{
// InstanceForm.BDatabase.CommitTransaction();
MessageBox.Show("预约登记成功!" + new_yzm, "提示");
}
else
{
//InstanceForm.BDatabase.RollbackTransaction();
MessageBox.Show("预约失败!原因:" + err_text, "提示");
}
}
catch (Exception ea)
{
//InstanceForm.BDatabase.RollbackTransaction();
MessageBox.Show("预约失败!原因:" + ea.Message, "提示");
}
}
else
{
string msg = string.Empty;
string orderid = string.Empty;
if (this.Cmb_Times.SelectedValue == null)
{
MessageBox.Show("必须选择时段!", "提示");
return;
}
string numid = this.Cmb_Times.SelectedValue.ToString();
int klxid = Convert.ToInt32(this.cmbklx.SelectedValue);
try
{
//性别从代码改成汉子 B/S组曾高贤这边要求 Modify by zp 2014-07-10
sex = sex.Trim() == "1" ? "男" : "女"; //只有男女
if (!this._orderMeans.SaveOrder(this.txtkh.Text.Trim(), this.txtxm.Text.Trim(), this.txt_Sfzh.Text.Trim(), sex,
this.txt_csrq.Text.Trim(), this.txtgrlxfs.Text.Trim(), this.txtjtdz.Text.Trim(), rowid, _cfg3060.Config.Trim(),
klxid, ref msg, ref new_yzm, ref orderid, ref numid, Memo)) //新增备注参数 Add by zp 2014-09-25
{
MessageBox.Show(msg, "提示", MessageBoxButtons.OK);
return;
}
else //Modify By zp 2014-03-28 更新成医生站预约
{
//Modify By zp 2014-07-15 更新预约平台id 统一由B/S的预约平台更新
MessageBox.Show("预约成功!取号时请出示诊疗卡或取号密码:" + "" + new_yzm + "" + "就诊", "提示", MessageBoxButtons.OK);
}
}
catch (Exception ea)
{
MessageBox.Show("出现错误!原因:" + ea.ToString(), "错误");
}
}
#endregion
}
catch (Exception ea)
{
MessageBox.Show("预约登记出现错误!原因:" + ea.ToString(), "错误");
}
}
private void BindYYGH()
{
try
{
string rq_begin = Dtp_Begin.Value.ToString("yyyy-MM-dd");
string rq_end = Dtp_End.Value.ToString("yyyy-MM-dd");
string kh = this.txtkh.Text.Trim();
string sfzh = this.Txt_Sfzh.Text.Trim();
string ysid = Convertor.IsNull(this.Lab_Doctor.SelectedValue, "0");
string ksid = Convertor.IsNull(this.Lab_Dept.SelectedValue, "0");
int klx = Convert.ToInt32(Convertor.IsNull(this.cmbklx.SelectedValue, "0"));
Mz_YYgh.YYgh_Status yystatus = new Mz_YYgh.YYgh_Status();
if (Rdo_Zt_All.Checked)
{
yystatus = Mz_YYgh.YYgh_Status.所有记录;
}
else if (Rdo_Zt_Wqh.Checked)
{
yystatus = Mz_YYgh.YYgh_Status.未作废未取号记录;
}
else if (Rdo_Zt_Wzf.Checked)
{
yystatus = Mz_YYgh.YYgh_Status.未作废记录;
}
else if (Rdo_Zt_Yqh.Checked)
{
yystatus = Mz_YYgh.YYgh_Status.未作废已取号记录;
}
else if (Rdo_Zt_Yzf.Checked)
{
yystatus = Mz_YYgh.YYgh_Status.已作废记录;
}
int err_code = 0;
string err_text = string.Empty;
#region 注释代码
/*
* DataTable dt_yyinfo = ts_mz_class.Mz_YYgh.GetYYghInfo("", sfzh, kh, "", yystatus, rq_begin, rq_end, klx, out err_code, out err_text, InstanceForm.BDatabase);
* //由于存储过程没有加预约类型条件所以此处在前台过滤
* DataRow[] drs = null;
* string yylx= Convertor.IsNull( this.Cmb_Type.SelectedValue,"0");
* DataTable dt_order = dt_yyinfo.Clone();
* string filter ="1=1";
* if (yylx != "0")
* {
* filter = "yylx=" + yylx + "";
* }
* //前台过滤科室
* if (ksid!="0")
* {
* filter += " AND GHKS=" + ksid + "";
* }
* //前台过滤医生
* if (ysid!="0")
* {
* filter += " AND GHYS=" + ysid + "";
* }
* if (filter != "1=1")
* {
* drs = dt_yyinfo.Select(filter);
* for (int i = 0; i < drs.Length; i++)
* dt_order.Rows.Add(drs[i].ItemArray);
* }
* else
* dt_order = dt_yyinfo.Copy();
*
* Fun.AddRowtNo(dt_order,"序号",true);
* this.Dgv_OrderInfo.DataSource = dt_order;
*/
#endregion
//存储过程里将条件去除 Modify By zp 2014-10-08
Mz_YYgh.YYgh_Sort _sort = new Mz_YYgh.YYgh_Sort();
switch (Convertor.IsNull(this.Cmb_Type.SelectedValue, "0"))
{
case "1":
_sort = Mz_YYgh.YYgh_Sort.院内预约;
break;
case "2":
_sort = Mz_YYgh.YYgh_Sort.网上预约;
break;
case "3":
_sort = Mz_YYgh.YYgh_Sort.电话预约;
break;
case "4":
_sort = Mz_YYgh.YYgh_Sort.医生站预约;
break;
default:
_sort = Mz_YYgh.YYgh_Sort.所有预约方式;
break;
}
int _ksid = int.Parse(ksid);
int _ysid = int.Parse(ysid);
DataTable dt_yyinfo = Mz_YYgh.GetYYghInfo("", sfzh, kh, "", yystatus, rq_begin, rq_end, klx, _ksid, _ysid, _sort, out err_code, out err_text, InstanceForm.BDatabase);
}
catch (Exception ea)
{
MessageBox.Show("获取预约信息出现异常!原因:" + ea.Message, "提示");
}
}
