public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisCheckMethodVO p_objCheckMethod, 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.clsTmdCheckMethodSvc", "m_lngInsert"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = @"INSERT INTO T_BSE_LIS_CHECKMETHOD( METHOD_SEQ_INT, CHECKMETHOD_NAME_VCHR, PYCODE_VCHR, WBCODE_VCHR ) VALUES ( ?, ? ,? ,?)"; try { lngRes = 0; lngRes = objHRPSvc.m_lngGenerateNewID("T_BSE_LIS_CHECKMETHOD", "METHOD_SEQ_INT", out p_intSeq); if (lngRes <= 0) { return(-1); } lngRes = 0; System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr( p_intSeq, p_objCheckMethod.m_strName, p_objCheckMethod.m_strPycode, p_objCheckMethod.m_strWbcode ); long lngRecEff = -1; //往表增加记录 lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr); objHRPSvc.Dispose(); if (lngRes > 0) { p_objCheckMethod.m_intSeq = p_intSeq;//给VO赋值ID } else { p_intSeq = -1; } } catch (Exception objEx) { new clsLogText().LogError(objEx); } return(lngRes); }
public void ConstructVO(DataRow p_dtrSource, ref clsLisCheckMethodVO p_objCheckMethod) { p_objCheckMethod.m_intSeq = DBAssist.ToInt32(p_dtrSource["METHOD_SEQ_INT"]); p_objCheckMethod.m_strName = p_dtrSource["CHECKMETHOD_NAME_VCHR"].ToString(); p_objCheckMethod.m_strPycode = p_dtrSource["PYCODE_VCHR"].ToString(); p_objCheckMethod.m_strWbcode = p_dtrSource["WBCODE_VCHR"].ToString(); }
public long m_lngUpdate(clsLisCheckMethodVO 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 clsLisCheckMethodVO 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); }
private void m_lsvCheckMethod_Click(object sender, EventArgs e) { if (this.m_lsvCheckMethod.FocusedItem == null) { return; } //变更状态标志 this.m_blnNewCheckMethod = false; clsLisCheckMethodVO objCheckMethod = (clsLisCheckMethodVO)this.m_lsvCheckMethod.FocusedItem.Tag; this.m_txtCMName.Text = objCheckMethod.m_strName; this.m_txtCMPYCode.Text = objCheckMethod.m_strPycode; this.m_txtCMWBCode.Text = objCheckMethod.m_strWbcode; }
public long m_lngInsert(clsLisCheckMethodVO 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); }
public void m_mthLoadData() { //加入空项 clsLisCheckMethodVO obj = new clsLisCheckMethodVO(); obj.m_strName = string.Empty; obj.m_intSeq = DBAssist.NullInt; this.Items.Add(obj); //加载数据 clsLisCheckMethodVO[] objCheckMethodArr = null; long lngRes = clsTmdCheckMethodSmp.s_object.m_lngFind(out objCheckMethodArr); if (lngRes > 0 && objCheckMethodArr != null) { this.Items.AddRange(objCheckMethodArr); } }
private void m_mthLoadCheckMethod() { Cursor.Current = Cursors.WaitCursor; //加载数据 clsLisCheckMethodVO[] objMethodsArr = null; clsTmdCheckMethodSmp.s_object.m_lngFind(out objMethodsArr); if (objMethodsArr == null) { objMethodsArr = new clsLisCheckMethodVO[0]; } m_lsvCheckMethod.Tag = objMethodsArr; //填充列表 m_mthShowCheckMethodList(objMethodsArr); Cursor.Current = Cursors.Default; }
private void m_cmdCMDelete_Click(object sender, EventArgs e) { if (this.m_lsvCheckMethod.FocusedItem == null) { return; } Cursor.Current = Cursors.WaitCursor; this.m_cmdCMDelete.Enabled = false; clsLisCheckMethodVO objMethod = (clsLisCheckMethodVO)this.m_lsvCheckMethod.FocusedItem.Tag; clsLisCheckMethodVO objCopy = new clsLisCheckMethodVO(); objMethod.m_mthCopyTo(objCopy); long lngRes = clsTmdCheckMethodSmp.s_object.m_lngDelete(objCopy.m_intSeq); if (lngRes > 0) {//成功 int intIdx = this.m_lsvCheckMethod.FocusedItem.Index; this.m_lsvCheckMethod.FocusedItem.Remove(); //设置新的具有焦点的 ListView 项 if (intIdx < this.m_lsvCheckMethod.Items.Count) { this.m_lsvCheckMethod.Items[intIdx].Selected = true; this.m_lsvCheckMethod.Items[intIdx].Focused = true; this.m_lsvCheckMethod_Click(null, null); } else if (intIdx - 1 >= 0) { this.m_lsvCheckMethod.Items[intIdx - 1].Selected = true; this.m_lsvCheckMethod.Items[intIdx - 1].Focused = true; this.m_lsvCheckMethod_Click(null, null); } } else {//失败 clsCommonDialog.m_mthShowDBError(); } this.m_cmdCMDelete.Enabled = true; Cursor.Current = Cursors.Default; }
public long m_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, out clsLisCheckMethodVO[] p_objResultArr) { long lngRes = 0; p_objResultArr = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdCheckMethodSvc", "m_lngFind"); if (lngRes <= 0) { return(-1); } string strSQL = @"SELECT * FROM T_BSE_LIS_CHECKMETHOD "; 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 clsLisCheckMethodVO[dtbResult.Rows.Count]; for (int i = 0; i < p_objResultArr.Length; i++) { p_objResultArr[i] = new clsLisCheckMethodVO(); 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_lngUpdate(System.Security.Principal.IPrincipal p_objPrincipal, clsLisCheckMethodVO p_objCheckMethod) { long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdCheckMethodSvc", "m_lngUpdate"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = @"UPDATE T_BSE_LIS_CHECKMETHOD SET CHECKMETHOD_NAME_VCHR=?, PYCODE_VCHR=?, WBCODE_VCHR=? WHERE METHOD_SEQ_INT=? " ; try { System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr( p_objCheckMethod.m_strName, p_objCheckMethod.m_strPycode, p_objCheckMethod.m_strWbcode, p_objCheckMethod.m_intSeq ); long lngRecEff = -1; //往表增加记录 lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr); objHRPSvc.Dispose(); } catch (Exception objEx) { new clsLogText().LogError(objEx); } return(lngRes); }
public long m_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, int p_intSeq, out clsLisCheckMethodVO p_objCheckMethod) { long lngRes = 0; p_objCheckMethod = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdCheckMethodSvc", "m_lngFind"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = @"SELECT * FROM T_BSE_LIS_CHECKMETHOD WHERE METHOD_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_objCheckMethod = new clsLisCheckMethodVO(); this.ConstructVO(dtbResult.Rows[0], ref p_objCheckMethod); } } catch (Exception objEx) { new clsLogText().LogError(objEx); } return(lngRes); }
private void m_cmdCMSave_Click(object sender, EventArgs e) { if (this.m_lsvCheckMethod.FocusedItem == null && !this.m_blnNewCheckMethod) { return; } Cursor.Current = Cursors.WaitCursor; this.m_cmdCMSave.Enabled = false; if (this.m_blnNewCheckMethod) {//新增的保存 clsLisCheckMethodVO objMethod = new clsLisCheckMethodVO(); objMethod.m_strName = this.m_txtCMName.Text.Trim(); objMethod.m_strPycode = this.m_txtCMPYCode.Text.Trim(); objMethod.m_strWbcode = this.m_txtCMWBCode.Text.Trim(); long lngRes = clsTmdCheckMethodSmp.s_object.m_lngInsert(objMethod); if (lngRes > 0) {//成功 //更新状态标志 this.m_blnNewCheckMethod = false; //加入到集合 clsLisCheckMethodVO[] objMethods = (clsLisCheckMethodVO[])this.m_lsvCheckMethod.Tag; clsLisCheckMethodVO[] objMethodsNewArr = new clsLisCheckMethodVO[objMethods.Length + 1]; objMethods.CopyTo(objMethodsNewArr, 0); objMethodsNewArr[objMethodsNewArr.Length - 1] = objMethod; this.m_lsvCheckMethod.Tag = objMethodsNewArr; //添加新项 ListViewItem item = new ListViewItem(objMethod.m_strName); item.SubItems.Add(objMethod.m_strPycode); item.SubItems.Add(objMethod.m_strWbcode); item.Tag = objMethod; this.m_lsvCheckMethod.Items.Add(item); item.Selected = true; item.Focused = true; this.m_lsvCheckMethod_Click(null, null); } else {//失败 clsCommonDialog.m_mthShowDBError(); } } else {//修改的保存 clsLisCheckMethodVO objMethod = (clsLisCheckMethodVO)this.m_lsvCheckMethod.FocusedItem.Tag; clsLisCheckMethodVO objNewMethod = new clsLisCheckMethodVO(); objMethod.m_mthCopyTo(objNewMethod); objNewMethod.m_strName = this.m_txtCMName.Text.Trim(); objNewMethod.m_strPycode = this.m_txtCMPYCode.Text.Trim(); objNewMethod.m_strWbcode = this.m_txtCMWBCode.Text.Trim(); long lngRes = clsTmdCheckMethodSmp.s_object.m_lngUpdate(objNewMethod); if (lngRes > 0) {//成功 objNewMethod.m_mthCopyTo(objMethod); this.m_lsvCheckMethod.FocusedItem.Text = objMethod.m_strName; this.m_lsvCheckMethod.FocusedItem.SubItems[1].Text = objMethod.m_strPycode; this.m_lsvCheckMethod.FocusedItem.SubItems[2].Text = objMethod.m_strWbcode; } else {//失败 clsCommonDialog.m_mthShowDBError(); } } this.m_cmdCMSave.Enabled = true; Cursor.Current = Cursors.Default; }