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