private void ChargeVoToOCDVo(clsBIHPatientCharge objCharge, ref clsORDERCHARGEDEPT_VO objItem)
{
objItem.m_decAmount_dec = objCharge.m_dmlAmount;
objItem.m_decUnitprice_dec = objCharge.m_dmlUnitPrice;
objItem.m_strChargeitemid_chr = objCharge.m_strChargeItemID;
objItem.m_strChargeitemname_chr = objCharge.m_strChargeItemName;
objItem.m_strClacarea_chr = objCharge.m_strClacArea;
objItem.m_strCreatearea_chr = objCharge.m_strCreateArea;
objItem.m_strCreatedate_dat = objCharge.m_dtCreateDate;
objItem.m_strCreator_vchr = LoginInfo.m_strEmpName;
objItem.m_strCreatorid_chr = LoginInfo.m_strEmpID;
objItem.m_strOrderdicid_chr = m_objExecOrder.m_strOrderDicID;
objItem.m_strOrderid_chr = m_objExecOrder.m_strOrderID;
objItem.m_strSeq_int = m_strSeq_int;
objItem.m_strSpec_vchr = m_txtSpec.Text.Trim();
objItem.m_strUnit_vchr = objCharge.m_strUnit;
objItem.REMARK = m_txtDes.Text.ToString().Trim();
//续用类型
objItem.m_intCONTINUEUSETYPE_INT = clsConverter.ToInt(this.m_cboCONTINUEUSETYPE_INT.m_strGetID(this.m_cboCONTINUEUSETYPE_INT.SelectedIndex));
objItem.m_strINSURACEDESC_VCHR = objCharge.m_strINSURACEDESC_VCHR;
//补次的一次的剂量
objItem.m_decSINGLEAMOUNT_DEC = objItem.m_decAmount_dec;
if (objItem.m_strClacarea_chr.ToString().Equals(""))
{
objItem.m_strClacarea_chr = this.LoginInfo.m_strInpatientAreaID;
}
}
//修改
public bool m_mthModify(clsBIHPatientCharge objCharge)
{
if (objCharge == null)
{
return(false);
}
m_intStatus = 2;
clsBIHChargeItem objItem;
long ret = m_objService.m_lngGetChargeItem(objCharge.m_strChargeItemID, out objItem);
if (ret > 0)
{
m_mthShowChargeItem(objItem);
}
else
{
return(false);
}
m_objTempCharge = objCharge;
m_txtGet.Text = objCharge.m_dmlAmount.ToString();
m_txtDiscount.Text = objCharge.m_dmlDiscount.ToString();
m_txtUnitPrice.Text = objCharge.m_dmlUnitPrice.ToString(); //当时的单价
m_txtDes.Text = objCharge.m_strDes;
if (this.ShowDialog() == DialogResult.OK)
{
return(true);
}
else
{
return(false);
}
}
public frmChargeItem(clsBIHPatientCharge m_objCharge, clsBIHExecOrder objExecOrder, string strDoctorID)
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
//m_objService = new clsBIHChargeItemService();
m_objService = new clsDcl_GetSvcObject().m_GetBIHChargeItemSvc();
m_objExecOrder = objExecOrder;
m_txtBedNo.Text = objExecOrder.m_strBedName;
m_txtPatientName.Text = objExecOrder.m_strPatientName;
m_txtOrderName.Text = objExecOrder.m_strName;
m_strDoctorID = strDoctorID;
ArrayList m_arclacarea = new ArrayList();
m_arclacarea.Add(m_objCharge.m_strClacArea);
m_arclacarea.Add(m_objCharge.m_strExecDeptName);
ctlCLACAREA_CHR.Tag = m_arclacarea;
ctlCLACAREA_CHR.Text = m_objCharge.m_strExecDeptName;
}
private void m_cmdOk_Click(object sender, System.EventArgs e)
{
if (((clsCtl_ChargeItem)this.objController).DeptTag)
{
((clsCtl_ChargeItem)this.objController).SaveTheDeptChange();
this.DialogResult = DialogResult.OK;
this.Close();
return;
}
if (!m_blnCheck())
{
return;
}
long ret = 0;
clsBIHPatientCharge objCharge = m_objGetCharge();
if (m_intNewStatus == 0)
{
if (m_intStatus == 1)
{
ret = m_objService.m_lngAddPatientCharge(objCharge);
}
else if (m_intStatus == 2)
{
ret = m_objService.m_mthModifyPatientCharge(objCharge);
}
else
{
return;
}
}
else
{
clsORDERCHARGEDEPT_VO objItem = new clsORDERCHARGEDEPT_VO();
ChargeVoToOCDVo(objCharge, ref objItem);
if (m_intNewStatus == 1)//新增信息到 [住院诊疗项目收费项目执行客户表-t_opr_bih_orderchargedept]
{
ret = m_ObjCHARGEDService.m_lngAddORDERCHARGEDEPT(objItem);
}
else if (m_intNewStatus == 2)
{
ret = m_ObjCHARGEDService.m_lngChangeORDERCHARGEDEPT(objItem);
}
}
if (ret > 0)
{
m_objTempCharge = objCharge;
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MessageBox.Show("保存失败!");
}
}
//添加新收费项目
public bool m_mthAddNew(out clsBIHPatientCharge objCharge)
{
objCharge = null;
m_intStatus = 1;
m_mthShowChargeItem(null);
if (this.ShowDialog() == DialogResult.OK)
{
objCharge = m_objTempCharge;
if (m_objTempCharge == null)
{
return(false);
}
else
{
return(true);
}
}
else
{
objCharge = null;
return(false);
}
}
private clsBIHPatientCharge m_objGetCharge()
{
clsBIHChargeItem objItem = m_txtInputCode.Tag as clsBIHChargeItem;
clsBIHPatientCharge objCharge = new clsBIHPatientCharge();
if (m_intNewStatus == 0)
{
if (m_intStatus == 1)
{
objCharge.m_strPChargeID = "";
objCharge.m_strPatientID = m_objExecOrder.m_strPatientID;
objCharge.m_strRegisterID = m_objExecOrder.m_strRegisterID;
objCharge.m_strOrderID = m_objExecOrder.m_strOrderID;
objCharge.m_intOrderExecType = m_objExecOrder.m_intExecuteType;
objCharge.m_strOrderExecID = m_objExecOrder.m_strEOrderExecID;
objCharge.m_strPatientName = m_objExecOrder.m_strPatientName;
objCharge.m_strBedNo = m_objExecOrder.m_strBedName;
}
else
{
objCharge = m_objTempCharge;
}
}
else
{
if (m_intNewStatus == 1)
{
objCharge.m_strPChargeID = "";
objCharge.m_strPatientID = m_objExecOrder.m_strPatientID;
objCharge.m_strRegisterID = m_objExecOrder.m_strRegisterID;
objCharge.m_strOrderID = m_objExecOrder.m_strOrderID;
objCharge.m_intOrderExecType = m_objExecOrder.m_intExecuteType;
objCharge.m_strOrderExecID = m_objExecOrder.m_strEOrderExecID;
objCharge.m_strPatientName = m_objExecOrder.m_strPatientName;
objCharge.m_strBedNo = m_objExecOrder.m_strBedName;
}
}
if (objItem.m_strItemIPCalcType != null)//给占用，要改回
{
objCharge.m_strCalcCateID = objItem.m_strItemIPCalcType;
}
objCharge.m_strInvCateID = objItem.m_strItemIPInvType;
objCharge.m_strChargeItemID = objItem.m_strItemID;
objCharge.m_strChargeItemName = objItem.m_strItemName;
objCharge.m_strUnit = objItem.m_strUnit;
objCharge.m_dmlUnitPrice = objItem.m_dmlPrice;
// 医保信息
objCharge.m_strINSURACEDESC_VCHR = objItem.m_strINSURACEDESC_VCHR;
objCharge.m_dmlAmount = clsConverter.ToDecimal(m_txtGet.Text);
objCharge.m_dmlDiscount = clsConverter.ToDecimal(m_txtDiscount.Text);
objCharge.m_intIsMepay = 0;
objCharge.m_strDes = m_txtDes.Text.Trim();
objCharge.m_intCreateType = 3;
objCharge.m_strCreator = m_strDoctorID;
objCharge.m_dtCreateDate = DateTime.Now;
objCharge.m_intStatus = 1;
objCharge.m_intPStatus = (objItem.m_intIsRich == 1?0:1);
// 开单及执行科室ID
string m_strClacarea_chr = "";
string m_strExecDeptName = "";
if (ctlCLACAREA_CHR.Tag != null)
{
m_strClacarea_chr = ((ArrayList)ctlCLACAREA_CHR.Tag)[0].ToString();
m_strExecDeptName = ((ArrayList)ctlCLACAREA_CHR.Tag)[1].ToString();
}
objCharge.m_strClacArea = m_strClacarea_chr;
objCharge.m_strExecDeptName = m_strExecDeptName;
objCharge.m_strCreateArea = m_objExecOrder.m_strCREATEAREA_ID;
/*<----------------------------------*/
return(objCharge);
}
public long m_lngAddPatientCharge(clsBIHPatientCharge objCharge)
{
// insert into T_Opr_Bih_PatientCharge(
// PChargeID_Chr,PatientID_Chr,RegisterID_Chr,
// OrderID_Chr, OrderExecType_Int, OrderExecID_Chr ,
// CalCCateID_Chr, InvCateID_Chr, ChargeItemID_Chr, ChargeItemName_Chr, Unit_Vchr, UnitPrice_Dec ,
// AMount_Dec, DisCount_Dec, IsMepay_Int , , ,
// Creator_Chr, Create_Dat, Status_Int, PStatus_Int )
// values( ?,?,? )"; //,
// ?,?,?
// ?,?,?,?,?,?,
// ?,?,?,?,? )" ;//,
// ?,?,1,? )
//
string strSql = @"
insert into T_Opr_Bih_PatientCharge(
PChargeID_Chr,PatientID_Chr,RegisterID_Chr,Active_Dat ,
OrderID_Chr, OrderExecType_Int, OrderExecID_Chr ,
CalCCateID_Chr, InvCateID_Chr, ChargeItemID_Chr, ChargeItemName_Chr, Unit_Vchr, UnitPrice_Dec ,
AMount_Dec, DisCount_Dec , IsMepay_Int , Des_VChr , CreateType_Int,
Creator_Chr, Create_Dat, Status_Int, PStatus_Int ,CLACAREA_CHR, CREATEAREA_CHR
)
values( ?,?,? , SysDate ,
?,?,?,
?,?,?,?,?,?,
?,? ,? ,? , ? ,
?,?,1,? ,?,? )
" ;
//to_date('[DateTimeNowValue]','yyyy-mm-dd hh24:mi:ss') ,
string strID = m_strCreateChargeID();
if (strID == "")
{
return(0);
}
objCharge.m_strPChargeID = strID;
strSql = strSql.Replace("[DateTimeNowValue]", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
//
OracleParameter[] arrParam = new OracleParameter[22];
for (int i = 0; i < arrParam.Length; i++)
{
arrParam[i] = new OracleParameter();
}
int n = -1;
n++; arrParam[n].Value = objCharge.m_strPChargeID;
n++; arrParam[n].Value = objCharge.m_strPatientID;
n++; arrParam[n].Value = objCharge.m_strRegisterID;
n++; arrParam[n].Value = objCharge.m_strOrderID;
n++; arrParam[n].Value = objCharge.m_intOrderExecType; arrParam[n].OracleDbType = OracleDbType.Int32;
n++; arrParam[n].Value = objCharge.m_strOrderExecID;
n++; arrParam[n].Value = objCharge.m_strCalcCateID;
n++; arrParam[n].Value = objCharge.m_strInvCateID;
n++; arrParam[n].Value = objCharge.m_strChargeItemID;
n++; arrParam[n].Value = objCharge.m_strChargeItemName;
n++; arrParam[n].Value = objCharge.m_strUnit;
n++; arrParam[n].Value = objCharge.m_dmlUnitPrice; arrParam[n].OracleDbType = OracleDbType.Decimal;
n++; arrParam[n].Value = objCharge.m_dmlAmount; arrParam[n].OracleDbType = OracleDbType.Decimal;
n++; arrParam[n].Value = objCharge.m_dmlDiscount; arrParam[n].OracleDbType = OracleDbType.Decimal;
n++; arrParam[n].Value = objCharge.m_intIsMepay; arrParam[n].OracleDbType = OracleDbType.Int32;
n++; arrParam[n].Value = objCharge.m_strDes;
n++; arrParam[n].Value = objCharge.m_intCreateType; arrParam[n].OracleDbType = OracleDbType.Int32;
n++; arrParam[n].Value = objCharge.m_strCreator;
n++; arrParam[n].Value = objCharge.m_dtCreateDate; arrParam[n].OracleDbType = OracleDbType.Date;
n++; arrParam[n].Value = objCharge.m_intPStatus; arrParam[n].OracleDbType = OracleDbType.Int32;
n++; arrParam[n].Value = objCharge.m_strClacArea; arrParam[n].OracleDbType = OracleDbType.NVarchar2;
n++; arrParam[n].Value = objCharge.m_strCreateArea; arrParam[n].OracleDbType = OracleDbType.NVarchar2;
long lngAff = 0;
long lngRes = 0;
try
{
lngRes = new clsHRPTableService().lngExecuteParameterSQL(strSql, ref lngAff,
arrParam[0], arrParam[1], arrParam[2], arrParam[3], arrParam[4], arrParam[5],
arrParam[6], arrParam[7], arrParam[8], arrParam[9], arrParam[10], arrParam[11],
arrParam[12], arrParam[13], arrParam[14], arrParam[15], arrParam[16],
arrParam[17], arrParam[18], arrParam[19], arrParam[20], arrParam[21]);
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_mthModifyPatientCharge(clsBIHPatientCharge objCharge)
{
string strSql = @"
update T_Opr_Bih_PatientCharge
set PatientID_Chr = ?, RegisterID_Chr =?,
OrderID_Chr=?, OrderExecType_Int=?, OrderExecID_Chr=? ,
CalCCateID_Chr=?, InvCateID_Chr=?, ChargeItemID_Chr=?, ChargeItemName_Chr=?, Unit_Vchr=?, UnitPrice_Dec=? ,
AMount_Dec=?, DisCount_Dec=?, IsMepay_Int =?, Des_VChr =? , CreateType_Int=?,
Creator_Chr=?, Create_Dat=?, Status_Int=1, PStatus_Int=? ,CLACAREA_CHR=?
where PChargeID_Chr = ?
" ;
//
OracleParameter[] arrParam = new OracleParameter[21];
for (int i = 0; i < arrParam.Length; i++)
{
arrParam[i] = new OracleParameter();
}
int n = -1;
n++; arrParam[n].Value = objCharge.m_strPatientID;
n++; arrParam[n].Value = objCharge.m_strRegisterID;
n++; arrParam[n].Value = objCharge.m_strOrderID;
n++; arrParam[n].Value = objCharge.m_intOrderExecType; arrParam[n].OracleDbType = OracleDbType.Int32;
n++; arrParam[n].Value = objCharge.m_strOrderExecID;
n++; arrParam[n].Value = objCharge.m_strCalcCateID;
n++; arrParam[n].Value = objCharge.m_strInvCateID;
n++; arrParam[n].Value = objCharge.m_strChargeItemID;
n++; arrParam[n].Value = objCharge.m_strChargeItemName;
n++; arrParam[n].Value = objCharge.m_strUnit;
n++; arrParam[n].Value = objCharge.m_dmlUnitPrice; arrParam[n].OracleDbType = OracleDbType.Decimal;
n++; arrParam[n].Value = objCharge.m_dmlAmount; arrParam[n].OracleDbType = OracleDbType.Decimal;
n++; arrParam[n].Value = objCharge.m_dmlDiscount; arrParam[n].OracleDbType = OracleDbType.Decimal;
n++; arrParam[n].Value = objCharge.m_intIsMepay; arrParam[n].OracleDbType = OracleDbType.Int32;
n++; arrParam[n].Value = objCharge.m_strDes;
n++; arrParam[n].Value = objCharge.m_intCreateType; arrParam[n].OracleDbType = OracleDbType.Int32;
n++; arrParam[n].Value = objCharge.m_strCreator;
n++; arrParam[n].Value = objCharge.m_dtCreateDate; arrParam[n].OracleDbType = OracleDbType.Date;
n++; arrParam[n].Value = objCharge.m_intPStatus; arrParam[n].OracleDbType = OracleDbType.Int32;
n++; arrParam[n].Value = objCharge.m_strClacArea;
n++; arrParam[n].Value = objCharge.m_strPChargeID;
long lngAff = 0;
long lngRes = 0;
try
{
lngRes = new clsHRPTableService().lngExecuteParameterSQL(strSql, ref lngAff,
arrParam[0], arrParam[1], arrParam[2], arrParam[3], arrParam[4], arrParam[5],
arrParam[6], arrParam[7], arrParam[8], arrParam[9], arrParam[10], arrParam[11],
arrParam[12], arrParam[13], arrParam[14], arrParam[15], arrParam[16], arrParam[17],
arrParam[18], arrParam[19], arrParam[20]);
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
