/// <summary>
/// 增加或更新医保特种病信息
/// </summary>
/// <param name="m_objYBSpeTypeDise_VO"></param>
/// <returns></returns>
public long m_mthModifyYBSpecialTypeDiseaseInfo(clsYBSpecialTypeDisease_VO m_objYBSpeTypeDise_VO)
{
long lngres = 0;
try
{
com.digitalwave.iCare.middletier.HIS.clsYBSpecialTypeDisease_SVC objSvc = (com.digitalwave.iCare.middletier.HIS.clsYBSpecialTypeDisease_SVC)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.HIS.clsYBSpecialTypeDisease_SVC));
lngres = objSvc.m_mthModifyYBSpecialTypeDiseaseInfo(objPrincipal, m_objYBSpeTypeDise_VO);
objSvc.Dispose();
objSvc = null;
}
catch
{
return(0);
}
return(lngres);
}
/// <summary>
/// 根据特种病ID获取特种病信息
/// </summary>
/// <param name="m_strDieaseCode">疾病代码</param>
/// <param name="m_objYBSpeTypeDiease_VO"></param>
/// <returns></returns>
public long m_mthGetYBSpecialTypeDiseaseByID(string m_strDieaseCode, out clsYBSpecialTypeDisease_VO m_objYBSpeTypeDiease_VO)
{
long lngres = 0;
m_objYBSpeTypeDiease_VO = null;
try
{
com.digitalwave.iCare.middletier.HIS.clsYBSpecialTypeDisease_SVC objSvc = (com.digitalwave.iCare.middletier.HIS.clsYBSpecialTypeDisease_SVC)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.HIS.clsYBSpecialTypeDisease_SVC));
lngres = objSvc.m_mthGetYBSpecialTypeDiseaseByID(objPrincipal, m_strDieaseCode, out m_objYBSpeTypeDiease_VO);
objSvc.Dispose();
objSvc = null;
}
catch
{
return(0);
}
return(lngres);
}
public void m_mthSave()
{
if (m_objViewer.m_tbDiseCode.Text.Trim() == "")
{
m_objViewer.m_tbDiseCode.Focus();
return;
}
long lngRes = 0;
clsYBSpecialTypeDisease_VO m_objResult = new clsYBSpecialTypeDisease_VO();
m_objResult.m_strDieaseCode = m_objViewer.m_tbDiseCode.Text.Trim();
m_objResult.m_strDieaseNamae = m_objViewer.m_tbDiseName.Text.Trim();
if (m_objViewer.m_tbYearMoney.Text.Trim() != "")
{
m_objResult.m_floatYearMoney = float.Parse(m_objViewer.m_tbYearMoney.Text.Trim());
}
else
{
m_objResult.m_floatYearMoney = 0;
}
if (m_objViewer.m_tbSortNO.Text.Trim() != "")
{
m_objResult.m_intSortNO = int.Parse(m_objViewer.m_tbSortNO.Text.Trim());
}
else
{
m_objResult.m_intSortNO = 0;
}
m_objResult.m_strComment = m_objViewer.m_tbComment.Text.Trim();
if (m_objViewer.lblState.Text.Trim() == "正常")
{
m_objResult.m_intStatus = 1;
}
else
{
m_objResult.m_intStatus = 0;
}
if (m_objViewer.m_tbDiseCode.Tag == null) //新增
{
for (int i = 0; i < m_objViewer.m_lvw.Items.Count; i++)
{
if (m_objViewer.m_lvw.Items[i].SubItems[0].Text.Trim() == m_objViewer.m_tbDiseCode.Text.Trim())
{
MessageBox.Show("该疾病代码已经存在！", "iCare", MessageBoxButtons.OK, MessageBoxIcon.Warning);
m_objViewer.m_tbDiseCode.Focus();
m_objViewer.m_tbDiseCode.SelectAll();
return;
}
}
lngRes = m_objDomain.m_mthModifyYBSpecialTypeDiseaseInfo(m_objResult);
int index = m_objViewer.m_lvw.Items.Count;
if (lngRes > 0)
{
ListViewItem lvw = new ListViewItem();
lvw.Text = m_objResult.m_strDieaseCode;
lvw.Tag = m_objResult.m_strDieaseCode;
lvw.SubItems.Add(m_objResult.m_strDieaseNamae);
lvw.SubItems.Add(m_objResult.m_floatYearMoney.ToString());
if (m_objResult.m_intSortNO.ToString().Trim() != "0")
{
lvw.SubItems.Add(m_objResult.m_intSortNO.ToString());
}
else
{
lvw.SubItems.Add(string.Empty);
}
lvw.SubItems.Add(m_objResult.m_strComment);
lvw.SubItems.Add(m_objResult.m_intStatus.ToString());
if (lvw.SubItems[5].Text == "0")
{
lvw.ForeColor = System.Drawing.Color.Red;
}
m_objViewer.m_lvw.Items.Add(lvw);
m_objViewer.m_lvw.Items[index].Selected = true;
}
else
{
MessageBox.Show("保存失败！", "iCare", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
if (m_objViewer.m_lvw.SelectedItems.Count <= 0)
{
return;
}
for (int i = 0; i < m_objViewer.m_lvw.Items.Count; i++)
{
if (i == m_objViewer.m_lvw.SelectedItems[0].Index)
{
continue;
}
if (m_objViewer.m_lvw.Items[i].SubItems[0].Text.Trim() == m_objViewer.m_tbDiseCode.Text.Trim())
{
MessageBox.Show("该疾病代码已经存在！", "iCare", MessageBoxButtons.OK, MessageBoxIcon.Warning);
m_objViewer.m_tbDiseCode.Focus();
m_objViewer.m_tbDiseCode.SelectAll();
return;
}
}
lngRes = m_objDomain.m_mthModifyYBSpecialTypeDiseaseInfo(m_objResult);
if (lngRes > 0)
{
MessageBox.Show("修改成功！", "iCare", MessageBoxButtons.OK, MessageBoxIcon.Information);
m_objViewer.m_lvw.SelectedItems[0].SubItems[0].Text = m_objResult.m_strDieaseCode;
m_objViewer.m_lvw.SelectedItems[0].SubItems[1].Text = m_objResult.m_strDieaseNamae;
m_objViewer.m_lvw.SelectedItems[0].SubItems[2].Text = m_objResult.m_floatYearMoney.ToString();
if (m_objResult.m_intSortNO.ToString().Trim() != "0")
{
m_objViewer.m_lvw.SelectedItems[0].SubItems[3].Text = m_objResult.m_intSortNO.ToString();
}
else
{
m_objViewer.m_lvw.SelectedItems[0].SubItems[3].Text = string.Empty;
}
m_objViewer.m_lvw.SelectedItems[0].SubItems[4].Text = m_objResult.m_strComment;
m_objViewer.m_lvw.SelectedItems[0].SubItems[5].Text = m_objResult.m_intStatus.ToString();
}
else
{
MessageBox.Show("修改失败！", "iCare", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
m_objViewer.lblState.Text = "正常";
m_objViewer.m_tbDiseCode.Text = "";
m_objViewer.m_tbDiseName.Text = "";
m_objViewer.m_tbYearMoney.Text = "";
m_objViewer.m_tbSortNO.Text = "";
m_objViewer.m_tbComment.Text = "";
m_objViewer.m_tbDiseCode.Tag = null;
m_objViewer.m_tbDiseCode.Focus();
}
public void m_mthIsStopUsing()
{
if (m_objViewer.m_lvw.Items.Count == 0 || m_objViewer.m_lvw.SelectedItems == null)
{
return;
}
if (m_objViewer.m_lvw.SelectedItems.Count <= 0)
{
return;
}
if (m_objViewer.m_lvw.SelectedItems[0].Tag == null)
{
return;
}
long lngRes = -1;
if (m_objViewer.m_tbDiseCode.Text.Trim() == string.Empty || m_objViewer.m_tbDiseName.Text.Trim() == string.Empty || m_objViewer.m_tbYearMoney.Text.Trim() == string.Empty)
{
return;
}
clsYBSpecialTypeDisease_VO m_objResult = new clsYBSpecialTypeDisease_VO();
m_objResult.m_strDieaseCode = m_objViewer.m_tbDiseCode.Text.Trim();
m_objResult.m_strDieaseNamae = m_objViewer.m_tbDiseName.Text.Trim();
if (m_objViewer.m_tbYearMoney.Text.Trim() != "")
{
m_objResult.m_floatYearMoney = float.Parse(m_objViewer.m_tbYearMoney.Text.Trim());
}
else
{
m_objResult.m_floatYearMoney = 0;
}
if (m_objViewer.m_tbSortNO.Text.Trim() != "")
{
m_objResult.m_intSortNO = int.Parse(m_objViewer.m_tbSortNO.Text.Trim());
}
else
{
m_objResult.m_intSortNO = 0;
}
m_objResult.m_strComment = m_objViewer.m_tbComment.Text.Trim();
if (m_objViewer.m_btnStopUse.Tag.ToString() == "0")
{
m_objResult.m_intStatus = 0;//停用
}
else if (m_objViewer.m_btnStopUse.Tag.ToString() == "1")
{
m_objResult.m_intStatus = 1;//启用
}
lngRes = m_objDomain.m_mthModifyYBSpecialTypeDiseaseInfo(m_objResult);
if (lngRes > 0)
{
if (m_objResult.m_intStatus == 0)
{
MessageBox.Show("停用成功！", "iCare", MessageBoxButtons.OK, MessageBoxIcon.Information);
m_objViewer.lblState.Text = "已停用";
m_objViewer.m_btnStopUse.Text = "启用(&R)";
m_objViewer.m_lvw.SelectedItems[0].SubItems[5].Text = "0";
m_objViewer.m_btnStopUse.Tag = "1";
m_objViewer.m_lvw.SelectedItems[0].ForeColor = System.Drawing.Color.Red;
}
else if (m_objResult.m_intStatus == 1)
{
MessageBox.Show("启用成功！", "iCare", MessageBoxButtons.OK, MessageBoxIcon.Information);
m_objViewer.lblState.Text = "正常";
m_objViewer.m_btnStopUse.Text = "停用(&T)";
m_objViewer.m_lvw.SelectedItems[0].SubItems[5].Text = "1";
m_objViewer.m_btnStopUse.Tag = "0";
m_objViewer.m_lvw.SelectedItems[0].ForeColor = System.Drawing.Color.Black;
}
}
else
{
if (m_objViewer.m_btnStopUse.Tag.ToString() == "0")
{
MessageBox.Show("停用失败！", "iCare", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (m_objViewer.m_btnStopUse.Tag.ToString() == "1")
{
MessageBox.Show("启用失败！", "iCare", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
public long m_mthGetYBSpecialTypeDiseaseByID(System.Security.Principal.IPrincipal p_objPrincipal, string m_strDieaseCode, out clsYBSpecialTypeDisease_VO m_objYBSpeTypeDiease_VO)
{
m_objYBSpeTypeDiease_VO = null;
DataTable p_dtbRecord = new DataTable();
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsYBSpecialTypeDisease_SVC", "m_mthGetYBSpecialTypeDiseaseByID");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"select a.deacode_chr,
a.deadesc_vchr,
a.yearmoney_int,
a.sort_int,
a.status_int,
a.note_vchr from t_opr_ybspecialtypedisease a where a.deacode_chr='" + m_strDieaseCode + "'";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_dtbRecord);
if (p_dtbRecord.Rows.Count > 0)
{
m_objYBSpeTypeDiease_VO = new clsYBSpecialTypeDisease_VO();
m_objYBSpeTypeDiease_VO.m_strDieaseCode = p_dtbRecord.Rows[0]["DEACODE_CHR"].ToString().Trim();
m_objYBSpeTypeDiease_VO.m_strDieaseNamae = p_dtbRecord.Rows[0]["DEADESC_VCHR"].ToString().Trim();
m_objYBSpeTypeDiease_VO.m_strComment = p_dtbRecord.Rows[0]["NOTE_VCHR"].ToString().Trim();
if (p_dtbRecord.Rows[0]["SORT_INT"].ToString().Trim() != "")
{
m_objYBSpeTypeDiease_VO.m_intSortNO = int.Parse(p_dtbRecord.Rows[0]["SORT_INT"].ToString().Trim());
}
else
{
m_objYBSpeTypeDiease_VO.m_intSortNO = 0;
}
if (p_dtbRecord.Rows[0]["STATUS_INT"].ToString().Trim() != "")
{
m_objYBSpeTypeDiease_VO.m_intStatus = int.Parse(p_dtbRecord.Rows[0]["STATUS_INT"].ToString().Trim());
}
else
{
m_objYBSpeTypeDiease_VO.m_intStatus = 0;
}
if (p_dtbRecord.Rows[0]["YEARMONEY_INT"].ToString().Trim() != "")
{
m_objYBSpeTypeDiease_VO.m_floatYearMoney = float.Parse(p_dtbRecord.Rows[0]["YEARMONEY_INT"].ToString().Trim());
}
else
{
m_objYBSpeTypeDiease_VO.m_floatYearMoney = 0;
}
}
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_mthModifyYBSpecialTypeDiseaseInfo(System.Security.Principal.IPrincipal p_objPrincipal, clsYBSpecialTypeDisease_VO m_objYBSpeTypeDise_VO)
{
long lngRes = 0;
DataTable m_objTable = new DataTable();
IDataParameter [] objDBParams = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsYBSpecialTypeDisease_SVC", "m_mthModifyYBSpecialTypeDiseaseInfo");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"select a.deacode_chr,
a.deadesc_vchr,
a.yearmoney_int,
a.sort_int,
a.status_int,
a.note_vchr from T_OPR_YBSPECIALTYPEDISEASE A where A.deacode_chr='" + m_objYBSpeTypeDise_VO.m_strDieaseCode + "'";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref m_objTable);
if (m_objTable.Rows.Count > 0)//存在，则更新该疾病对应的医保特种病信息
{
strSQL = @"update T_OPR_YBSPECIALTYPEDISEASE A set A.DEADESC_VCHR=?,A.YEARMONEY_INT=?,A.SORT_INT=?,A.STATUS_INT=?,A.NOTE_VCHR=? where A.deacode_chr='" + m_objYBSpeTypeDise_VO.m_strDieaseCode + "'";
objDBParams = null;
objHRPSvc.CreateDatabaseParameter(5, out objDBParams);
objDBParams[0].Value = m_objYBSpeTypeDise_VO.m_strDieaseNamae;
objDBParams[1].Value = m_objYBSpeTypeDise_VO.m_floatYearMoney;
objDBParams[2].Value = m_objYBSpeTypeDise_VO.m_intSortNO;
objDBParams[3].Value = m_objYBSpeTypeDise_VO.m_intStatus;
objDBParams[4].Value = m_objYBSpeTypeDise_VO.m_strComment;
long lngRecordAffect = -1;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecordAffect, objDBParams);
}
else //没有，则增加该疾病的医保特种病信息
{
strSQL = @"insert into T_OPR_YBSPECIALTYPEDISEASE(deacode_chr,DEADESC_VCHR,YEARMONEY_INT,SORT_INT,STATUS_INT,NOTE_VCHR)values(?,?,?,?,?,?)";
objDBParams = null;
objHRPSvc.CreateDatabaseParameter(6, out objDBParams);
objDBParams[0].Value = m_objYBSpeTypeDise_VO.m_strDieaseCode;
objDBParams[1].Value = m_objYBSpeTypeDise_VO.m_strDieaseNamae;
objDBParams[2].Value = m_objYBSpeTypeDise_VO.m_floatYearMoney;
objDBParams[3].Value = m_objYBSpeTypeDise_VO.m_intSortNO;
objDBParams[4].Value = m_objYBSpeTypeDise_VO.m_intStatus;
objDBParams[5].Value = m_objYBSpeTypeDise_VO.m_strComment;
long lngRecordAffect = -1;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecordAffect, objDBParams);
}
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
