public long m_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, int p_intSeq, out clsLisConcentrationVO p_objConcentration) { long lngRes = 0; p_objConcentration = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngFind"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); try { System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(p_intSeq); DataTable dtbResult = null; lngRes = 0; lngRes = objHRPSvc.lngGetDataTableWithParameters(m_strFindSql, ref dtbResult, objODPArr); objHRPSvc.Dispose(); if (lngRes == 1 && dtbResult != null && dtbResult.Rows.Count > 0) { p_objConcentration = new clsLisConcentrationVO(); this.ConstructVO(dtbResult.Rows[0], ref p_objConcentration); } } catch (Exception objEx) { new clsLogText().LogError(objEx); } return(lngRes); }
public long m_lngUpdate(System.Security.Principal.IPrincipal p_objPrincipal, clsLisConcentrationVO QCBatch) { long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngUpdate"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); try { System.Data.IDataParameter[] objODPArr = GetUpdateDataParameterArr(QCBatch); long lngRecEff = -1; //往表增加记录 lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(m_strUpdateSql, ref lngRecEff, objODPArr); objHRPSvc.Dispose(); } catch (Exception objEx) { new clsLogText().LogError(objEx); } return(lngRes); }
private System.Data.IDataParameter[] GetUpdateDataParameterArr(clsLisConcentrationVO p_objConcentration) { System.Data.IDataParameter[] objODPArr = null; objODPArr = clsPublicSvc.m_objConstructIDataParameterArr( p_objConcentration.m_strConcentration, (int)p_objConcentration.m_enmStatus, p_objConcentration.m_intSeq ); return(objODPArr); }
/// <summary> /// insert的参数组 /// </summary> /// <param name="p_objConcentration"></param> /// <param name="p_intSeq"></param> /// <returns></returns> private System.Data.IDataParameter[] GetInsertDataParameterArr(clsLisConcentrationVO p_objConcentration, int p_intSeq) { // CONCENTRATION_SEQ_INT, CONCENTRATION_VCHR, STATUS_INT System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr ( p_intSeq, p_objConcentration.m_strConcentration, (int)p_objConcentration.m_enmStatus ); return(objODPArr); }
public void ConstructVO(DataRow p_dtrSource, ref clsLisConcentrationVO p_objConcentration) { // CONCENTRATION_SEQ_INT, CONCENTRATION_VCHR, STATUS_INT p_objConcentration.m_intSeq = DBAssist.ToInt32(p_dtrSource["CONCENTRATION_SEQ_INT"]); p_objConcentration.m_strConcentration = p_dtrSource["CONCENTRATION_VCHR"].ToString(); try { p_objConcentration.m_enmStatus = (enmQCStatus)DBAssist.ToInt32(p_dtrSource["STATUS_INT"]); } catch { } }
public long m_lngUpdate(clsLisConcentrationVO 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 clsLisConcentrationVO 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_lsvConcentration_Click(object sender, EventArgs e) { if (this.m_lsvConcentration.FocusedItem == null) { return; } //变更状态标志 this.m_blnNewConcentration = false; clsLisConcentrationVO objConcentration = (clsLisConcentrationVO)this.m_lsvConcentration.FocusedItem.Tag; this.m_txtConcentration.Text = objConcentration.m_strConcentration; }
private void m_cmdCCancelDelete_Click(object sender, EventArgs e) { if (this.m_lsvConcentration.FocusedItem == null || this.m_lsvConcentration.FocusedItem.Tag == null) { return; } Cursor.Current = Cursors.WaitCursor; m_cmdCCancelDelete.Enabled = false; clsLisConcentrationVO objconcentration = (clsLisConcentrationVO)this.m_lsvConcentration.FocusedItem.Tag; clsLisConcentrationVO objCopy = new clsLisConcentrationVO(); objconcentration.m_mthCopyTo(objCopy);//拷贝到另一个对象 objCopy.m_enmStatus = enmQCStatus.Natrural; //更新到数据库 long lngRes = clsTmdConcentrationSmp.s_object.m_lngUpdate(objCopy); if (lngRes > 0) {//更新成功 objconcentration.m_enmStatus = enmQCStatus.Natrural; int intIdx = this.m_lsvConcentration.FocusedItem.Index; this.m_lsvConcentration.FocusedItem.Remove(); //设置新的具有焦点的 ListView 项 if (intIdx < this.m_lsvConcentration.Items.Count) { this.m_lsvConcentration.Items[intIdx].Selected = true; this.m_lsvConcentration.Items[intIdx].Focused = true; this.m_lsvConcentration_Click(null, null); } else if (intIdx - 1 >= 0) { this.m_lsvConcentration.Items[intIdx - 1].Selected = true; this.m_lsvConcentration.Items[intIdx - 1].Focused = true; this.m_lsvConcentration_Click(null, null); } } else {//更新失败 clsCommonDialog.m_mthShowDBError(); } m_cmdCCancelDelete.Enabled = true; Cursor.Current = Cursors.Default; }
public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisConcentrationVO p_objConcentration, out int p_intSeq) { long lngRes = 0; p_intSeq = -1; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngInsert"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); try { lngRes = 0; lngRes = objHRPSvc.m_lngGenerateNewID(m_strTableName, m_strPrimaryKey, out p_intSeq); if (lngRes <= 0) { return(-1); } lngRes = 0; System.Data.IDataParameter[] objODPArr = GetInsertDataParameterArr(p_objConcentration, p_intSeq); long lngRecEff = -1; //往表增加记录 lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(m_strInsertSql, ref lngRecEff, objODPArr); objHRPSvc.Dispose(); if (lngRes > 0) { p_objConcentration.m_intSeq = p_intSeq;//给VO赋值ID } else { p_intSeq = -1; } } catch (Exception objEx) { new clsLogText().LogError(objEx); } return(lngRes); }
public long m_lngInsert(clsLisConcentrationVO 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_mthLoadConcentration() { Cursor.Current = Cursors.WaitCursor; //加载数据 clsLisConcentrationVO[] objconcentrationArr = null; clsTmdConcentrationSmp.s_object.m_lngFind(out objconcentrationArr); if (objconcentrationArr == null) { objconcentrationArr = new clsLisConcentrationVO[0]; } m_lsvConcentration.Tag = objconcentrationArr; //填充列表 m_mthShowConcentrationList(objconcentrationArr, this.m_chkCShowDeleted.Checked); Cursor.Current = Cursors.Default; }
public long m_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, out clsLisConcentrationVO[] p_objResultArr) { long lngRes = 0; p_objResultArr = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngFind"); if (lngRes <= 0) { return(-1); } string strSQL = @"SELECT * FROM T_BSE_LIS_CONCENTRATION "; 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 clsLisConcentrationVO[dtbResult.Rows.Count]; for (int i = 0; i < p_objResultArr.Length; i++) { p_objResultArr[i] = new clsLisConcentrationVO(); 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); }
private void m_mthLoadData() { //加入空项 clsLisConcentrationVO obj = new clsLisConcentrationVO(); obj.m_strConcentration = string.Empty; obj.m_intSeq = DBAssist.NullInt; obj.m_enmStatus = enmQCStatus.Natrural; this.Items.Add(obj); //加载数据 clsLisConcentrationVO[] objConcentrationArr = null; long lngRes = clsTmdConcentrationSmp.s_object.m_lngFind(out objConcentrationArr); if (lngRes > 0 && objConcentrationArr != null) { foreach (clsLisConcentrationVO objConcentration in objConcentrationArr) { if (objConcentration.m_enmStatus == enmQCStatus.Natrural) { this.Items.Add(objConcentration); } } } }
private void m_cmdCSave_Click(object sender, EventArgs e) { if (this.m_lsvConcentration.FocusedItem == null && !this.m_blnNewConcentration) { return; } Cursor.Current = Cursors.WaitCursor; this.m_cmdCSave.Enabled = false; if (this.m_blnNewConcentration) {//新增的保存 clsLisConcentrationVO objConentration = new clsLisConcentrationVO(); objConentration.m_enmStatus = enmQCStatus.Natrural; objConentration.m_strConcentration = this.m_txtConcentration.Text.Trim(); long lngRes = clsTmdConcentrationSmp.s_object.m_lngInsert(objConentration); if (lngRes > 0) {//成功 //更新状态标志 this.m_blnNewConcentration = false; //加入到集合 clsLisConcentrationVO[] objconcentrationArr = (clsLisConcentrationVO[])this.m_lsvConcentration.Tag; clsLisConcentrationVO[] objconcentrationNewArr = new clsLisConcentrationVO[objconcentrationArr.Length + 1]; objconcentrationArr.CopyTo(objconcentrationNewArr, 0); objconcentrationNewArr[objconcentrationNewArr.Length - 1] = objConentration; this.m_lsvConcentration.Tag = objconcentrationNewArr; //添加新项 ListViewItem item = new ListViewItem(objConentration.m_strConcentration); item.Text = objConentration.m_intSeq.ToString(); item.SubItems.Add(objConentration.m_strConcentration); item.Tag = objConentration; this.m_lsvConcentration.Items.Add(item); item.Selected = true; item.Focused = true; this.m_lsvConcentration_Click(null, null); } else {//失败 clsCommonDialog.m_mthShowDBError(); } } else {//修改的保存 clsLisConcentrationVO objConcentration = (clsLisConcentrationVO)this.m_lsvConcentration.FocusedItem.Tag; clsLisConcentrationVO objNewConcentration = new clsLisConcentrationVO(); objConcentration.m_mthCopyTo(objNewConcentration); objNewConcentration.m_strConcentration = this.m_txtConcentration.Text.Trim(); long lngRes = clsTmdConcentrationSmp.s_object.m_lngUpdate(objNewConcentration); if (lngRes > 0) {//成功 objNewConcentration.m_mthCopyTo(objConcentration); this.m_lsvConcentration.FocusedItem.Text = objConcentration.m_intSeq.ToString(); this.m_lsvConcentration.FocusedItem.SubItems[1].Text = objConcentration.m_strConcentration; } else {//失败 clsCommonDialog.m_mthShowDBError(); } } this.m_cmdCSave.Enabled = true; Cursor.Current = Cursors.Default; }