public void m_mthSaveSpecialRemarkDic() { clsSpecialRemarkDicVo m_objVo = new clsSpecialRemarkDicVo(); if (this.m_objViewer.m_txtUserCode.Text.Trim() == string.Empty) { MessageBox.Show("用户编码不能为空!", "iCare系统温馨提示:", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1); this.m_objViewer.m_txtUserCode.Focus(); return; } m_objVo.m_strRemarkID = this.m_objViewer.m_txtRemarkID.Text.Trim(); m_objVo.m_strRemarkContent = this.m_objViewer.m_txtRemarkContent.Text.Trim(); m_objVo.m_strUserCode = this.m_objViewer.m_txtUserCode.Text.Trim(); if (this.m_objViewer.m_cboDebtControl.SelectedIndex == 1) { m_objVo.m_intDebtControll = 1; } else { m_objVo.m_intDebtControll = 0; } string m_strResult = ""; this.m_objDomainManage.m_lngModifySpecialRemakDic(m_objVo, ref m_strResult); MessageBox.Show(m_strResult, "iCare提示信息!", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); if (m_strResult == "添加成功!") { DataRow m_objDataRow = m_objTable.NewRow(); m_objDataRow["REMARKID_CHR"] = m_objVo.m_strRemarkID; m_objDataRow["REMARKNAME_VCHR"] = m_objVo.m_strRemarkContent; m_objDataRow["USERCODE_VCHR"] = m_objVo.m_strUserCode; if (m_objVo.m_intDebtControll == 0) { m_objDataRow["chargectl_status"] = "不允许"; } else { m_objDataRow["chargectl_status"] = "允许"; } m_objTable.Rows.Add(m_objDataRow); this.m_objViewer.m_dgvSpecialRemarkDic.DataSource = this.m_objTable; if (this.m_objTable.Rows.Count > 1) { this.m_objViewer.m_dgvSpecialRemarkDic.Rows[this.m_objTable.Rows.Count - 1].Selected = true; } else { this.m_objViewer.m_dgvSpecialRemarkDic.Rows[0].Selected = true; } } else if (m_strResult == "修改成功!") { int m_intCurrentIndex = this.m_objViewer.m_dgvSpecialRemarkDic.CurrentRow.Index; this.m_objViewer.m_dgvSpecialRemarkDic.Rows[m_intCurrentIndex].Cells[0].Value = m_objVo.m_strRemarkID; this.m_objViewer.m_dgvSpecialRemarkDic.Rows[m_intCurrentIndex].Cells[1].Value = m_objVo.m_strRemarkContent; this.m_objViewer.m_dgvSpecialRemarkDic.Rows[m_intCurrentIndex].Cells[2].Value = m_objVo.m_strUserCode; if (m_objVo.m_intDebtControll == 0) { this.m_objViewer.m_dgvSpecialRemarkDic.Rows[m_intCurrentIndex].Cells[3].Value = "不允许"; } else { this.m_objViewer.m_dgvSpecialRemarkDic.Rows[m_intCurrentIndex].Cells[3].Value = "允许"; } } }
/// <summary> /// ¸üÐÂÌØÊâ×¢ÊÍ×Öµä /// </summary> /// <param name="m_objVo"></param> /// <param name="m_strResult"></param> /// <returns></returns> public long m_lngModifySpecialRemakDic(clsSpecialRemarkDicVo m_objVo, ref string m_strResult) { com.digitalwave.iCare.middletier.BIHOrderServer.clsSpecialRemarkDicService objSvc = (com.digitalwave.iCare.middletier.BIHOrderServer.clsSpecialRemarkDicService) com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.BIHOrderServer.clsSpecialRemarkDicService)); return(objSvc.m_lngModifySpecialRemakDic(objPrincipal, m_objVo, ref m_strResult)); }
public long m_lngModifySpecialRemakDic(System.Security.Principal.IPrincipal p_objPricipal, clsSpecialRemarkDicVo m_objVo, ref string m_strResult) { long m_lngRes = -1; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); m_lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPricipal, "com.digitalwave.iCare.middletier.BIHOrderServer.clsSpecialRemarkDicService", "m_lngModifySpecialRemakDic"); if (m_lngRes < 0) { return(-1); } try { if (m_objVo == null) { return(-1); } DataTable m_objTable = new DataTable(); string m_strSQL = @"SELECT * FROM t_bse_bih_specremark a WHERE a.remarkid_chr = '" + m_objVo.m_strRemarkID.Trim() + "'"; com.digitalwave.iCare.middletier.HRPService.clsHRPTableService m_objHRP = new clsHRPTableService(); m_lngRes = m_objHRP.lngGetDataTableWithoutParameters(m_strSQL, ref m_objTable); if (m_lngRes > 0) { if (m_objTable.Rows.Count > 0) { m_strSQL = @"UPDATE t_bse_bih_specremark a SET a.remarkname_vchr = '" + m_objVo.m_strRemarkContent.Trim() + "', a.usercode_vchr = '" + m_objVo.m_strUserCode.Trim() + "', a.chargectl_int =" + m_objVo.m_intDebtControll + " WHERE a.remarkid_chr = '" + m_objVo.m_strRemarkID.Trim() + "'"; m_lngRes = m_objHRP.DoExcute(m_strSQL); if (m_lngRes > 0) { m_strResult = "Ð޸ijɹ¦£¡"; } else { m_strResult = "ÐÞ¸Äʧ°Ü£¡"; } } else { m_strSQL = @"INSERT INTO t_bse_bih_specremark a (a.remarkid_chr, a.remarkname_vchr, a.usercode_vchr, a.chargectl_int)VALUES ('" + m_objVo.m_strRemarkID.Trim() + "', '" + m_objVo.m_strRemarkContent.Trim() + "', '" + m_objVo.m_strUserCode.Trim() + "', " + m_objVo.m_intDebtControll + ")"; m_lngRes = m_objHRP.DoExcute(m_strSQL); if (m_lngRes > 0) { m_strResult = "Ìí¼Ó³É¹¦£¡"; } else { m_strResult = "Ìí¼Óʧ°Ü£¡"; } } } } catch (Exception ex) { string strTmp = ex.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(ex); } return(m_lngRes); }