private void FrmBussinessReportOfItem_Load(object sender, EventArgs e) { //FunAddComboBox.AddOperator(true, cmbuser); this.WindowState = FormWindowState.Maximized; dtpBjksj.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 00:00:00"); dtpEjksj.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 23:59:59"); SystemCfg cfg1054 = new SystemCfg(1054); string[] s = cfg1054.Config.ToString().Split(','); //cmbuser.SelectedValue = InstanceForm.BCurrentUser.EmployeeId.ToString(); //if (cmbuser.SelectedValue == null) cmbuser.SelectedValue = "0"; //if (cmbuser.SelectedValue.ToString() != InstanceForm.BCurrentUser.EmployeeId.ToString()) // this.cmbuser.SelectedValue = "0"; //FullCmbSfDept(); //FunAddComboBox.AddJgbm(true, cmbSource, InstanceForm.BDatabase); cmbSource.SelectedIndex = 0; cmbGroup.SelectedIndex = 0; cmbDepartMentType.SelectedIndex = 0; this.dataGridView1.Width = this.Width - 40; this.panel1.Left = this.Width - this.panel1.Width - 20; }
//private DataTable dt_time; public Order_Web(SystemCfg _cfg) { this.cfg = _cfg; SystemCfg cfg3063 = new SystemCfg(3063); Ts_Order = new Web_OrderClient(cfg3063.Config);; }
private void Frmxjsrtj_Load(object sender, EventArgs e) { FunAddComboBox.AddOperator(true, cmbuser, InstanceForm.BDatabase); this.WindowState = FormWindowState.Maximized; dtp1.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 00:00:00"); dtp2.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 23:59:59"); SystemCfg cfg1054 = new SystemCfg(1054); string[] s = cfg1054.Config.ToString().Split(','); if (s.Length == 2) { dtp1.Value = Convert.ToDateTime(dtp1.Value.AddDays(-1).ToShortDateString() + " " + s[0]); dtp2.Value = Convert.ToDateTime(dtp2.Value.ToShortDateString() + " " + s[1]); } FunAddComboBox.AddJgbm(true, cmbjgbm, InstanceForm.BDatabase); cmbjgbm.SelectedValue = TrasenFrame.Forms.FrmMdiMain.Jgbm; if (_menuTag.Function_Name == "Fun_ts_mz_tjbb_jk_pos") { label2.Text = "缴款日期"; } else { label2.Text = "收费日期"; } }
/// <summary> /// 医生站踢出队列 /// </summary> /// <param name="fzid">分诊id</param> /// <param name="_DataBase"></param> public static void DocUpdat_Hz(Guid fzid, SystemCfg _cfg3071, RelationalDatabase _DataBase) { /*通过参数3071判断是更新分诊记录表的接诊标志还是更新为现场病人 报到时间为当前最大值*/ string ssql = ""; if (_cfg3071.Config.Trim() == "1") //更新为现场挂号最后一位候诊记录 { //Modifi By zp 2013-07-05 ssql = @"SELECT TOP 1 ISNULL(A.PDSJ,DBO.FUN_GETDBTIME()) FROM MZHS_FZJL AS A INNER JOIN MZ_GHXX AS B ON A.GHXXID=B.GHXXID WHERE A.BSCBZ=0 AND A.BJZBZ=1 AND B.BQXGHBZ=0 AND B.YYLX=0 and convert(varchar(30),a.djsj,112) =convert(varchar(30),getdate(),112) ORDER BY A.PDSJ DESC"; long value = (Convert.ToInt64(_DataBase.GetDataResult(ssql))) + 1; ssql = @"UPDATE MZHS_FZJL SET BJZBZ=1,BZ='医生踢出队列',PDSJ=" + value + @" WHERE FZID='" + fzid + @"' AND BJZBZ = 2 "; } else { ssql = "update mzhs_fzjl set bjzbz=4 where fzid='" + fzid + "' and bjzbz in(1,2) "; } int i = _DataBase.DoCommand(ssql); if (i != 1) { throw new Exception("没有操作成功!,可能医生已接诊"); } }
private void FrmTurn_Load(object sender, System.EventArgs e) { loadData(); DateTime dt = DateManager.ServerDateTimeByDBType(FrmMdiMain.Database); this.dateTimePicker1.Value = dt; this.dateTimePicker1.MaxDate = dt.Date.AddDays(7); this.dateTimePicker1.MinDate = dt.Date.AddDays(-2); string cfg6031 = new SystemCfg(6031).Config; if (cfg6031 == "1") { dateTimePicker1.Enabled = true; //add by zouchihua 2012-02-14 转科医嘱必须大于除手术以为的医嘱的时间 try { string sql = "select * from zy_orderrecord where inpatient_id='" + this.BinID + "' and baby_id=0 and DELETE_BIT=0 and MNGTYPE in (0,1) and dept_id not in (SELECT DEPTID FROM SS_DEPT) order by ORDER_BDATE desc "; DataTable tb = InstanceForm._database.GetDataTable(sql); if (tb != null && tb.Rows.Count > 0) { this.dateTimePicker1.MinDate = Convert.ToDateTime(tb.Rows[0]["ORDER_BDATE"].ToString()).AddMinutes(1); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { dateTimePicker1.Enabled = false; } }
public FrmAddYpJg(int employee_id, int deptid, int cjid, RelationalDatabase DataBase) { InitializeComponent(); _cjid = cjid; _DataBase = DataBase; Ypcj cj = new Ypcj(cjid, DataBase); lblpm.Text = cj.S_YPPM; lblspm.Text = cj.S_YPSPM; lblgg.Text = cj.S_YPGG; txtsccj.Text = cj.S_SCCJ; txtsccj.Tag = cj.SCCJ; lbldw.Text = cj.S_YPDW; _employee_id = employee_id; _deptid = deptid; FillYP(cj.SCCJ, cj.GGID); SystemCfg cfg = new SystemCfg(8028); if (cfg.Config == "0") { txtpfj.Enabled = false; txtlsj.Enabled = false; txtsccj.Enabled = false; butsave.Enabled = false; } if (cfg.Config == "1") { txtsccj.Enabled = false; } }
/// <summary> /// 获取诊区的所有的诊室 /// </summary> /// <param name="zqid"></param> /// <param name="db"></param> /// <returns></returns> public DataTable GetZjList(int zqid, RelationalDatabase db) { string strSql = string.Empty; string strZq = new SystemCfg(3136).Config; strSql = string.Format(@"SELECT *, ISNULL(dbo.fun_getEmpName(ZZYS),'未坐诊') AS zzysname FROM dbo.JC_ZJSZ where ZQID = {0}", zqid); if (!string.IsNullOrEmpty(strZq)) { if (strZq == zqid.ToString()) { string strTemp = DateManager.ServerDateTimeByDBType(db).DayOfWeek.ToString(); string[] str3137 = new SystemCfg(3137).Config.Split(';'); string strZjList = ""; foreach (string str in str3137) { if (str.Contains(strTemp)) { strZjList = str.Split(':')[1]; } } strSql = string.Format(@"SELECT *, ISNULL(dbo.fun_getEmpName(ZZYS),'未坐诊') AS zzysname FROM dbo.JC_ZJSZ where ZQID = {0} and zjid in ({1})", zqid, strZjList); } } DataTable dt = db.GetDataTable(strSql); return(dt); }
private void Frmyjsq_Load(object sender, EventArgs e) { ts_mz_class.FunAddComboBox.AddJgbm(false, cmbjgbm, InstanceForm.BDatabase); //解决多院刷新报错问题 add by cc //ts_mz_class.Fun.FunAddComboBox.AddJgbm(false, cmbjgbm, InstanceForm.BDatabase); cmbjgbm.SelectedValue = InstanceForm._menuTag.Jgbm; cmbjgbm.SelectedIndexChanged += new EventHandler(cmbjgbm_SelectedIndexChanged); //end add //cmbjgbm.SelectedValue = InstanceForm._menuTag.Jgbm; TbOrderItem = select.SelectOrderItem(InstanceForm.BCurrentDept.DeptId, Convert.ToInt32(cmbjgbm.SelectedValue), InstanceForm.BDatabase); SystemCfg cfg10009 = new SystemCfg(10009); if (cfg10009.Config.Trim() != "") { string[] sArray = cfg10009.Config.ToString().Split(new char[1] { ',' }); for (int j = 0; j <= sArray.Length - 1; j++) { if (InstanceForm.BCurrentDept.DeptId.ToString() == Convertor.IsNull(sArray[j], "")) { btApplyAffirm.Enabled = false; } } } this.WindowState = FormWindowState.Maximized; }
private void Frmxtdz_Load(object sender, System.EventArgs e) { //初始化 FunBase.CsDataGrid(this.myDataGrid1, this.myDataGrid1.TableStyles[0], "Tb"); //初始化 FunBase.CsDataGrid(this.myDataGrid2, this.myDataGrid2.TableStyles[0], "Tb1"); SystemCfg cfg = new SystemCfg(8026); if (cfg.Config == "1") { butmodif.Enabled = true; } else { butmodif.Enabled = false; } int deptid = Convert.ToInt32(InstanceForm.BCurrentDept.DeptId); bpcgl = Yp.BPcgl(deptid, InstanceForm.BDatabase); if (!bpcgl) { col_批次号.Width = 0; col_批号.Width = 0; c批次号.Width = 0; c批号.Width = 0; c上期进货金额.Width = 0; c本期进货金额.Width = 0; c库存进货金额.Width = 0; c进货金额差值.Width = 0; } }
private void Frmsk_jktj_Load(object sender, EventArgs e) { FunAddComboBox.AddOperator(true, cmbuser, InstanceForm.BDatabase); this.WindowState = FormWindowState.Maximized; dtp1.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 00:00:00"); dtp2.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 23:59:59"); SystemCfg cfg1054 = new SystemCfg(1054); string[] s = cfg1054.Config.ToString().Split(','); if (s.Length == 2) { dtp1.Value = Convert.ToDateTime(dtp1.Value.AddDays(-1).ToShortDateString() + " " + s[0]); dtp2.Value = Convert.ToDateTime(dtp2.Value.ToShortDateString() + " " + s[1]); } cmbuser.SelectedValue = InstanceForm.BCurrentUser.EmployeeId.ToString(); if (cmbuser.SelectedValue == null) { cmbuser.SelectedValue = "0"; } if (cmbuser.SelectedValue.ToString() != InstanceForm.BCurrentUser.EmployeeId.ToString()) { this.cmbuser.SelectedValue = "0"; } FunAddComboBox.AddJgbm(true, cmbjgbm, InstanceForm.BDatabase); cmbjgbm.SelectedValue = TrasenFrame.Forms.FrmMdiMain.Jgbm; buttj_Click(sender, e); }
private void FrmZyMzJyCx_Load(object sender, EventArgs e) { CshMxGrid(this.myDataGrid1); CshHzGrid(this.myDataGrid2); SystemCfg sysrq = new SystemCfg(8019); this.dtprq1.Value = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).AddDays(Convert.ToInt32(sysrq.Config) * (-1)); this.dtprq2.Value = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase); this.chkrq.Checked = true; this.tabControl1.SelectedTab = this.tabPage1; //Modify by jchl try { DataTable dt = new DataTable(); dt.Columns.Add("id", typeof(string)); dt.Columns.Add("name", typeof(string)); dt.Rows.Add(new object[] { "-1", "全部" }); dt.Rows.Add(new object[] { "1", "住院" }); dt.Rows.Add(new object[] { "2", "门诊" }); Addcmb(cmbFylb, dt, "id", "name"); cmbFylb.SelectedIndex = 0; } catch { } }
public static void InitializationHLYY(string Employeeid, string dept_id, int Systemid, string mzh, int cs, string brxm, string xb, string csrq) { SystemCfg cfg3027 = new SystemCfg(3027);//挂号有效天数 if (cfg3027.Config == "1") { try { //0=用户 1=科室 2=模块 3=住院号 4=住院次数 5=病人姓名 6=性别 7=出生日期 8=体重 9=身高 10=出院日期 object[] _values = new object[11]; _values[0] = Employeeid; //用户 _values[1] = dept_id; //科室 _values[2] = Systemid; //系统str _values[3] = mzh; _values[4] = cs; //入院次数默认1 _values[5] = brxm; _values[6] = xb; _values[7] = Convert.ToDateTime(csrq).ToString("yyyy-MM-dd"); _values[8] = ""; _values[9] = ""; _values[10] = ""; string hlyytype = ApiFunction.GetIniString("hlyy", "name", System.Windows.Forms.Application.StartupPath + "\\Hlyy.ini"); Ts_Hlyy_Interface.HlyyInterface hl = Ts_Hlyy_Interface.HlyyFactory.Hlyy(hlyytype); hl.RegisterServer_fun(_values); hl.Refresh(); } catch (System.Exception err) { } } }
private void Frmjcsqd_Load(object sender, EventArgs e) { try { SystemCfg cg = new SystemCfg(3014); string ssql = @"select 0 选择,order_name 内容,c.name 执行科室,exec_dept ,a.order_id yzid from jc_hoitemdiction a,jc_hoi_dept b,jc_dept_property c where a.order_id=b.order_id and b.exec_dept=c.dept_id and c.jgbm=" + _menuTag.Jgbm + " and a.order_id in " + cg.Config + ""; DataTable tb = InstanceForm.BDatabase.GetDataTable(ssql); this.dataGridView2.DataSource = tb; if (tb.Rows.Count == 1) { tb.Rows[0]["选择"] = "1"; } lblxm.Text = Dqcf.brxm; lblxb.Text = Dqcf.xb; lblnl.Text = Dqcf.nl; lblgzdw.Text = Dqcf.gzdw; lbllxdh.Text = Dqcf.lxfs; lbltz.Text = Dqcf.tz; lblmzh.Text = Dqcf.mzh; } catch (System.Exception err) { MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Frmsk_jktj_Load(object sender, EventArgs e) { this.WindowState = FormWindowState.Maximized; dtp1.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 00:00:00"); dtp2.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 23:59:59"); dtpqrrq1.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 00:00:00"); dtpqrrq2.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 23:59:59"); SystemCfg cfg1054 = new SystemCfg(1054); string[] s = cfg1054.Config.ToString().Split(','); if (s.Length == 2) { dtp1.Value = Convert.ToDateTime(dtp1.Value.AddDays(-1).ToShortDateString() + " " + s[0]); dtp2.Value = Convert.ToDateTime(dtp2.Value.ToShortDateString() + " " + s[1]); dtpqrrq1.Value = Convert.ToDateTime(dtp1.Value.AddDays(-1).ToShortDateString() + " " + s[0]); dtpqrrq2.Value = Convert.ToDateTime(dtp2.Value.ToShortDateString() + " " + s[1]); } cmbFG.Items.Add("列宽适应网格内容"); cmbFG.Items.Add("列宽仅适应有数据的区域"); cmbFG.SelectedIndex = 0; FunAddComboBox.AddJgbm(true, cmbjgbm, InstanceForm.BDatabase); cmbjgbm.SelectedValue = TrasenFrame.Forms.FrmMdiMain.Jgbm; depttb = InstanceForm.BDatabase.GetDataTable("select DEPT_ID,NAME,PY_CODE,WB_CODE from JC_DEPT_PROPERTY where LAYER=3 and deleted=0"); }
public frmfy(string _order_id, string _orderexec_id, string _yjsqid, string _yjqrid, int _zxks, RelationalDatabase _db, int _jgbm) { _DataBase = _db; order_id = _order_id; yjsqid = _yjsqid; yjqrid = _yjqrid; orderexec_id = _orderexec_id; jgbm = _jgbm; myFunc = new BaseFunc(_DataBase); if (_orderexec_id == Guid.Empty.ToString()) { MessageBox.Show("医嘱执行ID不能为空"); btsave.Enabled = false; return; } InitializeComponent(); DialogResult = DialogResult.Yes; zxks = _zxks; Tbitem = Tbitem = select.SelectItem(zxks, _jgbm, _DataBase); SystemCfg s = new SystemCfg(10001, _DataBase); if (s.Config == "0") { btadd.Enabled = false; } if (new SystemCfg(10020).Config.ToString() == "1") { btcancel.Enabled = false; } }
private void Frmyssrtj_ByDate_Load(object sender, EventArgs e) { //FunAddComboBox.AddOperator(true, cmbuser); this.WindowState = FormWindowState.Maximized; dtp1.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 00:00:00"); dtp2.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 23:59:59"); SystemCfg cfg1054 = new SystemCfg(1054); string[] s = cfg1054.Config.ToString().Split(','); if (s.Length == 2) { dtp1.Value = Convert.ToDateTime(dtp1.Value.AddDays(-1).ToShortDateString() + " " + s[0]); dtp2.Value = Convert.ToDateTime(dtp2.Value.ToShortDateString() + " " + s[1]); } //cmbuser.SelectedValue = InstanceForm.BCurrentUser.EmployeeId.ToString(); //if (cmbuser.SelectedValue == null) cmbuser.SelectedValue = "0"; //if (cmbuser.SelectedValue.ToString() != InstanceForm.BCurrentUser.EmployeeId.ToString()) // this.cmbuser.SelectedValue = "0"; cmbFG.Items.Add("列宽适应网格内容"); cmbFG.Items.Add("列宽仅适应有数据的区域"); cmbFG.SelectedIndex = 0; FunAddComboBox.AddJgbm(true, cmbjgbm, InstanceForm.BDatabase); FunAddComboBox.AddDept(true, 1, cmbdept, InstanceForm.BDatabase); //Add By Zj 2012-08-01 cmbjgbm.SelectedValue = TrasenFrame.Forms.FrmMdiMain.Jgbm; FullCmbSfDept(); //add by zp 2013-05-24 this.list_datewhere.Add(this.dtp1); this.list_datewhere.Add(this.dtp2); }
private void Frmzzsq_Load(object sender, EventArgs e) { SystemCfg cfg = new SystemCfg(3022); if (cfg.Config == "2") { txttjys.Enabled = false; } }
public static DataTable GetItem(string mydept, string d_code) { SystemCfg cfg29378 = new SystemCfg(29378); string sql = ""; DataTable dt = new DataTable(); // sql = string.Format(@"SELECT DISTINCT A.ORDER_ID, A.ORDER_NAME, A.DEFAULT_DEPT,(select NAME from JC_DEPT_PROPERTY where JC_DEPT_PROPERTY.DEPT_ID=A.DEFAULT_DEPT) as DeptName,A.JCLXID,(select name from jc_jcclassdiction where jc_jcclassdiction.ID=A.JCLXID) // as JCLXNaMe, A.ORDER_UNIT, // A.DEFAULT_USAGE,LOWER(A.PY_CODE) PY_CODE,A.D_CODE,A.WB_CODE, A.BOOKING_BIT ,TCID,PRICE--, SEEKHOITEMPRICE(A.ORDER_ID) PRICE // FROM // ( // SELECT BB.ORDER_ID, 0 BOOKING_BIT, CASE WHEN (BZ IS NULL OR BZ='') THEN ORDER_NAME ELSE (ORDER_NAME) END ORDER_NAME, // isnull(CC.EXEC_DEPT,BB.DEFAULT_DEPT) AS DEFAULT_DEPT,AA.JCLXID as JCLXID, ORDER_UNIT,PY_CODE,DEFAULT_USAGE,D_CODE,WB_CODE,BB.PRICE // FROM (SELECT YZID,JCLXID // FROM JC_JC_ITEM WHERE JCLXID = '{0}' // ) AA, // (SELECT ORDER_ID, ORDER_NAME, DEFAULT_DEPT, ORDER_UNIT, PY_CODE,D_CODE,WB_CODE,BZ ,DEFAULT_USAGE,dbo.FUN_BASE_HOIPRICE(ORDER_ID) as PRICE // FROM JC_HOITEMDICTION WHERE DELETE_BIT = 0--WHERE DEFAULT_DEPT=@DEPTID // ) BB left join // JC_HOI_DEPT CC on BB.ORDER_ID=CC.ORDER_ID AND CC.EXEC_DEPT='{1}' // and dbo.fun_getFirstLevelDeptId(CC.EXEC_DEPT)=dbo.fun_getFirstLevelDeptId('{2}') --Modify By Tany 2015-06-05 // WHERE AA.YZID = BB.ORDER_ID // ) A join JC_HOI_hdi b on a.ORDER_ID=b.hoitem_ID ", itemclass,execdept,mydept); string[] deptarr_qx = cfg29378.Config.Split(','); bool qx_all = false; foreach (string i in deptarr_qx) { if (InstanceForm._currentDept.DeptId.ToString() == i.ToString()) { qx_all = true; } } if (!qx_all) { sql = string.Format(@"SELECT DISTINCT A.ORDER_ID, A.ORDER_NAME, A.DEFAULT_DEPT,(select NAME from JC_DEPT_PROPERTY where JC_DEPT_PROPERTY.DEPT_ID=A.DEFAULT_DEPT) as DeptName,'1' as JCLXID,'0' as JCLXNaMe, A.ORDER_UNIT, A.DEFAULT_USAGE,LOWER(A.PY_CODE) PY_CODE,A.D_CODE,A.WB_CODE, '0' as BOOKING_BIT ,'0' as TCID ,dbo.FUN_BASE_HOIPRICE(A.ORDER_ID) as PRICE --, SEEKHOITEMPRICE(A.ORDER_ID) PRICE from (select * from JC_HOITEMDICTION where DELETE_BIT=0) A inner join JC_YZQXMX t2 on A.ORDER_ID=t2.ORDER_ID left join jc_yzqx_ks t3 on t2.QXID=t3.QXID where A.ORDER_TYPE in ('4','5','6','7','8','9') and A.DELETE_BIT=0 and t3.DEPTID='{0}' and a.d_code like '%{1}%' order by ORDER_ID ", mydept, d_code); } else { sql = string.Format(@"SELECT top 10 A.ORDER_ID, A.ORDER_NAME, A.DEFAULT_DEPT,(select NAME from JC_DEPT_PROPERTY where JC_DEPT_PROPERTY.DEPT_ID=A.DEFAULT_DEPT) as DeptName,'1' as JCLXID,'0' as JCLXNaMe, A.ORDER_UNIT, A.DEFAULT_USAGE,LOWER(A.PY_CODE) PY_CODE,A.D_CODE,A.WB_CODE, '0' as BOOKING_BIT ,'0' as TCID ,dbo.FUN_BASE_HOIPRICE(A.ORDER_ID) as PRICE --, SEEKHOITEMPRICE(A.ORDER_ID) PRICE from JC_HOITEMDICTION A where A.DELETE_BIT=0 and A.ORDER_TYPE in ('4','5','6','7','8','9') and a.d_code like '%{1}%' order by ORDER_ID ", mydept, d_code); } dt = InstanceForm._database.GetDataTable(sql); return(dt); }
/// <summary> /// Add By zp 2014-06-14 /// </summary> /// <param name="Fz_Br"></param> /// <param name="_cfg3080"></param> /// <returns></returns> public static string GetShowLabString(MZHS_FZJL Fz_Br, SystemCfg _cfg3080, SystemCfg _cfg3117) { string result = ""; //Fz_Br.patName.Trim() + "(" + Fz_Br.roomName + ")" + Fz_Br.patGHZKName; string xsgs = _cfg3080.Config.Trim(); string[] par = xsgs.Split('+'); for (int i = 0; i < par.Length; i++) { //Add by zp 2014-11-05 if (par[i] == "候诊号") { result += "[" + Fz_Br.patdlxh + "]"; continue; } //End Add By zp 2014-10-30 if (par[i] == "姓名") { result += Fz_Br.patName.Trim(); continue; } if (par[i] == "科室") { result += " " + Fz_Br.patGHZKName.Trim(); continue; } if (par[i] == "时段" && (!string.IsNullOrEmpty(Fz_Br.Sjnc.Trim()))) { result += "(" + Fz_Br.Sjnc.Trim() + ")"; continue; } if (par[i] == "诊室" && (!string.IsNullOrEmpty(Fz_Br.roomName.Trim()))) { if (_cfg3117.Config.Trim() == "0") { result += "(" + Fz_Br.roomName.Trim() + ")"; } else { result += "(" + Fz_Br.patzjjc.Trim() + ")"; } continue; } //湘潭妇幼需求 Add by zp 2014-10-23 if (par[i] == "预约标识" && (!string.IsNullOrEmpty(Fz_Br.yysd.Trim()))) { result += " 预约"; } } if (string.IsNullOrEmpty(result)) { result = Fz_Br.patName.Trim() + "(" + Fz_Br.roomName + ")" + Fz_Br.patGHZKName; } return(result); }
private void FrmICBCRec_Load(object sender, EventArgs e) { SystemCfg cfg1054 = new SystemCfg(1054); string[] s = cfg1054.Config.ToString().Split(','); if (s.Length == 2) { StartTime.Value = Convert.ToDateTime(StartTime.Value.AddDays(-1).ToShortDateString() + " " + s[0]); EndTime.Value = Convert.ToDateTime(EndTime.Value.ToShortDateString() + " " + s[1]); } }
/// <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; } } }
private void Frmserch_Load(object sender, EventArgs e) { SystemCfg cfg5026 = new SystemCfg(5026); int leng = Int32.Parse(cfg5026.Config); for (int i = 0; i < leng; i++) { INpatient_no += "0"; } this.txtinpatientNo.InpatientNoLength = leng; zyh = INpatient_no; }
private void Frmsf_Load(object sender, EventArgs e) { #region 窗口输入项的控制 string ylzf = new SystemCfg(1012).Config == "0" ? "true" : "false"; txtpos.Enabled = ylzf == "true" ? true : false; //this.groupBox2.Visible = false; //this.Height = this.Height - 83; txtssxj.Focus(); //BindZffs();// #endregion }
void FrmLockScreen_Load(object sender, EventArgs e) { this.lblUserName.Text = currentUser.Name; try { SystemCfg cfg_unlocktime_15 = new SystemCfg(15); leftTime = Convert.ToInt32(cfg_unlocktime_15.Config); } catch { leftTime = 0; } LoadBackgroupPicture(); }
private void Frmyjjjk_Load(object sender, EventArgs e) { this.WindowState = FormWindowState.Maximized; dtpjsrq1.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 00:00:00"); dtpjsrq2.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 23:59:59"); FunAddComboBox.AddOperator(true, cmbsfy, InstanceForm.BDatabase); SystemCfg cfg1054 = new SystemCfg(1054); string[] s = cfg1054.Config.ToString().Split(','); if (s.Length == 2) { dtpjsrq1.Value = Convert.ToDateTime(dtpjsrq1.Value.AddDays(-1).ToShortDateString() + " " + s[0]); dtpjsrq2.Value = Convert.ToDateTime(dtpjsrq2.Value.ToShortDateString() + " " + s[1]); } }
private void Frmsk_jktj_Load(object sender, EventArgs e) { //FunAddComboBox.AddOperator(true, cmbuser); this.WindowState = FormWindowState.Maximized; dtp1.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 00:00:00"); dtp2.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 23:59:59"); SystemCfg cfg1054 = new SystemCfg(1054); string[] s = cfg1054.Config.ToString().Split(','); if (s.Length == 2) { dtp1.Value = Convert.ToDateTime(dtp1.Value.AddDays(-1).ToShortDateString() + " " + s[0]); dtp2.Value = Convert.ToDateTime(dtp2.Value.ToShortDateString() + " " + s[1]); } //cmbuser.SelectedValue = InstanceForm.BCurrentUser.EmployeeId.ToString(); //if (cmbuser.SelectedValue == null) cmbuser.SelectedValue = "0"; //if (cmbuser.SelectedValue.ToString() != InstanceForm.BCurrentUser.EmployeeId.ToString()) // this.cmbuser.SelectedValue = "0"; cmbFG.Items.Add("列宽适应网格内容"); cmbFG.Items.Add("列宽仅适应有数据的区域"); cmbFG.SelectedIndex = 0; FunAddComboBox.AddJgbm(true, cmbjgbm, InstanceForm.BDatabase); FunAddComboBox.AddDept(true, 1, cmbdept, InstanceForm.BDatabase); //Add By Zj 2012-08-01 cmbjgbm.SelectedValue = TrasenFrame.Forms.FrmMdiMain.Jgbm; FullCmbSfDept(); //add by zp 2013-05-24 //其他统计项目 deptb = InstanceForm.BDatabase.GetDataTable("SELECT CLASS_CODE AS ID,NAME FROM JC_DM_CLASS WHERE CLASS_CODE LIKE 'TJDXM%'"); if (deptb == null) { MessageBox.Show("错误,未能取得其他统计项目信息!", "提示"); } DataRow rowQt = deptb.NewRow(); rowQt["ID"] = -1; rowQt["NAME"] = ""; cmbQt.DataSource = deptb; cmbQt.DisplayMember = "NAME"; cmbQt.ValueMember = "ID"; cmbQt.SelectedValue = -1; rdJg.Checked = true; }
private void Frmsk_jktj_Load(object sender, EventArgs e) { FunAddComboBox.AddOperator(true, cmbuser, InstanceForm.BDatabase); this.WindowState = FormWindowState.Maximized; dtp1.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 00:00:00"); dtp2.Value = Convert.ToDateTime(DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 23:59:59"); SystemCfg cfg1054 = new SystemCfg(1054); string[] s = cfg1054.Config.ToString().Split(','); if (s.Length == 2) { dtp1.Value = Convert.ToDateTime(dtp1.Value.AddDays(-1).ToShortDateString() + " " + s[0]); dtp2.Value = Convert.ToDateTime(dtp2.Value.ToShortDateString() + " " + s[1]); } cmbuser.SelectedValue = InstanceForm.BCurrentUser.EmployeeId.ToString(); if (cmbuser.SelectedValue == null) { cmbuser.SelectedValue = "0"; } if (cmbuser.SelectedValue.ToString() != InstanceForm.BCurrentUser.EmployeeId.ToString()) { this.cmbuser.SelectedValue = "0"; } if (_menuTag.Function_Name == "Fun_ts_mz_tjbb_mzjk_xmsrtj") { lbluser.Text = "缴款员"; lblrq.Text = "缴款日期"; cmbyblx.Visible = false; label4.Visible = false; } FunAddComboBox.AddJgbm(true, cmbjgbm, InstanceForm.BDatabase); cmbjgbm.SelectedValue = TrasenFrame.Forms.FrmMdiMain.Jgbm; string ssql = "select '全部' name,'-1' code union all select '自费' name,'0' code union all select name,id from jc_yblx where delete_bit=0"; DataTable tb = InstanceForm.BDatabase.GetDataTable(ssql); cmbyblx.ValueMember = "CODE"; cmbyblx.DisplayMember = "NAME"; cmbyblx.DataSource = tb; }
private void Frm_YYPTSZ_Load(object sender, EventArgs e) { SystemCfg _cfg1150 = new SystemCfg(1150); if (string.IsNullOrEmpty(_cfg1150.Config)) { MessageBox.Show("未设置预约平台地址[1150]参数值,请设置1150参数值!", "提示"); return; } this.webBrowser1.Url = new Uri(_cfg1150.Config); Screen[] _screen = Screen.AllScreens; int width = _screen[0].WorkingArea.Width; int height = _screen[0].WorkingArea.Height; this.Width = width; this.Height = height; this.WindowState = FormWindowState.Maximized; }
/// <summary> /// 取消候诊 Modfi By zp 2013-06-18 /// </summary> /// <param name="fzid">分诊id</param> /// <param name="_DataBase"></param> public static void Delete_Hz(Guid fzid, SystemCfg _cfg3070, RelationalDatabase _DataBase) { string ssql = ""; if (_cfg3070.Config == "1") //如果是老的分诊系统(未采用分时段叫号) 则更新删除标记 { ssql = "update mzhs_fzjl set bscbz=1 where fzid='" + fzid + "' and bjzbz=0 "; } else //新分诊更新接诊标志 新分诊系统里 bjzbz=0:未分诊1:已分诊2:已呼叫 3:已接诊 4:踢出队列 5:已结束就诊 { ssql = "update mzhs_fzjl set bjzbz=4,pxxh=9999 where fzid='" + fzid + "' and bjzbz in(1,2) "; } int i = _DataBase.DoCommand(ssql); if (i != 1) { throw new Exception("没有取消成功,可能医生已接诊"); } }
//是否自动分配批号库存 public static bool BfpKcph(string ywlx, int deptid, RelationalDatabase db) { string t_kcmx = Yp.Seek_kcmx_table(Convert.ToInt32(deptid), db); string ssql = ""; bool temp = false; if (t_kcmx.Trim() == "yk_kcmx") { ssql = string.Format(" select ywfx from yk_ywlx where ywlx='{0}' ", ywlx); DataTable tb = new DataTable(); tb = db.GetDataTable(ssql); if (tb.Rows.Count > 0) { if (Convertor.IsNull(tb.Rows[0][0], "-") == "-") { temp = true; } } } if (t_kcmx.Trim() == "yf_kcmx") { ssql = string.Format(" select ywfx from yf_ywlx where ywlx='{0}' ", ywlx); DataTable tb = new DataTable(); tb = db.GetDataTable(ssql); if (tb.Rows.Count > 0) { if (Convertor.IsNull(tb.Rows[0][0], "-") == "-") { temp = true; } } } SystemCfg config8050 = new SystemCfg(8050); if (config8050.Config == "1" && temp) //启用自动分配批号库存 且 业务方向为出库 { return(true); } else { return(false); } }