public long m_lngUpdate(clsSysParamVO objReader)
{
long lngRes = 0;
string sql = @"
update t_bse_sysparm
set syscode_chr = ?,
parmdesc_vchr = ?,
parmvalue_vchr = ?,
status_int = ?,
note_vchr = ?
where parmcode_chr = ?
";
clsHRPTableService objHRPSvc = new clsHRPTableService();
IDataParameter[] paramsArr = null;
objHRPSvc.CreateDatabaseParameter(6, out paramsArr);
paramsArr[0].Value = objReader.m_intSysCode;
paramsArr[1].Value = objReader.m_strParamDesc;
paramsArr[2].Value = objReader.m_strParamValue;
paramsArr[3].Value = objReader.m_intStatus;
paramsArr[4].Value = objReader.m_strNote;
paramsArr[5].Value = objReader.m_strParamCode;
try
{
long lngRecEff = -1;
lngRes = objHRPSvc.lngExecuteParameterSQL(sql, ref lngRecEff, paramsArr);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
return(lngRes);
}
private void ConstructVO(DataRow p_dtrSource, ref clsSysParamVO objReader)
{
objReader.m_intStatus = DBAssist.ToInt32(p_dtrSource["status_int"]);
objReader.m_intSysCode = DBAssist.ToInt32(p_dtrSource["syscode_chr"]);
objReader.m_strParamCode = p_dtrSource["parmcode_chr"].ToString();
objReader.m_strParamDesc = p_dtrSource["parmdesc_vchr"].ToString();
objReader.m_strParamValue = p_dtrSource["parmvalue_vchr"].ToString();
objReader.m_strNote = p_dtrSource["note_vchr"].ToString();
}
private clsSysParamVO[] ConstructVOArr(DataTable dtbResult)
{
clsSysParamVO[] p_objResultArr = new clsSysParamVO[dtbResult.Rows.Count];
for (int i = 0; i < p_objResultArr.Length; i++)
{
p_objResultArr[i] = new clsSysParamVO();
ConstructVO(dtbResult.Rows[i], ref p_objResultArr[i]);
}
return(p_objResultArr);
}
//恢复
private void m_cmdCancelDelete_Click(object sender, EventArgs e)
{
if (this.m_lsvSysParams.FocusedItem == null ||
this.m_lsvSysParams.FocusedItem.Tag == null)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
m_cmdCancelDelete.Enabled = false;
clsSysParamVO objSysParam = (clsSysParamVO)this.m_lsvSysParams.FocusedItem.Tag;
clsSysParamVO objCopy = new clsSysParamVO();
objSysParam.m_mthCopyTo(objCopy);//拷贝到另一个对象
objCopy.m_intStatus = 1;
//更新到数据库
long lngRes = clsDcl_SysParamSmp.s_object.m_lngUpdate(objCopy);
if (lngRes > 0)
{//更新成功
objSysParam.m_intStatus = 0;
int intIdx = this.m_lsvSysParams.FocusedItem.Index;
this.m_lsvSysParams.FocusedItem.Remove();
//设置新的具有焦点的 ListView 项
if (intIdx < this.m_lsvSysParams.Items.Count)
{
this.m_lsvSysParams.Items[intIdx].Selected = true;
this.m_lsvSysParams.Items[intIdx].Focused = true;
this.m_lsvSysParams_Click(null, null);
}
else if (intIdx - 1 >= 0)
{
this.m_lsvSysParams.Items[intIdx - 1].Selected = true;
this.m_lsvSysParams.Items[intIdx - 1].Focused = true;
this.m_lsvSysParams_Click(null, null);
}
}
else
{//更新失败
//clsCommonDialog.m_mthShowDBError();
MessageBox.Show("删除失败！");
}
m_cmdCancelDelete.Enabled = true;
Cursor.Current = Cursors.Default;
}
public long m_lngUpdate(clsSysParamVO sysParamVO)
{
long lngRes = 0;
try
{
lngRes = objSvc.m_lngUpdate(sysParamVO);
}
catch
{
lngRes = 0;
}
return lngRes;
}
//加载数据和填充列表
private void m_mthLoadSysParams()
{
Cursor.Current = Cursors.WaitCursor;
//加载数据
clsSysParamVO[] arrSysParams = null;
clsDcl_SysParamSmp.s_object.m_lngFind(out arrSysParams);
if (arrSysParams == null)
{
arrSysParams = new clsSysParamVO[0];
}
m_lsvSysParams.Tag = arrSysParams;
//填充列表
m_mthShowSysParamsList(arrSysParams, this.m_chkShowDeleted.Checked);
Cursor.Current = Cursors.Default;
}
//列表选定项变更
private void m_lsvSysParams_Click(object sender, EventArgs e)
{
if (this.m_lsvSysParams.FocusedItem == null)
{
return;
}
//变更状态标志
this.m_blnNewSysParams = false;
this.m_txtPramCode.Enabled = false;
clsSysParamVO objSysParam = (clsSysParamVO)this.m_lsvSysParams.FocusedItem.Tag;
this.m_txtPramCode.Text = objSysParam.m_strParamCode;
this.m_txtParamDesc.Text = objSysParam.m_strParamDesc;
this.m_txtParamValue.Text = objSysParam.m_strParamValue;
this.m_txtNote.Text = objSysParam.m_strNote;
this.m_cboSysModule.SelectedIndex = objSysParam.m_intSysCode;
}
//保存
private void m_cmdSave_Click(object sender, EventArgs e)
{
if (this.m_lsvSysParams.FocusedItem == null &&
!this.m_blnNewSysParams)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
this.m_cmdSave.Enabled = false;
if (this.m_blnNewSysParams)
{//新增的保存
clsSysParamVO objSysParam = new clsSysParamVO();
objSysParam.m_intSysCode = this.m_cboSysModule.SelectedIndex;
objSysParam.m_strParamCode = this.m_txtPramCode.Text.Trim();
objSysParam.m_strParamDesc = this.m_txtParamDesc.Text.Trim();
objSysParam.m_strParamValue = this.m_txtParamValue.Text.Trim();
objSysParam.m_strNote = this.m_txtNote.Text.Trim();
objSysParam.m_intStatus = 1;
long lngRes = clsDcl_SysParamSmp.s_object.m_lngInsert(objSysParam);
if (lngRes > 0)
{//成功
//更新状态标志
this.m_blnNewSysParams = false;
//加入到集合
clsSysParamVO[] objGroupArr = (clsSysParamVO[])this.m_lsvSysParams.Tag;
clsSysParamVO[] objGroupNewArr = new clsSysParamVO[objGroupArr.Length + 1];
objGroupArr.CopyTo(objGroupNewArr, 0);
objGroupNewArr[objGroupNewArr.Length - 1] = objSysParam;
this.m_lsvSysParams.Tag = objGroupNewArr;
//添加新项
ListViewItem item = new ListViewItem(GetModuleName(objSysParam.m_intSysCode));
item.SubItems.Add(objSysParam.m_strParamCode);
item.SubItems.Add(objSysParam.m_strParamDesc);
item.SubItems.Add(objSysParam.m_strParamValue);
item.SubItems.Add(objSysParam.m_strNote);
item.Tag = objSysParam;
this.m_lsvSysParams.Items.Add(item);
item.Selected = true;
item.Focused = true;
this.m_txtPramCode.Enabled = false;
this.m_lsvSysParams_Click(null, null);
}
else
{//失败
MessageBox.Show("新增数据失败！");
}
}
else
{//修改的保存
clsSysParamVO objSysParams = (clsSysParamVO)this.m_lsvSysParams.FocusedItem.Tag;
clsSysParamVO objGroup = new clsSysParamVO();
objSysParams.m_mthCopyTo(objGroup);
objGroup.m_intSysCode = this.m_cboSysModule.SelectedIndex;
objGroup.m_strParamCode = this.m_txtPramCode.Text.Trim();
objGroup.m_strParamDesc = this.m_txtParamDesc.Text.Trim();
objGroup.m_strParamValue = this.m_txtParamValue.Text.Trim();
objGroup.m_strNote = this.m_txtNote.Text.Trim();
objGroup.m_intStatus = 1;
long lngRes = clsDcl_SysParamSmp.s_object.m_lngUpdate(objGroup);
if (lngRes > 0)
{//成功
objGroup.m_mthCopyTo(objSysParams);
this.m_lsvSysParams.FocusedItem.Text = GetModuleName(objSysParams.m_intSysCode);
this.m_lsvSysParams.FocusedItem.SubItems[1].Text = objSysParams.m_strParamCode;
this.m_lsvSysParams.FocusedItem.SubItems[2].Text = objSysParams.m_strParamDesc;
this.m_lsvSysParams.FocusedItem.SubItems[3].Text = objSysParams.m_strParamValue;
this.m_lsvSysParams.FocusedItem.SubItems[4].Text = objSysParams.m_strNote;
}
else
{//失败
MessageBox.Show("修改数据失败！");
}
this.m_txtPramCode.Enabled = false;
}
this.m_cmdSave.Enabled = true;
Cursor.Current = Cursors.Default;
}
