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();
}
