/// <summary>
/// 制单时获取出库明细数据
/// </summary>
/// <param name="objvalue_Param">查询条件D</param>
/// <param name="dtbResult">结果集</param>
/// <returns></returns>
internal long m_lngGetOutStorageDetailData_MakerBill(ref clsMs_MedicineWithdrawOutStorageQueryCondition_VO objvalue_Param, ref DataTable dtbResult)
{
long lngRes = 0;
com.digitalwave.iCare.middletier.MedicineStoreService.clsMiddletier_InStorageMedicineWithdrawSVC objSvc =
(com.digitalwave.iCare.middletier.MedicineStoreService.clsMiddletier_InStorageMedicineWithdrawSVC)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.MedicineStoreService.clsMiddletier_InStorageMedicineWithdrawSVC));
lngRes = objSvc.m_lngGetOutStorageDetailData_MadkerBill(objPrincipal, ref objvalue_Param, ref dtbResult);
return(lngRes);
}
/// <summary>
/// 获取药品出库主表数据
/// </summary>
/// <param name="objvalue_Param">查询条件</param>
/// <param name="dtbResult">结果集</param>
/// <returns></returns>
public long m_mthGetOutStorageMainData(ref clsMs_MedicineWithdrawOutStorageQueryCondition_VO objvalue_Param, out DataTable dtbResult)
{
long lngRes = 0;
try
{
//调用Com+服务端
DataTable Query_dtbResult = new DataTable();//数据库返回的结果集
lngRes = m_objDomain.m_lngGetOutStorageMainData(ref objvalue_Param, ref Query_dtbResult);
if (lngRes > 0)
{
DataColumn[] drColumns = new DataColumn[] { new DataColumn("SortNum") };
Query_dtbResult.Columns.AddRange(drColumns);
DataRow m_dtbResultRow = null;
for (int i1 = 0; i1 < Query_dtbResult.Rows.Count; i1++)
{
m_dtbResultRow = Query_dtbResult.Rows[i1];
m_dtbResultRow["SortNum"] = i1 + 1;
}
Query_dtbResult.AcceptChanges();
dtbResult = Query_dtbResult;
}
else
{
dtbResult = null;
}
return(lngRes);
}//try
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
MessageBox.Show("查询失败！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
dtbResult = null;
return(lngRes);
}
/// <summary>
/// 获取出库明细数据
/// </summary>
private void m_mthGetOutStorageDetailDate()
{
long lngRes = 0;
if ((m_dtbOutStorageDetail != null) && (m_dtbOutStorageDetail.Rows.Count > 0))
{
m_dtbOutStorageDetail.Rows.Clear();
}
int m_intSn = 0;
int m_intRowIndex = 0;
clsMs_MedicineWithdrawOutStorageQueryCondition_VO objvalue_Param = new clsMs_MedicineWithdrawOutStorageQueryCondition_VO();
m_dtbOutStorageDetail = null;
//m_dgvSubInfo.DataSource = "";
if (m_rdbOutStorageID.Checked)
{
objvalue_Param.m_strStorageID = m_strStorageID;
objvalue_Param.m_strASKDEPT_CHR = m_strWithdrawDeptID;
objvalue_Param.m_strOutStorageID = m_txtOutStorageID.Text.Trim();
objvalue_Param.m_strMedicineID = string.Empty;
objvalue_Param.m_strLotNo = string.Empty;
}
else
{
objvalue_Param.m_strStorageID = m_strStorageID;
objvalue_Param.m_strASKDEPT_CHR = m_strWithdrawDeptID;
objvalue_Param.m_strOutStorageID = string.Empty;
objvalue_Param.m_strMedicineID = m_objMedicineBase.m_strMedicineID;
objvalue_Param.m_strLotNo = m_txtLotNo.Text.Trim();
}
lngRes = ((clsCtl_InMedicineWithdrawOutStorageInfo)objController).m_mthGetOutStorageDetailData(ref objvalue_Param);
if (lngRes > 0)
{
m_dgvSubInfo.DataSource = m_dtbOutStorageDetail;
m_mthCheckAvailAmount();
}
}
/// <summary>
/// 获取出库主表数据
/// </summary>
public void m_mthGetOutStorageData()
{
long lngRes = 0;
m_dtbOutStorageMain = null;
m_dtbOutStorageDetail = null;
m_dgvMainInfo.DataSource = "";
m_dgvSubInfo.DataSource = "";
if (m_value_Param == null)
{
m_value_Param = new clsMs_MedicineWithdrawOutStorageQueryCondition_VO();
}
m_value_Param.m_strQueryBeginDate = string.Empty;
m_value_Param.m_strQueryEndDate = string.Empty;
m_value_Param.m_strStorageID = string.Empty;
m_value_Param.m_strOutStorageID = string.Empty;
m_value_Param.m_intOutStorageType = 0;
m_value_Param.m_strMedicineID = string.Empty;
m_value_Param.m_strLotNo = string.Empty;
if ((m_dtpSearchBeginDate.Text.Trim().Length == 11) && (m_dtpSearchEndDate.Text.Trim().Length == 11))
{
if ((Convert.ToDateTime(m_dtpSearchBeginDate.Text)) > (Convert.ToDateTime(m_dtpSearchEndDate.Text)))
{
MessageBox.Show("开始日期必须小于或等于结束日期！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Stop);
m_dtpSearchBeginDate.Focus();
return;
}
}
if (m_dtpSearchBeginDate.Text.Trim().Length == 11)
{
string strDate = m_dtpSearchBeginDate.Text;
m_value_Param.m_strQueryBeginDate = Convert.ToDateTime(strDate).ToString("yyyy-MM-dd 00:00:00");
}
if (m_dtpSearchEndDate.Text.Trim().Length == 11)
{
string strDate = m_dtpSearchEndDate.Text;
m_value_Param.m_strQueryEndDate = Convert.ToDateTime(strDate).ToString("yyyy-MM-dd 23:59:59");
}
//仓库ID
m_value_Param.m_strStorageID = m_strStorageID;
//出库单号
m_value_Param.m_strOutStorageID = m_txtOutStorageBillNo.Text.Trim();
//药品批号
m_value_Param.m_strLotNo = m_txtLotNo.Text.Trim();
//药品代码
if (m_txtMedicineName.Text.Trim().Length == 0)
{
m_value_Param.m_strMedicineID = string.Empty;
}
else
{
m_value_Param.m_strMedicineID = m_objMedicineBase.m_strMedicineID;
}
//出库类型
if (m_cboOutStorageType.Text.Trim() == "全部")
{
m_value_Param.m_intOutStorageType = 0;
}
else
{
if (m_cboOutStorageType.Text.Trim() == "领药出库")
{
m_value_Param.m_intOutStorageType = 1;
}
else if (m_cboOutStorageType.Text.Trim() == "销售出库")
{
m_value_Param.m_intOutStorageType = 2;
}
else
{
m_value_Param.m_intOutStorageType = -1;
}
}
//单据类型
m_value_Param.m_intFormType = 1;
//单据状态
m_value_Param.m_intStatus = 2;
//出库部门
m_value_Param.m_strASKDEPT_CHR = m_strWithdrawDeptID;
//lngRes = m_objMedicineWithdrawCtl.m_mthGetOutStorageMainData(ref m_value_Param, out m_dtbOutStorageMain);
lngRes = ((clsCtl_MedicWithdrawCallOutStorage)objController).m_mthGetOutStorageMainData(ref m_value_Param, out m_dtbOutStorageMain);
if (lngRes > 0)
{
m_dgvMainInfo.DataSource = m_dtbOutStorageMain;
}
}
/// <summary>
/// 获取药品出库明细数据
/// </summary>
/// <param name="p_strStorageID"></param>
/// <param name="dtbResult"></param>
/// <returns></returns>
public long m_mthGetOutStorageDetailData(ref clsMs_MedicineWithdrawOutStorageQueryCondition_VO objvalue_Param)
{
long lngRes = 0;
decimal m_decNetAmount = 0; //出库数量
int m_intMedicineWithdrawNum = 0; //退药次数
decimal m_decMedicineWithdrawSum = 0;//已退药数量
decimal m_decAvailAmount = 0;//可退数量
try
{
//调用Com+服务端
DataTable Query_dtbResult = new DataTable();//数据库返回的结果集
lngRes = m_objDomain.m_lngGetOutStorageDetailData_MakerBill(ref objvalue_Param, ref Query_dtbResult);
if (lngRes > 0)
{
DataColumn[] drColumns = new DataColumn[] {
new DataColumn("SortNum", typeof(int)),
new DataColumn("ReturnAmount", typeof(decimal)),
new DataColumn("AvailAmount", typeof(decimal)),
new DataColumn("AMOUNT", typeof(decimal)),
new DataColumn("AVAILAGROSS_INT", typeof(decimal)),
//new DataColumn("validperiod_dat") ,
new DataColumn("ReturnNum", typeof(int))
};
Query_dtbResult.Columns.AddRange(drColumns);
DataRow m_dtbResultRow = null;
DataRow m_dtbCancelDetailRow = null;
m_objMedicineWithdrawNumCondition = new clsMs_MedicineWithdrawNumQueryCondition_VO();
for (int i1 = 0; i1 < Query_dtbResult.Rows.Count; i1++)
{
m_dtbResultRow = Query_dtbResult.Rows[i1];
m_dtbResultRow["SortNum"] = i1 + 1;
m_objMedicineWithdrawNumCondition.m_strStorageID = m_dtbResultRow["STORAGEID_CHR"].ToString();
m_objMedicineWithdrawNumCondition.m_strMedicineID = m_dtbResultRow["MEDICINEID_CHR"].ToString();
m_objMedicineWithdrawNumCondition.m_strLotNo = m_dtbResultRow["LOTNO_VCHR"].ToString();
m_objMedicineWithdrawNumCondition.m_strOutStorageID = m_dtbResultRow["OUTSTORAGEID_VCHR"].ToString();
m_objMedicineWithdrawNumCondition.m_strInStorageID = string.Empty;
////退药次数
//m_objDomain.m_lngGetMedicineWithdrawNum(ref m_objMedicineWithdrawNumCondition, out m_intMedicineWithdrawNum);
//m_dtbResultRow["ReturnNum"] = m_intMedicineWithdrawNum;
//出库数量
decimal.TryParse(m_dtbResultRow["NETAMOUNT_INT"].ToString(), out m_decNetAmount);
//已退药数量
m_dtbResultRow["ReturnAmount"] = 0;
//可退数量
m_dtbResultRow["AvailAmount"] = m_decNetAmount;
//退药数量
m_dtbResultRow["Amount"] = 0;
//内退次数
m_dtbResultRow["ReturnNum"] = 0;
//药品当前库存
m_dtbResultRow["AVAILAGROSS_INT"] = m_dtbResultRow["realgross_int"];
//m_dtbResultRow["validperiod_dat"] = m_dtbResultRow["validperiod_dat"];
//m_decAvailAmount = 0;
//for (int j1 = 0; j1 < m_dtbMedicineCancelDetail.Rows.Count; j1++)
//{
// m_dtbCancelDetailRow = m_dtbMedicineCancelDetail.Rows[j1];
// if ((m_dtbCancelDetailRow["MEDICINEID_CHR"].ToString().Trim() == m_objMedicineWithdrawNumCondition.m_strMedicineID)
// && (m_dtbCancelDetailRow["OUTSTORAGEID_VCHR"].ToString().Trim() == m_objMedicineWithdrawNumCondition.m_strOutStorageID)
// && (m_dtbCancelDetailRow["LOTNO_VCHR"].ToString().Trim() == m_objMedicineWithdrawNumCondition.m_strLotNo))
// {
// decimal.TryParse(m_dtbCancelDetailRow["Amount"].ToString(), out m_decAvailAmount);
// break;
// }
//}
}
Query_dtbResult.AcceptChanges();
//已退药数量
m_objMedicineWithdrawNumCondition.m_strStorageID = objvalue_Param.m_strStorageID;
m_objMedicineWithdrawNumCondition.m_strOutStorageID = objvalue_Param.m_strOutStorageID;
m_objMedicineWithdrawNumCondition.m_strInStorageID = string.Empty;
m_mthGetInnerWithdrawNum(m_objMedicineWithdrawNumCondition, ref Query_dtbResult);
m_objViewer.m_dtbOutStorageDetail = Query_dtbResult;
}
else
{
m_objViewer.m_dtbOutStorageDetail = null;
}
return(lngRes);
}//try
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
MessageBox.Show("查询失败！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
m_objViewer.m_dtbOutStorageDetail = null;
return(lngRes);
}
