/// <summary>
/// 保存库存明细和修改记录
/// </summary>
/// <param name="objHistory"></param>
/// <returns></returns>
internal long m_lngSaveAmount(clsDS_StorageHistory_VO objHistory)
{
long lngRes = 0;
com.digitalwave.iCare.middletier.HIS.clsDrugStorageQuery_SVC objSvc =
(com.digitalwave.iCare.middletier.HIS.clsDrugStorageQuery_SVC)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.HIS.clsDrugStorageQuery_SVC));
lngRes = objSvc.m_lngSaveAmount(objPrincipal, objHistory);
return(lngRes);
}
/// <summary>
/// 根据ID获取库存明细表的资料
/// </summary>
/// <param name="p_intSeriesID"></param>
/// <param name="objHistory"></param>
/// <returns></returns>
internal long m_lngGetAmountBySeriesID(long p_intSeriesID, out clsDS_StorageHistory_VO p_objHistory)
{
long lngRes = 0;
com.digitalwave.iCare.middletier.HIS.clsDrugStorageQuery_Supported_SVC objSvc =
(com.digitalwave.iCare.middletier.HIS.clsDrugStorageQuery_Supported_SVC)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.HIS.clsDrugStorageQuery_Supported_SVC));
lngRes = objSvc.m_lngGetAmountBySeriesID(objPrincipal, p_intSeriesID, out p_objHistory);
return(lngRes);
}
private void m_dgvDrugStorage_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (m_dgvDrugStorage.CurrentCell == null)
{
return;
}
if (m_intCanModifyAmount == 1 && e.ColumnIndex == m_dgvDrugStorage.Columns["colIPAvailaGross"].Index && m_rdbDetail.Checked == true)
{
frmEditAvailableStorage frmEAS = new frmEditAvailableStorage();
frmEAS.OnSaveAmount += new OnSave(frmEAS_OnSaveAmount);
DataRow drvSelectedRow = ((DataRowView)(m_dgvDrugStorage.CurrentCell.OwningRow.DataBoundItem)).Row;
frmEAS.m_strMedicineID = drvSelectedRow["medicineid_chr"].ToString();
frmEAS.m_intOPChargeFlage = Convert.ToInt16(drvSelectedRow["opchargeflg_int"]);
frmEAS.m_intIPChargeFlage = Convert.ToInt16(drvSelectedRow["ipchargeflg_int"]);
frmEAS.m_dblPackQty = Convert.ToDouble(drvSelectedRow["packqty_dec"]);
frmEAS.m_txtMedicineName.Text = drvSelectedRow["MEDICINENAME_VCHR"].ToString();
frmEAS.m_txtLotno.Text = drvSelectedRow["LOTNO_VCHR"].ToString();
frmEAS.m_txtUnit.Text = drvSelectedRow["unit_chr"].ToString();
frmEAS.m_blnIsHospital = m_blnHospital;
clsDS_StorageHistory_VO objHistory = null;
((clsCtl_DrugStorageQuery)objController).m_lngGetAmountBySeriesID(Convert.ToInt64(drvSelectedRow["seriesid_int"]), out objHistory);
objHistory.m_strMODIFYUSERID_CHR = LoginInfo.m_strEmpID;
if (m_blnHospital)
{
if (frmEAS.m_intIPChargeFlage == 0)
{
frmEAS.m_txtOldAmount.Text = objHistory.m_dblOPAVAILABLEGROSS_NUM.ToString();
}
else
{
frmEAS.m_txtOldAmount.Text = objHistory.m_dblIPAVAILABLEGROSS_NUM.ToString();
}
}
else
{
if (frmEAS.m_intOPChargeFlage == 0)
{
frmEAS.m_txtOldAmount.Text = objHistory.m_dblOPAVAILABLEGROSS_NUM.ToString();
}
else
{
frmEAS.m_txtOldAmount.Text = objHistory.m_dblIPAVAILABLEGROSS_NUM.ToString();
}
}
frmEAS.m_objHistory = objHistory;
if (frmEAS.ShowDialog() == DialogResult.None)
{
frmEAS.Visible = true;
}
}
}
public long m_lngGetAmountBySeriesID(System.Security.Principal.IPrincipal p_objPrincipal, long p_intSeriesID, out clsDS_StorageHistory_VO p_objHistory)
{
p_objHistory = new clsDS_StorageHistory_VO();
long lngRes = 0;
try
{
DataTable m_dtbTemp = new DataTable();
clsHRPTableService objHRPServ = new clsHRPTableService();
IDataParameter[] objParamArr = null;
string strSQL = @"select a.opavailablegross_num,
a.ipavailablegross_num,
a.opunit_chr,
a.ipunit_chr,
a.drugstoreid_chr,
a.medicineid_chr
from t_ds_storage_detail a
where a.seriesid_int = ?";
objHRPServ.CreateDatabaseParameter(1, out objParamArr);
objParamArr[0].Value = p_intSeriesID;
objHRPServ.lngGetDataTableWithParameters(strSQL, ref m_dtbTemp, objParamArr);
if (m_dtbTemp != null && m_dtbTemp.Rows.Count > 0)
{
p_objHistory.m_lngSERIESID2_INT = p_intSeriesID;
p_objHistory.m_dblOPAVAILABLEGROSS_NUM = Convert.ToDouble(m_dtbTemp.Rows[0]["opavailablegross_num"]);
p_objHistory.m_dblIPAVAILABLEGROSS_NUM = Convert.ToDouble(m_dtbTemp.Rows[0]["ipavailablegross_num"]);
p_objHistory.m_strOPUNIT_CHR = m_dtbTemp.Rows[0]["opunit_chr"].ToString();
p_objHistory.m_strIPUNIT_CHR = m_dtbTemp.Rows[0]["ipunit_chr"].ToString();
p_objHistory.m_strDRUGSTOREID_CHR = m_dtbTemp.Rows[0]["drugstoreid_chr"].ToString();
p_objHistory.m_strMEDICINEID_CHR = m_dtbTemp.Rows[0]["medicineid_chr"].ToString();
}
objHRPServ.Dispose();
objHRPServ = null;
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
void frmEAS_OnSaveAmount(clsDS_StorageHistory_VO objHistory)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (((clsCtl_DrugStorageQuery)objController).m_lngSaveAmount(objHistory) > 0)
{
((clsCtl_DrugStorageQuery)objController).m_mthQuery();
((clsCtl_DrugStorageQuery)objController).m_mthBindStorageRack();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Cursor = Cursors.Default;
}
}
public long m_lngSaveAmount(System.Security.Principal.IPrincipal p_objPrincipal, clsDS_StorageHistory_VO p_objHistory)
{
long lngRes = 0;
try
{
string strSQL = @"update t_ds_storage_detail a
set a.opavailablegross_num = ?,a.ipavailablegross_num = ? where a.seriesid_int = ?" ;
clsHRPTableService objHRPServ = new clsHRPTableService();
IDataParameter[] objDPArr = null;
objHRPServ.CreateDatabaseParameter(3, out objDPArr);
objDPArr[0].Value = p_objHistory.m_dblNEWOPAVAILABLEGROSS_NUM;
objDPArr[1].Value = p_objHistory.m_dblNEWIPAVAILABLEGROSS_NUM;
objDPArr[2].Value = p_objHistory.m_lngSERIESID2_INT;
long lngEff = -1;
lngRes = objHRPServ.lngExecuteParameterSQL(strSQL, ref lngEff, objDPArr);
//保存修改可用库存的log
if (lngRes > 0)
{
strSQL = @"insert into t_ds_storagedetail_history a
(a.seriesid_int,
a.seriesid2_int,
a.drugstoreid_chr,
a.ipavailablegross_num,
a.newipavailablegross_num,
a.ipunit_chr,
a.opavailablegross_num,
a.newopavailablegross_num,
a.opunit_chr,
a.modifydate_dat,
a.modifyuserid_chr,a.medicineid_chr)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?, sysdate, ?,?)";
clsDS_Public_Supported_SVC objPubSvc = new clsDS_Public_Supported_SVC();
long[] lngSEQArr = null;
objPubSvc.m_lngGetSequenceArr(p_objPrincipal, "SEQ_T_DS_STORAGEDETAIL_HISTORY", 1, out lngSEQArr);
objDPArr = null;
objHRPServ.CreateDatabaseParameter(11, out objDPArr);
objDPArr[0].Value = lngSEQArr[0];
objDPArr[1].Value = p_objHistory.m_lngSERIESID2_INT;
objDPArr[2].Value = p_objHistory.m_strDRUGSTOREID_CHR;
objDPArr[3].Value = p_objHistory.m_dblIPAVAILABLEGROSS_NUM;
objDPArr[4].Value = p_objHistory.m_dblNEWIPAVAILABLEGROSS_NUM;
objDPArr[5].Value = p_objHistory.m_strIPUNIT_CHR;
objDPArr[6].Value = p_objHistory.m_dblOPAVAILABLEGROSS_NUM;
objDPArr[7].Value = p_objHistory.m_dblNEWOPAVAILABLEGROSS_NUM;
objDPArr[8].Value = p_objHistory.m_strOPUNIT_CHR;
objDPArr[9].Value = p_objHistory.m_strMODIFYUSERID_CHR;
objDPArr[10].Value = p_objHistory.m_strMEDICINEID_CHR;
lngEff = -1;
lngRes = objHRPServ.lngExecuteParameterSQL(strSQL, ref lngEff, objDPArr);
}
objHRPServ.Dispose();
objHRPServ = null;
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
