/// <summary>
/// 添加新的药品类型设置
/// </summary>
internal void m_mthModifyTypeSet()
{
if (string.IsNullOrEmpty(m_objViewer.m_txtMedicineStoreRoom.Text))
{
System.Windows.Forms.MessageBox.Show("请先填写药品类型名称", "药品类型设置", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return;
}
if (m_objViewer.m_lsvMedicineName.Items.Count == 0 || m_objViewer.m_lsvMedicineName.CheckedItems.Count == 0)
{
System.Windows.Forms.MessageBox.Show("请先选择对应的药品基本类型", "药品类型设置", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return;
}
clsMS_MedicineTypeSetVO objTypeSet = new clsMS_MedicineTypeSetVO();
int intSetID = 1;
if (int.TryParse(m_objViewer.m_txtMedicineStoreRoom.Tag.ToString(), out intSetID))
{
objTypeSet.m_intMedicineTypeSetID = intSetID;
}
else
{
System.Windows.Forms.MessageBox.Show("保存失败", "药品类型设置", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return;
}
long lngRes = 0;
objTypeSet.m_strMedicineTypeSetName = m_objViewer.m_txtMedicineStoreRoom.Text;
objTypeSet.m_strMedicineTypeIDArr = new string[m_objViewer.m_lsvMedicineName.CheckedItems.Count];
string strSetName = string.Empty;
for (int iItem = 0; iItem < m_objViewer.m_lsvMedicineName.CheckedItems.Count; iItem++)
{
objTypeSet.m_strMedicineTypeIDArr[iItem] = m_objViewer.m_lsvMedicineName.CheckedItems[iItem].Tag.ToString();
lngRes = m_objDomain.m_lngCheckHasSetOtherType(objTypeSet.m_strMedicineTypeIDArr[iItem], out strSetName);
if (!string.IsNullOrEmpty(strSetName) && strSetName != m_objViewer.m_txtMedicineStoreRoom.Text)
{
System.Windows.Forms.MessageBox.Show(m_objViewer.m_lsvMedicineName.CheckedItems[iItem].Text + "已设置为属于" + strSetName + "，不能重复设置",
"药品类型设置", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Stop);
return;
}
}
lngRes = m_objDomain.m_lngModifyMedicineTypeSet(objTypeSet);
if (lngRes > 0)
{
m_mthClear();
m_objViewer.m_lsvMedicineTypeSet.Items.Clear();
m_mthGetAllMedicineTypeSetInfo();
System.Windows.Forms.MessageBox.Show("保存成功", "药品类型设置", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
}
else
{
System.Windows.Forms.MessageBox.Show("保存失败", "药品类型设置", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
}
}
/// <summary>
/// 修改药品类型设置
/// </summary>
/// <param name="p_objTypeVO">药品类型设置</param>
/// <returns></returns>
internal long m_lngModifyMedicineTypeSet(clsMS_MedicineTypeSetVO p_objTypeVO)
{
long lngRes = 0;
com.digitalwave.iCare.middletier.MedicineStoreService.clsMedicineTypeSetSVC objSvc =
(com.digitalwave.iCare.middletier.MedicineStoreService.clsMedicineTypeSetSVC)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.MedicineStoreService.clsMedicineTypeSetSVC));
lngRes = objSvc.m_lngModifyMedicineTypeSet(objPrincipal, p_objTypeVO);
return(lngRes);
}
/// <summary>
/// 统计供药单位供药明细
/// </summary>
internal void m_mthStatistics()
{
DateTime dtmBegin = DateTime.Parse(Convert.ToDateTime(m_objViewer.m_dtpBeginDate.Text).ToString("yyyy-MM-dd 00:00:00"));
DateTime dtmEnd = DateTime.Parse(Convert.ToDateTime(m_objViewer.m_dtpEndDate.Text).ToString("yyyy-MM-dd 23:59:59"));
string strVendor = m_objViewer.m_txtVendor.Text;
this.m_objViewer.m_dwcData.Modify("begindate.text = '" + dtmBegin.ToString("yyyy-MM-dd") + "'");
this.m_objViewer.m_dwcData.Modify("enddate.text = '" + dtmEnd.ToString("yyyy-MM-dd") + "'");
this.m_objViewer.m_dwcData.Modify("vendorname.text = '" + strVendor + "'");
m_mthSetStorageNameToReport();
string strVendorID = string.Empty;
if (m_objViewer.m_txtVendor.Tag != null && !string.IsNullOrEmpty(m_objViewer.m_txtVendor.Text))
{
strVendorID = m_objViewer.m_txtVendor.Tag.ToString();
}
int intSetID = 0;
if (m_objViewer.m_cboType.SelectedItem != null)
{
clsMS_MedicineTypeSetVO objSet = m_objViewer.m_cboType.SelectedItem as clsMS_MedicineTypeSetVO;
if (objSet != null)
{
intSetID = objSet.m_intMedicineTypeSetID;
}
}
DataTable dtbData = null;
long lngRes = m_objDomain.m_lngStatistics(m_objViewer.m_strStorageID, dtmBegin, dtmEnd, strVendorID, intSetID, out dtbData);
if (dtbData == null || dtbData.Rows.Count == 0)
{
m_objViewer.m_dwcData.Reset();
return;
}
DataTable dtbNewdata = null;
if (dtbData != null)
{
this.m_objViewer.m_dwcData.SetRedrawOff();
//按药品ID排序
DataView dtv = new DataView();
dtv = dtbData.DefaultView;
dtv.Sort = "assistcode_chr";
dtbNewdata = dtv.ToTable();
this.m_objViewer.m_dwcData.Retrieve(dtbNewdata);
this.m_objViewer.m_dwcData.SetRedrawOn();
this.m_objViewer.m_dwcData.Refresh();
}
}
//#region 设置药品类型
///// <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;
//}
//#endregion
//public long m_getMedIcineType()
//{
// long ret;
// clsMS_MedicineType_VO[] p_objMPVO;
// ret = m_objDomain.m_lngGetStorageMedicineType(m_objViewer.typeID, out p_objMPVO);
// m_mthSetMedicineType(p_objMPVO);
// return ret;
//}
public long m_getMedIcineCheck()
{
DataTable dt;
long ret;
if (m_objViewer.m_txtProviderName.Text.Trim() == "")
{
MessageBox.Show("请选译供应商名称！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(-1);
}
clsMS_MedicineTypeSetVO objVo = m_objViewer.m_cboType.SelectedItem as clsMS_MedicineTypeSetVO;
string strVendor = m_objViewer.m_txtProviderName.Tag.ToString();
int intMedicinetype = objVo.m_intMedicineTypeSetID;
string strDateStar = this.m_objViewer.dtpStar.Value.ToShortDateString() + " 00:00:00";
string strDateEnd = this.m_objViewer.dtpEnd.Value.ToShortDateString() + " 23:59:59";
string STORAGEID = this.m_objViewer.typeID;
ret = this.m_objDomain.m_lngGetMedIcineCheck(strVendor, intMedicinetype, strDateStar, strDateEnd, STORAGEID, out dt);
DataTable dtbOut = null;//外退数据
if (m_objViewer.m_chkStatOut.Checked)
{
ret = m_objDomain.m_lngStatisticsForeignRetreat(STORAGEID, Convert.ToDateTime(strDateStar), Convert.ToDateTime(strDateEnd), strVendor, intMedicinetype, out dtbOut);
}
DataTable dtbShow = m_dtbMergeStatisticsData(dt, dtbOut);
if (dtbShow == null || dt.Rows.Count <= 0)
{
MessageBox.Show("抱歉,没有找到符合条件的记录！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.m_objViewer.m_dwRpt.Reset();
return(-1);
}
this.m_objViewer.m_dwRpt.Modify("t_date.text = '" + DateTime.Now.ToString("yyyy年MM月dd日") + "'");
this.m_objViewer.m_dwRpt.Modify("t_tile.text = '" + this.m_objComInfo.m_strGetHospitalTitle() + "验收单" + "'");
this.m_objViewer.m_dwRpt.Retrieve(dt);
return(ret);
}
/// <summary>
/// 药品报废明细
/// </summary>
internal void m_mthStatistics()
{
DateTime dtmBegin = DateTime.Parse(Convert.ToDateTime(m_objViewer.txtOutStorageBeginDate.Text).ToString("yyyy-MM-dd 00:00:00"));
DateTime dtmEnd = DateTime.Parse(Convert.ToDateTime(m_objViewer.txtOutStorageEndDate.Text).ToString("yyyy-MM-dd 23:59:59"));
this.m_objViewer.dwOutStorageStat.Modify("t_9.text = '" + dtmBegin.ToString("yyyy-MM-dd") + " 至 " + dtmEnd.ToString("yyyy-MM-dd") + "'");
this.m_objViewer.dwOutStorageStat.Modify("t_type.text='" + this.m_objViewer.m_cboType.Text + "'");
m_mthSetStorageNameToReport();
int intSetID = 0;
if (m_objViewer.m_cboType.SelectedItem != null)
{
clsMS_MedicineTypeSetVO objSet = m_objViewer.m_cboType.SelectedItem as clsMS_MedicineTypeSetVO;
if (objSet != null)
{
intSetID = objSet.m_intMedicineTypeSetID;
}
}
DataTable dtbData = null;
long lngRes = m_objDomain.m_lngStatistics(m_objViewer.m_strStorageID, dtmBegin, dtmEnd, intSetID, out dtbData);
if (dtbData == null || dtbData.Rows.Count == 0)
{
m_objViewer.dwOutStorageStat.Reset();
return;
}
if (dtbData != null)
{
this.m_objViewer.dwOutStorageStat.SetRedrawOff();
this.m_objViewer.dwOutStorageStat.Retrieve(dtbData);
this.m_objViewer.dwOutStorageStat.SetRedrawOn();
this.m_objViewer.dwOutStorageStat.Refresh();
}
}
/// <summary>
/// 获取药品类型设置
/// </summary>
internal void m_mthGetMedicineTypeSet()
{
clsMS_MedicineTypeSetVO[] objMPVO = null;
clsDcl_MedicineTypeSet objMTDomain = new clsDcl_MedicineTypeSet();
long lngRes = objMTDomain.m_lngGetAllMedicinTypeSetInfo(out objMPVO);
objMTDomain = null;
if (objMPVO == null || m_cboType.Items.Count > 0)
{
return;
}
clsMS_MedicineTypeSetVO objAll = new clsMS_MedicineTypeSetVO();
objAll.m_intMedicineTypeSetID = 0;
objAll.m_strMedicineTypeSetName = "全部";
m_cboType.Items.Add(objAll);
m_cboType.Items.AddRange(objMPVO);
m_cboType.SelectedIndex = 0;
}
public long m_lngGetAllMedicinTypeSetInfo(System.Security.Principal.IPrincipal p_objPrincipal, out clsMS_MedicineTypeSetVO[] p_objTypeVO)
{
p_objTypeVO = null;
long lngRes = 0;
try
{
string strSQL = @"select distinct medicinetypesetid, medicinetypesetname
from t_ms_medicinetypeset
order by medicinetypesetid";
DataTable dtbValue = null;
clsHRPTableService objHRPServ = new clsHRPTableService();
lngRes = objHRPServ.lngGetDataTableWithoutParameters(strSQL, ref dtbValue);
if (lngRes > 0 && dtbValue != null)
{
int intRowsCount = dtbValue.Rows.Count;
if (intRowsCount > 0)
{
p_objTypeVO = new clsMS_MedicineTypeSetVO[intRowsCount];
for (int iRow = 0; iRow < intRowsCount; iRow++)
{
p_objTypeVO[iRow] = new clsMS_MedicineTypeSetVO();
p_objTypeVO[iRow].m_intMedicineTypeSetID = Convert.ToInt32(dtbValue.Rows[iRow]["medicinetypesetid"]);
p_objTypeVO[iRow].m_strMedicineTypeSetName = dtbValue.Rows[iRow]["medicinetypesetname"].ToString();
}
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
/// <summary>
/// 查询条件保存在“clsMS_OutStorageStatQueryCondition_VO”类型对象中
/// </summary>
private void GetOutStorageStatData()
{
long lngRes = 0;
if (m_value_Param == null)
{
m_value_Param = new clsMS_OutStorageStatQueryCondition_VO();
}
m_value_Param.m_blnPharmacyMedicineCancel = false;
m_value_Param.m_blnStorageMedicineCancel = false;
m_value_Param.m_intOutStorageType = 0;
m_value_Param.m_strReceiveDept = "";
m_value_Param.m_dtmOutStorageBeginDate = "";
m_value_Param.m_dtmOutStorageEndDate = "";
m_value_Param.m_strStorageID = m_strStorageID;
if ((txtOutStorageBeginDate.Text.Trim().Length == 11) && (txtOutStorageEndDate.Text.Trim().Length == 11))
{
if ((Convert.ToDateTime(txtOutStorageBeginDate.Text)) > (Convert.ToDateTime(txtOutStorageEndDate.Text)))
{
MessageBox.Show("出库开始日期必须小于或等于出库结束日期！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtOutStorageBeginDate.Focus();
return;
}
}
if (txtOutStorageBeginDate.Text.Trim().Length == 11)
{
string strDate = txtOutStorageBeginDate.Text;
m_value_Param.m_dtmOutStorageBeginDate = Convert.ToDateTime(strDate).ToString("yyyy-MM-dd 00:00:00");
}
else
{
m_value_Param.m_dtmOutStorageBeginDate = "";
}
if (txtOutStorageEndDate.Text.Trim().Length == 11)
{
string strDate = txtOutStorageEndDate.Text;
m_value_Param.m_dtmOutStorageEndDate = Convert.ToDateTime(strDate).ToString("yyyy-MM-dd 23:59:59");
}
else
{
m_value_Param.m_dtmOutStorageEndDate = "";
}
m_value_Param.m_blnPharmacyMedicineCancel = chkPharmacyMedicineCancel.Checked;
m_value_Param.m_intOutStorageType = 0;
if (m_txtAskDeptPage1.Text.Length > 0)
{
m_value_Param.m_strReceiveDept = m_txtAskDeptPage1.StrItemId;
}
else
{
m_value_Param.m_strReceiveDept = "all";
}
int intMedicineTypeSetID = -1;
if (m_cboType.SelectedItem != null)
{
clsMS_MedicineTypeSetVO objSet = m_cboType.SelectedItem as clsMS_MedicineTypeSetVO;
if (objSet != null)
{
intMedicineTypeSetID = objSet.m_intMedicineTypeSetID;
m_value_Param.m_intMedicineTypeSetID = objSet.m_intMedicineTypeSetID;
}
}
clsDomainController_OutStorageStat objDomain = new clsDomainController_OutStorageStat();
//调用Com+服务端
DataTable dtbOut = null; //出库数据
DataTable dtbWithin = null; //内退数据
lngRes = objDomain.m_lngGetResultByOutStorageStat(ref m_value_Param, ref dtbOut);
if (chkPharmacyMedicineCancel.Checked)
{
string strDeptID = string.Empty;
if (!string.IsNullOrEmpty(m_txtAskDeptPage1.Text) && !string.IsNullOrEmpty(m_txtAskDeptPage1.StrItemId))
{
strDeptID = m_txtAskDeptPage1.StrItemId;
}
lngRes = objDomain.m_lngGetWithinWithdrawal(m_strStorageID, Convert.ToDateTime(Convert.ToDateTime(txtOutStorageBeginDate.Text).ToString("yyyy-MM-dd 00:00:00")), Convert.ToDateTime(Convert.ToDateTime(txtOutStorageEndDate.Text).ToString("yyyy-MM-dd 23:59:59")), strDeptID, intMedicineTypeSetID, out dtbWithin);
}
if (lngRes <= 0)
{
dtbResult = null;
return;
}
dtbResult = m_dtbMergeStatisticsData(dtbOut, dtbWithin);
}
public long m_lngModifyMedicineTypeSet(System.Security.Principal.IPrincipal p_objPrincipal, clsMS_MedicineTypeSetVO p_objTypeVO)
{
if (p_objTypeVO == null)
{
return(-1);
}
long lngRes = 0;
try
{
lngRes = m_lngDeleteMedicineTypeSet(p_objPrincipal, p_objTypeVO.m_intMedicineTypeSetID);
if (lngRes <= 0)
{
return(-1);
}
lngRes = m_lngAddNewMedicneTypeSet(p_objPrincipal, p_objTypeVO);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngAddNewMedicneTypeSet(System.Security.Principal.IPrincipal p_objPrincipal, clsMS_MedicineTypeSetVO p_objTypeVO)
{
if (p_objTypeVO == null || p_objTypeVO.m_strMedicineTypeIDArr == null)
{
return(-1);
}
long lngRes = 0;
try
{
string strSQL = @"insert into t_ms_medicinetypeset
(medicinetypesetid, medicinetypesetname, medicinetypeid_chr)
values
(?, ?, ?)";
string strGetMax = @"select max(medicinetypesetid)
from t_ms_medicinetypeset";
clsHRPTableService objHRPServ = new clsHRPTableService();
long lngEff = -1;
if (p_objTypeVO.m_intMedicineTypeSetID <= 0)
{
DataTable dtbValue = null;
lngRes = objHRPServ.lngGetDataTableWithoutParameters(strGetMax, ref dtbValue);
if (dtbValue == null || dtbValue.Rows.Count == 0)
{
p_objTypeVO.m_intMedicineTypeSetID = 1;
}
else
{
if (dtbValue.Rows[0][0] == DBNull.Value)
{
p_objTypeVO.m_intMedicineTypeSetID = 1;
}
else
{
p_objTypeVO.m_intMedicineTypeSetID = Convert.ToInt32(dtbValue.Rows[0][0]) + 1;
}
}
}
if (clsHRPTableService.bytDatabase_Selector != (byte)clsHRPTableService.enumDatabase_Selector.bytOracle)
{
IDataParameter[] objDPArr = null;
for (int i = 0; i < p_objTypeVO.m_strMedicineTypeIDArr.Length; i++)
{
objHRPServ.CreateDatabaseParameter(3, out objDPArr);
objDPArr[0].Value = p_objTypeVO.m_intMedicineTypeSetID;
objDPArr[1].Value = p_objTypeVO.m_strMedicineTypeSetName;
objDPArr[2].Value = p_objTypeVO.m_strMedicineTypeIDArr[i];
lngRes = objHRPServ.lngExecuteParameterSQL(strSQL, ref lngEff, objDPArr);
}
}
else
{
DbType[] dbTypes = new DbType[] { DbType.Int32, DbType.String, DbType.String };
object[][] objValues = new object[3][];
int intItemCount = p_objTypeVO.m_strMedicineTypeIDArr.Length;
for (int j = 0; j < objValues.Length; j++)
{
objValues[j] = new object[intItemCount];//初始化
}
for (int i = 0; i < intItemCount; i++)
{
objValues[0][i] = p_objTypeVO.m_intMedicineTypeSetID;
objValues[1][i] = p_objTypeVO.m_strMedicineTypeSetName;
objValues[2][i] = p_objTypeVO.m_strMedicineTypeIDArr[i];
}
lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes);
}
p_objTypeVO = null;
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
/// <summary>
/// 获取药品明细帐表
/// </summary>
internal void m_mthGetMedicineDetailReport()
{
try
{
m_objViewer.Cursor = Cursors.WaitCursor;
m_objViewer.m_dtbAccou.Clear();
if (m_objViewer.m_txtMedicine.Text.Trim() != "")//指定某种药品
{
m_objDomain.m_lngGetMedicineTotalAccountByTime(m_objViewer.m_strStorageID, m_objViewer.m_txtMedicine.Tag.ToString(),
DateTime.Parse(Convert.ToDateTime(m_objViewer.m_dtpBeginDate.Text).ToString("yyyy-MM-dd 00:00:00")),
DateTime.Parse(Convert.ToDateTime(m_objViewer.m_dtpEndDate.Text).ToString("yyyy-MM-dd 23:59:59")),
m_objViewer.m_strForeAccount, m_objViewer.m_strBackAccount, out accountMedicineVO);
}
//指定药品的类型
else if ((m_objViewer.m_cboMedicineType.SelectedIndex >= 0) && (m_objViewer.m_cboMedicineType.Text != "全部"))
{
clsMS_MedicineTypeSetVO objMPVO = new clsMS_MedicineTypeSetVO();
objMPVO = (clsMS_MedicineTypeSetVO)m_objViewer.m_cboMedicineType.Items[m_objViewer.m_cboMedicineType.SelectedIndex];
m_objDomain.m_lngGetMedicineTypeAccountByTime(m_objViewer.m_strStorageID, objMPVO.m_intMedicineTypeSetID.ToString(),
DateTime.Parse(Convert.ToDateTime(m_objViewer.m_dtpBeginDate.Text).ToString("yyyy-MM-dd 00:00:00")),
DateTime.Parse(Convert.ToDateTime(m_objViewer.m_dtpEndDate.Text).ToString("yyyy-MM-dd 23:59:59")),
m_objViewer.m_strForeAccount, m_objViewer.m_strBackAccount, out accountVO);
}
//全部药品
else
{
m_objDomain.m_lngGetAllMedicineDetailAccountByTime(m_objViewer.m_strStorageID,
DateTime.Parse(Convert.ToDateTime(m_objViewer.m_dtpBeginDate.Text).ToString("yyyy-MM-dd 00:00:00")),
DateTime.Parse(Convert.ToDateTime(m_objViewer.m_dtpEndDate.Text).ToString("yyyy-MM-dd 23:59:59")),
m_objViewer.m_strForeAccount, m_objViewer.m_strBackAccount, out accountVO);
}
if ((m_objViewer.m_txtMedicine.Tag == null) && (accountVO == null || accountVO.Length == 0))
{
MessageBox.Show("抱歉，没有查到该期药品明细帐数据。", "药品明细帐表", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
m_objViewer.datWindow.Reset();
return;
}
if (m_objViewer.m_txtMedicine.Text.Trim() != "")
{
if (accountMedicineVO == null)
{
MessageBox.Show("抱歉，没有查到该药品明细帐数据。", "药品明细帐表", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
m_objViewer.datWindow.Reset();
return;
}
DataRow dr = m_objViewer.m_dtbAccou.NewRow();
dr["medicinename_vch"] = accountMedicineVO.m_strMedicineName;
dr["medspec_vchr"] = accountMedicineVO.m_strMedicineSpec;
dr["m_dblBeginAmount"] = accountMedicineVO.m_dblBeginAmount;
dr["m_dblBeginCallMoney"] = accountMedicineVO.m_dblBeginCallMoney;
dr["m_dblBeginRetailMoney"] = accountMedicineVO.m_dblBeginRetailMoney;
dr["m_dblBeginWholesaleMoney"] = accountMedicineVO.m_dblBeginWholesaleMoney;
dr["m_dblInAmount"] = accountMedicineVO.m_dblInAmount;
dr["m_dblInCallMoney"] = accountMedicineVO.m_dblInCallMoney;
dr["m_dblInRetailMoney"] = accountMedicineVO.m_dblInRetailMoney;
dr["m_dblInWholesaleMoney"] = accountMedicineVO.m_dblInWholesaleMoney;
dr["m_dblOutAmount"] = accountMedicineVO.m_dblOutAmount;
dr["m_dblOutCallMoney"] = accountMedicineVO.m_dblOutCallMoney;
dr["m_dblOutRetailMoney"] = accountMedicineVO.m_dblOutRetailMoney;
dr["m_dblOutWholesaleMoney"] = accountMedicineVO.m_dblOutWholesaleMoney;
dr["m_dblEndAmount"] = accountMedicineVO.m_dblEndAmount;
dr["m_dblEndCallMoney"] = accountMedicineVO.m_dblEndCallMoney;
dr["m_dblEndRetailMoney"] = accountMedicineVO.m_dblEndRetailMoney;
dr["m_dblEndWholesaleMoney"] = accountMedicineVO.m_dblEndWholesaleMoney;
m_objViewer.m_dtbAccou.Rows.Add(dr);
}
else
{
for (int i = 0; i < accountVO.Length; i++)
{
DataRow dr = m_objViewer.m_dtbAccou.NewRow();
dr["medicinename_vch"] = accountVO[i].m_strMedicineName;
dr["medspec_vchr"] = accountVO[i].m_strMedicineSpec;
dr["m_dblBeginAmount"] = accountVO[i].m_dblBeginAmount;
dr["m_dblBeginCallMoney"] = accountVO[i].m_dblBeginCallMoney;
dr["m_dblBeginRetailMoney"] = accountVO[i].m_dblBeginRetailMoney;
dr["m_dblBeginWholesaleMoney"] = accountVO[i].m_dblBeginWholesaleMoney;
dr["m_dblInAmount"] = accountVO[i].m_dblInAmount;
dr["m_dblInCallMoney"] = accountVO[i].m_dblInCallMoney;
dr["m_dblInRetailMoney"] = accountVO[i].m_dblInRetailMoney;
dr["m_dblInWholesaleMoney"] = accountVO[i].m_dblInWholesaleMoney;
dr["m_dblOutAmount"] = accountVO[i].m_dblOutAmount;
dr["m_dblOutCallMoney"] = accountVO[i].m_dblOutCallMoney;
dr["m_dblOutRetailMoney"] = accountVO[i].m_dblOutRetailMoney;
dr["m_dblOutWholesaleMoney"] = accountVO[i].m_dblOutWholesaleMoney;
dr["m_dblEndAmount"] = accountVO[i].m_dblEndAmount;
dr["m_dblEndCallMoney"] = accountVO[i].m_dblEndCallMoney;
dr["m_dblEndRetailMoney"] = accountVO[i].m_dblEndRetailMoney;
dr["m_dblEndWholesaleMoney"] = accountVO[i].m_dblEndWholesaleMoney;
m_objViewer.m_dtbAccou.Rows.Add(dr);
}
}
m_objViewer.datWindow.LibraryList = clsPublic.PBLPath;
m_objViewer.datWindow.DataWindowObject = "ms_account_Detail2";
string strStoreRoomName;
m_objDomain.m_lngGetStoreRoomName(m_objViewer.m_strStorageID, out strStoreRoomName);
m_objViewer.datWindow.Modify("t_storage.text='" + strStoreRoomName + "'");
m_objViewer.datWindow.Modify("t_22.text='" + m_objViewer.m_dtpBeginDate.Text + "到" + m_objViewer.m_dtpEndDate.Text + "'");
DataView dtv = new DataView();
dtv = m_objViewer.m_dtbAccou.DefaultView;
dtv.Sort = "m_dbloutamount desc";
m_objViewer.m_dtbAccou = dtv.ToTable();
m_objViewer.datWindow.SetRedrawOff();
m_objViewer.datWindow.Retrieve(m_objViewer.m_dtbAccou);
m_objViewer.datWindow.SetRedrawOn();
m_objViewer.datWindow.Refresh();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
finally
{
m_objViewer.Cursor = Cursors.Default;
}
}
/// <summary>
/// 统计入库
/// </summary>
internal void m_mthStatistics()
{
DateTime dtmBegin = DateTime.Parse(Convert.ToDateTime(m_objViewer.m_dtpBeginDate.Text).ToString("yyyy-MM-dd 00:00:00"));
DateTime dtmEnd = DateTime.Parse(Convert.ToDateTime(m_objViewer.m_dtpEndDate.Text).ToString("yyyy-MM-dd 23:59:59"));
this.m_objViewer.m_dwcData.Modify("begindate.text = '" + dtmBegin.ToString("yyyy-MM-dd") + "'");
this.m_objViewer.m_dwcData.Modify("enddate.text = '" + dtmEnd.ToString("yyyy-MM-dd") + "'");
m_mthSetStorageNameToReport();
string strVendorID = string.Empty;
if (m_objViewer.m_txtVendor.Tag != null && !string.IsNullOrEmpty(m_objViewer.m_txtVendor.Text))
{
strVendorID = m_objViewer.m_txtVendor.Tag.ToString();
}
int intSetID = 0;
if (m_objViewer.m_cboType.SelectedItem != null)
{
clsMS_MedicineTypeSetVO objSet = m_objViewer.m_cboType.SelectedItem as clsMS_MedicineTypeSetVO;
if (objSet != null)
{
intSetID = objSet.m_intMedicineTypeSetID;
}
}
DataTable dtbData = null;
long lngRes = m_objDomain.m_lngStatistics(m_objViewer.m_strStorageID, dtmBegin, dtmEnd, strVendorID, intSetID, out dtbData);
DataTable dtbForeignRetreat = null;
if (m_objViewer.m_chkStatOut.Checked)
{
lngRes = m_objDomain.m_lngStatisticsForeignRetreat(m_objViewer.m_strStorageID, dtmBegin, dtmEnd, strVendorID, intSetID, out dtbForeignRetreat);
}
if ((dtbData == null || dtbData.Rows.Count == 0) && (dtbForeignRetreat == null || dtbForeignRetreat.Rows.Count == 0))
{
m_objViewer.m_dwcData.Reset();
return;
}
//合并入库统计及外退统计
DataTable dtbStatistics = m_dtbMergeStatisticsData(dtbData, dtbForeignRetreat);
if (dtbStatistics != null)
{
this.m_objViewer.m_dwcData.SetRedrawOff();
//按药品ID排序
int intTaxis;
DataView dtv = new DataView();
dtv = dtbStatistics.DefaultView;
m_objDomain.m_lngGetTaxisType(out intTaxis);
if (intTaxis == 0)
{
dtv.Sort = "vendorname_vchr";
}
else
{
dtv.Sort = "usercode_chr";
}
dtbStatistics = dtv.ToTable();
this.m_objViewer.m_dwcData.Retrieve(dtbStatistics);
this.m_objViewer.m_dwcData.SetRedrawOn();
this.m_objViewer.m_dwcData.Refresh();
}
}
/// <summary>
/// 获取药品明细帐表
/// </summary>
internal void m_mthGetMedicineDetailReport()
{
m_objViewer.m_dtbAccou.Clear();
if (m_objViewer.m_txtAccountID.Text.Trim() == "")
{
MessageBox.Show("请先选择帐期。", "药品明细帐表", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (m_objViewer.m_txtMedicine.Text.Trim() != "")
{
if (m_objViewer.m_txtAccountID.Text.Trim() == "未结转")
{
m_objDomain.m_lngGetMedicineTotalAccountNoAcc(m_objViewer.m_strStorageID, m_objViewer.m_txtMedicine.Tag.ToString(), m_objViewer.AccouVO.m_dtmSTARTTIME_DAT,
m_objViewer.AccouVO.m_dtmENDTIME_DAT, m_objViewer.m_strLastStorageID, m_objViewer.AccouVO.m_strACCOUNTID_CHR, out accountMedicineVO);
}
else
{
m_objDomain.m_lngGetMedicineTotalAccount(m_objViewer.m_strStorageID, m_objViewer.m_txtMedicine.Tag.ToString(), m_objViewer.AccouVO.m_dtmSTARTTIME_DAT,
m_objViewer.AccouVO.m_dtmENDTIME_DAT, m_objViewer.m_strLastStorageID, m_objViewer.AccouVO.m_strACCOUNTID_CHR, out accountMedicineVO);
}
}
else if ((m_objViewer.m_cboMedicineType.SelectedIndex >= 0) && (m_objViewer.m_cboMedicineType.Text != "全部"))
{
if (m_objViewer.m_txtAccountID.Text.Trim() == "未结转")
{
clsMS_MedicineTypeSetVO objMPVO = new clsMS_MedicineTypeSetVO();
objMPVO = (clsMS_MedicineTypeSetVO)m_objViewer.m_cboMedicineType.Items[m_objViewer.m_cboMedicineType.SelectedIndex];
m_objDomain.m_lngGetMedicineTypeAccountNoAcc(m_objViewer.m_strStorageID, objMPVO.m_intMedicineTypeSetID.ToString(), m_objViewer.AccouVO.m_dtmSTARTTIME_DAT,
m_objViewer.AccouVO.m_dtmENDTIME_DAT, m_objViewer.m_strLastStorageID, m_objViewer.AccouVO.m_strACCOUNTID_CHR, out accountVO);
}
else
{
clsMS_MedicineTypeSetVO objMPVO = new clsMS_MedicineTypeSetVO();
objMPVO = (clsMS_MedicineTypeSetVO)m_objViewer.m_cboMedicineType.Items[m_objViewer.m_cboMedicineType.SelectedIndex];
m_objDomain.m_lngGetMedicineTypeAccount(m_objViewer.m_strStorageID, objMPVO.m_intMedicineTypeSetID.ToString(), m_objViewer.AccouVO.m_dtmSTARTTIME_DAT,
m_objViewer.AccouVO.m_dtmENDTIME_DAT, m_objViewer.m_strLastStorageID, m_objViewer.AccouVO.m_strACCOUNTID_CHR, out accountVO);
}
}
else
{
if (m_objViewer.m_txtAccountID.Text.Trim() == "未结转")
{
m_objDomain.m_lngGetAllMedicineDetailAccountNoAcc(m_objViewer.m_strStorageID, m_objViewer.AccouVO.m_dtmSTARTTIME_DAT,
m_objViewer.AccouVO.m_dtmENDTIME_DAT, m_objViewer.m_strLastStorageID, m_objViewer.AccouVO.m_strACCOUNTID_CHR, out accountVO);
}
else
{
m_objDomain.m_lngGetAllMedicineDetailAccount(m_objViewer.m_strStorageID, m_objViewer.AccouVO.m_dtmSTARTTIME_DAT,
m_objViewer.AccouVO.m_dtmENDTIME_DAT, m_objViewer.m_strLastStorageID, m_objViewer.AccouVO.m_strACCOUNTID_CHR, out accountVO);
}
}
if ((m_objViewer.m_txtMedicine.Tag == null) && (accountVO == null || accountVO.Length == 0))
{
MessageBox.Show("抱歉，没有查到该期药品明细帐数据。", "药品明细帐表", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
m_objViewer.datWindow.Reset();
return;
}
//m_objViewer.m_dtbAccou.Columns.Add("medicinename_vch", typeof(System.String));
//m_objViewer.m_dtbAccou.Columns.Add("m_dblbeginwholesalemoney", typeof(System.Double));
//m_objViewer.m_dtbAccou.Columns.Add("m_dblbeginretailmoney", typeof(System.Double));
//m_objViewer.m_dtbAccou.Columns.Add("m_dblincallmoney", typeof(System.Double));
//m_objViewer.m_dtbAccou.Columns.Add("m_dblinwholesalemoney", typeof(System.Double));
//m_objViewer.m_dtbAccou.Columns.Add("m_dblinretailmoney", typeof(System.Double));
//m_objViewer.m_dtbAccou.Columns.Add("m_dbloutwholesalemoney", typeof(System.Double));
//m_objViewer.m_dtbAccou.Columns.Add("m_dbloutretailmoney", typeof(System.Double));
//m_objViewer.m_dtbAccou.Columns.Add("m_dblendwholesalemoney", typeof(System.Double));
//m_objViewer.m_dtbAccou.Columns.Add("m_dblendretailmoney", typeof(System.Double));
//m_objViewer.m_dtbAccou.Columns.Add("m_dblBeginAmount", typeof(System.Double));
//m_objViewer.m_dtbAccou.Columns.Add("m_dblinAmount", typeof(System.Double));
//m_objViewer.m_dtbAccou.Columns.Add("m_dbloutAmount", typeof(System.Double));
//m_objViewer.m_dtbAccou.Columns.Add("m_dblendAmount", typeof(System.Double));
//m_objViewer.m_dtbAccou.Columns.Add("m_dblBeginCallMoney", typeof(System.Double));
//m_objViewer.m_dtbAccou.Columns.Add("m_dblOutCallMoney", typeof(System.Double));
//m_objViewer.m_dtbAccou.Columns.Add("m_dblEndCallMoney", typeof(System.Double));
if (m_objViewer.m_txtMedicine.Text.Trim() != "")
{
if (accountMedicineVO == null)
{
MessageBox.Show("抱歉，没有查到该药品明细帐数据。", "药品明细帐表", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
m_objViewer.datWindow.Reset();
return;
}
DataRow dr = m_objViewer.m_dtbAccou.NewRow();
dr[0] = accountMedicineVO.m_strMedicineName;
dr[1] = accountMedicineVO.m_dblBeginWholesaleMoney;
dr[2] = accountMedicineVO.m_dblBeginRetailMoney;
dr[3] = accountMedicineVO.m_dblInCallMoney;
dr[4] = accountMedicineVO.m_dblInWholesaleMoney;
dr[5] = accountMedicineVO.m_dblInRetailMoney;
dr[6] = accountMedicineVO.m_dblOutWholesaleMoney;
dr[7] = accountMedicineVO.m_dblOutRetailMoney;
dr[8] = accountMedicineVO.m_dblEndWholesaleMoney;
dr[9] = accountMedicineVO.m_dblEndRetailMoney;
dr[10] = accountMedicineVO.m_dblBeginAmount;
dr[11] = accountMedicineVO.m_dblInAmount;
dr[12] = accountMedicineVO.m_dblOutAmount;
dr[13] = accountMedicineVO.m_dblEndAmount;
dr[14] = accountMedicineVO.m_dblBeginCallMoney;
dr[15] = accountMedicineVO.m_dblOutCallMoney;
dr[16] = accountMedicineVO.m_dblEndCallMoney;
m_objViewer.m_dtbAccou.Rows.Add(dr);
}
else
{
for (int i = 0; i < accountVO.Length; i++)
{
DataRow dr = m_objViewer.m_dtbAccou.NewRow();
dr[0] = accountVO[i].m_strMedicineName;
dr[1] = accountVO[i].m_dblBeginWholesaleMoney;
dr[2] = accountVO[i].m_dblBeginRetailMoney;
dr[3] = accountVO[i].m_dblInCallMoney;
dr[4] = accountVO[i].m_dblInWholesaleMoney;
dr[5] = accountVO[i].m_dblInRetailMoney;
dr[6] = accountVO[i].m_dblOutWholesaleMoney;
dr[7] = accountVO[i].m_dblOutRetailMoney;
dr[8] = accountVO[i].m_dblEndWholesaleMoney;
dr[9] = accountVO[i].m_dblEndRetailMoney;
dr[10] = accountVO[i].m_dblBeginAmount;
dr[11] = accountVO[i].m_dblInAmount;
dr[12] = accountVO[i].m_dblOutAmount;
dr[13] = accountVO[i].m_dblEndAmount;
dr[14] = accountVO[i].m_dblBeginCallMoney;
dr[15] = accountVO[i].m_dblOutCallMoney;
dr[16] = accountVO[i].m_dblEndCallMoney;
m_objViewer.m_dtbAccou.Rows.Add(dr);
}
}
m_objViewer.datWindow.LibraryList = clsPublic.PBLPath;
m_objViewer.datWindow.DataWindowObject = "ms_account_Detail";
string strStoreRoomName;
m_objDomain.m_lngGetStoreRoomName(m_objViewer.m_strStorageID, out strStoreRoomName);
m_objViewer.datWindow.Modify("t_storage.text='" + strStoreRoomName + "'");
DataView dtv = new DataView();
dtv = m_objViewer.m_dtbAccou.DefaultView;
dtv.Sort = "m_dbloutamount desc";
m_objViewer.m_dtbAccou = dtv.ToTable();
m_objViewer.datWindow.SetRedrawOff();
m_objViewer.datWindow.Retrieve(m_objViewer.m_dtbAccou);
m_objViewer.datWindow.SetRedrawOn();
m_objViewer.datWindow.Refresh();
}
