public long m_lngUpdate(clsLisWorkGroupVO p_objRecord) { long lngRes = 0; try { lngRes = m_objSvc.m_lngUpdate(m_objPrincipal, p_objRecord); } catch { lngRes = 0; } return(lngRes); }
public long m_lngFind(int p_intID, out clsLisWorkGroupVO p_objRecord) { long lngRes = 0; p_objRecord = null; try { lngRes = m_objSvc.m_lngFind(m_objPrincipal, p_intID, out p_objRecord); } catch { lngRes = 0; } return(lngRes); }
public void ConstructVO(DataRow p_dtrSource, ref clsLisWorkGroupVO p_objWorkGroup) { p_objWorkGroup.m_intSeq = p_dtrSource["WORKGROUP_SEQ_INT"] == System.DBNull.Value ? 0 : int.Parse(p_dtrSource["WORKGROUP_SEQ_INT"].ToString().Trim()); p_objWorkGroup.m_strName = p_dtrSource["WORKGROUP_NAME_VCHR"].ToString().Trim(); p_objWorkGroup.m_strSummary = p_dtrSource["SUMMARY_VCHR"].ToString().Trim(); try { p_objWorkGroup.m_enmStatus = (enmQCStatus)DBAssist.ToInt32(p_dtrSource["STATUS_INT"]); } catch { } }
//列表选定项变更 private void m_lsvWorkGroup_Click(object sender, EventArgs e) { if (this.m_lsvWorkGroup.FocusedItem == null) { return; } //变更状态标志 this.m_blnNewWorkGroup = false; clsLisWorkGroupVO objWorkGroup = (clsLisWorkGroupVO)this.m_lsvWorkGroup.FocusedItem.Tag; this.m_txtWGName.Text = objWorkGroup.m_strName; this.m_txtWGSummary.Text = objWorkGroup.m_strSummary; }
//恢复 private void m_cmdWGCancelDelete_Click(object sender, EventArgs e) { if (this.m_lsvWorkGroup.FocusedItem == null || this.m_lsvWorkGroup.FocusedItem.Tag == null) { return; } Cursor.Current = Cursors.WaitCursor; m_cmdWGCancelDelete.Enabled = false; clsLisWorkGroupVO objGroup = (clsLisWorkGroupVO)this.m_lsvWorkGroup.FocusedItem.Tag; clsLisWorkGroupVO objCopy = new clsLisWorkGroupVO(); objGroup.m_mthCopyTo(objCopy);//拷贝到另一个对象 objCopy.m_enmStatus = enmQCStatus.Natrural; //更新到数据库 long lngRes = clsTmdWorkGroupSmp.s_object.m_lngUpdate(objCopy); if (lngRes > 0) {//更新成功 objGroup.m_enmStatus = enmQCStatus.Natrural; int intIdx = this.m_lsvWorkGroup.FocusedItem.Index; this.m_lsvWorkGroup.FocusedItem.Remove(); //设置新的具有焦点的 ListView 项 if (intIdx < this.m_lsvWorkGroup.Items.Count) { this.m_lsvWorkGroup.Items[intIdx].Selected = true; this.m_lsvWorkGroup.Items[intIdx].Focused = true; this.m_lsvWorkGroup_Click(null, null); } else if (intIdx - 1 >= 0) { this.m_lsvWorkGroup.Items[intIdx - 1].Selected = true; this.m_lsvWorkGroup.Items[intIdx - 1].Focused = true; this.m_lsvWorkGroup_Click(null, null); } } else {//更新失败 clsCommonDialog.m_mthShowDBError(); } m_cmdWGCancelDelete.Enabled = true; Cursor.Current = Cursors.Default; }
public long m_lngInsert(clsLisWorkGroupVO p_objRecord) { int intID = -1; long lngRes = 0; try { lngRes = m_objSvc.m_lngInsert(m_objPrincipal, p_objRecord, out intID); } catch { lngRes = 0; } if (lngRes > 0) { p_objRecord.m_intSeq = intID; } return(lngRes); }
//加载数据和填充列表 private void m_mthLoadWorkGroup() { Cursor.Current = Cursors.WaitCursor; //加载数据 clsLisWorkGroupVO[] objGroupArr = null; clsTmdWorkGroupSmp.s_object.m_lngFind(out objGroupArr); if (objGroupArr == null) { objGroupArr = new clsLisWorkGroupVO[0]; } m_lsvWorkGroup.Tag = objGroupArr; //填充列表 m_mthShowWorkGroupList(objGroupArr, this.m_chkWGShowDeleted.Checked); Cursor.Current = Cursors.Default; }
public long m_lngUpdate(System.Security.Principal.IPrincipal p_objPrincipal, clsLisWorkGroupVO p_objWorkGroup) { long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdWorkGroupSvc", "m_lngUpdate"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = @"UPDATE T_BSE_LIS_WORKGROUP SET WORKGROUP_NAME_VCHR=?, SUMMARY_VCHR=?, STATUS_INT=? WHERE WORKGROUP_SEQ_INT=? " ; try { System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr( p_objWorkGroup.m_strName, p_objWorkGroup.m_strSummary, (int)p_objWorkGroup.m_enmStatus, p_objWorkGroup.m_intSeq ); long lngRecEff = -1; //往表增加记录 lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr); 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_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, out clsLisWorkGroupVO[] p_objResultArr) { long lngRes = 0; p_objResultArr = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdWorkGroupSvc", "m_lngFind"); if (lngRes <= 0) { return(-1); } string strSQL = @"SELECT * FROM T_BSE_LIS_WORKGROUP "; com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); try { DataTable dtbResult = null; lngRes = 0; lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbResult); objHRPSvc.Dispose(); if (lngRes == 1 && dtbResult != null && dtbResult.Rows.Count > 0) { p_objResultArr = new clsLisWorkGroupVO[dtbResult.Rows.Count]; for (int i = 0; i < p_objResultArr.Length; i++) { p_objResultArr[i] = new clsLisWorkGroupVO(); this.ConstructVO(dtbResult.Rows[i], ref p_objResultArr[i]); } } } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, int p_intSeq, out clsLisWorkGroupVO p_objWorkGroup) { long lngRes = 0; p_objWorkGroup = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdWorkGroupSvc", "m_lngFind"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = @"SELECT * FROM T_BSE_LIS_WORKGROUP WHERE WORKGROUP_SEQ_INT = ?"; try { System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr( p_intSeq); DataTable dtbResult = null; lngRes = 0; lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtbResult, objODPArr); objHRPSvc.Dispose(); if (lngRes == 1 && dtbResult != null && dtbResult.Rows.Count > 0) { p_objWorkGroup = new clsLisWorkGroupVO(); this.ConstructVO(dtbResult.Rows[0], ref p_objWorkGroup); } } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
private void m_mthLoadData() { //加入空项 clsLisWorkGroupVO obj = new clsLisWorkGroupVO(); obj.m_strName = string.Empty; obj.m_intSeq = DBAssist.NullInt; obj.m_enmStatus = enmQCStatus.Natrural; this.Items.Add(obj); //加载数据 clsLisWorkGroupVO[] objGroupArr = null; long lngRes = clsTmdWorkGroupSmp.s_object.m_lngFind(out objGroupArr); if (lngRes > 0 && objGroupArr != null) { foreach (clsLisWorkGroupVO objGroup in objGroupArr) { if (objGroup.m_enmStatus == enmQCStatus.Natrural) { this.Items.Add(objGroup); } } } }
//保存 private void m_cmdWGSave_Click(object sender, EventArgs e) { if (this.m_lsvWorkGroup.FocusedItem == null && !this.m_blnNewWorkGroup) { return; } Cursor.Current = Cursors.WaitCursor; this.m_cmdWGSave.Enabled = false; if (this.m_blnNewWorkGroup) {//新增的保存 clsLisWorkGroupVO objGroup = new clsLisWorkGroupVO(); objGroup.m_enmStatus = enmQCStatus.Natrural; objGroup.m_strName = this.m_txtWGName.Text.Trim(); objGroup.m_strSummary = this.m_txtWGSummary.Text; long lngRes = clsTmdWorkGroupSmp.s_object.m_lngInsert(objGroup); if (lngRes > 0) {//成功 //更新状态标志 this.m_blnNewWorkGroup = false; //加入到集合 clsLisWorkGroupVO[] objGroupArr = (clsLisWorkGroupVO[])this.m_lsvWorkGroup.Tag; clsLisWorkGroupVO[] objGroupNewArr = new clsLisWorkGroupVO[objGroupArr.Length + 1]; objGroupArr.CopyTo(objGroupNewArr, 0); objGroupNewArr[objGroupNewArr.Length - 1] = objGroup; this.m_lsvWorkGroup.Tag = objGroupNewArr; //添加新项 ListViewItem item = new ListViewItem(objGroup.m_strName); item.SubItems.Add(objGroup.m_strSummary); item.Tag = objGroup; this.m_lsvWorkGroup.Items.Add(item); item.Selected = true; item.Focused = true; this.m_lsvWorkGroup_Click(null, null); } else {//失败 clsCommonDialog.m_mthShowDBError(); } } else {//修改的保存 clsLisWorkGroupVO objWorkGroup = (clsLisWorkGroupVO)this.m_lsvWorkGroup.FocusedItem.Tag; clsLisWorkGroupVO objGroup = new clsLisWorkGroupVO(); objWorkGroup.m_mthCopyTo(objGroup); objGroup.m_strName = this.m_txtWGName.Text.Trim(); objGroup.m_strSummary = this.m_txtWGSummary.Text; long lngRes = clsTmdWorkGroupSmp.s_object.m_lngUpdate(objGroup); if (lngRes > 0) {//成功 objGroup.m_mthCopyTo(objWorkGroup); this.m_lsvWorkGroup.FocusedItem.Text = objWorkGroup.m_strName; this.m_lsvWorkGroup.FocusedItem.SubItems[1].Text = objWorkGroup.m_strSummary; } else {//失败 clsCommonDialog.m_mthShowDBError(); } } this.m_cmdWGSave.Enabled = true; Cursor.Current = Cursors.Default; }
public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisWorkGroupVO p_objWorkGroup, out int p_intSeq) { long lngRes = 0; p_intSeq = -1; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdWorkGroupSvc", "m_lngInsert"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = @" INSERT INTO T_BSE_LIS_WORKGROUP ( WORKGROUP_SEQ_INT, WORKGROUP_NAME_VCHR, SUMMARY_VCHR, STATUS_INT ) VALUES ( ?, ? ,? , ?)"; try { lngRes = 0; lngRes = objHRPSvc.m_lngGenerateNewID("T_BSE_LIS_WORKGROUP", "WORKGROUP_SEQ_INT", out p_intSeq); if (lngRes <= 0) { return(-1); } lngRes = 0; System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr( p_intSeq, p_objWorkGroup.m_strName, p_objWorkGroup.m_strSummary, (int)p_objWorkGroup.m_enmStatus ); long lngRecEff = -1; //往表增加记录 lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr); objHRPSvc.Dispose(); if (lngRes > 0) { p_objWorkGroup.m_intSeq = p_intSeq;//给VO赋值ID } else { p_intSeq = -1; } } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }