Example #1
0
        public static GridModel GetField(int fieldId)
        {
            GridModel model = new GridModel();

            using (var sqlb = DbHelper.CreateSql())
            {
                sqlb.SelectSql = @"SELECT f.*, t.ControlTypeName FROM DevFieldInfo f LEFT JOIN dbo.DevControlType t ON f.ControlTypeId=t.ControlTypeId ";
                sqlb.AddFilter("f.FieldId = @FieldId", "@FieldId",  fieldId);
                model.Data = sqlb.QueryDataTable() ;
                model.AutoSetFields();
            }
            return model;
        }