/// <summary>
/// 构造函数
/// </summary>
public frmPrint(DataWindowControl dw, bool _blnChoosePrinter, ArrayList _OnlyPriviewCtlArr)
{
InitializeComponent();
DataSourceSyntax = dw.Describe("datawindow.syntax");
DataFullState = dw.GetFullState();
blnChoosePrinter = _blnChoosePrinter;
OnlyPriviewCtlArr = _OnlyPriviewCtlArr;
}
/// <summary>
/// 打印
/// </summary>
internal void m_mthPrint()
{
return;//报表尚未做
m_mthQuery();
DataWindowControl m_dwcDrugQuery = new DataWindowControl();
m_dwcDrugQuery.LibraryList = Application.StartupPath + "\\PB_OP.pbl";
m_dwcDrugQuery.DataWindowObject = "d_op_drugquerydetail";
//datWindow.Modify("t_tile.text = '" + base.m_objComInfo.m_strGetHospitalTitle() + "(" + p_strStorageName + ")'");
m_dwcDrugQuery.SetRedrawOff();
m_dwcDrugQuery.Retrieve(dtbResult);
m_dwcDrugQuery.Refresh();
m_dwcDrugQuery.SetRedrawOn();
m_dwcDrugQuery.Modify("t_storename.text = '药房：" + m_objViewer.m_cboStorage.Text + "'");
m_dwcDrugQuery.Modify("t_drugtypename.text = '药品类型：" + m_objViewer.m_cboMedicineType.Text + "'");
com.digitalwave.iCare.gui.MedicineStore.clsCtl_Public.PrintDialog(m_dwcDrugQuery);
}
/// <summary>
/// 构造函数
/// </summary>
public frmPrintDialog(DataWindowControl dw)
{
InitializeComponent();
DataSourceSyntax = dw.Describe("datawindow.syntax");
DataFullState = dw.GetFullState();
}
/// <summary>
/// 门诊各科挂号人次统计报表
/// </summary>
/// <param name="BeginDate"></param>
/// <param name="EndDate"></param>
public bool m_mthDeptReg(string BeginDate, string EndDate, ref DataWindowControl DWC)
{
bool ret = true;
clsDomainConrol_Print objPrint = new clsDomainConrol_Print();
DataTable dtDeptRpt;
DataTable dtDeptSort;
long l = objPrint.m_lngDepIncomerpt(BeginDate, EndDate, out dtDeptRpt, out dtDeptSort);
if (l > 0)
{
try
{
DWC.Reset();
DataView DV = new DataView(dtDeptRpt);
DataView DV2 = new DataView(dtDeptSort);
int prow = 0;
string pdeptname = "";
string cdeptname = "";
int Normal1Total = 0;
int Normal2Total = 0;
int ExpertTotal = 0;
int EmerTotal = 0;
Hashtable hasPDept = new Hashtable();
for (int i = 0; i < dtDeptSort.Rows.Count; i++)
{
if (dtDeptSort.Rows[i]["code_vchr"].ToString() != "1")
{
pdeptname = dtDeptSort.Rows[i]["parentname_vchr"].ToString();
if (pdeptname.Trim() != "" && !hasPDept.ContainsKey(pdeptname))
{
prow = DWC.InsertRow(0);
DWC.SetItemString(prow, "parentflag", "1");
DWC.SetItemString(prow, "deptname", pdeptname);
DV2.RowFilter = "parentname_vchr = '" + pdeptname + "'";
foreach (DataRowView drv in DV2)
{
cdeptname = drv["deptname_vchr"].ToString();
DV.RowFilter = "deptname_vchr = '" + cdeptname + "'";
//总数
int total = DV.Count;
//日诊
DV.RowFilter = "deptname_vchr = '" + cdeptname + "' and trim(planperiod_chr) = '上午'";
int day1 = DV.Count;
DV.RowFilter = "deptname_vchr = '" + cdeptname + "' and trim(planperiod_chr) = '下午'";
int day2 = DV.Count;
//夜诊
DV.RowFilter = "deptname_vchr = '" + cdeptname + "' and trim(planperiod_chr) = '晚上'";
int day3 = DV.Count;
}
hasPDept.Add(pdeptname, null);
}
}
else
{
pdeptname = dtDeptSort.Rows[i]["deptname_vchr"].ToString();
if (pdeptname.Trim() != "" && !hasPDept.ContainsKey(pdeptname))
{
ArrayList cdeptarr = new ArrayList();
cdeptarr.Add(pdeptname);
hasPDept.Add(pdeptname, cdeptarr);
}
}
}
//ArrayList PDeptArr = new ArrayList();
//PDeptArr.AddRange(hasPDept.Keys);
//for (int i = 0; i < PDeptArr.Count; i++)
//{
// pdeptname = PDeptArr[i].ToString();
// ArrayList CDeptArr = hasPDept[pdeptname] as ArrayList;
// prow = DWC.InsertRow(0);
// DWC.SetItemString(prow, "parentflag", "1");
// DWC.SetItemString(prow, "deptname", pdeptname);
// for (int j = 0; j < CDeptArr.Count; j++)
// {
// }
//}
}
catch
{
ret = false;
}
}
objPrint = null;
dtDeptRpt = null;
dtDeptSort = null;
return(ret);
}
/// <summary>
/// 查询
/// </summary>
/// <param name="p_dwRpt"></param>
/// <param name="p_strStartDate"></param>
/// <param name="p_strEndDate"></param>
/// <param name="p_strOutStartDate"></param>
/// <param name="p_strOutEndDate"></param>
public void m_mthGetYbCheckBill(DataWindowControl p_dwRpt, string p_strStartDate, string p_strEndDate, string p_strOutStartDate, string p_strOutEndDate)
{
clsDcl_DeptTransfer objSvc = new clsDcl_DeptTransfer();
DataTable dtbReulst = null;
long lngRes = objSvc.m_lngGetCollectorReport_PatientSource(p_strStartDate, p_strEndDate, p_strOutStartDate, p_strOutEndDate, out dtbReulst);
p_dwRpt.Reset();
p_dwRpt.SetRedrawOff();
if (!string.IsNullOrEmpty(p_strStartDate))
{
p_dwRpt.Modify("t_date.text='" + DateTime.Parse(p_strStartDate).ToShortDateString() + "到" + DateTime.Parse(p_strEndDate).ToShortDateString() + "'");
}
else
{
p_dwRpt.Modify("t_date.text='" + DateTime.Parse(p_strOutStartDate).ToShortDateString() + "到" + DateTime.Parse(p_strOutEndDate).ToShortDateString() + "'");
}
if (lngRes > 0 && dtbReulst.Rows.Count > 0)
{
//处理数据
int intRowCount = dtbReulst.Rows.Count;
DataRow objDr = null;
DataTable objDtResult = new DataTable();
objDtResult.Columns.Add("deptname");
objDtResult.Columns.Add("bz_peo");
objDtResult.Columns.Add("bz_percent");
objDtResult.Columns.Add("bswz_peo");
objDtResult.Columns.Add("bswz_percent");
objDtResult.Columns.Add("bsqt_peo");
objDtResult.Columns.Add("bsqt_percent");
objDtResult.Columns.Add("ws_peo");
objDtResult.Columns.Add("ws_percent");
objDtResult.Columns.Add("gat_peo");
objDtResult.Columns.Add("gat_percent");
objDtResult.Columns.Add("wg_peo");
Hashtable objHashTable = new Hashtable();
DataRow OneRow = objDtResult.NewRow();
for (int intI = 0; intI < intRowCount; intI++)
{
objDr = dtbReulst.Rows[intI];
OneRow["deptname"] = objDr["deptname_vchr"].ToString();
if (!objHashTable.Contains(OneRow["deptname"].ToString()))
{
clsPatientSoureVo objVo = new clsPatientSoureVo();
if (objDr["patientsources_vchr"].ToString() == "本镇区")
{
OneRow["deptname"] = objDr["deptname_vchr"].ToString();
OneRow["bz_peo"] = int.Parse(objDr["a1"].ToString());
OneRow["bz_percent"] = double.Parse(objDr["a3"].ToString());
objVo.m_strDeptname = OneRow["deptname"].ToString();
objVo.m_intBz_peo = int.Parse(OneRow["bz_peo"].ToString());
objVo.m_dblBz_percent = double.Parse(OneRow["bz_percent"].ToString());
objHashTable.Add(OneRow["deptname"].ToString(), objVo);
}
if (objDr["patientsources_vchr"].ToString() == "本市外镇")
{
OneRow["deptname"] = objDr["deptname_vchr"].ToString();
OneRow["bswz_peo"] = int.Parse(objDr["a1"].ToString());
OneRow["bswz_percent"] = double.Parse(objDr["a3"].ToString());
objVo.m_strDeptname = OneRow["deptname"].ToString();
objVo.m_intBswz_peo = int.Parse(OneRow["bswz_peo"].ToString());
objVo.m_dblBswz_percent = double.Parse(OneRow["bswz_percent"].ToString());
objHashTable.Add(OneRow["deptname"].ToString(), objVo);
}
if (objDr["patientsources_vchr"].ToString() == "本省其它市")
{
OneRow["deptname"] = objDr["deptname_vchr"].ToString();
OneRow["bsqt_peo"] = int.Parse(objDr["a1"].ToString());
OneRow["bsqt_percent"] = double.Parse(objDr["a3"].ToString());
objVo.m_strDeptname = OneRow["deptname"].ToString();
objVo.m_intBsqt_peo = int.Parse(OneRow["bsqt_peo"].ToString());
objVo.m_dblBsqt_percent = double.Parse(OneRow["bsqt_percent"].ToString());
objHashTable.Add(OneRow["deptname"].ToString(), objVo);
}
if (objDr["patientsources_vchr"].ToString() == "外省（直辖市）")
{
OneRow["deptname"] = objDr["deptname_vchr"].ToString();
OneRow["ws_peo"] = int.Parse(objDr["a1"].ToString());
OneRow["ws_percent"] = double.Parse(objDr["a3"].ToString());
objVo.m_strDeptname = OneRow["deptname"].ToString();
objVo.m_intWs_peo = int.Parse(OneRow["ws_peo"].ToString());
objVo.m_dblWs_percent = double.Parse(OneRow["ws_percent"].ToString());
objHashTable.Add(OneRow["deptname"].ToString(), objVo);
}
if (objDr["patientsources_vchr"].ToString() == "港、澳、台")
{
OneRow["deptname"] = objDr["deptname_vchr"].ToString();
OneRow["gat_peo"] = int.Parse(objDr["a1"].ToString());
OneRow["gat_percent"] = double.Parse(objDr["a3"].ToString());
objVo.m_strDeptname = OneRow["deptname"].ToString();
objVo.m_intGat_peo = int.Parse(OneRow["gat_peo"].ToString());
objVo.m_dblGat_percent = double.Parse(OneRow["gat_percent"].ToString());
objHashTable.Add(OneRow["deptname"].ToString(), objVo);
}
if (objDr["patientsources_vchr"].ToString() == "外国")
{
OneRow["deptname"] = objDr["deptname_vchr"].ToString();
OneRow["wg_peo"] = int.Parse(objDr["a1"].ToString());
objVo.m_strDeptname = OneRow["deptname"].ToString();
objVo.m_intWg_peo = int.Parse(OneRow["wg_peo"].ToString());
objHashTable.Add(OneRow["deptname"].ToString(), objVo);
}
}
else
{
clsPatientSoureVo objVo = new clsPatientSoureVo();
if (objDr["patientsources_vchr"].ToString() == "本镇区")
{
OneRow["bz_peo"] = int.Parse(objDr["a1"].ToString());
OneRow["bz_percent"] = double.Parse(objDr["a3"].ToString());
objVo.m_intBz_peo = int.Parse(OneRow["bz_peo"].ToString());
objVo.m_dblBz_percent = double.Parse(OneRow["bz_percent"].ToString());
((clsPatientSoureVo)(objHashTable[OneRow["deptname"].ToString()])).m_intBz_peo = int.Parse(OneRow["bz_peo"].ToString());
((clsPatientSoureVo)(objHashTable[OneRow["deptname"].ToString()])).m_dblBz_percent = double.Parse(OneRow["bz_percent"].ToString());
}
if (objDr["patientsources_vchr"].ToString() == "本市外镇")
{
OneRow["bswz_peo"] = int.Parse(objDr["a1"].ToString());
OneRow["bswz_percent"] = double.Parse(objDr["a3"].ToString());
objVo.m_intBswz_peo = int.Parse(OneRow["bswz_peo"].ToString());
objVo.m_dblBswz_percent = double.Parse(OneRow["bswz_percent"].ToString());
((clsPatientSoureVo)(objHashTable[OneRow["deptname"].ToString()])).m_intBswz_peo = int.Parse(OneRow["bswz_peo"].ToString());
((clsPatientSoureVo)(objHashTable[OneRow["deptname"].ToString()])).m_dblBswz_percent = double.Parse(OneRow["bswz_percent"].ToString());
}
if (objDr["patientsources_vchr"].ToString() == "本省其它市")
{
OneRow["bsqt_peo"] = int.Parse(objDr["a1"].ToString());
OneRow["bsqt_percent"] = double.Parse(objDr["a3"].ToString());
objVo.m_intBsqt_peo = int.Parse(OneRow["bsqt_peo"].ToString());
objVo.m_dblBsqt_percent = double.Parse(OneRow["bsqt_percent"].ToString());
((clsPatientSoureVo)(objHashTable[OneRow["deptname"].ToString()])).m_intBsqt_peo = int.Parse(OneRow["bsqt_peo"].ToString());
((clsPatientSoureVo)(objHashTable[OneRow["deptname"].ToString()])).m_dblBsqt_percent = double.Parse(OneRow["bsqt_percent"].ToString());
}
if (objDr["patientsources_vchr"].ToString() == "外省（直辖市）")
{
OneRow["ws_peo"] = int.Parse(objDr["a1"].ToString());
OneRow["ws_percent"] = double.Parse(objDr["a3"].ToString());
objVo.m_intWs_peo = int.Parse(OneRow["ws_peo"].ToString());
objVo.m_dblWs_percent = double.Parse(OneRow["ws_percent"].ToString());
((clsPatientSoureVo)(objHashTable[OneRow["deptname"].ToString()])).m_intWs_peo = int.Parse(OneRow["ws_peo"].ToString());
((clsPatientSoureVo)(objHashTable[OneRow["deptname"].ToString()])).m_dblWs_percent = double.Parse(OneRow["ws_percent"].ToString());
}
if (objDr["patientsources_vchr"].ToString() == "港、澳、台")
{
OneRow["gat_peo"] = int.Parse(objDr["a1"].ToString());
OneRow["gat_percent"] = double.Parse(objDr["a3"].ToString());
objVo.m_intGat_peo = int.Parse(OneRow["gat_peo"].ToString());
objVo.m_dblGat_percent = double.Parse(OneRow["gat_percent"].ToString());
((clsPatientSoureVo)(objHashTable[OneRow["deptname"].ToString()])).m_intGat_peo = int.Parse(OneRow["gat_peo"].ToString());
((clsPatientSoureVo)(objHashTable[OneRow["deptname"].ToString()])).m_dblGat_percent = double.Parse(OneRow["gat_percent"].ToString());
}
if (objDr["patientsources_vchr"].ToString() == "外国")
{
OneRow["wg_peo"] = int.Parse(objDr["a1"].ToString());
objVo.m_intWg_peo = int.Parse(OneRow["wg_peo"].ToString());
((clsPatientSoureVo)(objHashTable[OneRow["deptname"].ToString()])).m_intWg_peo = int.Parse(OneRow["wg_peo"].ToString());
}
}
}
foreach (DictionaryEntry var in objHashTable)
{
clsPatientSoureVo objVo = (clsPatientSoureVo)var.Value as clsPatientSoureVo;
int intRow = p_dwRpt.InsertRow();
p_dwRpt.SetItemString(intRow, "deptname", objVo.m_strDeptname);
p_dwRpt.SetItemDouble(intRow, "bz_peo", objVo.m_intBz_peo);
p_dwRpt.SetItemDouble(intRow, "bz_ratio", objVo.m_dblBz_percent);
p_dwRpt.SetItemDouble(intRow, "bswz_peo", objVo.m_intBswz_peo);
p_dwRpt.SetItemDouble(intRow, "bswz_ratio", objVo.m_dblBswz_percent);
p_dwRpt.SetItemDouble(intRow, "bsqt_peo", objVo.m_intBsqt_peo);
p_dwRpt.SetItemDouble(intRow, "bsqt_ratio", objVo.m_dblBsqt_percent);
p_dwRpt.SetItemDouble(intRow, "ws_peo", objVo.m_intWs_peo);
p_dwRpt.SetItemDouble(intRow, "ws_ratio", objVo.m_dblWs_percent);
p_dwRpt.SetItemDouble(intRow, "gat_peo", objVo.m_intGat_peo);
p_dwRpt.SetItemDouble(intRow, "gat_ratio", objVo.m_dblGat_percent);
p_dwRpt.SetItemDouble(intRow, "wg_peo", objVo.m_intWg_peo);
}
}
else
{
MessageBox.Show("没有检索到数据！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
p_dwRpt.CalculateGroups();
p_dwRpt.Sort();
p_dwRpt.SetRedrawOn();
p_dwRpt.Refresh();
objSvc = null;
}
