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