/// <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); }