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