/// <summary> /// 医生站传输 构造函数 /// </summary> /// <param name="menuTag"></param> /// <param name="chineseName">窗体text值</param> /// <param name="mdiParent"></param> /// <param name="_user">当前用户</param> /// <param name="yylx">预约类型</param> /// <param name="deptid">科室id</param> /// <param name="ysid">医生id</param> public Frm_OrderRegist(MenuTag menuTag, string chineseName, Form mdiParent, User _user, Mz_YYgh.YYgh_Sort yylx, int deptid, string cardno, string klx, RelationalDatabase db) { InitializeComponent(); if (db != null) { InstanceForm.BDatabase = db; } _menuTag = menuTag; _chineseName = chineseName; this.Text = _chineseName; _currentuser = _user; _CurrentYylx = yylx; _currentdeptid = deptid; cmb_sxw.SelectedIndex = 0; this.cmbghjb.Enabled = false; this.Lab_Doctor.Enable = false; this.Lab_Dept.Enable = false; this.cmb_sxw.Enabled = false; _orderMeans = new Order_Web(_cfg3059); _CurrentYylx = yylx; //添加卡类型 FunAddComboBox.AddKlx(false, 0, cmbklx, InstanceForm.BDatabase); if (!string.IsNullOrEmpty(cardno)) { this.cmbklx.SelectedValue = klx; this.txtkh.Text = cardno; this.txtkh.Enabled = false; this.cmbklx.Enabled = false; SetControls(cardno); } }
/// <summary> /// 释放预约资源 /// </summary> /// <param name="_cfg3059"></param> /// <param name="_DataBase"></param> public static void UpdateYyResource(SystemCfg _cfg3059, RelationalDatabase _DataBase) { /*释放指定时间段内还未取号的预约资源,如当前时间为8点 8点半的号还未进行取号 如果参数设置为 * 半个小时未取号就释放,则释放八点半的号源*/ string sql = @" SELECT convert(varchar(10),getdate(),120), convert(varchar(16),DATEADD(MINUTE,(SELECT CAST(CONFIG AS INT) FROM JC_CONFIG WHERE ID=1127),GETDATE()),120), SUBSTRING(convert(varchar(16),getdate(),120),11,16) "; DataTable dt_Date = _DataBase.GetDataTable(sql); string Date_Now = dt_Date.Rows[0][0].ToString(); string Time_Now = dt_Date.Rows[0][1].ToString(); string HourMinute = dt_Date.Rows[0][2].ToString(); sql = @"SELECT *,substring(YYSD,1,5) AS KSSJ ,substring(YYSD,7,5) as JSSJ FROM MZ_YYGHLB WHERE CONVERT(VARCHAR(10),YYRQ,120)='" + Date_Now + @"' AND substring('" + Time_Now + @"',12,len('" + Time_Now + @"')) >= substring(YYSD,7,5) AND BQHBZ=0 AND BSCBZ=0"; //获取需要释放资源的预约记录 DataTable dt_YYxx = _DataBase.GetDataTable(sql); Order_Web _orderMeans = new Order_Web(_cfg3059); for (int i = 0; i < dt_YYxx.Rows.Count; i++) { /*作废预约信息,但是要根据时间判断是否释放分时段信息,如果预约的分时段 * 结束时间小于当前时间则不需要释放 */ try { string ptid = Convertor.IsNull(dt_YYxx.Rows[i]["PTID"], ""); string qhyzm = dt_YYxx.Rows[i]["YZM"].ToString(); string czyh = dt_YYxx.Rows[i]["DJY"].ToString(); string msg = ""; _orderMeans.CancelOrder(ptid, qhyzm, czyh, ref msg); //撤销预约后,需要对分时段资源进行处理 //获取资源id int ghks = Convert.ToInt32(dt_YYxx.Rows[i]["GHKS"]); int ghjb = Convert.ToInt32(dt_YYxx.Rows[i]["GHJB"]); int ghys = Convert.ToInt32(dt_YYxx.Rows[i]["GHYS"]); string yydate = dt_YYxx.Rows[i]["YYRQ"].ToString(); VisitResource _Resource = new VisitResource(ghks, ghjb, ghys, yydate, _DataBase); if (_Resource.Resid <= 0) { return; } string kssj = dt_YYxx.Rows[i]["KSSJ"].ToString().Trim(); string jssj = dt_YYxx.Rows[i]["JSSJ"].ToString().Trim(); FsdClass.UpdateFsdStatus(_Resource.Resid, kssj, jssj, yydate, _DataBase); } catch (Exception ea) { throw ea; } } }
/// <summary> ///构造函数 /// </summary> /// <param name="menuTag"></param> /// <param name="chineseName"></param> /// <param name="mdiParent"></param> /// <param name="_user"></param> /// <param name="yylx">预约类型</param> public Frm_OrderRegist(MenuTag menuTag, string chineseName, Form mdiParent, User _user, Mz_YYgh.YYgh_Sort yylx) { InitializeComponent(); _menuTag = menuTag; _chineseName = chineseName; _mdiParent = mdiParent; this.Text = _chineseName; _currentuser = _user; _CurrentYylx = yylx; cmb_sxw.SelectedIndex = 0; _orderMeans = new Order_Web(_cfg3059); //添加卡类型 FunAddComboBox.AddKlx(false, 0, cmbklx, InstanceForm.BDatabase); }