/// <summary> /// 根据区分代码和区分明细代码,检查数据表中是否存在 ///<param name="clsCd"></param> ///<param name="detailCd"></param> ///<param name="langCd"></param> /// <returns>Boolean</returns> /// </summary> public Boolean Check01Bool(string langCd, string clsCd, string detailCd) { Boolean rtnVal = false; CClsDetailNoAR vo = Check01Vo(langCd, clsCd, detailCd); if (vo != null && !String.IsNullOrEmpty(vo.IClsDetailCd)) { rtnVal = true; } return(rtnVal); }
/// <summary> /// 根据区分代码和区分明细代码,检查数据表中是否存在 ///<param name="clsCd"></param> ///<param name="detailCd"></param> ///<param name="langCd"></param> /// <returns>Boolean</returns> /// <returns>CClsDetailNoAR</returns> /// </summary> public CClsDetailNoAR Check01Vo(string langCd, string clsCd, string detailCd) { CClsDetailNoAR vo = null; try { if (!String.IsNullOrEmpty(clsCd) && !(string.IsNullOrEmpty(detailCd)) && !(string.IsNullOrEmpty(langCd))) { ICClsDetailNoARDao d = ComponentLocator.Instance().Resolve <ICClsDetailNoARDao>(); vo = d.GetClsDetail(langCd, clsCd, detailCd); } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } return(vo); }
/// <summary> /// 制造商Check "72" /// </summary> private void ruleMakerExist_CustomValidationMethod(object sender, CustomValidationEventArgs e) { if (string.IsNullOrEmpty(this.atxtMakerCd.Text)) { return; } CheckCls check = new CheckCls(); this.lblMakerNm.Text = ""; CClsDetailNoAR vo = check.Check01Vo(LangUtils.GetCurrentLanguage(), "72", this.atxtMakerCd.Text); if (vo != null && !String.IsNullOrEmpty(vo.IClsDetailCd)) { e.IsValid = true; this.lblMakerNm.Text = vo.IClsDetailDesc; } else { e.IsValid = false; } }
public CClsDetailNoAR GetClsDetail(string langId, string clsCd, string detailCd) { CClsDetailNoAR result = null; ISession ss = holder.CreateSession(typeof(CClsDetailNoARDaoOracleImp)); ITransaction tran = ss.BeginTransaction(); try { //IList<TClsMs> clsmslist = new List<TClsMs>(); TClsMs clsms = null; //get role by userid ScalarQuery <TClsMs> queryclsms = new ScalarQuery <TClsMs>(typeof(TClsMs), @" from TClsMs where IClsCd=:clsCd"); queryclsms.SetParameter("clsCd", clsCd); clsms = queryclsms.Execute(); if (clsms == null) { throw new ApplicationException(MessageUtils.GetMessage("E0001")); } StringBuilder sb = new StringBuilder(); //select f.catalogid,f.functionid,f.functionimage,f.functionindex,f.functionname,f.functionpath,f.langid,c.catalogimage,c.catalogname from (M_FUNCTION f inner join (select functionid from m_role_function //where roleid=1 group by functionid) r on (f.functionid=r.functionid)) left join //m_functioncatalog c on (f.catalogid=c.catalogid and f.langid=c.langid) //where f.langid='zh-CN' //order by f.catalogid,f.functionindex if ("1".Equals(clsms.IClsCls)) { sb.Append(" select d.i_cls_cd as iClsCd,"); sb.Append(" d.i_language_cd as iLanguageCd,"); sb.Append(" d.i_cls_detail_cd as iClsDetailCd,"); sb.Append(" d.i_cls_detail_desc as iClsDetailDesc,"); sb.Append(" d.i_inq_item as iInqItem,"); sb.Append(" '' as iClsNameDesc"); sb.Append(" from t_cls_detail_ms d"); sb.Append(" where d.i_cls_cd=:clsCd"); sb.Append(" and d.i_language_cd=:langId"); sb.Append(" and d.i_cls_detail_cd=:detailCd"); } else if ("2".Equals(clsms.IClsCls)) { sb.Append(" select d.i_cls_cd as iClsCd ,"); sb.Append(" d.i_language_cd as iLanguageCd ,"); sb.Append(" d.i_name_cd as iClsDetailCd,"); sb.Append(" d.i_name_desc as iClsDetailDesc,"); sb.Append(" d.i_inq_item as iInqItem,"); sb.Append(" d.i_name_kana as iClsNameDesc"); sb.Append(" from t_desc_ms d"); sb.Append(" where d.i_cls_cd=:clsCd"); sb.Append(" and d.i_language_cd=:langId"); sb.Append(" and d.i_name_cd=:detailCd"); } ISQLQuery querydetail = ss.CreateSQLQuery(sb.ToString()); querydetail.AddScalar("iClsCd", NHibernateUtil.String); querydetail.AddScalar("iLanguageCd", NHibernateUtil.String); querydetail.AddScalar("iClsDetailCd", NHibernateUtil.String); querydetail.AddScalar("iClsDetailDesc", NHibernateUtil.String); querydetail.AddScalar("iInqItem", NHibernateUtil.String); querydetail.AddScalar("iClsNameDesc", NHibernateUtil.String); querydetail.SetParameter("langId", langId); querydetail.SetParameter("clsCd", clsms.IClsCd); querydetail.SetParameter("detailCd", detailCd); IList <CClsDetailNoAR> temp = querydetail.SetResultTransformer(Transformers.AliasToBean <CClsDetailNoAR>()).List <CClsDetailNoAR>(); if (temp.Count > 0) { result = temp[0]; } tran.Commit(); } catch (Castle.ActiveRecord.Framework.ActiveRecordException ex) { tran.Rollback(); throw new ApplicationException(ex.Message, ex); } catch (DbException ex) { tran.Rollback(); throw new ApplicationException(ex.Message, ex); } finally { tran.Dispose(); holder.ReleaseSession(ss); } return(result); }