public void m_mthInit()
{
m_objViewer.m_dtpSearchBeginDate.Text = clsPublic.SysDateTimeNow.AddMonths(-1).ToString("yyyy年MM月dd日 00时00分00秒");
this.m_objViewer.m_dtpSearchEndDate.Text = clsPublic.SysDateTimeNow.ToString("yyyy年MM月dd日 HH时mm分ss秒");
this.m_objViewer.dw.LibraryList = clsPublic.PBLPath;
this.m_objViewer.dw.DataWindowObject = "outstroage_summonery_3yuna";
this.m_objViewer.dw.PrintProperties.Preview = true;
this.m_objViewer.dw.PrintProperties.ShowPreviewRulers = true;
//this.m_objViewer.dw.InsertRow(0);
DataTable dtStorge;
long lngRes = objSvc.m_lngGetMedStroge(out dtStorge);
lngRes = objSvc.m_lngGetMedType(out dtMedType);
clsColumns_VO[] column3 = new clsColumns_VO[] { new clsColumns_VO("库房名称", "medicineroomname", HorizontalAlignment.Left, 145) };
this.m_objViewer.txtStoreroom.m_mthInitListView(column3);
this.m_objViewer.txtStoreroom.m_dtbDataSourse = dtStorge;
this.m_objViewer.txtStoreroom.m_mthFillData();
clsColumns_VO[] column2 = new clsColumns_VO[] { new clsColumns_VO("类别名称", "medicinetypename_vchr", HorizontalAlignment.Left, 145) };
this.m_objViewer.txtTypecode.m_mthInitListView(column2);
this.m_objViewer.txtTypecode.m_dtbDataSourse = dtMedType;
}
public void m_mthFillMedType()
{
//this.m_objViewer.txtTypecode.m_listView.Items.Clear();
clsDcl_OutStorageDetailReport2 objTmp = new clsDcl_OutStorageDetailReport2();
DataTable dtRoom;
DataTable dtVonder;
DataTable dtMedType;
long lngRes = objTmp.m_lngGetExptypeAndVendor(m_objViewer.m_blnForDrugStore, out dtRoom, out dtVonder, out dtMedType);
DataView dtvMedType = new DataView(dtMedType);
clsColumns_VO[] column2 = new clsColumns_VO[] { new clsColumns_VO("类别名称", "medicinetypename_vchr", HorizontalAlignment.Left, 145) };
this.m_objViewer.txtTypecode.m_mthInitListView(column2);
if (m_objViewer.m_blnForDrugStore)
{
dtvMedType.RowFilter = "medicineroomid='" + this.m_objViewer.m_strDeptID + "'";
}
else
{
dtvMedType.RowFilter = "medicineroomid='" + this.m_objViewer.m_strStorageID + "'";
}
DataTable dtValue = dtvMedType.ToTable();
DataRow drTmp = dtValue.NewRow();
drTmp["medicinetypeid_chr"] = "";
drTmp["medicinetypename_vchr"] = "全部";
drTmp["medicineroomid"] = "-1";
dtValue.BeginLoadData();
dtValue.Rows.Add(drTmp);
dtValue.EndLoadData();
this.m_objViewer.txtTypecode.m_dtbDataSourse = dtValue;
this.m_objViewer.txtTypecode.m_mthFillData();
}
public void m_mthGetSections()
{
clsColumns_VO[] columArr = new clsColumns_VO[] {
new clsColumns_VO("编号", "code_vchr", HorizontalAlignment.Left, 50),
new clsColumns_VO("拼音码", "pycode_chr", HorizontalAlignment.Left, 60),
new clsColumns_VO("科室名称", "deptname_vchr", HorizontalAlignment.Left, 130),
new clsColumns_VO("", "deptid_chr", HorizontalAlignment.Left, 0)
};
this.m_objViewer.m_txtSections.m_strSQL = @"select '%' deptid_chr,
'全院' deptname_vchr,
'qy' pycode_chr,
'00' code_vchr
from t_bse_deptdesc
where rownum = 1
union all
select a.deptid_chr, a.deptname_vchr, a.pycode_chr, a.code_vchr
from t_bse_deptdesc a
where a.attributeid = '0000003'
and a.status_int = 1
and a.category_int = 0
and a.inpatientoroutpatient_int = 1
order by code_vchr";
this.m_objViewer.m_txtSections.m_mthInitListView(columArr);
}
private void frmOrderBooking_Load(object sender, EventArgs e)
{
m_mthSetEnter2Tab(new System.Windows.Forms.Control[] { m_txtArea });
// 病区列表
clsColumns_VO[] columArr = new clsColumns_VO[] {
new clsColumns_VO("编号", "code_vchr", HorizontalAlignment.Left, 50),
new clsColumns_VO("拼音码", "pycode_chr", HorizontalAlignment.Left, 60),
new clsColumns_VO("病区名称", "deptname_vchr", HorizontalAlignment.Left, 130)
};
this.m_txtArea.m_strSQL = @"SELECT a.deptid_chr, a.deptname_vchr, a.pycode_chr, a.code_vchr
FROM t_bse_deptdesc a, T_BSE_DEPTEMP b
WHERE a.deptid_chr = b.deptid_chr and
a.attributeid = '0000003' AND a.status_int = 1
and b.EMPID_CHR = '" + this.LoginInfo.m_strEmpID + "' ORDER BY code_vchr";
this.m_txtArea.m_mthInitListView(columArr);
this.m_txtArea.Focus();
this.m_txtArea.SelectAll();
//设置默认病区
this.m_txtArea.Value = this.LoginInfo.m_strInpatientAreaID;
this.m_txtArea.Text = this.LoginInfo.m_strInpatientAreaName;
this.m_dtpBeginDate.Text = DateTime.Now.ToShortDateString() + " 00:00";
this.m_dtpEndDate.Text = DateTime.Now.ToShortDateString() + " 23:59";
this.m_cmbStatus.SelectedIndex = 0;
this.m_cmbPrintFlag.SelectedIndex = 1;
((clsOrderBooking)this.objController).m_mthInit();
m_cmdSearch_Click(sender, e);
}
private void frmRptOwnCastBill_Load(object sender, EventArgs e)
{
this.dwReport.LibraryList = clsPublic.PBLPath;
this.dwReport.DataWindowObject = "d_bill_owncastbill";
this.dwReport.PrintProperties.Preview = true;
this.dwReport.PrintProperties.ShowPreviewRulers = true;
this.dwReport.InsertRow(0);
clsColumns_VO[] columArr = new clsColumns_VO[] { new clsColumns_VO("流水号", "registerid_chr", HorizontalAlignment.Left, 120),
new clsColumns_VO("入院时间", "inpatient_dat", HorizontalAlignment.Left, 80),
new clsColumns_VO("状态", "status", HorizontalAlignment.Left, 70) };
this.txtRegisterID.m_mthInitListView(columArr);
this.txtRegisterID.m_listView.Font = new System.Drawing.Font("宋体", 11.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.txtRegisterID.m_dtbDataSourse = null;
ArrayList tmplist = clsPublic.m_ArrGettoken(clsPublic.m_strGetSysparm("0045"), ";");
foreach (Object obj in tmplist)
{
strTypeList += "'" + obj.ToString() + "',";
}
strTypeList = strTypeList.TrimEnd(',');
this.cobSelect.SelectedIndex = 0;
}
/// <summary>
/// 动态加载执行地点
/// </summary>
/// <param name="Flag">1 全部科室 2 项目执行分类所对应的科室列表</param>
/// <param name="ItemID"></param>
public void m_mthLoadExecArea(int Flag, string ItemID)
{
string SqlSource = "";
clsColumns_VO[] columArr = new clsColumns_VO[] { new clsColumns_VO("编号", "code_vchr", HorizontalAlignment.Left, 50),
new clsColumns_VO("拼音码", "pycode_chr", HorizontalAlignment.Left, 60),
new clsColumns_VO("地点名称", "deptname_vchr", HorizontalAlignment.Left, 130),
new clsColumns_VO("", "deptid_chr", HorizontalAlignment.Left, 0) };
if (Flag == 1)
{
SqlSource = @"select deptid_chr, deptname_vchr, pycode_chr, code_vchr
from t_bse_deptdesc
where status_int = 1
order by code_vchr";
}
else if (Flag == 2)
{
SqlSource = @"select a.deptid_chr, a.deptname_vchr, a.pycode_chr, a.code_vchr
from t_bse_deptdesc a,
t_aid_bih_ocdeptlist b,
t_bse_chargeitem c
where a.status_int = 1
and a.deptid_chr = b.clacarea_chr
and b.ordercateid_chr = c.ordercateid_chr
and c.itemid_chr = '" + ItemID + @"'
order by a.code_vchr";
}
this.txtExecArea.m_strSQL = SqlSource;
this.txtExecArea.m_mthInitListView(columArr);
this.txtExecArea.m_listView.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
}
internal void m_mthInitialType()
{
DataTable dtRoom;
DataTable dtRoomToid = new DataTable();
DataTable dtVonder;
DataTable dtMedType;
m_objDomain.m_lngGetExptypeAndVendor(true, out dtRoom, out dtVonder, out dtMedType);
dtvMedType = new DataView(dtMedType);
clsColumns_VO[] column2 = new clsColumns_VO[] { new clsColumns_VO("类别名称", "medicinetypename_vchr", HorizontalAlignment.Left, 145) };
this.m_objViewer.txtTypecode.m_mthInitListView(column2);
this.m_objViewer.txtTypecode.m_dtbDataSourse = null;
string m_strDeptID = string.Empty;
if (m_objViewer.m_strStorageid != "0000")
{
m_objDomain.m_lngGetDeptIDForStore(m_objViewer.m_strStorageid, out m_strDeptID);
if (dtRoom.Rows.Count > 0)
{
dtRoomToid = dtRoom.Clone();
DataRow dr = null;
int iRowCount = dtRoom.Rows.Count;
dtRoomToid.BeginLoadData();
for (int j = 0; j < iRowCount; j++)
{
dr = dtRoom.Rows[j];
if (m_strDeptID == dr["medicineroomid"].ToString().Trim())
{
dtRoomToid.LoadDataRow(dr.ItemArray, true);
}
}
dtRoomToid.EndLoadData();
dtRoomToid.AcceptChanges();
}
}
this.m_objViewer.txtTypecode.m_listView.Items.Clear();
this.dtvMedType.RowFilter = "medicineroomid='" + m_strDeptID + "'";
DataTable dtValue = dtvMedType.ToTable();
DataRow drTmp = dtValue.NewRow();
drTmp["medicinetypeid_chr"] = "";
drTmp["medicinetypename_vchr"] = "全部";
drTmp["medicineroomid"] = "-1";
dtValue.BeginLoadData();
dtValue.Rows.Add(drTmp);
dtValue.EndLoadData();
this.m_objViewer.txtTypecode.m_dtbDataSourse = dtValue;
this.m_objViewer.txtTypecode.m_mthFillData();
}
public void m_mthInit()
{
this.m_objViewer.dw.LibraryList = clsPublic.PBLPath;
this.m_objViewer.dw.DataWindowObject = "ms_gowaystat";
this.m_objViewer.dw.InsertRow(0);
DataTable dtMedType;
long lngRes = m_objDomain.m_lngGetMedicineType(out dtMedType);
this.dtvMedType = new DataView(dtMedType);
clsColumns_VO[] column2 = new clsColumns_VO[] { new clsColumns_VO("类别名称", "medicinetypename_vchr", HorizontalAlignment.Left, 145) };
this.m_objViewer.txtTypecode.m_mthInitListView(column2);
this.m_objViewer.txtTypecode.m_dtbDataSourse = null;
}
/// <summary>
/// 加载控件数据
/// </summary>
/// <returns></returns>
private long m_lngLoadDataCtl()
{
try
{
// 病区列表
clsColumns_VO[] columArr = new clsColumns_VO[] {
new clsColumns_VO("编号", "code_vchr", HorizontalAlignment.Left, 50),
new clsColumns_VO("拼音码", "pycode_chr", HorizontalAlignment.Left, 60),
new clsColumns_VO("病区名称", "deptname_vchr", HorizontalAlignment.Left, 130)
};
m_objViewer.txtDept.m_strSQL = @"select deptid_chr, deptname_vchr, pycode_chr, code_vchr
from t_bse_deptdesc t1
where attributeid = '0000003' and status_int = 1
order by code_vchr";
m_objViewer.txtDept.m_mthInitListView(columArr);
//获取床位列表
columArr = new clsColumns_VO[] {
new clsColumns_VO("科室ID", "areaid_chr", HorizontalAlignment.Left, 0),
new clsColumns_VO("床位ID", "bedid_chr", HorizontalAlignment.Left, 0),
new clsColumns_VO("床位号", "code_chr", HorizontalAlignment.Left, 60)
};
m_objViewer.txtBedno.m_strSQL = @"select areaid_chr,bedid_chr,code_chr from t_bse_bed where status_int=1 and areaid_chr='0000209' order by bedid_chr,bed_no";
m_objViewer.txtBedno.m_mthInitListView(columArr);
//获取主治医生列表
columArr = new clsColumns_VO[] {
new clsColumns_VO("工号", "empno_chr", HorizontalAlignment.Left, 50),
new clsColumns_VO("拼音码", "pycode_chr", HorizontalAlignment.Left, 60),
new clsColumns_VO("姓名", "doctorname", HorizontalAlignment.Left, 80),
};
m_objViewer.txtDoctor.m_strSQL = @"select distinct t1.empid_chr,
t2.empno_chr,
t2.pycode_chr,
t2.lastname_vchr as doctorname
from t_bse_deptemp t1, t_bse_employee t2
where t2.hasprescriptionright_chr = 1
and t2.status_int = 1
and t1.empid_chr = t2.empid_chr
order by t2.empno_chr";
m_objViewer.txtDoctor.m_mthInitListView(columArr);
}
catch (Exception)
{
return(-1);
}
return(1);
}
/// <summary>
/// 初始化
/// </summary>
public void m_mthInit()
{
//初始化主管医生
//医生列表
clsColumns_VO[] columArr = new clsColumns_VO[] { new clsColumns_VO("工号", "empno_chr", HorizontalAlignment.Left, 50),
new clsColumns_VO("拼音码", "pycode_chr", HorizontalAlignment.Left, 60),
new clsColumns_VO("姓名", "doctorname", HorizontalAlignment.Left, 80),
new clsColumns_VO("", "empid_chr", HorizontalAlignment.Left, 0) };
string SqlSource = @"select empid_chr, empno_chr, pycode_chr, lastname_vchr as doctorname
from t_bse_employee
where status_int = 1
order by empno_chr";
//and hasprescriptionright_chr = '1' 具有处方权限
this.txtChargeDoctor.m_strSQL = SqlSource;
this.txtChargeDoctor.m_mthInitListView(columArr);
this.txtChargeDoctor.m_listView.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
//初始化执行地点
//地点列表
columArr = new clsColumns_VO[] { new clsColumns_VO("编号", "code_vchr", HorizontalAlignment.Left, 50),
new clsColumns_VO("拼音码", "pycode_chr", HorizontalAlignment.Left, 60),
new clsColumns_VO("地点名称", "deptname_vchr", HorizontalAlignment.Left, 130),
new clsColumns_VO("", "deptid_chr", HorizontalAlignment.Left, 0) };
SqlSource = @"select deptid_chr, deptname_vchr, pycode_chr, code_vchr
from t_bse_deptdesc
where status_int = 1
order by code_vchr";
this.txtApplyArea.m_strSQL = SqlSource;
this.txtApplyArea.m_mthInitListView(columArr);
this.txtApplyArea.m_listView.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
//填充默认开单科室、开单人
this.txtApplyArea.m_mthFindAndSelect(this.LoginInfo.m_strInpatientAreaID);
this.txtChargeDoctor.m_mthFindAndSelect(this.LoginInfo.m_strEmpID);
this.m_mthGetCat();
this.m_mthGetDeptList();
}
internal void m_FillCboPatientType()
{
clsColumns_VO[] columArr = new clsColumns_VO[] {
new clsColumns_VO("编号", "PAYTYPENO_VCHR", HorizontalAlignment.Left, 50),
new clsColumns_VO("名称", "PAYTYPENAME_VCHR", HorizontalAlignment.Left, 130)
};
this.m_objViewer.m_txtProtectType.m_strSQL = @"
select '0000' PAYTYPEID_CHR,'00' PAYTYPENO_VCHR,'全部' PAYTYPENAME_VCHR from dual
union all
select t.PAYTYPEID_CHR, t.PAYTYPENO_VCHR, t.PAYTYPENAME_VCHR
from t_bse_patientpaytype t
where t.ISUSING_NUM = 1 and
(t.PAYFLAG_DEC = 0 or t.PAYFLAG_DEC = 2)
ORDER BY PAYTYPENO_VCHR";
this.m_objViewer.m_txtProtectType.m_mthInitListView(columArr);
}
private void frmRptPatientSum_Load(object sender, EventArgs e)
{
#region 两层事务处理，稍后改回三层。
string ServerName = "";
string UserID = "";
string Pwd = "";
clsPublic.m_mthGetICareParm(out ServerName, out UserID, out Pwd);
pbTrans = new Transaction();
pbTrans.Dbms = Sybase.DataWindow.DbmsType.Oracle9i;
pbTrans.ServerName = ServerName;
pbTrans.UserId = UserID;
pbTrans.Password = Pwd;
pbTrans.AutoCommit = true;
pbTrans.Connect();
#endregion
#region 初始化病区
// 病区列表
clsColumns_VO[] columArr = new clsColumns_VO[] { new clsColumns_VO("编号", "code_vchr", HorizontalAlignment.Left, 50),
new clsColumns_VO("拼音码", "pycode_chr", HorizontalAlignment.Left, 60),
new clsColumns_VO("病区名称", "deptname_vchr", HorizontalAlignment.Left, 130) };
this.txtAREAID.m_strSQL = @"select '00' as deptid_chr,
'全院科室' as deptname_vchr,
'qy' as pycode_chr,
'00' as code_vchr
from dual
union all
select a.deptid_chr, a.deptname_vchr, a.pycode_chr, a.code_vchr
from t_bse_deptdesc a
where a.status_int = 1
and a.attributeid = '0000003'";
this.txtAREAID.m_mthInitListView(columArr);
this.txtAREAID.m_listView.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
#endregion
this.dwRep.LibraryList = clsPublic.PBLPath;
this.dwRep.DataWindowObject = "d_bih_patientsum";
this.dwRep.Modify("t_title.text = '" + this.objReport.HospitalName + "住院病人阶段费用一览表'");
}
private void frmRptDeptWorkLog_Detail_Load(object sender, EventArgs e)
{
this.dwRep.LibraryList = clsPublic.PBLPath;
this.dwRep.DataWindowObject = "d_bih_deptworklog_det";
this.dwRep.Modify("t_title.text = '" + this.objReport.HospitalName + this.dwRep.Describe("t_title.text") + "'");
this.dwRep.PrintProperties.ShowPreviewRulers = true;
YBPayTypeIDArr = clsPublic.m_ArrGettoken(clsPublic.m_strGetSysparm("0008"), ";");
// 病区列表
clsColumns_VO[] columArr = new clsColumns_VO[] { new clsColumns_VO("编号", "code_vchr", HorizontalAlignment.Left, 50),
new clsColumns_VO("拼音码", "pycode_chr", HorizontalAlignment.Left, 60),
new clsColumns_VO("病区名称", "deptname_vchr", HorizontalAlignment.Left, 130) };
this.txtAREAID.m_strSQL = @"select a.deptid_chr, a.deptname_vchr, a.pycode_chr, a.code_vchr
from t_bse_deptdesc a
where a.status_int = 1
and a.attributeid = '0000003'";
this.txtAREAID.m_mthInitListView(columArr);
this.txtAREAID.m_listView.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
}
/// <summary>
/// 药品类型绑定
/// </summary>
public void m_mthGetMedType()
{
DataTable dtMedType;
long lngRes = m_objDomain.m_lngGetMedicineType(out dtMedType);
this.dtvMedType = new DataView(dtMedType);
clsColumns_VO[] column2 = new clsColumns_VO[] { new clsColumns_VO("类别名称", "medicinetypename_vchr", HorizontalAlignment.Left, 145) };
this.m_objViewer.txtMedType.m_mthInitListView(column2);
this.m_objViewer.txtMedType.m_dtbDataSourse = null;
this.m_objViewer.txtMedType.m_listView.Items.Clear();
DataTable dtValue = dtvMedType.ToTable();
DataRow drTmp = dtValue.NewRow();
drTmp["medicinetypeid_chr"] = "";
drTmp["medicinetypename_vchr"] = "全部";
dtValue.BeginLoadData();
dtValue.Rows.Add(drTmp);
dtValue.EndLoadData();
this.m_objViewer.txtMedType.m_dtbDataSourse = dtValue;
this.m_objViewer.txtMedType.m_mthFillData();
}
private void frmAidEditItem_Load(object sender, EventArgs e)
{
clsColumns_VO[] columArr = new clsColumns_VO[] { new clsColumns_VO("编号", "code_vchr", HorizontalAlignment.Left, 50),
new clsColumns_VO("拼音码", "pycode_chr", HorizontalAlignment.Left, 60),
new clsColumns_VO("地点名称", "deptname_vchr", HorizontalAlignment.Left, 130),
new clsColumns_VO("", "deptid_chr", HorizontalAlignment.Left, 0) };
string SqlSource = @"select deptid_chr, deptname_vchr, pycode_chr, code_vchr
from t_bse_deptdesc
where status_int = 1
order by code_vchr";
this.txtExecArea.m_strSQL = SqlSource;
this.txtExecArea.m_mthInitListView(columArr);
this.txtExecArea.m_listView.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.txtExecArea.Value = Item_VO.DeptID;
this.txtExecArea.Text = Item_VO.DeptName;
this.lblItemCode.Text = Item_VO.ItemCode;
this.lblItemName.Text = Item_VO.ItemName;
this.txtAmount.Text = Item_VO.ItemAmout.ToString();
}
private void frmOrderBookingRe_Load(object sender, EventArgs e)
{
m_mthSetEnter2Tab(new System.Windows.Forms.Control[] { m_txtApplyType });
// 检查类型列表
clsColumns_VO[] columArr = new clsColumns_VO[] {
new clsColumns_VO("检查类型", "TYPETEXT", HorizontalAlignment.Left, 150)
};
this.m_txtApplyType.m_strSQL = @"SELECT 0 TYPEID, '全部' TYPETEXT, 0 ORDERSEQ_INT
FROM ar_apply_typelist
WHERE rownum = 1
union all
SELECT * from (SELECT distinct a.TYPEID, a.TYPETEXT,a.ORDERSEQ_INT
FROM ar_apply_typelist a,
T_OPR_CHECKDEPT_ROLE b,
T_Sys_EmpRoleMap c
WHERE a.TYPEID = b.APPLY_TYPE_INT and
b.ROLEID_CHR = c.ROLEID_CHR and
a.DELETED = 0 and
c.EmpID_Chr='" + this.LoginInfo.m_strEmpID
+ @"') ORDER BY ORDERSEQ_INT";
this.m_txtApplyType.m_mthInitListView(columArr);
this.m_txtApplyType.Text = "全部";
this.m_txtApplyType.Value = "0";
this.m_dtpBeginDate.Text = DateTime.Now.ToShortDateString() + " 00:00";
this.m_dtpEndDate.Text = DateTime.Now.ToShortDateString() + " 23:59";
this.m_cmbStatus.SelectedIndex = 1;
this.dw_seach.LibraryList = clsPublic.PBLPath;
this.dw_seach.DataWindowObject = "d_orderbooking_list";
m_cmdSearch_Click(sender, e);
}
/// <summary>
/// 初始化数据
/// </summary>
public void m_mthInit()
{
// 获取病区列表
// clsListViewColumns_VO[] m_objColumnsArr = new clsListViewColumns_VO[2]{
// new clsListViewColumns_VO("拼音码","pycode_chr",HorizontalAlignment.Left,80),
// new clsListViewColumns_VO("名称","deptname_vchr",HorizontalAlignment.Left,120)
// };
// m_objViewer.m_txtListArea.m_mthInitListView(m_objColumnsArr);
// m_objViewer.m_txtListArea.m_strSQL = @"SELECT deptid_chr, deptname_vchr, shortno_chr, pycode_chr, code_vchr
// FROM t_bse_deptdesc t1
// WHERE attributeid = '0000003'
// AND status_int = 1
// AND deptid_chr <> '" + m_objViewer.m_strAreaID + @"'
//ORDER BY code_vchr";
// 病区列表
clsColumns_VO[] columArr = new clsColumns_VO[] {
new clsColumns_VO("编号", "code_vchr", HorizontalAlignment.Left, 50),
new clsColumns_VO("拼音码", "pycode_chr", HorizontalAlignment.Left, 60),
new clsColumns_VO("病区名称", "deptname_vchr", HorizontalAlignment.Left, 130)
};
this.m_objViewer.m_txtListArea.m_strSQL = @"SELECT deptid_chr, deptname_vchr, shortno_chr, pycode_chr, code_vchr
FROM t_bse_deptdesc t1
WHERE attributeid = '0000003'
AND status_int = 1
AND deptid_chr <> '" + m_objViewer.m_strAreaID + @"'
ORDER BY code_vchr";
m_objViewer.m_txtListArea.m_mthInitListView(columArr);
//m_objViewer.m_txtListArea.m_mthGetData();
m_strOperatorID = m_objViewer.LoginInfo.m_strEmpID;
m_objViewer.m_cobPrint.SelectedIndex = 0;
}
private void m_ckbBedNo_CheckedChanged(object sender, EventArgs e)
{
this.m_txtBedNo.Enabled = this.m_ckbBedNo.Checked;
if (this.m_ckbBedNo.Checked == true)
{
//床位列表
clsColumns_VO[] columArr = new clsColumns_VO[] {
new clsColumns_VO("床号", "code_chr", HorizontalAlignment.Left, 50),
new clsColumns_VO("姓名", "lastname_vchr", HorizontalAlignment.Left, 80),
new clsColumns_VO("性别", "sex_chr", HorizontalAlignment.Left, 50)
};
this.m_txtBedNo.m_strSQL = @"SELECT a.bedid_chr,a.code_chr,a.areaid_chr,b.lastname_vchr,b.sex_chr
FROM t_bse_bed a,t_opr_bih_registerdetail b,t_opr_bih_register c
where a.bihregisterid_chr = c.registerid_chr
and b.registerid_chr = c.registerid_chr
AND (c.pstatus_int = 1 or c.PSTATUS_INT=2)
AND c.areaid_chr= '" + this.m_txtArea.Value + @"'
AND (a.status_int = 2 or a.status_int = 6)
order by a.code_chr";
this.m_txtBedNo.m_mthInitListView(columArr);
}
}
public void m_mthInit()
{
this.m_objViewer.dw.LibraryList = clsPublic.PBLPath;
this.m_objViewer.dw.DataWindowObject = "outstorage_detailreport_3yuan";
//this.m_objViewer.dw.PrintProperties.Preview = true;
//this.m_objViewer.dw.PrintProperties.ShowPreviewRulers = true;
this.m_objViewer.dw.InsertRow(0);
DataTable dtEmp;
DataTable dtEmpToid = new DataTable();
DataTable dtVonder;
DataTable dtMedType;
long lngRes = objSvc.m_lngGetExptypeAndVendor(m_objViewer.m_blnForDrugStore, out dtEmp, out dtVonder, out dtMedType);
if (m_objViewer.m_strRoomidArr.Length > 0)
{
if (dtEmp.Rows.Count > 0)
{
dtEmpToid = dtEmp.Clone();
DataRow dr = null;
int iRowCount = dtEmp.Rows.Count;
int iLength = m_objViewer.m_strRoomidArr.Length;
dtEmpToid.BeginLoadData();
for (int i = 0; i < iLength; i++)
{
for (int j = 0; j < iRowCount; j++)
{
dr = dtEmp.Rows[j];
if (m_objViewer.m_strRoomidArr[i].ToString().Trim() == dr["medicineroomid"].ToString().Trim())
{
dtEmpToid.LoadDataRow(dr.ItemArray, true);
}
}
}
dtEmpToid.EndLoadData();
dtEmpToid.AcceptChanges();
}
}
clsColumns_VO[] column2 = new clsColumns_VO[] { new clsColumns_VO("类别名称", "medicinetypename_vchr", HorizontalAlignment.Left, 145) };
this.m_objViewer.txtTypecode.m_mthInitListView(column2);
this.m_objViewer.txtTypecode.m_dtbDataSourse = dtMedType;
clsColumns_VO[] column3 = new clsColumns_VO[] { new clsColumns_VO("库房名称", "medicineroomname", HorizontalAlignment.Left, 145) };
this.m_objViewer.txtStoreroom.m_mthInitListView(column3);
if (m_objViewer.m_strRoomidArr.Length > 0)
{
this.m_objViewer.txtStoreroom.m_dtbDataSourse = dtEmpToid;
}
else
{
this.m_objViewer.txtStoreroom.m_dtbDataSourse = dtEmp;
}
this.m_objViewer.txtStoreroom.m_mthFillData();
if (m_objViewer.m_strRoomidArr.Length > 0)
{
DataRow drRoom = null;
int iCount = dtEmp.Rows.Count;
for (int iRow = 0; iRow < iCount; iRow++)
{
drRoom = dtEmp.Rows[iRow];
if (m_objViewer.m_strRoomidArr[0].ToString().Trim() == drRoom["medicineroomid"].ToString().Trim())
{
this.m_objViewer.txtStoreroom.Text = drRoom["medicineroomname"].ToString().Trim();
this.m_objViewer.txtStoreroom.Value = drRoom["medicineroomid"].ToString().Trim();
break;
}
}
}
else
{
this.m_objViewer.txtStoreroom.Text = dtEmp.Rows[0]["medicineroomname"].ToString().Trim();
this.m_objViewer.txtStoreroom.Value = dtEmp.Rows[0]["medicineroomid"].ToString().Trim();
}
this.dtvMedType = new DataView(dtMedType);
this.m_objViewer.m_dtProduct = dtVonder;
m_mthGetImpExpTypeInfo();
}
private void frmRptEveryDayBill_Load(object sender, EventArgs e)
{
// 病区列表
clsColumns_VO[] columArr = new clsColumns_VO[] { new clsColumns_VO("编号", "code_vchr", HorizontalAlignment.Left, 50),
new clsColumns_VO("拼音码", "pycode_chr", HorizontalAlignment.Left, 60),
new clsColumns_VO("病区名称", "deptname_vchr", HorizontalAlignment.Left, 130) };
if (Scope == "%")
{
this.m_txtAREAID.m_strSQL = @" select '00' as deptid_chr,
'全院' as deptname_vchr,
'qy' as pycode_chr,
'00' as code_vchr
from dual
union all
select a.deptid_chr, a.deptname_vchr, a.pycode_chr, a.code_vchr
from t_bse_deptdesc a
where a.status_int = 1
and a.attributeid = '0000003'";
}
else
{
this.m_txtAREAID.m_strSQL = @"select a.deptid_chr, a.deptname_vchr, a.pycode_chr, a.code_vchr
from t_bse_deptdesc a,
t_bse_deptemp b
where a.deptid_chr = b.deptid_chr
and a.status_int = 1
and a.attributeid = '0000003'
and b.empid_chr = '" + this.LoginInfo.m_strEmpID + @"'
order by a.code_vchr";
}
this.m_txtAREAID.m_mthInitListView(columArr);
this.m_txtAREAID.Value = this.LoginInfo.m_strInpatientAreaID;
this.m_txtAREAID.Text = this.LoginInfo.m_strInpatientAreaName;
this.lsvBed.Tag = objReport.m_dtGetBed(this.LoginInfo.m_strInpatientAreaID);
this.m_txtAREAID.SelectAll();
TimeSpan ts = new TimeSpan(1, 0, 0, 0);
this.dteRq.Value = DateTime.Now.Subtract(ts);
this.rdoArea.Checked = true;
this.lsvBed.Enabled = false;
//默认按分类 2008-02-21 yunjie.xie 修改
//if (clsPublic.m_strGetSysparm("1000") == "001")
//{
// this.cboType.SelectedIndex = 0;
// this.cboType.Enabled = false;
//}
//else
//{
// this.cboType.SelectedIndex = 1;
//}
this.cboType.SelectedIndex = 1;
//获取项目代码使用类型
ItemCodeType = clsPublic.m_intGetSysParm("9008");
intDiffCostOn = clsPublic.m_intGetSysParm("9002");
if (intDiffCostOn == 1)
{
this.dwRep.DataWindowObject = "d_everydaybill_diff";
}
else
{
this.dwRep.DataWindowObject = "d_everydaybill";
}
}
/// <summary>
/// 载入科室
/// </summary>
public void LoadAreaID()
{
dtbResult1 = new DataTable();
m_objBedAdmin.m_lngGetsickArea(out dtbResult1);
// clsListViewColumns_VO[] m_objColumnsArr = new clsListViewColumns_VO[]{
// new clsListViewColumns_VO("编号","code_vchr",HorizontalAlignment.Left,50),
// new clsListViewColumns_VO("拼音码","pycode_chr",HorizontalAlignment.Left,60),
// new clsListViewColumns_VO("名称","deptname_vchr",HorizontalAlignment.Left,70)
// };
// m_objViewer.m_txtAREAID_CHR.m_mthInitListView(m_objColumnsArr);
// m_objViewer.m_txtAREAID_CHR.m_strSQL = @"SELECT '0' AS deptid_chr, '全院' AS deptname_vchr, 'QY' AS pycode_chr,
// '0' AS code_vchr
// FROM DUAL
//UNION ALL
//SELECT deptid_chr, deptname_vchr, pycode_chr, code_vchr
// FROM t_bse_deptdesc t1
// WHERE TRIM (attributeid) = '0000003' AND status_int = 1
//ORDER BY code_vchr";
// //AND t1.deptid_chr IN (" +strAreaID+@")";
// m_objViewer.m_txtAREAID_CHR.m_mthGetData();
// m_objViewer.m_txtAREAID_CHR.Tag = "0";
// m_objViewer.m_txtAREAID_CHR.m_listView.Items[0].SubItems[1].Text = "";
// m_objViewer.m_txtAREAID_CHR.Text = "全院";
// 病区列表
clsColumns_VO[] columArr = new clsColumns_VO[] {
new clsColumns_VO("编号", "code_vchr", HorizontalAlignment.Left, 50),
new clsColumns_VO("病区名称", "deptname_vchr", HorizontalAlignment.Left, 130)
};
if (this.m_objViewer.m_bolAllArea == true)
{
this.m_objViewer.m_txtAREAID_CHR.m_strSQL = @"select '0' deptid_chr, '全院' deptname_vchr, 'qy' pycode_chr, '00' code_vchr
from t_bse_deptdesc
where rownum = 1
union all
select a.deptid_chr, a.deptname_vchr, a.pycode_chr, a.code_vchr
from t_bse_deptdesc a
where
a.attributeid = '0000003' and a.status_int = 1
order by code_vchr";
this.m_objViewer.m_txtAREAID_CHR.m_mthInitListView(columArr);
this.m_objViewer.m_txtAREAID_CHR.Focus();
this.m_objViewer.m_txtAREAID_CHR.SelectAll();
//设置默认病区
this.m_objViewer.m_txtAREAID_CHR.Value = "0";
this.m_objViewer.m_txtAREAID_CHR.Text = "全院";
}
else
{
this.m_objViewer.m_txtAREAID_CHR.m_strSQL = @"SELECT a.deptid_chr, a.deptname_vchr, a.pycode_chr, a.code_vchr
FROM t_bse_deptdesc a, T_BSE_DEPTEMP b
WHERE a.deptid_chr = b.deptid_chr and
a.attributeid = '0000003' AND a.status_int = 1
and b.EMPID_CHR = '" + this.m_objViewer.LoginInfo.m_strEmpID + "' ORDER BY code_vchr";
this.m_objViewer.m_txtAREAID_CHR.m_mthInitListView(columArr);
this.m_objViewer.m_txtAREAID_CHR.Focus();
this.m_objViewer.m_txtAREAID_CHR.SelectAll();
//设置默认病区
this.m_objViewer.m_txtAREAID_CHR.Value = this.m_objViewer.LoginInfo.m_strInpatientAreaID;
this.m_objViewer.m_txtAREAID_CHR.Text = this.m_objViewer.LoginInfo.m_strInpatientAreaName;
}
}
public frmOrderBookingAdvSearch()
{
InitializeComponent();
m_mthSetEnter2Tab(new System.Windows.Forms.Control[] { m_txtArea, m_txtBedNo, m_txtApplyType });
// 病区列表
clsColumns_VO[] columArr = new clsColumns_VO[] {
new clsColumns_VO("编号", "code_vchr", HorizontalAlignment.Left, 50),
new clsColumns_VO("拼音码", "pycode_chr", HorizontalAlignment.Left, 60),
new clsColumns_VO("病区名称", "deptname_vchr", HorizontalAlignment.Left, 130)
};
this.m_txtArea.m_strSQL = @"SELECT a.deptid_chr, a.deptname_vchr, a.pycode_chr, a.code_vchr
FROM t_bse_deptdesc a
WHERE a.attributeid = '0000003' AND a.status_int = 1
ORDER BY code_vchr";
this.m_txtArea.m_mthInitListView(columArr);
//设置默认病区
this.m_txtArea.Value = this.LoginInfo.m_strInpatientAreaID;
this.m_txtArea.Text = this.LoginInfo.m_strInpatientAreaName;
//床位列表
// columArr = new clsColumns_VO[]{
// new clsColumns_VO("床号","code_chr",HorizontalAlignment.Left,50),
// new clsColumns_VO("姓名","lastname_vchr",HorizontalAlignment.Left,100),
// new clsColumns_VO("性别","sex_chr",HorizontalAlignment.Left,50)
// };
// this.m_txtBedNo.m_strSQL = @"SELECT a.bedid_chr,a.code_chr,a.areaid_chr,b.lastname_vchr,b.sex_chr
// FROM t_bse_bed a,t_opr_bih_registerdetail b,t_opr_bih_register c
// where a.bihregisterid_chr = c.registerid_chr
// and b.registerid_chr = c.registerid_chr
// AND (c.pstatus_int = 1 or c.PSTATUS_INT=2)
// AND c.areaid_chr= '" + this.m_txtArea.Value + @"'
// AND (a.status_int = 2 or a.status_int = 6)
// order by a.code_chr";
// this.m_txtBedNo.m_mthInitListView(columArr);
// 检查类型列表
columArr = new clsColumns_VO[] {
new clsColumns_VO("检查类型", "TYPETEXT", HorizontalAlignment.Left, 150)
};
this.m_txtApplyType.m_strSQL = @"SELECT 0 TYPEID, '全部' TYPETEXT, 0 ORDERSEQ_INT
FROM ar_apply_typelist
WHERE rownum = 1
union all
SELECT * from (SELECT distinct a.TYPEID, a.TYPETEXT,a.ORDERSEQ_INT
FROM ar_apply_typelist a,
T_OPR_CHECKDEPT_ROLE b,
T_Sys_EmpRoleMap c
WHERE a.TYPEID = b.APPLY_TYPE_INT and
b.ROLEID_CHR = c.ROLEID_CHR and
a.DELETED = 0 and
c.EmpID_Chr='" + this.LoginInfo.m_strEmpID
+ @"') ORDER BY ORDERSEQ_INT";
this.m_txtApplyType.m_mthInitListView(columArr);
this.m_txtApplyType.Text = "全部";
this.m_txtApplyType.Value = "0";
this.m_dtpOprBgnDate.Text = DateTime.Now.ToShortDateString() + " 00:00";
this.m_dtpOprEndDate.Text = DateTime.Now.ToShortDateString() + " 23:59";
this.m_dtpBookBgnDate.Text = DateTime.Now.ToShortDateString() + " 00:00";
this.m_dtpBookEndDate.Text = DateTime.Now.ToShortDateString() + " 23:59";
this.m_cmbStatus.SelectedIndex = 1;
}
/// <summary>
/// 初始化数据
/// </summary>
public void m_mthInit()
{
//系统参数设置
int sysSet = 0;
this.m_objManage.m_lngGetSetingByID("1056", out sysSet);
#region 获取主治医生列表
clsColumns_VO[] columArr = new clsColumns_VO[]
{
new clsColumns_VO("工号", "empno_chr", HorizontalAlignment.Left, 50),
new clsColumns_VO("拼音码", "pycode_chr", HorizontalAlignment.Left, 60),
new clsColumns_VO("姓名", "doctorname", HorizontalAlignment.Left, 80)
};
if (sysSet == 1)
{
m_objViewer.m_txtMaindoctor.m_strSQL = @"SELECT t3.empid_chr, t3.empno_chr, t3.pycode_chr, t3.doctorname, t4.flag
FROM (SELECT t1.empid_chr, t1.empno_chr, t1.pycode_chr,
t1.lastname_vchr AS doctorname, 1 AS flag
FROM t_bse_employee t1
WHERE status_int = 1 AND hasprescriptionright_chr = 1) t3,
(SELECT DISTINCT t1.empid_chr, t2.empno_chr, t2.pycode_chr,
t2.lastname_vchr AS doctorname, 0 AS flag
FROM t_bse_deptemp t1, t_bse_employee t2
WHERE ( t1.deptid_chr = '" + m_objViewer.m_strAreaID + @"'
OR t1.deptid_chr = '0000001'
)
AND t2.hasprescriptionright_chr = 1
AND t2.status_int = 1
AND t1.empid_chr = t2.empid_chr) t4
WHERE t3.empid_chr = t4.empid_chr(+)
ORDER BY flag, empno_chr";
}
else
{
m_objViewer.m_txtMaindoctor.m_strSQL = @"SELECT DISTINCT t1.empid_chr, t2.empno_chr, t2.pycode_chr,
t2.lastname_vchr AS doctorname, 0 AS flag
FROM t_bse_deptemp t1, t_bse_employee t2
WHERE ( t1.deptid_chr = '" + m_objViewer.m_strAreaID + @"'
OR t1.deptid_chr = '0000001'
)
AND t2.hasprescriptionright_chr = 1
AND t2.status_int = 1
AND t1.empid_chr = t2.empid_chr
ORDER BY flag, t2.empno_chr";
}
m_objViewer.m_txtMaindoctor.m_mthInitListView(columArr);
for (int i1 = 0; i1 < m_objViewer.m_txtMaindoctor.m_listView.Items.Count; i1++)
{
DataRowView drv = (DataRowView)m_objViewer.m_txtMaindoctor.m_listView.Items[i1].Tag;
if (drv["flag"].ToString().Trim() == "")
{
if (m_objViewer.m_txtMaindoctor.m_listView.Items[i1].ForeColor == System.Drawing.SystemColors.WindowText)
{
m_objViewer.m_txtMaindoctor.m_listView.Items[i1].ForeColor = System.Drawing.Color.Red;
}
}
}
#endregion
#region 获取饮食列表
columArr = new clsColumns_VO[]
{
new clsColumns_VO("编码", "USERCODE_CHR", HorizontalAlignment.Left, 50),
new clsColumns_VO("项目名称", "NAME_CHR", HorizontalAlignment.Left, 150),
new clsColumns_VO("拼音码", "PYCODE_CHR", HorizontalAlignment.Left, 80)
};
m_objViewer.m_txtEat.m_strSQL = @"SELECT a.ORDERDICID_CHR, a.USERCODE_CHR, a.NAME_CHR, a.PYCODE_CHR from t_bse_bih_orderdic a, T_BSE_BIH_SPECORDERCATE b
WHERE a.ordercateid_chr = b.EATDICCATE
ORDER BY a.USERCODE_CHR";
m_objViewer.m_txtEat.m_mthInitListView(columArr);
#endregion
#region 获取护理列表
columArr = new clsColumns_VO[]
{
new clsColumns_VO("编码", "USERCODE_CHR", HorizontalAlignment.Left, 50),
new clsColumns_VO("项目名称", "NAME_CHR", HorizontalAlignment.Left, 100),
new clsColumns_VO("拼音码", "PYCODE_CHR", HorizontalAlignment.Left, 80)
};
m_objViewer.m_txtNurse.m_strSQL = @"SELECT a.ORDERDICID_CHR, a.USERCODE_CHR, a.NAME_CHR, a.PYCODE_CHR from t_bse_bih_orderdic a, T_BSE_BIH_SPECORDERCATE b
WHERE a.ordercateid_chr = b.NURSECATE
ORDER BY a.USERCODE_CHR";
m_objViewer.m_txtNurse.m_mthInitListView(columArr);
#endregion
m_mthGetTurnInNotAccept();
m_mthGetEmptyBed();
//没置默认选中的病人
if (m_objViewer.m_strRegisterID != "")
{
for (int i1 = 0; i1 < m_objViewer.m_lsvPatientInfo.Items.Count; i1++)
{
if (m_objViewer.m_lsvPatientInfo.Items[i1].Tag.ToString().Trim().Equals(m_objViewer.m_strRegisterID))
{
m_objViewer.m_lsvPatientInfo.Items[i1].Selected = true;
break;
}
}
try
{
string state = GetPatientStateByRegId(m_objViewer.m_strRegisterID);
this.m_objViewer.m_cboSTATE_INT.SelectedIndex = Convert.ToInt16(state);
}
catch
{
this.m_objViewer.m_cboSTATE_INT.SelectedIndex = 3;
}
}
else if (m_objViewer.m_lsvPatientInfo.Items.Count > 0)
{
m_objViewer.m_lsvPatientInfo.Items[0].Selected = true;
}
//设置默认选中的床位
if (m_objViewer.m_strBedID != "")
{
this.m_objViewer.m_cmbBed.SelectedValue = m_objViewer.m_strBedID;
}
//入病区时间默认为当前时间
//m_objViewer.m_inAreaDate.Text = DateTime.Now.ToString("yyyy年MM月dd日HH时mm分");
//读取系统配置
string setting = clsSysSetting.GetSettingByID("1043");
if (setting != "1")
{
this.m_objViewer.m_txtEat.Enabled = false;
this.m_objViewer.m_txtNurse.Enabled = false;
}
}
private void frmDemandPayment_Load(object sender, EventArgs e)
{
this.dw_1.LibraryList = clsPublic.PBLPath;
this.dw_1.DataWindowObject = "d_demandpayment";
this.dwEveryDayBill.LibraryList = clsPublic.PBLPath;
//this.dwEveryDayBill.DataWindowObject = "d_everydaybill";
this.dwEveryDayBill.DataWindowObject = "d_bih_everydaybill_entry2";
// 病区列表
clsColumns_VO[] columArr = new clsColumns_VO[] {
new clsColumns_VO("编号", "code_vchr", HorizontalAlignment.Left, 50),
new clsColumns_VO("拼音码", "pycode_chr", HorizontalAlignment.Left, 60),
new clsColumns_VO("病区名称", "deptname_vchr", HorizontalAlignment.Left, 130)
};
this.m_txtArea.m_strSQL = @"SELECT a.deptid_chr, a.deptname_vchr, a.pycode_chr, a.code_vchr
FROM t_bse_deptdesc a, T_BSE_DEPTEMP b
WHERE a.deptid_chr = b.deptid_chr and
a.attributeid = '0000003' AND a.status_int = 1
and b.EMPID_CHR = '" + this.LoginInfo.m_strEmpID + "' ORDER BY code_vchr";
if (this.m_bolAllArea == true)
{
this.m_txtArea.m_strSQL = @"SELECT '%' deptid_chr, '全院' deptname_vchr, 'qy' pycode_chr, '00' code_vchr
FROM t_bse_deptdesc
WHERE rownum = 1
union all
SELECT a.deptid_chr, a.deptname_vchr, a.pycode_chr, a.code_vchr
FROM t_bse_deptdesc a
WHERE
a.attributeid = '0000003' AND a.status_int = 1
ORDER BY code_vchr";
}
this.m_txtArea.m_mthInitListView(columArr);
this.m_txtArea.Focus();
this.m_txtArea.SelectAll();
//设置默认病区
this.m_txtArea.Value = this.LoginInfo.m_strInpatientAreaID;
this.m_txtArea.Text = this.LoginInfo.m_strInpatientAreaName;
this.m_cmbStatus.SelectedIndex = 0;
TimeSpan ts = new TimeSpan(1, 0, 0, 0);
this.m_dtpDate.Value = DateTime.Now.Subtract(ts);
if (this.m_blnInHospitalFlag)
{
this.Text = "催款查询-【在院病人】";
}
else
{
this.Text = "催款查询-【出院病人】";
this.lblCysj.Visible = true;
this.lblToDate.Visible = true;
this.dteBeginDate.Visible = true;
this.dteEndDate.Visible = true;
this.dteBeginDate.Value = DateTime.Now;
this.dteEndDate.Value = DateTime.Now;
}
}
/// <summary>
/// 初始化数据
/// </summary>
public void m_mthInit()
{
//系统参数设置
int sysSet = 0;
this.m_objManage.m_lngGetSetingByID("1056", out sysSet);
#region 获取主治医生列表
clsColumns_VO[] columArr = new clsColumns_VO[]
{
new clsColumns_VO("工号", "empno_chr", HorizontalAlignment.Left, 50),
new clsColumns_VO("拼音码", "pycode_chr", HorizontalAlignment.Left, 60),
new clsColumns_VO("姓名", "doctorname", HorizontalAlignment.Left, 80)
};
if (sysSet == 1)
{
m_objViewer.m_txtMaindoctor.m_strSQL = @"SELECT t3.empid_chr, t3.empno_chr, t3.pycode_chr, t3.doctorname, t4.flag
FROM (SELECT t1.empid_chr, t1.empno_chr, t1.pycode_chr,
t1.lastname_vchr AS doctorname, 1 AS flag
FROM t_bse_employee t1
WHERE status_int = 1 AND hasprescriptionright_chr = 1) t3,
(SELECT DISTINCT t1.empid_chr, t2.empno_chr, t2.pycode_chr,
t2.lastname_vchr AS doctorname, 0 AS flag
FROM t_bse_deptemp t1, t_bse_employee t2
WHERE ( t1.deptid_chr = '" + this.m_strAreaID + @"'
OR t1.deptid_chr = '0000001'
)
AND t2.hasprescriptionright_chr = 1
AND t2.status_int = 1
AND t1.empid_chr = t2.empid_chr) t4
WHERE t3.empid_chr = t4.empid_chr(+)
ORDER BY flag, empno_chr";
}
else
{
m_objViewer.m_txtMaindoctor.m_strSQL = @"SELECT DISTINCT t1.empid_chr, t2.empno_chr, t2.pycode_chr,
t2.lastname_vchr AS doctorname, 0 AS flag
FROM t_bse_deptemp t1, t_bse_employee t2
WHERE ( t1.deptid_chr = '" + this.m_strAreaID + @"'
OR t1.deptid_chr = '0000001'
)
AND t2.hasprescriptionright_chr = 1
AND t2.status_int = 1
AND t1.empid_chr = t2.empid_chr
ORDER BY flag, t2.empno_chr";
}
m_objViewer.m_txtMaindoctor.m_mthInitListView(columArr);
for (int i1 = 0; i1 < m_objViewer.m_txtMaindoctor.m_listView.Items.Count; i1++)
{
DataRowView drv = (DataRowView)m_objViewer.m_txtMaindoctor.m_listView.Items[i1].Tag;
if (drv["flag"].ToString().Trim() == "")
{
if (m_objViewer.m_txtMaindoctor.m_listView.Items[i1].ForeColor == System.Drawing.SystemColors.WindowText)
{
m_objViewer.m_txtMaindoctor.m_listView.Items[i1].ForeColor = System.Drawing.Color.Red;
}
}
}
#endregion
#region 医保诊断
clsColumns_VO[] columArr2 = new clsColumns_VO[]
{
new clsColumns_VO("编号", "dmcode", HorizontalAlignment.Left, 60),
new clsColumns_VO("诊断名称(医保)", "zhsm", HorizontalAlignment.Left, 180),
};
//m_objViewer.m_txtDIAGNOSE.m_mthInitListView(lsvCloumnArr);
m_objViewer.m_txtDIAGNOSE.m_strSQL = @"SELECT zdfl || dmzh dmcode, zhsm
FROM ybgd05 a, ybgd04 b
WHERE a.zdfl = b.dmlb";
//m_objViewer.m_txtDIAGNOSE.m_mthGetData();
//m_objViewer.m_txtDIAGNOSE.m_strFindFieldsArr = new string[2] { "dmcode", "zhsm" };
m_objViewer.m_txtDIAGNOSE.m_mthInitListView(columArr2);
#endregion
#region 获取饮食列表
columArr = new clsColumns_VO[]
{
new clsColumns_VO("编码", "USERCODE_CHR", HorizontalAlignment.Left, 50),
new clsColumns_VO("项目名称", "NAME_CHR", HorizontalAlignment.Left, 150),
new clsColumns_VO("拼音码", "PYCODE_CHR", HorizontalAlignment.Left, 0)
};
m_objViewer.m_txtEat.m_strSQL = @"SELECT a.ORDERDICID_CHR, a.USERCODE_CHR, a.NAME_CHR, a.PYCODE_CHR from t_bse_bih_orderdic a, T_BSE_BIH_SPECORDERCATE b
WHERE a.ordercateid_chr = b.EATDICCATE
ORDER BY a.USERCODE_CHR";
m_objViewer.m_txtEat.m_mthInitListView(columArr);
#endregion
#region 获取护理列表
columArr = new clsColumns_VO[]
{
new clsColumns_VO("编码", "USERCODE_CHR", HorizontalAlignment.Left, 50),
new clsColumns_VO("项目名称", "NAME_CHR", HorizontalAlignment.Left, 100),
new clsColumns_VO("拼音码", "PYCODE_CHR", HorizontalAlignment.Left, 0)
};
m_objViewer.m_txtNurse.m_strSQL = @"SELECT a.ORDERDICID_CHR, a.USERCODE_CHR, a.NAME_CHR, a.PYCODE_CHR from t_bse_bih_orderdic a, T_BSE_BIH_SPECORDERCATE b
WHERE a.ordercateid_chr = b.NURSECATE
ORDER BY a.USERCODE_CHR";
m_objViewer.m_txtNurse.m_mthInitListView(columArr);
#endregion
//读取系统配置
string setting = clsSysSetting.GetSettingByID("1043");
if (setting != "1")
{
this.m_objViewer.m_txtEat.Enabled = false;
this.m_objViewer.m_txtNurse.Enabled = false;
}
}
