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