Beispiel #1
0
        public void LoadEnforcementGrid(string caseId)
        {
            Param  param  = new Param();
            string strSQL = " select distinct tbet.statu as typeStatu, ce.*,et.TemplateCode,et.TemplateName,et.Height,et.Width from TBCase_EnforementName ce  join TBCase_EnforcementType tbet on tbet.EnforcementTypeId=ce.EnforcementTypeId left join TBEnforcementTemplate et on ce.EnforcementTemplateId=et.TemplateId where ce.CaseId=@caseId and tbet.CaseId=@caseId and ce.EnforcementTypeId=(select CaseCurrentTypeId from TBCase  where CaseId=@caseId)";

            param.Add("@caseId", caseId);
            string str = commonDao.DataGridTemp(strSQL, param);

            param.Clear();
            WebJson.Write(context, str);
        }