private void SelectInputGroup() { #region 新增组保存 if (this.trvList.SelectedNode.Tag == null) { return; } #endregion this.ClearInfo(); this.pnlGroupInfo.Visible = true; this.btnSave.Visible = true; this.btnDelete.Visible = true; this.btnDelete.Enabled = true; this.btnNew.Visible = false; clsInputGroupBaseInfo_VO objBaseInfo = null; clsInputGroupDetail_VO[] objDetailVOArr = null; long lngRes = this.objDomain.m_lngGetInputGroupInfo(this.trvList.SelectedNode.Tag.ToString(), out objBaseInfo, out objDetailVOArr); if (lngRes <= 0) { MessageBox.Show(strDBErr, strMessageBoxTitle); return; } this.ShowInputGroupInfo(objBaseInfo, objDetailVOArr); FillApplyUnitItem(objBaseInfo.m_strAPPLY_UNIT_ID_CHR); }
private void ShowInputGroupInfo(clsInputGroupBaseInfo_VO objBaseInfo, clsInputGroupDetail_VO[] objDetailVOArr) { if (objBaseInfo != null) { this.txtASCode.Text = objBaseInfo.m_strASCODE_VCHR; this.txtGroupID.Text = objBaseInfo.m_strINPUT_GROUP_ID_CHR; this.txtGroupName.Text = objBaseInfo.m_strINPUT_GROUP_NAME_VCHR; this.txtPYCode.Text = objBaseInfo.m_strPYCODE_VCHR; this.txtSummary.Text = objBaseInfo.m_strSUMMARY_VCHR; this.txtWBCode.Text = objBaseInfo.m_strWBCODE_VCHR; if (objBaseInfo.m_intINUSEFLAG_NUM == 0) { this.chkStopUse.Checked = true; } else { this.chkStopUse.Checked = false; } } if (objDetailVOArr != null) { foreach (clsInputGroupDetail_VO objDetail in objDetailVOArr) { ListViewItem lvi = new ListViewItem(objDetail.m_strCHECK_ITEM_ID_CHR); lvi.SubItems.Add(objDetail.m_strCHECK_ITEM_NAME_CHR); this.lsvGroupItem.Items.Add(lvi); } } }
public long m_lngUpdateInputGroup(clsInputGroupBaseInfo_VO p_objBaseInfo, clsInputGroupDetail_VO[] p_objResults) { long lngRes = 0; com.digitalwave.iCare.middletier.LIS.clsInputGroupSvc objSvc = (com.digitalwave.iCare.middletier.LIS.clsInputGroupSvc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.LIS.clsInputGroupSvc)); try { lngRes = objSvc.m_lngUpdateInputGroup(this.objPrincipal, p_objBaseInfo, p_objResults); } catch { } return(lngRes); }
private void btnSave_Click(object sender, EventArgs e) { if (!CheckDataFull()) { MessageBox.Show("请将资料填写完整!", this.strMessageBoxTitle); return; } clsInputGroupBaseInfo_VO objBaseInfo = null; clsInputGroupDetail_VO[] objDetailVOArr = null; this.ConstructSaveVO(out objBaseInfo, out objDetailVOArr); long lngRes = 0; string strID = null; if (this.blnNew) { lngRes = this.objDomain.m_lngAddNewInputGroup(objBaseInfo, objDetailVOArr, out strID); } else { lngRes = this.objDomain.m_lngUpdateInputGroup(objBaseInfo, objDetailVOArr); } if (lngRes <= 0) { MessageBox.Show(this.strDBErr, this.strMessageBoxTitle); return; } if (blnNew) { this.txtGroupID.Text = strID; TreeNode node = new TreeNode(); node.Text = objBaseInfo.m_strINPUT_GROUP_NAME_VCHR; this.trvList.SelectedNode.Nodes.Add(node); this.trvList.SelectedNode = node; node.Tag = strID; } if (this.chkStopUse.Checked) { this.trvList.SelectedNode.ForeColor = this.notInuseColor; } else { this.trvList.SelectedNode.ForeColor = this.inuseColor; } this.btnDelete.Enabled = true; }
public long m_lngGetInputGroupInfo(string p_strInputGroupID, out clsInputGroupBaseInfo_VO p_objBaseInfo, out clsInputGroupDetail_VO[] p_objResults) { long lngRes = 0; p_objResults = null; p_objBaseInfo = null; com.digitalwave.iCare.middletier.LIS.clsQueryInputGroupSvc objSvc = (com.digitalwave.iCare.middletier.LIS.clsQueryInputGroupSvc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.LIS.clsQueryInputGroupSvc)); try { lngRes = objSvc.m_lngGetInputGroupInfo(this.objPrincipal, p_strInputGroupID, out p_objBaseInfo, out p_objResults); } catch { } return(lngRes); }
private void ConstructSaveVO(out clsInputGroupBaseInfo_VO objBaseInfo, out clsInputGroupDetail_VO[] objDetailVOArr) { objBaseInfo = new clsInputGroupBaseInfo_VO(); if (this.chkStopUse.Checked) { objBaseInfo.m_intINUSEFLAG_NUM = 0; } else { objBaseInfo.m_intINUSEFLAG_NUM = 1; } objBaseInfo.m_intSEQUENCE_NUM = 0; if (this.blnNew) { objBaseInfo.m_strAPPLY_UNIT_ID_CHR = this.trvList.SelectedNode.Tag.ToString(); } else { objBaseInfo.m_strAPPLY_UNIT_ID_CHR = this.trvList.SelectedNode.Parent.Tag.ToString(); } objBaseInfo.m_strASCODE_VCHR = this.txtASCode.Text.Trim(); objBaseInfo.m_strINPUT_GROUP_ID_CHR = this.txtGroupID.Text.Trim(); objBaseInfo.m_strINPUT_GROUP_NAME_VCHR = this.txtGroupName.Text.Trim(); objBaseInfo.m_strPYCODE_VCHR = this.txtPYCode.Text.Trim(); objBaseInfo.m_strSUMMARY_VCHR = this.txtSummary.Text.Trim(); objBaseInfo.m_strWBCODE_VCHR = this.txtWBCode.Text.Trim(); objDetailVOArr = new clsInputGroupDetail_VO[this.lsvGroupItem.Items.Count]; for (int i = 0; i < objDetailVOArr.Length; i++) { objDetailVOArr[i] = new clsInputGroupDetail_VO(); objDetailVOArr[i].m_strINPUT_GROUP_ID_CHR = objBaseInfo.m_strINPUT_GROUP_ID_CHR; objDetailVOArr[i].m_strCHECK_ITEM_ID_CHR = this.lsvGroupItem.Items[i].Text; objDetailVOArr[i].m_strCHECK_ITEM_NAME_CHR = this.lsvGroupItem.Items[i].SubItems[1].Text; objDetailVOArr[i].m_intSEQUENCE_NUM = i; } }
private void ConstructInputGroupBaseInfoVO(DataRow dtr, clsInputGroupBaseInfo_VO vo) { if (dtr != null && vo != null) { try { vo.m_intINUSEFLAG_NUM = int.Parse(dtr["INUSEFLAG_NUM"].ToString()); } catch { } try { vo.m_intSEQUENCE_NUM = int.Parse(dtr["SEQUENCE_NUM"].ToString()); } catch { } vo.m_strAPPLY_UNIT_ID_CHR = dtr["APPLY_UNIT_ID_CHR"].ToString(); vo.m_strASCODE_VCHR = dtr["ASCODE_VCHR"].ToString(); vo.m_strINPUT_GROUP_ID_CHR = dtr["INPUT_GROUP_ID_CHR"].ToString(); vo.m_strINPUT_GROUP_NAME_VCHR = dtr["INPUT_GROUP_NAME_VCHR"].ToString(); vo.m_strPYCODE_VCHR = dtr["PYCODE_VCHR"].ToString(); vo.m_strSUMMARY_VCHR = dtr["SUMMARY_VCHR"].ToString(); vo.m_strWBCODE_VCHR = dtr["WBCODE_VCHR"].ToString(); } }
public long m_lngGetInputGroupInfo(System.Security.Principal.IPrincipal p_objPrincipal, string p_strInputGroupID, out clsInputGroupBaseInfo_VO p_objBaseInfo, out clsInputGroupDetail_VO[] p_objResults) { long lngRes = 0; p_objResults = null; p_objBaseInfo = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsInputGroupSvc", "m_lngGetInputGroupInfo"); if (lngRes < 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL1 = @"SELECT * FROM t_bse_lis_input_group a WHERE a.input_group_id_chr = ?"; string strSQL2 = @"SELECT a.*, b.check_item_name_vchr FROM t_bse_lis_input_group_detail a, t_bse_lis_check_item b WHERE a.check_item_id_chr = b.check_item_id_chr AND a.input_group_id_chr = ? ORDER BY a.sequence_num"; DataTable tableResult = new DataTable(); try { IDataParameter[] objParamArr = null; objHRPSvc.CreateDatabaseParameter(1, out objParamArr); objParamArr[0].Value = p_strInputGroupID; lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL1, ref tableResult, objParamArr); if (lngRes > 0 && tableResult != null && tableResult.Rows.Count > 0) { p_objBaseInfo = new clsInputGroupBaseInfo_VO(); ConstructInputGroupBaseInfoVO(tableResult.Rows[0], p_objBaseInfo); objHRPSvc.CreateDatabaseParameter(1, out objParamArr); objParamArr[0].Value = p_strInputGroupID; lngRes = 0; lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL2, ref tableResult, objParamArr); if (lngRes > 0 && tableResult != null) { p_objResults = new clsInputGroupDetail_VO[tableResult.Rows.Count]; for (int i = 0; i < p_objResults.Length; i++) { p_objResults[i] = new clsInputGroupDetail_VO(); ConstructInputGroupDetailVO(tableResult.Rows[i], p_objResults[i]); } } } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。 lngRes = 0; } return(lngRes); }
public long m_lngUpdateInputGroup(System.Security.Principal.IPrincipal p_objPrincipal, clsInputGroupBaseInfo_VO p_objBaseInfo, clsInputGroupDetail_VO[] p_objResults) { long lngRes = 0; if (p_objBaseInfo == null) { return(lngRes); } clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsInputGroupSvc", "m_lngUpdateInputGroup"); if (lngRes < 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL1 = @"UPDATE t_bse_lis_input_group a SET apply_unit_id_chr = ?, input_group_name_vchr = ?, summary_vchr = ?, pycode_vchr = ?, wbcode_vchr = ?, ascode_vchr = ?, sequence_num = ?, inuseflag_num = ? WHERE input_group_id_chr = ?"; string strSQL2 = @"DELETE FROM t_bse_lis_input_group_detail WHERE input_group_id_chr = ?"; string strSQL3 = @"INSERT INTO t_bse_lis_input_group_detail VALUES (?, ?, ?)"; try { IDataParameter[] objParamArr1 = null; objHRPSvc.CreateDatabaseParameter(9, out objParamArr1); objParamArr1[0].Value = p_objBaseInfo.m_strAPPLY_UNIT_ID_CHR; objParamArr1[1].Value = p_objBaseInfo.m_strINPUT_GROUP_NAME_VCHR; objParamArr1[2].Value = p_objBaseInfo.m_strSUMMARY_VCHR; objParamArr1[3].Value = p_objBaseInfo.m_strPYCODE_VCHR; objParamArr1[4].Value = p_objBaseInfo.m_strWBCODE_VCHR; objParamArr1[5].Value = p_objBaseInfo.m_strASCODE_VCHR; objParamArr1[6].Value = p_objBaseInfo.m_intSEQUENCE_NUM; objParamArr1[7].Value = p_objBaseInfo.m_intINUSEFLAG_NUM; objParamArr1[8].Value = p_objBaseInfo.m_strINPUT_GROUP_ID_CHR; long lngEff = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL1, ref lngEff, objParamArr1); if (lngRes > 0) { IDataParameter[] objParamArr2 = null; objHRPSvc.CreateDatabaseParameter(1, out objParamArr2); objParamArr2[0].Value = p_objBaseInfo.m_strINPUT_GROUP_ID_CHR; lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL2, ref lngEff, objParamArr2); if (lngRes > 0 && p_objResults != null) { for (int i = 0; i < p_objResults.Length; i++) { IDataParameter[] objParamArr3 = null; objHRPSvc.CreateDatabaseParameter(3, out objParamArr3); objParamArr3[0].Value = p_objBaseInfo.m_strINPUT_GROUP_ID_CHR; objParamArr3[1].Value = p_objResults[i].m_strCHECK_ITEM_ID_CHR; objParamArr3[2].Value = p_objResults[i].m_intSEQUENCE_NUM; lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL3, ref lngEff, objParamArr3); if (lngRes <= 0) { break; } } } } if (lngRes <= 0) { System.EnterpriseServices.ContextUtil.SetAbort(); } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。 lngRes = 0; } return(lngRes); }
public long m_lngAddNewInputGroup(System.Security.Principal.IPrincipal p_objPrincipal, clsInputGroupBaseInfo_VO p_objBaseInfo, clsInputGroupDetail_VO[] p_objResults, out string strID) { long lngRes = 0; strID = null; if (p_objBaseInfo == null) { return(lngRes); } clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsInputGroupSvc", "m_lngAddNewInputGroup"); if (lngRes < 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL1 = @"INSERT INTO t_bse_lis_input_group VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"; string strSQL2 = @"INSERT INTO t_bse_lis_input_group_detail VALUES (?, ?, ?)"; try { objHRPSvc.m_lngGenerateNewID("t_bse_lis_input_group", "input_group_id_chr", out strID); if (strID == null || strID.Trim() == "") { return(-1); } p_objBaseInfo.m_strINPUT_GROUP_ID_CHR = strID; IDataParameter[] objParamArr1 = null; objHRPSvc.CreateDatabaseParameter(9, out objParamArr1); objParamArr1[0].Value = p_objBaseInfo.m_strAPPLY_UNIT_ID_CHR; objParamArr1[1].Value = p_objBaseInfo.m_strINPUT_GROUP_ID_CHR; objParamArr1[2].Value = p_objBaseInfo.m_strINPUT_GROUP_NAME_VCHR; objParamArr1[3].Value = p_objBaseInfo.m_strSUMMARY_VCHR; objParamArr1[4].Value = p_objBaseInfo.m_strPYCODE_VCHR; objParamArr1[5].Value = p_objBaseInfo.m_strWBCODE_VCHR; objParamArr1[6].Value = p_objBaseInfo.m_strASCODE_VCHR; objParamArr1[7].Value = p_objBaseInfo.m_intSEQUENCE_NUM; objParamArr1[8].Value = p_objBaseInfo.m_intINUSEFLAG_NUM; long lngEff = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL1, ref lngEff, objParamArr1); if (lngRes > 0 && p_objResults != null) { for (int i = 0; i < p_objResults.Length; i++) { IDataParameter[] objParamArr2 = null; objHRPSvc.CreateDatabaseParameter(3, out objParamArr2); objParamArr2[0].Value = strID; objParamArr2[1].Value = p_objResults[i].m_strCHECK_ITEM_ID_CHR; objParamArr2[2].Value = p_objResults[i].m_intSEQUENCE_NUM; lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL2, ref lngEff, objParamArr2); if (lngRes <= 0) { break; } } } if (lngRes <= 0) { System.EnterpriseServices.ContextUtil.SetAbort(); } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。 lngRes = 0; } return(lngRes); }