/// <summary>
/// 异步获取主表内容
/// </summary>
private void m_mthGetMainDate()
{
DateTime dtmBegin = Convert.ToDateTime(Convert.ToDateTime(m_dtpSearchBeginDate.Text).ToString("yyyy-MM-dd 00:00:00"));
DateTime dtmEnd = Convert.ToDateTime(Convert.ToDateTime(m_dtpSearchEndDate.Text).ToString("yyyy-MM-dd 23:59:59"));
if (dtmBegin.Date > dtmEnd)
{
return;
}
System.Collections.ArrayList arrPa = new System.Collections.ArrayList();
arrPa.Add(dtmBegin);
arrPa.Add(dtmEnd);
arrPa.Add(m_strStorageID);
arrPa.Add(m_txtMedicineName.Text.Trim());
arrPa.Add(m_txtProviderName.Text);
arrPa.Add(m_txtBillNumber.Text);
if (m_cboDoseType.SelectedIndex < 0 || m_cboDoseType.SelectedIndex == 0)
{
arrPa.Add(0);
}
else
{
clsMS_MedicineType_VO objVo = m_cboDoseType.SelectedItem as clsMS_MedicineType_VO;
arrPa.Add(objVo.m_strMedicineTypeID_CHR);
}
if (!m_bgwGetData.IsBusy)
{
m_bgwGetData.RunWorkerAsync(arrPa);
}
}
public long m_lngGetMedicineInfo(System.Security.Principal.IPrincipal p_objPrincipal, out clsMS_MedicineType_VO[] p_objMedicineTypeArr)
{
p_objMedicineTypeArr = null;
DataTable m_dtbMedicineType = new DataTable();
long lngRes = 0;
try
{
string strSQL = @"select t.medicinetypeid_chr medicinetypeid,
t.medicinetypename_vchr medicinetypename
from t_aid_medicinetype t";
clsHRPTableService objHRPServ = new clsHRPTableService();
lngRes = objHRPServ.lngGetDataTableWithoutParameters(strSQL, ref m_dtbMedicineType);
objHRPServ.Dispose();
objHRPServ = null;
int currentRow = 0;
clsMS_MedicineType_VO[] m_objMedicineTypeArr = new clsMS_MedicineType_VO[m_dtbMedicineType.Rows.Count];
foreach (DataRow dr in m_dtbMedicineType.Rows)
{
m_objMedicineTypeArr[currentRow] = new clsMS_MedicineType_VO();
m_objMedicineTypeArr[currentRow].m_strMedicineTypeID_CHR = dr["MedicineTypeID"] as string;
m_objMedicineTypeArr[currentRow].m_strMedicineTypeName_VCHR = dr["MedicineTypeName"] as string;
currentRow++;
}
p_objMedicineTypeArr = m_objMedicineTypeArr;
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetStorageMedicineType(out clsMS_MedicineType_VO[] objMTVO)
{
objMTVO = new clsMS_MedicineType_VO[0];
long lngRes = 0;
System.Security.Principal.IPrincipal objPrincipal = null;
com.digitalwave.iCare.middletier.HIS.clsGetStoreCheckMedicine_Supported_SVC objSvc =
(com.digitalwave.iCare.middletier.HIS.clsGetStoreCheckMedicine_Supported_SVC)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.HIS.clsGetStoreCheckMedicine_Supported_SVC));
lngRes = objSvc.m_lngGetStorageMedicineType(objPrincipal, out objMTVO);
return(lngRes);
}
public long m_lngGetMedStoreSetCheck(System.Security.Principal.IPrincipal p_objPrincipal, string p_strStoreRoomID, out clsMS_MedicineType_VO[] p_objType)
{
p_objType = null;
long lngRes = 0;
try
{
string strSQL = @"select b.medicinetypeid_chr, b.medicinetypename_vchr
from t_ds_medstoreset a, t_aid_medicinetype b
where a.medicinetypeid_chr = b.medicinetypeid_chr
and a.medstoreid = ?";
clsHRPTableService objHRPServ = new clsHRPTableService();
IDataParameter[] objDPArr = null;
objHRPServ.CreateDatabaseParameter(1, out objDPArr);
objDPArr[0].Value = p_strStoreRoomID;
DataTable dtbValue = null;
lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtbValue, objDPArr);
objHRPServ.Dispose();
objHRPServ = null;
if (lngRes > 0 && dtbValue != null)
{
int intRowsCount = dtbValue.Rows.Count;
if (intRowsCount == 0)
{
return(0);
}
p_objType = new clsMS_MedicineType_VO[intRowsCount];
DataRow drTemp = null;
for (int iRow = 0; iRow < intRowsCount; iRow++)
{
p_objType[iRow] = new clsMS_MedicineType_VO();
drTemp = dtbValue.Rows[iRow];
p_objType[iRow].m_strMedicineTypeID_CHR = drTemp["medicinetypeid_chr"].ToString();
p_objType[iRow].m_strMedicineTypeName_VCHR = drTemp["medicinetypename_vchr"].ToString();
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
/// <summary>
/// 设置药品类型
/// </summary>
/// <param name="p_objMPVO"></param>
internal void m_mthSetMedicineType(clsMS_MedicineType_VO[] p_objMPVO)
{
if (p_objMPVO == null || m_objViewer.m_cboDoseType.Items.Count > 0)
{
return;
}
clsMS_MedicineType_VO objAll = new clsMS_MedicineType_VO();
objAll.m_strMedicineTypeID_CHR = "0";
objAll.m_strMedicineTypeName_VCHR = "全部";
m_objViewer.m_cboDoseType.Items.Add(objAll);
m_objViewer.m_cboDoseType.Items.AddRange(p_objMPVO);
m_objViewer.m_cboDoseType.SelectedIndex = 0;
}
/// <summary>
/// 获取新购药品明细数据
/// 实现统计查询和明细查询功能。
/// 可按药品的助记码、拼音码、五笔码、药品的ID或药品名称进行模糊查询
/// </summary>
internal void m_mthQuery()
{
if (m_objViewer.m_strStorageID == string.Empty)
{
MessageBox.Show("必须选择药库!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (m_objViewer.m_dtpSearchBeginDate.Text.Trim().Length < 11)
{
m_objViewer.m_dtpSearchBeginDate.Text = "";
}
if (m_objViewer.m_dtpSearchEndDate.Text.Trim().Length < 11)
{
m_objViewer.m_dtpSearchEndDate.Text = "";
}
if ((m_objViewer.m_dtpSearchBeginDate.Text.Trim().Length == 11) && (m_objViewer.m_dtpSearchEndDate.Text.Trim().Length == 11))
{
if ((Convert.ToDateTime(m_objViewer.m_dtpSearchBeginDate.Text)) > (Convert.ToDateTime(m_objViewer.m_dtpSearchEndDate.Text)))
{
DialogResult tmpResult = MessageBox.Show("开始日期必须小于结束日期！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Stop);
m_objViewer.m_dtpSearchBeginDate.Focus();
return;
}
}
long lngRes = 0;
m_objViewer.m_dgvNewMedicine.DataSource = null;
if (dtbResult != null)
{
dtbResult.Clear();
dtbResult.Dispose();
dtbResult = null;
}
m_objViewer.m_mthInitDataTable();
ArrayList al = new ArrayList();
al.Add(m_objViewer.m_strStorageID);
DateTime m_datBeginTime = Convert.ToDateTime((Convert.ToDateTime(m_objViewer.m_dtpSearchBeginDate.Text)).ToString("yyyy-MM-dd 00:00:00"));
DateTime m_datEndTime = Convert.ToDateTime((Convert.ToDateTime(m_objViewer.m_dtpSearchEndDate.Text)).ToString("yyyy-MM-dd 23:59:59"));
al.Add(m_datBeginTime);
al.Add(m_datEndTime);
al.Add(m_objViewer.m_txtMedicineName.Text.Trim());
al.Add(m_objViewer.m_txtProviderName.Text);
al.Add(m_objViewer.m_txtBillNumber.Text);
if (m_objViewer.m_cboDoseType.SelectedIndex < 0 || m_objViewer.m_cboDoseType.SelectedIndex == 0)
{
al.Add(0);
}
else
{
clsMS_MedicineType_VO objVo = m_objViewer.m_cboDoseType.SelectedItem as clsMS_MedicineType_VO;
al.Add(objVo.m_strMedicineTypeID_CHR);
}
dtbResult = new DataTable();
lngRes = ((clsDcl_NewPurchaseMedicine)this.m_objDomain).m_lngGetNewPurchaseMedicine(al, out dtbResult);
if ((lngRes > 0) && (dtbResult != null))
{
m_objViewer.m_dgvNewMedicine.DataSource = dtbResult;
}
}
