public long m_lngDoUpdRecipeFrequencyTypeByID(clsRecipefreq_VO p_objResultArr) { long lngRes = 0; com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc objSvc = (com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc)); lngRes = objSvc.m_lngDoUpdRecipeFrequencyByID(objPrincipal, p_objResultArr); objSvc.Dispose(); return(lngRes); }
public long m_lngFindRecipeFrequencyTypeList(System.Security.Principal.IPrincipal p_objPrincipal, out clsRecipefreq_VO[] objResult) { long lngRes = 0; objResult = new clsRecipefreq_VO[0]; //权限类 clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); //检查是否有使用些函数的权限 lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc", "m_lngFindRecipeFrequencyTypeList"); if (lngRes < 0) //没有使用的权限 { return(-1); } string strSQL = "Select FREQID_CHR ,FREQNAME_CHR ,USERCODE_CHR,TIMES_INT,DAYS_INT ,OPFREDESC_VCHR From t_aid_recipefreq ORDER BY FREQID_CHR"; try { DataTable dtResult = new DataTable(); com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtResult); objHRPSvc.Dispose(); if (lngRes > 0 && dtResult.Rows.Count > 0) { objResult = new clsRecipefreq_VO[dtResult.Rows.Count]; for (int i1 = 0; i1 < objResult.Length; i1++) { objResult[i1] = new clsRecipefreq_VO(); objResult[i1].m_strFREQID_CHR = dtResult.Rows[i1]["FREQID_CHR"].ToString().Trim(); objResult[i1].m_strFREQNAME_CHR = dtResult.Rows[i1]["FREQNAME_CHR"].ToString().Trim(); objResult[i1].m_strUSERCODE_CHR = dtResult.Rows[i1]["USERCODE_CHR"].ToString().Trim(); objResult[i1].m_intTIMES_INT = Convert.ToInt32(dtResult.Rows[i1]["TIMES_INT"].ToString().Trim()); objResult[i1].m_intDAYS_INT = Convert.ToInt32(dtResult.Rows[i1]["DAYS_INT"].ToString().Trim()); objResult[i1].m_strOPFreqDesc = dtResult.Rows[i1]["OPFREDESC_VCHR"].ToString(); } } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngDoUpdRecipeFrequencyByID(System.Security.Principal.IPrincipal p_objPrincipal, clsRecipefreq_VO objResult) { long lngRes = 0; long lngAffected = 0; //权限类 clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); //检查是否有使用些函数的权限 lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc", "m_lngDoUpdRecipeFrequencyByID"); if (lngRes < 0) //没有使用的权限 { return(-1); } string strSQL = @"UPDate t_aid_recipefreq Set FREQNAME_CHR=?, USERCODE_CHR=?, TIMES_INT=?, DAYS_INT=?,OPFREDESC_VCHR=? Where trim(FREQID_CHR)=? "; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); System.Data.IDataParameter[] objLisAddItemRefArr = null; objHRPSvc.CreateDatabaseParameter(6, out objLisAddItemRefArr); objLisAddItemRefArr[0].Value = objResult.m_strFREQNAME_CHR; objLisAddItemRefArr[1].Value = objResult.m_strUSERCODE_CHR; objLisAddItemRefArr[2].Value = objResult.m_intTIMES_INT; objLisAddItemRefArr[3].Value = objResult.m_intDAYS_INT; objLisAddItemRefArr[4].Value = objResult.m_strOPFreqDesc; objLisAddItemRefArr[5].Value = objResult.m_strFREQID_CHR; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngAffected, objLisAddItemRefArr); objHRPSvc.Dispose(); } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngAddNewRecipeFrequencyType(System.Security.Principal.IPrincipal p_objPrincipal, clsRecipefreq_VO objResult, out string p_strRecordID) { long lngRes = 0; p_strRecordID = ""; //权限类 clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); //检查是否有使用些函数的权限 lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc", "m_lngAddNewRecipeFrequencyType"); if (lngRes < 0) //没有使用的权限 { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); //返回一最大的计划号 lngRes = objHRPSvc.lngGenerateID(4, "to_number(FREQID_CHR)", "t_aid_recipefreq", out p_strRecordID); if (lngRes < 0) { return(lngRes); } string strSQL = "INSERT INTO t_aid_recipefreq (FREQID_CHR,FREQNAME_CHR ,USERCODE_CHR,TIMES_INT,DAYS_INT,OPFREDESC_VCHR) VALUES ('" + p_strRecordID + "','" + objResult.m_strFREQNAME_CHR + "','" + objResult.m_strUSERCODE_CHR + "','" + objResult.m_intTIMES_INT + "','" + objResult.m_intDAYS_INT + "','" + objResult.m_strOPFreqDesc + "')"; try { lngRes = objHRPSvc.DoExcute(strSQL); objHRPSvc.Dispose(); } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public void m_lngSaveRecipeFequencyType() { if(m_objViewer.m_txtName.Text.Trim()=="") { m_ephHandler.m_mthAddControl(m_objViewer.m_txtName); m_ephHandler.m_mthShowControlsErrorProvider(); m_ephHandler.m_mthClearControl(); m_objViewer.m_txtName.Focus(); return; } if(m_objViewer.m_txtUSERCODE_CHR.Text.Trim()=="") { m_ephHandler.m_mthAddControl(m_objViewer.m_txtUSERCODE_CHR); m_ephHandler.m_mthShowControlsErrorProvider(); m_ephHandler.m_mthClearControl(); m_objViewer.m_txtUSERCODE_CHR.Focus(); return; } if(m_objViewer.m_txtTIMES_INT.Text.Trim()=="") { m_ephHandler.m_mthAddControl(m_objViewer.m_txtTIMES_INT); m_ephHandler.m_mthShowControlsErrorProvider(); m_ephHandler.m_mthClearControl(); m_objViewer.m_txtTIMES_INT.Focus(); return; } if(m_objViewer.tex_DAYS_INT.Text.Trim()=="") { m_ephHandler.m_mthAddControl(m_objViewer.tex_DAYS_INT); m_ephHandler.m_mthShowControlsErrorProvider(); m_ephHandler.m_mthClearControl(); m_objViewer.tex_DAYS_INT.Focus(); return; } long lngRes=0; string strID=""; clsRecipefreq_VO objResult=new clsRecipefreq_VO(); objResult.m_strFREQNAME_CHR=m_objViewer.m_txtName.Text; objResult.m_strUSERCODE_CHR=m_objViewer.m_txtUSERCODE_CHR.Text; objResult.m_intTIMES_INT=Convert.ToInt32(m_objViewer.m_txtTIMES_INT.Text); objResult.m_intDAYS_INT=Convert.ToInt32(m_objViewer.tex_DAYS_INT.Text); objResult.m_strOPFreqDesc = this.m_objViewer.m_txtDesc.Text; if(m_objViewer.m_txtName.Tag==null) //新增 { for(int i=0;i<m_objViewer.m_lvw.Items.Count;i++) { if(m_objViewer.m_lvw.Items[i].SubItems[3].Text.Trim()==m_objViewer.m_txtUSERCODE_CHR.Text.Trim()) { MessageBox.Show("该助记码已存在!","提示"); m_ephHandler.m_mthAddControl(m_objViewer.m_txtUSERCODE_CHR); m_ephHandler.m_mthShowControlsErrorProvider(); m_ephHandler.m_mthClearControl(); m_objViewer.m_txtUSERCODE_CHR.Focus(); m_objViewer.m_txtUSERCODE_CHR.SelectAll(); return; } } lngRes=clsDomain.m_lngAddRecipeFrequencyType(objResult,out strID); int index=m_objViewer.m_lvw.Items.Count; if(lngRes>0) { //MessageBox.Show("保存成功!","提示"); ListViewItem lvw=new ListViewItem(); lvw.SubItems.Add(strID); lvw.SubItems.Add(m_objViewer.m_txtName.Text); lvw.SubItems.Add(m_objViewer.m_txtUSERCODE_CHR.Text); lvw.SubItems.Add(m_objViewer.m_txtTIMES_INT.Text); lvw.SubItems.Add(m_objViewer.tex_DAYS_INT.Text); lvw.SubItems.Add(m_objViewer.m_txtDesc.Text); lvw.Tag=strID; m_objViewer.m_lvw.Items.Add(lvw); m_objViewer.m_lvw.Items[index].Selected=true; }else MessageBox.Show("保存失败!","提示"); } else //修改 { if(m_objViewer.m_lvw.SelectedItems.Count<=0) { return; } for(int i=0;i<m_objViewer.m_lvw.Items.Count;i++) { if (i==m_objViewer.m_lvw.SelectedItems[0].Index) continue; if(m_objViewer.m_lvw.Items[i].SubItems[3].Text.Trim()==m_objViewer.m_txtUSERCODE_CHR.Text.Trim()) { MessageBox.Show("该助记码已存在!","提示"); m_ephHandler.m_mthAddControl(m_objViewer.m_txtUSERCODE_CHR); m_ephHandler.m_mthShowControlsErrorProvider(); m_ephHandler.m_mthClearControl(); m_objViewer.m_txtUSERCODE_CHR.Focus(); m_objViewer.m_txtUSERCODE_CHR.SelectAll(); return; } } objResult.m_strFREQID_CHR=m_objViewer.m_txtName.Tag.ToString(); lngRes=clsDomain.m_lngDoUpdRecipeFrequencyTypeByID(objResult); if(lngRes>0) { MessageBox.Show("修改成功!","提示"); m_objViewer.m_lvw.SelectedItems[0].SubItems[2].Text=m_objViewer.m_txtName.Text; m_objViewer.m_lvw.SelectedItems[0].SubItems[3].Text=m_objViewer.m_txtUSERCODE_CHR.Text; m_objViewer.m_lvw.SelectedItems[0].SubItems[4].Text=m_objViewer.m_txtTIMES_INT.Text; m_objViewer.m_lvw.SelectedItems[0].SubItems[5].Text=m_objViewer.tex_DAYS_INT.Text; m_objViewer.m_lvw.SelectedItems[0].SubItems[6].Text = m_objViewer.m_txtDesc.Text; } else MessageBox.Show("修改失败!","提示"); } m_objViewer.m_txtName.Text=""; m_objViewer.m_txtUSERCODE_CHR.Text=""; m_objViewer.m_txtTIMES_INT.Text=""; m_objViewer.tex_DAYS_INT.Text=""; m_objViewer.m_txtName.Tag=null; m_objViewer.m_txtName.Focus(); }