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